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()
2398 char *sql; in add_subscription() local
2442 sql = sqlite3_mprintf("UPDATE eventlog SET user=%Q, realm=%Q WHERE " in add_subscription()
2445 if (sql) { in add_subscription()
2446 debug_print(ctx, 1, "DB: %s", sql); in add_subscription()
2447 if (sqlite3_exec(ctx->db, sql, NULL, NULL, NULL) != SQLITE_OK) { in add_subscription()
2452 sqlite3_free(sql); in add_subscription()
2469 …sql = sqlite3_mprintf("INSERT INTO users(identity,realm,phase2,methods,cert,cert_pem,machine_manag… in add_subscription()
2480 if (sql == NULL) in add_subscription()
2482 debug_print(ctx, 1, "DB: %s", sql); in add_subscription()
2483 if (sqlite3_exec(ctx->db, sql, NULL, NULL, NULL) != SQLITE_OK) { in add_subscription()
2486 sqlite3_free(sql); in add_subscription()
2489 sqlite3_free(sql); in add_subscription()
2496 …sql = sqlite3_mprintf("DELETE FROM users WHERE identity=%Q AND realm=%Q AND (phase2=1 OR methods='… in add_subscription()
2498 if (sql) { in add_subscription()
2499 debug_print(ctx, 1, "DB: %s", sql); in add_subscription()
2500 sqlite3_exec(ctx->db, sql, NULL, NULL, NULL); in add_subscription()
2501 sqlite3_free(sql); in add_subscription()
2530 …sql = sqlite3_mprintf("INSERT OR REPLACE INTO cert_enroll (mac_addr,user,realm,serialnum) VALUES(%… in add_subscription()
2534 if (sql) { in add_subscription()
2535 debug_print(ctx, 1, "DB: %s", sql); in add_subscription()
2536 if (sqlite3_exec(ctx->db, sql, NULL, NULL, NULL) != in add_subscription()
2542 sqlite3_free(sql); in add_subscription()
2549 sql = sqlite3_mprintf("DELETE FROM sim_provisioning WHERE mobile_identifier_hash=%Q", in add_subscription()
2551 if (sql) { in add_subscription()
2552 debug_print(ctx, 1, "DB: %s", sql); in add_subscription()
2553 if (sqlite3_exec(ctx->db, sql, NULL, NULL, NULL) != in add_subscription()
2559 sqlite3_free(sql); in add_subscription()