Lines Matching refs:sSelect
14901 ShellText sSelect; in dump_callback() local
14933 initText(&sSelect); in dump_callback()
14934 appendText(&sSelect, "SELECT ", 0); in dump_callback()
14936 appendText(&sSelect, azCol[0], 0); in dump_callback()
14937 appendText(&sSelect, ",", 0); in dump_callback()
14940 appendText(&sSelect, azCol[i], quoteChar(azCol[i])); in dump_callback()
14942 appendText(&sSelect, ",", 0); in dump_callback()
14946 appendText(&sSelect, " FROM ", 0); in dump_callback()
14947 appendText(&sSelect, zTable, quoteChar(zTable)); in dump_callback()
14953 rc = shell_exec(p, sSelect.z, 0); in dump_callback()
14957 shell_exec(p, sSelect.z, 0); in dump_callback()
14963 freeText(&sSelect); in dump_callback()
20458 ShellText sSelect; in do_meta_command() local
20472 initText(&sSelect); in do_meta_command()
20524 appendText(&sSelect, "SELECT sql FROM", 0); in do_meta_command()
20530 appendText(&sSelect, zDiv, 0); in do_meta_command()
20532 appendText(&sSelect, "SELECT shell_add_schema(sql,", 0); in do_meta_command()
20534 appendText(&sSelect, zDb, '\''); in do_meta_command()
20536 appendText(&sSelect, "NULL", 0); in do_meta_command()
20538 appendText(&sSelect, ",name) AS sql, type, tbl_name, name, rowid,", 0); in do_meta_command()
20539 appendText(&sSelect, zScNum, 0); in do_meta_command()
20540 appendText(&sSelect, " AS snum, ", 0); in do_meta_command()
20541 appendText(&sSelect, zDb, '\''); in do_meta_command()
20542 appendText(&sSelect, " AS sname FROM ", 0); in do_meta_command()
20543 appendText(&sSelect, zDb, quoteChar(zDb)); in do_meta_command()
20544 appendText(&sSelect, ".sqlite_schema", 0); in do_meta_command()
20549 appendText(&sSelect, in do_meta_command()
20555 appendText(&sSelect, ") WHERE ", 0); in do_meta_command()
20561 appendText(&sSelect, "lower(printf('%s.%s',sname,tbl_name))", 0); in do_meta_command()
20563 appendText(&sSelect, "lower(tbl_name)", 0); in do_meta_command()
20565 appendText(&sSelect, bGlob ? " GLOB " : " LIKE ", 0); in do_meta_command()
20566 appendText(&sSelect, zQarg, 0); in do_meta_command()
20568 appendText(&sSelect, " ESCAPE '\\' ", 0); in do_meta_command()
20570 appendText(&sSelect, " AND ", 0); in do_meta_command()
20574 appendText(&sSelect, "name NOT LIKE 'sqlite_%%' AND ", 0); in do_meta_command()
20576 appendText(&sSelect, "sql IS NOT NULL" in do_meta_command()
20579 utf8_printf(p->out, "SQL: %s;\n", sSelect.z); in do_meta_command()
20581 rc = sqlite3_exec(p->db, sSelect.z, callback, &data, &zErrMsg); in do_meta_command()
20583 freeText(&sSelect); in do_meta_command()