Lines Matching refs:execute

4041 …cur.execute("CREATE TABLE users(identity TEXT PRIMARY KEY, methods TEXT, password TEXT, remediatio…
4042         cur.execute("CREATE TABLE wildcards(identity TEXT PRIMARY KEY, methods TEXT)")
4043 …cur.execute("INSERT INTO users(identity,methods,password,phase2,remediation) VALUES ('user-mschapv…
4044         cur.execute("INSERT INTO wildcards(identity,methods) VALUES ('','TTLS,TLS')")
4045 …cur.execute("CREATE TABLE authlog(timestamp TEXT, session TEXT, nas_ip TEXT, username TEXT, note T…
4081             cur.execute("SELECT * from authlog")
4105 …cur.execute("CREATE TABLE users(identity TEXT PRIMARY KEY, methods TEXT, password TEXT, remediatio…
4106         cur.execute("CREATE TABLE wildcards(identity TEXT PRIMARY KEY, methods TEXT)")
4107         cur.execute("INSERT INTO wildcards(identity,methods) VALUES ('1','SIM')")
4108 …cur.execute("CREATE TABLE authlog(timestamp TEXT, session TEXT, nas_ip TEXT, username TEXT, note T…
4109 …cur.execute("CREATE TABLE current_sessions(mac_addr TEXT PRIMARY KEY, identity TEXT, start_time TE…
4159             cur.execute("SELECT * from authlog")
4166             cur.execute("SELECT * from sim_provisioning")
6366 …cur.execute("CREATE TABLE users(identity TEXT PRIMARY KEY, methods TEXT, password TEXT, remediatio…
6367         cur.execute("CREATE TABLE wildcards(identity TEXT PRIMARY KEY, methods TEXT)")
6368 …cur.execute("INSERT INTO users(identity,methods,password,phase2) VALUES ('user-mschapv2','TTLS-MSC…
6369         cur.execute("INSERT INTO wildcards(identity,methods) VALUES ('','TTLS,TLS')")
6370 …cur.execute("CREATE TABLE authlog(timestamp TEXT, session TEXT, nas_ip TEXT, username TEXT, note T…
6371         cur.execute("CREATE TABLE pending_tc(mac_addr TEXT PRIMARY KEY, identity TEXT)")
6372 …cur.execute("CREATE TABLE current_sessions(mac_addr TEXT PRIMARY KEY, identity TEXT, start_time TE…
6423             cur.execute("SELECT * from current_sessions")
6445             cur.execute("SELECT * from current_sessions")
6460             cur.execute("SELECT identity FROM pending_tc WHERE mac_addr='" +
6468             cur.execute("UPDATE users SET t_c_timestamp=123456789 WHERE identity='user-mschapv2'")
6510             cur.execute("UPDATE users SET t_c_timestamp=123456790 WHERE identity='user-mschapv2'")