Home
last modified time | relevance | path

Searched refs:sql (Results 1 – 25 of 37) sorted by relevance

12

/illumos-gate/usr/src/lib/libsqlite/test/
H A Dtester.tcl193 proc execsql {sql {db db}} {
195 return [$db eval $sql]
200 proc catchsql {sql {db db}} {
202 set r [catch {$db eval $sql} msg]
209 proc explain {sql {db db}} {
213 $db eval "explain $sql" {} {
221 proc execsql2 {sql} { argument
223 db eval $sql data {
233 proc stepsql {dbptr sql} { argument
234 set sql [string trim $sql]
[all …]
H A Dtableapi.test168 set sql "CREATE TABLE t2("
171 append sql ${sep}x$i
174 append sql )
175 sqlite_get_table_printf $::dbx $sql {}
176 set sql "INSERT INTO t2 VALUES("
179 append sql ${sep}$i
182 append sql )
183 sqlite_get_table_printf $::dbx $sql {}
187 set sql "INSERT INTO t2 VALUES("
190 append sql ${sep}[expr {$i+1000}]
[all …]
H A Dinterrupt.test24 set txt [$db eval {SELECT name, type, sql FROM sqlite_master}]\n
36 # This routine attempts to execute the sql in $sql. It triggers an
41 proc interrupt_test {testid sql result {initcnt 0} {maxcnt 1000000}} {
52 } [list $sql]] 1
154 set sql {
158 execsql $sql
163 catchsql $sql
H A Djoin3_28.test29 set sql "SELECT * FROM t1"
30 for {set i 2} {$i<=$N} {incr i} {append sql ", t$i"}
31 execsql $sql
H A Dtable.test30 SELECT sql FROM sqlite_master WHERE type!='meta'
167 execsql {SELECT sql FROM sqlite_master WHERE type=='table'}
200 set sql "CREATE TABLE [format test%03d $i] ("
202 append sql "field$k text,"
204 append sql "last_field text)"
205 execsql $sql
224 set sql "DROP TABLE [format TEST%03d $i]"
225 execsql $sql
235 set sql "DROP TABLE [format test%03d $i]"
236 execsql $sql
[all …]
H A Drowid.test42 set sql "SELECT x FROM t1 WHERE rowid==$x2rowid(1)"
43 execsql $sql
47 set sql "SELECT x FROM t1 WHERE rowid==$x2rowid(3)"
48 execsql $sql
52 set sql "SELECT x FROM t1 WHERE oid==$x2rowid(1)"
53 execsql $sql
57 set sql "SELECT x FROM t1 WHERE OID==$x2rowid(3)"
58 execsql $sql
62 set sql "SELECT x FROM t1 WHERE _rowid_==$x2rowid(1)"
63 execsql $sql
[all …]
H A Dbigrow.test45 set sql "INSERT INTO t1 VALUES('abc',"
46 append sql "'$::big1', 'xyz');"
47 execsql $sql
55 set sql "INSERT INTO t1 VALUES('abc2',"
56 append sql "'$::big2', 'xyz2');"
57 set r [catch {execsql $sql} msg]
H A Dselect2.test35 set sql {SELECT DISTINCT f1 FROM tbl1 ORDER BY f1}
37 db eval $sql data {
49 set sql {SELECT DISTINCT f1 FROM tbl1 WHERE f1>3 AND f1<5}
51 db eval $sql data {
H A Dtrans.test690 execsql {SELECT md5sum(type,name,tbl_name,rootpage,sql) FROM sqlite_master}
698 execsql {SELECT md5sum(type,name,tbl_name,rootpage,sql) FROM sqlite_master}
742 execsql {SELECT md5sum(type,name,tbl_name,rootpage,sql) FROM sqlite_master}
754 execsql {SELECT md5sum(type,name,tbl_name,rootpage,sql) FROM sqlite_master}
769 execsql {SELECT md5sum(type,name,tbl_name,rootpage,sql) FROM sqlite_master}
780 execsql {SELECT md5sum(type,name,tbl_name,rootpage,sql) FROM sqlite_master}
806 execsql {SELECT md5sum(type,name,tbl_name,rootpage,sql) FROM sqlite_master}
/illumos-gate/usr/src/lib/smbsrv/libsmb/common/
H A Dsmb_lgrp.c803 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()
[all …]
H A Dsmb_nic.c735 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()
[all …]
/illumos-gate/usr/src/tools/smatch/src/smatch_data/db/
H A Dfill_db_caller_info.pl67 my ($fn, $dummy, $sql);
85 ($dummy, $dummy, $sql) = split(/:/, $_, 3);
87 if ($sql =~ /%call_marker%/) {
88 $sql =~ s/%call_marker%//; # don't need this taking space in the db.
91 $sql =~ s/%CALL_ID%/$call_id/;
93 $db->do($sql);
H A Dfill_db_sql.pl22 my ($dummy, $sql);
30 ($dummy, $dummy, $sql) = split(/:/, $_, 3);
32 $db->do($sql);
42 ($dummy, $dummy, $sql) = split(/:/, $_, 3);
44 $db->do($sql);
H A Dcreate_db.sh27 if [ -e ${info_file}.sql ] ; then
28 ${bin_dir}/fill_db_sql.pl "$PROJ" ${info_file}.sql $db_file
H A Dfill_db_type_size.pl133 my $sql = "insert into type_size values ('$type', '$printed_range');";
134 $db->do($sql);
H A Dfill_db_type_value.pl137 my $sql = "insert into type_value values ('$type', '$printed_range');";
138 $db->do($sql);
/illumos-gate/usr/src/lib/libsqlite/tool/
H A Dspeedtest2.tcl16 set sql [string trim [read $fd [file size $sqlfile]]]
18 set sx [split $sql \n]
21 set sql {}
22 for {set i 0} {$i<3} {incr i} {append sql [lindex $sx $i]<br>\n}
23 append sql "<i>... [expr {$n-6}] lines omitted</i><br>\n"
25 append sql [lindex $sx $i]<br>\n
28 regsub -all \n [string trim $sql] <br> sql
31 puts "$sql"
H A Dspeedtest.tcl16 set sql [string trim [read $fd [file size $sqlfile]]]
18 set sx [split $sql \n]
21 set sql {}
22 for {set i 0} {$i<3} {incr i} {append sql [lindex $sx $i]<br>\n}
23 append sql "<i>... [expr {$n-6}] lines omitted</i><br>\n"
25 append sql [lindex $sx $i]<br>\n
28 regsub -all \n [string trim $sql] <br> sql
31 puts "$sql"
H A Dspace_used.tcl36 set sql {
53 foreach {name type rootpage} [db eval $sql] {
H A Dspaceanal.tcl53 set sql {
63 foreach {name tblname type rootpage} [db eval $sql] {
100 set sql "INSERT INTO space_used VALUES('$name'"
102 append sql ",'$tblname',[expr {$type=="index"}],$n_entry"
103 append sql ",$size,$mx_size,$cnt_ovfl,"
104 append sql "$n_primary,$n_overflow,$unused_primary,$unused_ovfl);"
105 mem eval $sql
/illumos-gate/usr/src/cmd/idmap/idmapd/
H A Ddbutils.c219 static int sql_exec_tran_no_cb(sqlite *db, char *sql, const char *dbname,
229 const char *detect_version_sql, char * const *sql, in init_db_instance() argument
309 sql[curr_version]); in init_db_instance()
311 rc = sql_exec_tran_no_cb(db, sql[curr_version], dbname, in init_db_instance()
496 char *sql[4]; in init_dbs() local
500 sql[0] = DB_INSTALL_SQL; in init_dbs()
501 sql[1] = DB_UPGRADE_FROM_v1_SQL; in init_dbs()
502 sql[2] = NULL; in init_dbs()
504 if (init_db_instance(IDMAP_DBNAME, DB_VERSION, DB_VERSION_SQL, sql, in init_dbs()
509 sql[0] = CACHE_INSTALL_SQL; in init_dbs()
[all …]
H A Dserver.c61 #define PROCESS_LIST_SVC_SQL(rcode, db, dbname, sql, limit, flag, cb, res, len)\ argument
62 rcode = process_list_svc_sql(db, dbname, sql, limit, flag, cb, res);\
666 char *sql = NULL; in idmap_list_mappings_1_svc() local
707 sql = sqlite_mprintf("SELECT rowid, sidprefix, rid, pid, w2u, " in idmap_list_mappings_1_svc()
716 if (sql == NULL) { in idmap_list_mappings_1_svc()
723 PROCESS_LIST_SVC_SQL(retcode, cache, IDMAP_CACHENAME, sql, limit, in idmap_list_mappings_1_svc()
730 if (sql) in idmap_list_mappings_1_svc()
731 sqlite_freemem(sql); in idmap_list_mappings_1_svc()
818 char *sql = NULL; in idmap_list_namerules_1_svc() local
857 sql = sqlite_mprintf("SELECT rowid, is_user, is_wuser, windomain, " in idmap_list_namerules_1_svc()
[all …]
/illumos-gate/usr/src/tools/smatch/src/smatch_scripts/
H A Dtest_kernel.sh72 find -name \*.c.smatch.sql -exec cat \{\} \; -exec rm \{\} \; > $WLOG.sql
/illumos-gate/usr/src/tools/smatch/src/
H A Dsmatch.h925 …exec(struct sqlite3 *db, int (*callback)(void*, int, char**, char**), void *data, const char *sql);
927 #define sql_helper(db, call_back, data, sql...) \ argument
931 sqlite3_snprintf(sizeof(sql_txt), sql_txt, sql); \
937 #define run_sql(call_back, data, sql...) \ argument
941 sql_helper(smatch_db, call_back, data, sql); \
944 #define mem_sql(call_back, data, sql...) \ argument
945 sql_helper(mem_db, call_back, data, sql)
947 #define cache_sql(call_back, data, sql...) \ argument
948 sql_helper(cache_db, call_back, data, sql)
/illumos-gate/usr/src/uts/common/os/
H A Dstrsubr.c4585 syncql_t *sql, *sql2; in strlock() local
4645 for (sql = sqlist->sqlist_head; sql; sql = sql->sql_next) { in strlock()
4646 syncq_t *sq = sql->sql_sq; in strlock()
4669 for (sql2 = sqlist->sqlist_head; sql2 != sql; in strlock()
4708 syncql_t *sql; in strunlock() local
4725 for (sql = sqlist->sqlist_head; sql; sql = sql->sql_next) { in strunlock()
4726 SQ_PUTLOCKS_EXIT(sql->sql_sq); in strunlock()
4727 mutex_exit(SQLOCK(sql->sql_sq)); in strunlock()
5288 syncql_t *sql; in strblock() local
5301 for (sql = sqlist->sqlist_head; sql != NULL; sql = sql->sql_next) in strblock()
[all …]

12