Lines Matching defs:stmt
452 static inline void sqlite_bind_text(sqlite3_stmt *stmt, const char *field, const char *var, int len)
454 if (sqlite3_bind_text(stmt, sqlite3_bind_parameter_index(stmt, field), var, len, SQLITE_STATIC) != SQLITE_OK)
458 static inline void sqlite_bind_int64(sqlite3_stmt *stmt, const char *field, long long var)
460 if (sqlite3_bind_int64(stmt, sqlite3_bind_parameter_index(stmt, field), var) != SQLITE_OK)
464 static inline void sqlite_prepare(const char *sql, sqlite3_stmt **stmt)
468 ret = sqlite3_prepare_v2(semind_db, sql, -1, stmt, NULL);
474 static inline void sqlite_prepare_persistent(const char *sql, sqlite3_stmt **stmt)
478 ret = sqlite3_prepare_v3(semind_db, sql, -1, SQLITE_PREPARE_PERSISTENT, stmt, NULL);
484 static inline void sqlite_reset_stmt(sqlite3_stmt *stmt)
489 sqlite3_clear_bindings(stmt);
490 sqlite3_reset(stmt);
493 static int sqlite_run(sqlite3_stmt *stmt)
495 int ret = sqlite3_step(stmt);
497 semind_error(1, 0, "unable to process query: %s: %s", sqlite3_errmsg(semind_db), sqlite3_sql(stmt));
503 sqlite3_stmt *stmt;
504 sqlite_prepare(sql, &stmt);
505 sqlite_run(stmt);
506 sqlite3_finalize(stmt);
511 sqlite3_stmt *stmt;
514 sqlite_prepare("PRAGMA user_version", &stmt);
515 sqlite_run(stmt);
516 dbversion = sqlite3_column_int64(stmt, 0);
517 sqlite3_finalize(stmt);
843 sqlite3_stmt *stmt;
846 sqlite_prepare("DELETE FROM file WHERE name GLOB @file", &stmt);
849 message("SQL: %s", sqlite3_sql(stmt));
852 sqlite_bind_text(stmt, "@file", argv[i], -1);
853 sqlite_run(stmt);
854 sqlite_reset_stmt(stmt);
857 sqlite3_finalize(stmt);