diff options
author | Cyrille Bagard <nocbos@gmail.com> | 2018-07-16 14:31:40 (GMT) |
---|---|---|
committer | Cyrille Bagard <nocbos@gmail.com> | 2018-07-16 14:31:40 (GMT) |
commit | e0d03e3eddb9d240cc21ac1b7a7ade915fd17942 (patch) | |
tree | 9543a9d1330262239f3943b8459bde1429a35dbb /src/analysis/db/items/comment.c | |
parent | 7a009c76657478c9270acec0c2b236523bfd68eb (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.c | 18 |
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; |