Page MenuHomePhorge
Files F33037461

D7257.1768410713.diff
No OneTemporary
Actions

Size
2 KB
Referenced Files
None
Subscribers
None

D7257.1768410713.diff
View Options

diff --git a/native/cpp/CommonCpp/DatabaseManagers/SQLiteQueryExecutor.cpp b/native/cpp/CommonCpp/DatabaseManagers/SQLiteQueryExecutor.cpp
--- a/native/cpp/CommonCpp/DatabaseManagers/SQLiteQueryExecutor.cpp
+++ b/native/cpp/CommonCpp/DatabaseManagers/SQLiteQueryExecutor.cpp
@@ -304,6 +304,27 @@
return false;
}
+bool add_avatar_column_to_threads_table(sqlite3 *db) {
+ char *error;
+ sqlite3_exec(
+ db,
+ "ALTER TABLE threads ADD COLUMN avatar TEXT;",
+ nullptr,
+ nullptr,
+ &error);
+
+ if (!error) {
+ return true;
+ }
+
+ std::ostringstream stringStream;
+ stringStream << "Error adding avatar column to threads table: " << error;
+ Logger::log(stringStream.str());
+
+ sqlite3_free(error);
+ return false;
+}
+
bool create_schema(sqlite3 *db) {
char *error;
sqlite3_exec(
@@ -357,7 +378,8 @@
" roles TEXT NOT NULL,"
" current_user TEXT NOT NULL,"
" source_message_id TEXT,"
- " replies_count INTEGER NOT NULL"
+ " replies_count INTEGER NOT NULL,"
+ " avatar TEXT"
");"
"CREATE TABLE IF NOT EXISTS metadata ("
@@ -599,7 +621,8 @@
{22, {enable_write_ahead_logging_mode, false}},
{23, {create_metadata_table, true}},
{24, {add_not_null_constraint_to_drafts, true}},
- {25, {add_not_null_constraint_to_metadata, true}}}};
+ {25, {add_not_null_constraint_to_metadata, true}},
+ {26, {add_avatar_column_to_threads_table, false}}}};
enum class MigrationResult { SUCCESS, FAILURE, NOT_APPLIED };
@@ -800,7 +823,8 @@
make_column("roles", &Thread::roles),
make_column("current_user", &Thread::current_user),
make_column("source_message_id", &Thread::source_message_id),
- make_column("replies_count", &Thread::replies_count)),
+ make_column("replies_count", &Thread::replies_count),
+ make_column("avatar", &Thread::avatar)),
make_table(
"metadata",
make_column("name", &Metadata::name, unique(), primary_key()),
diff --git a/native/cpp/CommonCpp/DatabaseManagers/entities/Thread.h b/native/cpp/CommonCpp/DatabaseManagers/entities/Thread.h
--- a/native/cpp/CommonCpp/DatabaseManagers/entities/Thread.h
+++ b/native/cpp/CommonCpp/DatabaseManagers/entities/Thread.h
@@ -20,6 +20,7 @@
std::string current_user;
std::unique_ptr<std::string> source_message_id;
int replies_count;
+ std::string avatar;
};
} // namespace comm

File Metadata

Mime Type
text/plain
Expires
Wed, Jan 14, 5:11 PM (12 h, 49 m)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
5929415
Default Alt Text
D7257.1768410713.diff (2 KB)

Event Timeline