diff options
Diffstat (limited to 'src')
| -rw-r--r-- | src/database_interaction.c | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/src/database_interaction.c b/src/database_interaction.c index e31d197..1f2d9af 100644 --- a/src/database_interaction.c +++ b/src/database_interaction.c @@ -221,7 +221,7 @@ int prepare_statements() { /* INSERT */ LOCAL_PREP_STMT("INSERT INTO filenames (name) VALUES (?);", &insert_filename); LOCAL_PREP_STMT("INSERT INTO paths (pathname) VALUES (?);", &insert_pathname); - LOCAL_PREP_STMT("INSERT INTO hashes (blake2, sha256, sha512) VALUES (@blake2, @sha256, @sha512);", &insert_hashes); + LOCAL_PREP_STMT("INSERT INTO hashes (blake2, sha256, sha512) VALUES (?, ?, ?);", &insert_hashes); LOCAL_PREP_STMT("INSERT INTO fileinfo (p_id, fn_id, h_id, size, last_seen, stat_struct) " "VALUES (?, ?, ?, ?, ?, ?);", &insert_fileinfo); @@ -424,17 +424,17 @@ int64_t dbi_select_hashes_by_strings(const char *blake2, const char *sha256, con sqlite3_clear_bindings(st); sqlite3_reset(st); - if (sqlite3_bind_text(st, sqlite3_bind_parameter_index(st, "blake2"), blake2, -1, SQLITE_TRANSIENT) != SQLITE_OK) { + if (sqlite3_bind_text(st, 1, blake2, -1, SQLITE_TRANSIENT) != SQLITE_OK) { LOGERR("ERROR: Failed to bind field blake2 to prepared statement: %s\n", sqlite3_errmsg(dbconn)); return -2; } - if (sqlite3_bind_text(st, sqlite3_bind_parameter_index(st, "sha256"), sha256, -1, SQLITE_TRANSIENT) != SQLITE_OK) { + if (sqlite3_bind_text(st, 2, sha256, -1, SQLITE_TRANSIENT) != SQLITE_OK) { LOGERR("ERROR: Failed to bind field sha256 to prepared statement: %s\n", sqlite3_errmsg(dbconn)); return -2; } - if (sqlite3_bind_text(st, sqlite3_bind_parameter_index(st, "sha512"), sha512, -1, SQLITE_TRANSIENT) != SQLITE_OK) { + if (sqlite3_bind_text(st, 3, sha512, -1, SQLITE_TRANSIENT) != SQLITE_OK) { LOGERR("ERROR: Failed to bind field sha512 to prepared statement: %s\n", sqlite3_errmsg(dbconn)); return -2; } @@ -479,17 +479,17 @@ int dbi_insert_hashes(const char *blake2, const char *sha256, const char *sha512 sqlite3_clear_bindings(st); sqlite3_reset(st); - if (sqlite3_bind_text(st, sqlite3_bind_parameter_index(st, "blake2"), blake2, -1, SQLITE_TRANSIENT) != SQLITE_OK) { + if (sqlite3_bind_text(st, 1, blake2, -1, SQLITE_TRANSIENT) != SQLITE_OK) { LOGERR("ERROR: Failed to bind field blake2 to prepared statement: %s\n", sqlite3_errmsg(dbconn)); return -2; } - if (sqlite3_bind_text(st, sqlite3_bind_parameter_index(st, "sha256"), sha256, -1, SQLITE_TRANSIENT) != SQLITE_OK) { + if (sqlite3_bind_text(st, 2, sha256, -1, SQLITE_TRANSIENT) != SQLITE_OK) { LOGERR("ERROR: Failed to bind field sha256 to prepared statement: %s\n", sqlite3_errmsg(dbconn)); return -2; } - if (sqlite3_bind_text(st, sqlite3_bind_parameter_index(st, "sha512"), sha512, -1, SQLITE_TRANSIENT) != SQLITE_OK) { + if (sqlite3_bind_text(st, 3, sha512, -1, SQLITE_TRANSIENT) != SQLITE_OK) { LOGERR("ERROR: Failed to bind field sha512 to prepared statement: %s\n", sqlite3_errmsg(dbconn)); return -2; } |