Lines Matching refs:appendText

851 static void appendText(ShellText *p, const char *zAppend, char quote){
929 appendText(&s, zSchema, cQuote);
930 appendText(&s, ".", 0);
933 appendText(&s, zName, cQuote);
937 appendText(&s, zDiv, 0);
941 appendText(&s, zCol, cQuote);
943 appendText(&s, ")", 0);
16954 if( p->n ) appendText(p, "|", 0);
16956 if( i ) appendText(p, ",", 0);
16957 if( azArg[i] ) appendText(p, azArg[i], 0);
18627 appendText(&sTable, zTable, quoteChar(zTable));
18633 appendText(&sTable, "(", 0);
18634 appendText(&sTable, azCol[0], 0);
18636 appendText(&sTable, ",", 0);
18637 appendText(&sTable, azCol[i], quoteChar(azCol[i]));
18639 appendText(&sTable, ")", 0);
18644 appendText(&sSelect, "SELECT ", 0);
18646 appendText(&sSelect, azCol[0], 0);
18647 appendText(&sSelect, ",", 0);
18650 appendText(&sSelect, azCol[i], quoteChar(azCol[i]));
18652 appendText(&sSelect, ",", 0);
18656 appendText(&sSelect, " FROM ", 0);
18657 appendText(&sSelect, zTable, quoteChar(zTable));
24009 appendText(&sSelect, "SELECT sql FROM", 0);
24015 appendText(&sSelect, zDiv, 0);
24017 appendText(&sSelect, "SELECT shell_add_schema(sql,", 0);
24019 appendText(&sSelect, zDb, '\'');
24021 appendText(&sSelect, "NULL", 0);
24023 appendText(&sSelect, ",name) AS sql, type, tbl_name, name, rowid,", 0);
24024 appendText(&sSelect, zScNum, 0);
24025 appendText(&sSelect, " AS snum, ", 0);
24026 appendText(&sSelect, zDb, '\'');
24027 appendText(&sSelect, " AS sname FROM ", 0);
24028 appendText(&sSelect, zDb, quoteChar(zDb));
24029 appendText(&sSelect, ".sqlite_schema", 0);
24034 appendText(&sSelect,
24040 appendText(&sSelect, ") WHERE ", 0);
24048 appendText(&sSelect, "lower(printf('%s.%s',sname,tbl_name))", 0);
24050 appendText(&sSelect, "lower(tbl_name)", 0);
24052 appendText(&sSelect, bGlob ? " GLOB " : " LIKE ", 0);
24053 appendText(&sSelect, zQarg, 0);
24055 appendText(&sSelect, " ESCAPE '\\' ", 0);
24057 appendText(&sSelect, " AND ", 0);
24061 appendText(&sSelect, "name NOT LIKE 'sqlite_%%' AND ", 0);
24063 appendText(&sSelect, "sql IS NOT NULL"
24356 appendText(&str, "x", 0);
24499 appendText(&sSql, "WITH [sha3sum$query](a,b) AS(",0);
24506 appendText(&sQuery,"SELECT * FROM ", 0);
24507 appendText(&sQuery,zTab,'"');
24508 appendText(&sQuery," NOT INDEXED;", 0);
24510 appendText(&sQuery,"SELECT type,name,tbl_name,sql FROM sqlite_schema"
24513 appendText(&sQuery,"SELECT name,seq FROM sqlite_sequence"
24516 appendText(&sQuery,"SELECT tbl,idx,stat FROM sqlite_stat1"
24519 appendText(&sQuery, "SELECT * FROM ", 0);
24520 appendText(&sQuery, zTab, 0);
24521 appendText(&sQuery, " ORDER BY tbl, idx, rowid;\n", 0);
24523 appendText(&sSql, zSep, 0);
24524 appendText(&sSql, sQuery.z, '\'');
24526 appendText(&sSql, ",", 0);
24527 appendText(&sSql, zTab, '\'');
24678 if( s.z && s.z[0] ) appendText(&s, " UNION ALL ", 0);
24680 appendText(&s, "SELECT name FROM ", 0);
24682 appendText(&s, "SELECT ", 0);
24683 appendText(&s, zDbName, '\'');
24684 appendText(&s, "||'.'||name FROM ", 0);
24686 appendText(&s, zDbName, '"');
24687 appendText(&s, ".sqlite_schema ", 0);
24689 appendText(&s," WHERE type IN ('table','view')"
24693 appendText(&s," WHERE type='index'"
24699 appendText(&s, " ORDER BY 1", 0);