Lines Matching refs:sql
735 char *sql;
739 sql = sqlite_mprintf("SELECT * FROM hosts");
740 if (sql == NULL)
745 sqlite_freemem(sql);
749 rc = sqlite_compile(db, sql, NULL, &vm, &errmsg);
750 sqlite_freemem(sql);
992 char *sql;
998 sql = sqlite_mprintf("SELECT * FROM db_info");
999 if (sql == NULL)
1004 sqlite_freemem(sql);
1008 rc = sqlite_get_table(db, sql, &result, &nrow, &ncol, &errmsg);
1009 sqlite_freemem(sql);
1038 sql = sqlite_mprintf("SELECT hostname FROM hosts");
1039 if (sql == NULL) {
1044 rc = sqlite_get_table(db, sql, &result, &nrow, &ncol, &errmsg);
1045 sqlite_freemem(sql);
1069 char *sql;
1073 sql = sqlite_mprintf("REPLACE INTO hosts (hostname, comment, ifnames)"
1075 if (sql == NULL)
1080 sqlite_freemem(sql);
1084 rc = sqlite_exec(db, sql, NULL, NULL, &errmsg);
1085 sqlite_freemem(sql);
1102 char *sql;
1106 sql = sqlite_mprintf("DELETE FROM hosts WHERE hostname = '%s'", host);
1107 if (sql == NULL)
1112 sqlite_freemem(sql);
1116 rc = sqlite_exec(db, sql, NULL, NULL, &errmsg);
1117 sqlite_freemem(sql);
1139 char *sql;
1142 sql = sqlite_mprintf("INSERT INTO db_info (ver_major, ver_minor,"
1146 if (sql == NULL)
1149 rc = sqlite_exec(db, sql, NULL, NULL, &errmsg);
1150 sqlite_freemem(sql);