summaryrefslogtreecommitdiff
path: root/src/analysis/db/items/comment.c
diff options
context:
space:
mode:
authorCyrille Bagard <nocbos@gmail.com>2018-07-16 14:31:40 (GMT)
committerCyrille Bagard <nocbos@gmail.com>2018-07-16 14:31:40 (GMT)
commite0d03e3eddb9d240cc21ac1b7a7ade915fd17942 (patch)
tree9543a9d1330262239f3943b8459bde1429a35dbb /src/analysis/db/items/comment.c
parent7a009c76657478c9270acec0c2b236523bfd68eb (diff)
Updated the move entry from database items.
Diffstat (limited to 'src/analysis/db/items/comment.c')
-rw-r--r--src/analysis/db/items/comment.c18
1 files changed, 14 insertions, 4 deletions
diff --git a/src/analysis/db/items/comment.c b/src/analysis/db/items/comment.c
index 57bb017..182b2d0 100644
--- a/src/analysis/db/items/comment.c
+++ b/src/analysis/db/items/comment.c
@@ -1587,20 +1587,30 @@ GCommentCollection *g_comment_collection_new(void)
static bool g_comment_collection_create_db_table(const GCommentCollection *collec, sqlite3 *db)
{
- char *sql; /* Requête à exécuter */
- int ret; /* Bilan de la création */
+ const char *sql; /* Patron de Requête SQL */
+ char *addr_fields; /* Champs pour l'adresse */
+ char *request; /* Requête à exécuter */
char *msg; /* Message d'erreur */
+ int ret; /* Bilan de la création */
sql = "CREATE TABLE Comments (" \
SQLITE_DB_ITEM_CREATE ", " \
- SQLITE_SIMPLE_VMPA_CREATE ", " \
+ "%%s, " \
"flags INTEGER, " \
SQLITE_RLESTR_CREATE("text") ", " \
"inlined INTEGER, " \
"repeatable INTEGER" \
");";
+ addr_fields = create_vmpa_db_table(NULL);
+
+ asprintf(&request, sql, addr_fields);
+
ret = sqlite3_exec(db, sql, NULL, NULL, &msg);
+
+ free(addr_fields);
+ free(request);
+
if (ret != SQLITE_OK)
{
fprintf(stderr, "sqlite3_exec(): %s\n", msg);
@@ -1635,7 +1645,7 @@ static bool g_comment_collection_setup_load(GCommentCollection *collec, bound_va
values, count);
if (!status) return false;
- if (!setup_load_for_vmpa(NULL, NULL, values, count))
+ if (!setup_load_for_vmpa(NULL, values, count))
return false;
*count += 1;