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