diff options
author | Jon Bergli Heier <snakebite@jvnv.net> | 2010-04-25 00:04:52 +0200 |
---|---|---|
committer | Jon Bergli Heier <snakebite@jvnv.net> | 2010-04-25 00:04:52 +0200 |
commit | e52bbb2a3d17cc12cab75deba113d3075b62337e (patch) | |
tree | 5fec5072869c6441411ed43399669afa56d9961c /db.c | |
parent | e4bd032ee3f525a8f774402c6128ba0646c30bcd (diff) |
Set parent when adding tags.
Diffstat (limited to 'db.c')
-rw-r--r-- | db.c | 14 |
1 files changed, 12 insertions, 2 deletions
@@ -515,11 +515,11 @@ int db_get_walls_by_tags(GArray *tags, GArray **array) { return 1; } -sqlite_uint64 db_add_tag(const char *name) { +sqlite_uint64 db_add_tag(const char *name, sqlite_uint64 parent) { sqlite3_stmt *stmt; int rc; - rc = sqlite3_prepare_v2(db, "INSERT INTO tag (name) VALUES (?)", -1, &stmt, NULL); + rc = sqlite3_prepare_v2(db, "INSERT INTO tag (name, parent) VALUES (?, ?)", -1, &stmt, NULL); if(rc != SQLITE_OK) { return 0; @@ -531,6 +531,16 @@ sqlite_uint64 db_add_tag(const char *name) { return 0; } + if(parent == 0) { + rc = sqlite3_bind_null(stmt, 2); + } else { + rc = sqlite3_bind_int64(stmt, 2, parent); + } + if(rc != SQLITE_OK) { + sqlite3_finalize(stmt); + return 0; + } + rc = sqlite3_step(stmt); sqlite3_finalize(stmt); |