Lines Matching refs:sql
70 char *sql; in db_add_session() local
78 sql = sqlite3_mprintf("INSERT INTO sessions(timestamp,id,user,realm," in db_add_session()
87 if (sql == NULL) in db_add_session()
89 debug_print(ctx, 1, "DB: %s", sql); in db_add_session()
90 if (sqlite3_exec(ctx->db, sql, NULL, NULL, NULL) != SQLITE_OK) { in db_add_session()
95 sqlite3_free(sql); in db_add_session()
104 char *sql; in db_update_session_password() local
106 sql = sqlite3_mprintf("UPDATE sessions SET password=%Q WHERE id=%Q AND " in db_update_session_password()
109 if (sql == NULL) in db_update_session_password()
111 debug_print(ctx, 1, "DB: %s", sql); in db_update_session_password()
112 if (sqlite3_exec(ctx->db, sql, NULL, NULL, NULL) != SQLITE_OK) { in db_update_session_password()
116 sqlite3_free(sql); in db_update_session_password()
126 char *sql; in db_update_session_machine_managed() local
128 …sql = sqlite3_mprintf("UPDATE sessions SET machine_managed=%Q WHERE id=%Q AND user=%Q AND realm=%Q… in db_update_session_machine_managed()
130 if (sql == NULL) in db_update_session_machine_managed()
132 debug_print(ctx, 1, "DB: %s", sql); in db_update_session_machine_managed()
133 if (sqlite3_exec(ctx->db, sql, NULL, NULL, NULL) != SQLITE_OK) { in db_update_session_machine_managed()
138 sqlite3_free(sql); in db_update_session_machine_managed()
147 char *sql; in db_add_session_pps() local
152 sql = sqlite3_mprintf("UPDATE sessions SET pps=%Q WHERE id=%Q AND " in db_add_session_pps()
156 if (sql == NULL) in db_add_session_pps()
158 debug_print(ctx, 1, "DB: %s", sql); in db_add_session_pps()
159 if (sqlite3_exec(ctx->db, sql, NULL, NULL, NULL) != SQLITE_OK) { in db_add_session_pps()
163 sqlite3_free(sql); in db_add_session_pps()
171 char *sql; in db_add_session_devinfo() local
176 sql = sqlite3_mprintf("UPDATE sessions SET devinfo=%Q WHERE id=%Q", in db_add_session_devinfo()
179 if (sql == NULL) in db_add_session_devinfo()
181 debug_print(ctx, 1, "DB: %s", sql); in db_add_session_devinfo()
182 if (sqlite3_exec(ctx->db, sql, NULL, NULL, NULL) != SQLITE_OK) { in db_add_session_devinfo()
186 sqlite3_free(sql); in db_add_session_devinfo()
195 char *sql; in db_add_session_devdetail() local
200 sql = sqlite3_mprintf("UPDATE sessions SET devdetail=%Q WHERE id=%Q", in db_add_session_devdetail()
203 if (sql == NULL) in db_add_session_devdetail()
205 debug_print(ctx, 1, "DB: %s", sql); in db_add_session_devdetail()
206 if (sqlite3_exec(ctx->db, sql, NULL, NULL, NULL) != SQLITE_OK) { in db_add_session_devdetail()
210 sqlite3_free(sql); in db_add_session_devdetail()
217 char *sql; in db_add_session_dmacc() local
219 sql = sqlite3_mprintf("UPDATE sessions SET osu_user=%Q, osu_password=%Q WHERE id=%Q", in db_add_session_dmacc()
221 if (!sql) in db_add_session_dmacc()
223 debug_print(ctx, 1, "DB: %s", sql); in db_add_session_dmacc()
224 if (sqlite3_exec(ctx->db, sql, NULL, NULL, NULL) != SQLITE_OK) { in db_add_session_dmacc()
228 sqlite3_free(sql); in db_add_session_dmacc()
236 char *sql; in db_add_session_eap_method() local
238 sql = sqlite3_mprintf("UPDATE sessions SET eap_method=%Q WHERE id=%Q", in db_add_session_eap_method()
240 if (!sql) in db_add_session_eap_method()
242 debug_print(ctx, 1, "DB: %s", sql); in db_add_session_eap_method()
243 if (sqlite3_exec(ctx->db, sql, NULL, NULL, NULL) != SQLITE_OK) { in db_add_session_eap_method()
247 sqlite3_free(sql); in db_add_session_eap_method()
254 char *sql; in db_add_session_id_hash() local
256 sql = sqlite3_mprintf("UPDATE sessions SET mobile_identifier_hash=%Q WHERE id=%Q", in db_add_session_id_hash()
258 if (!sql) in db_add_session_id_hash()
260 debug_print(ctx, 1, "DB: %s", sql); in db_add_session_id_hash()
261 if (sqlite3_exec(ctx->db, sql, NULL, NULL, NULL) != SQLITE_OK) { in db_add_session_id_hash()
265 sqlite3_free(sql); in db_add_session_id_hash()
273 char *sql; in db_remove_session() local
276 sql = sqlite3_mprintf("DELETE FROM sessions WHERE " in db_remove_session()
279 sql = sqlite3_mprintf("DELETE FROM sessions WHERE " in db_remove_session()
283 if (sql == NULL) in db_remove_session()
285 debug_print(ctx, 1, "DB: %s", sql); in db_remove_session()
286 if (sqlite3_exec(ctx->db, sql, NULL, NULL, NULL) != SQLITE_OK) { in db_remove_session()
290 sqlite3_free(sql); in db_remove_session()
299 char *sql; in hs20_eventlog() local
313 sql = sqlite3_mprintf("INSERT INTO eventlog" in hs20_eventlog()
322 if (sql == NULL) in hs20_eventlog()
324 if (sqlite3_exec(ctx->db, sql, NULL, NULL, NULL) != SQLITE_OK) { in hs20_eventlog()
328 sqlite3_free(sql); in hs20_eventlog()
352 char *sql; in db_update_mo_str() local
355 …sql = sqlite3_mprintf("UPDATE users SET %s=%Q WHERE identity=%Q AND realm=%Q AND (phase2=1 OR meth… in db_update_mo_str()
357 if (sql == NULL) in db_update_mo_str()
359 debug_print(ctx, 1, "DB: %s", sql); in db_update_mo_str()
360 if (sqlite3_exec(ctx->db, sql, NULL, NULL, NULL) != SQLITE_OK) { in db_update_mo_str()
364 sqlite3_free(sql); in db_update_mo_str()
2401 char *sql; in add_subscription() local
2445 sql = sqlite3_mprintf("UPDATE eventlog SET user=%Q, realm=%Q WHERE " in add_subscription()
2448 if (sql) { in add_subscription()
2449 debug_print(ctx, 1, "DB: %s", sql); in add_subscription()
2450 if (sqlite3_exec(ctx->db, sql, NULL, NULL, NULL) != SQLITE_OK) { in add_subscription()
2455 sqlite3_free(sql); in add_subscription()
2472 …sql = sqlite3_mprintf("INSERT INTO users(identity,realm,phase2,methods,cert,cert_pem,machine_manag… in add_subscription()
2483 if (sql == NULL) in add_subscription()
2485 debug_print(ctx, 1, "DB: %s", sql); in add_subscription()
2486 if (sqlite3_exec(ctx->db, sql, NULL, NULL, NULL) != SQLITE_OK) { in add_subscription()
2489 sqlite3_free(sql); in add_subscription()
2492 sqlite3_free(sql); in add_subscription()
2499 …sql = sqlite3_mprintf("DELETE FROM users WHERE identity=%Q AND realm=%Q AND (phase2=1 OR methods='… in add_subscription()
2501 if (sql) { in add_subscription()
2502 debug_print(ctx, 1, "DB: %s", sql); in add_subscription()
2503 sqlite3_exec(ctx->db, sql, NULL, NULL, NULL); in add_subscription()
2504 sqlite3_free(sql); in add_subscription()
2533 …sql = sqlite3_mprintf("INSERT OR REPLACE INTO cert_enroll (mac_addr,user,realm,serialnum) VALUES(%… in add_subscription()
2537 if (sql) { in add_subscription()
2538 debug_print(ctx, 1, "DB: %s", sql); in add_subscription()
2539 if (sqlite3_exec(ctx->db, sql, NULL, NULL, NULL) != in add_subscription()
2545 sqlite3_free(sql); in add_subscription()
2552 sql = sqlite3_mprintf("DELETE FROM sim_provisioning WHERE mobile_identifier_hash=%Q", in add_subscription()
2554 if (sql) { in add_subscription()
2555 debug_print(ctx, 1, "DB: %s", sql); in add_subscription()
2556 if (sqlite3_exec(ctx->db, sql, NULL, NULL, NULL) != in add_subscription()
2562 sqlite3_free(sql); in add_subscription()