Lines Matching refs:sql

803 	char *sql;  in smb_lgrp_iteropen()  local
814 sql = sqlite_mprintf("SELECT * FROM groups"); in smb_lgrp_iteropen()
815 if (sql == NULL) { in smb_lgrp_iteropen()
822 sqlite_freemem(sql); in smb_lgrp_iteropen()
827 rc = sqlite_compile(iter->sgi_db, sql, NULL, &iter->sgi_vm, &errmsg); in smb_lgrp_iteropen()
828 sqlite_freemem(sql); in smb_lgrp_iteropen()
1321 char *sql; in smb_lgrp_gtbl_lookup() local
1337 sql = sqlite_mprintf("SELECT * FROM groups WHERE name = '%s'", in smb_lgrp_gtbl_lookup()
1357 sql = sqlite_mprintf("SELECT * FROM groups " in smb_lgrp_gtbl_lookup()
1368 if (sql == NULL) in smb_lgrp_gtbl_lookup()
1371 rc = sqlite_get_table(db, sql, &result, &nrow, &ncol, &errmsg); in smb_lgrp_gtbl_lookup()
1372 sqlite_freemem(sql); in smb_lgrp_gtbl_lookup()
1405 char *sql; in smb_lgrp_gtbl_exists() local
1413 sql = sqlite_mprintf("SELECT name FROM groups WHERE name = '%s'", in smb_lgrp_gtbl_exists()
1415 rc = sqlite_get_table(db, sql, &result, &nrow, &ncol, &errmsg); in smb_lgrp_gtbl_exists()
1416 sqlite_freemem(sql); in smb_lgrp_gtbl_exists()
1439 char *sql; in smb_lgrp_gtbl_count() local
1448 sql = sqlite_mprintf("SELECT sid_idx FROM groups WHERE sid_idx = %d", in smb_lgrp_gtbl_count()
1450 rc = sqlite_get_table(db, sql, &result, &nrow, &ncol, &errmsg); in smb_lgrp_gtbl_count()
1451 sqlite_freemem(sql); in smb_lgrp_gtbl_count()
1481 char *sql; in smb_lgrp_gtbl_insert() local
1495 sql = sqlite_mprintf("INSERT INTO groups " in smb_lgrp_gtbl_insert()
1503 if (sql == NULL) in smb_lgrp_gtbl_insert()
1506 rc = sqlite_exec(db, sql, NULL, NULL, &errmsg); in smb_lgrp_gtbl_insert()
1507 sqlite_freemem(sql); in smb_lgrp_gtbl_insert()
1530 char *sql; in smb_lgrp_gtbl_delete() local
1536 sql = sqlite_mprintf("DELETE FROM groups WHERE name = '%s'", gname); in smb_lgrp_gtbl_delete()
1537 if (sql == NULL) in smb_lgrp_gtbl_delete()
1540 rc = sqlite_exec(db, sql, NULL, NULL, &errmsg); in smb_lgrp_gtbl_delete()
1541 sqlite_freemem(sql); in smb_lgrp_gtbl_delete()
1565 char *sql; in smb_lgrp_gtbl_update() local
1579 sql = sqlite_mprintf("UPDATE groups SET name = '%s' " in smb_lgrp_gtbl_update()
1584 sql = sqlite_mprintf("UPDATE groups SET comment = '%q' " in smb_lgrp_gtbl_update()
1592 if (sql == NULL) in smb_lgrp_gtbl_update()
1595 rc = sqlite_exec(db, sql, NULL, NULL, &errmsg); in smb_lgrp_gtbl_update()
1596 sqlite_freemem(sql); in smb_lgrp_gtbl_update()
1624 char *sql; in smb_lgrp_gtbl_update_mlist() local
1632 sql = sqlite_mprintf("SELECT n_members, members FROM groups " in smb_lgrp_gtbl_update_mlist()
1635 if (sql == NULL) in smb_lgrp_gtbl_update_mlist()
1638 rc = sqlite_get_table(db, sql, &result, &nrow, &ncol, &errmsg); in smb_lgrp_gtbl_update_mlist()
1639 sqlite_freemem(sql); in smb_lgrp_gtbl_update_mlist()
1686 sql = sqlite_mprintf("UPDATE groups SET n_members = %u, members = '%s'" in smb_lgrp_gtbl_update_mlist()
1691 if (sql == NULL) in smb_lgrp_gtbl_update_mlist()
1694 rc = sqlite_exec(db, sql, NULL, NULL, &errmsg); in smb_lgrp_gtbl_update_mlist()
1695 sqlite_freemem(sql); in smb_lgrp_gtbl_update_mlist()
1719 char *sql; in smb_lgrp_gtbl_update_plist() local
1730 sql = sqlite_mprintf("SELECT n_privs, privs FROM groups " in smb_lgrp_gtbl_update_plist()
1733 if (sql == NULL) in smb_lgrp_gtbl_update_plist()
1736 rc = sqlite_get_table(db, sql, &result, &nrow, &ncol, &errmsg); in smb_lgrp_gtbl_update_plist()
1737 sqlite_freemem(sql); in smb_lgrp_gtbl_update_plist()
1769 sql = sqlite_mprintf("UPDATE groups SET n_privs = %u, privs = '%q'" in smb_lgrp_gtbl_update_plist()
1775 if (sql == NULL) in smb_lgrp_gtbl_update_plist()
1778 rc = sqlite_exec(db, sql, NULL, NULL, &errmsg); in smb_lgrp_gtbl_update_plist()
1779 sqlite_freemem(sql); in smb_lgrp_gtbl_update_plist()
1804 char *sql; in smb_lgrp_dtbl_insert() local
1807 sql = sqlite_mprintf("INSERT INTO domains (dom_sid, dom_cnt)" in smb_lgrp_dtbl_insert()
1809 if (sql == NULL) in smb_lgrp_dtbl_insert()
1812 rc = sqlite_exec(db, sql, NULL, NULL, &errmsg); in smb_lgrp_dtbl_insert()
1813 sqlite_freemem(sql); in smb_lgrp_dtbl_insert()
1844 char *sql; in smb_lgrp_dtbl_getidx() local
1864 sql = sqlite_mprintf("SELECT dom_idx FROM domains WHERE dom_sid = '%s'", in smb_lgrp_dtbl_getidx()
1866 if (sql == NULL) in smb_lgrp_dtbl_getidx()
1869 rc = sqlite_get_table(db, sql, &result, &nrow, &ncol, &errmsg); in smb_lgrp_dtbl_getidx()
1870 sqlite_freemem(sql); in smb_lgrp_dtbl_getidx()
1910 char *sql; in smb_lgrp_dtbl_getsid() local
1913 sql = sqlite_mprintf("SELECT dom_sid FROM domains WHERE dom_idx = %u", in smb_lgrp_dtbl_getsid()
1915 if (sql == NULL) in smb_lgrp_dtbl_getsid()
1918 rc = sqlite_get_table(db, sql, &result, &nrow, &ncol, &errmsg); in smb_lgrp_dtbl_getsid()
1919 sqlite_freemem(sql); in smb_lgrp_dtbl_getsid()
1957 char *sql; in smb_lgrp_db_setinfo() local
1960 sql = sqlite_mprintf("INSERT INTO db_info (ver_major, ver_minor," in smb_lgrp_db_setinfo()
1964 if (sql == NULL) in smb_lgrp_db_setinfo()
1967 rc = sqlite_exec(db, sql, NULL, NULL, &errmsg); in smb_lgrp_db_setinfo()
1968 sqlite_freemem(sql); in smb_lgrp_db_setinfo()