Lines Matching refs:appendText

833 static void appendText(ShellText *p, const char *zAppend, char quote){  function
911     appendText(&s, zSchema, cQuote);
912     appendText(&s, ".", 0);
915   appendText(&s, zName, cQuote);
919     appendText(&s, zDiv, 0);
923     appendText(&s, zCol, cQuote);
925   appendText(&s, ")", 0);
2550   if( p->n ) appendText(p, "|", 0);
2552     if( i ) appendText(p, ",", 0);
2553     if( azArg[i] ) appendText(p, azArg[i], 0);
4223     appendText(&sTable, zTable, quoteChar(zTable));
4229       appendText(&sTable, "(", 0);
4230       appendText(&sTable, azCol[0], 0);
4232         appendText(&sTable, ",", 0);
4233         appendText(&sTable, azCol[i], quoteChar(azCol[i]));
4235       appendText(&sTable, ")", 0);
4240     appendText(&sSelect, "SELECT ", 0);
4242       appendText(&sSelect, azCol[0], 0);
4243       appendText(&sSelect, ",", 0);
4246       appendText(&sSelect, azCol[i], quoteChar(azCol[i]));
4248         appendText(&sSelect, ",", 0);
4252     appendText(&sSelect, " FROM ", 0);
4253     appendText(&sSelect, zTable, quoteChar(zTable));
9605       appendText(&sSelect, "SELECT sql FROM", 0);
9611         appendText(&sSelect, zDiv, 0);
9613         appendText(&sSelect, "SELECT shell_add_schema(sql,", 0);
9615           appendText(&sSelect, zDb, '\'');
9617           appendText(&sSelect, "NULL", 0);
9619         appendText(&sSelect, ",name) AS sql, type, tbl_name, name, rowid,", 0);
9620         appendText(&sSelect, zScNum, 0);
9621         appendText(&sSelect, " AS snum, ", 0);
9622         appendText(&sSelect, zDb, '\'');
9623         appendText(&sSelect, " AS sname FROM ", 0);
9624         appendText(&sSelect, zDb, quoteChar(zDb));
9625         appendText(&sSelect, ".sqlite_schema", 0);
9630         appendText(&sSelect,
9636       appendText(&sSelect, ") WHERE ", 0);
9644           appendText(&sSelect, "lower(printf('%s.%s',sname,tbl_name))", 0);
9646           appendText(&sSelect, "lower(tbl_name)", 0);
9648         appendText(&sSelect, bGlob ? " GLOB " : " LIKE ", 0);
9649         appendText(&sSelect, zQarg, 0);
9651           appendText(&sSelect, " ESCAPE '\\' ", 0);
9653         appendText(&sSelect, " AND ", 0);
9657         appendText(&sSelect, "name NOT LIKE 'sqlite_%%' AND ", 0);
9659       appendText(&sSelect, "sql IS NOT NULL"
9952     appendText(&str, "x", 0);
10095     appendText(&sSql, "WITH [sha3sum$query](a,b) AS(",0);
10102         appendText(&sQuery,"SELECT * FROM ", 0);
10103         appendText(&sQuery,zTab,'"');
10104         appendText(&sQuery," NOT INDEXED;", 0);
10106         appendText(&sQuery,"SELECT type,name,tbl_name,sql FROM sqlite_schema"
10109         appendText(&sQuery,"SELECT name,seq FROM sqlite_sequence"
10112         appendText(&sQuery,"SELECT tbl,idx,stat FROM sqlite_stat1"
10115         appendText(&sQuery, "SELECT * FROM ", 0);
10116         appendText(&sQuery, zTab, 0);
10117         appendText(&sQuery, " ORDER BY tbl, idx, rowid;\n", 0);
10119       appendText(&sSql, zSep, 0);
10120       appendText(&sSql, sQuery.z, '\'');
10122       appendText(&sSql, ",", 0);
10123       appendText(&sSql, zTab, '\'');
10274       if( s.z && s.z[0] ) appendText(&s, " UNION ALL ", 0);
10276         appendText(&s, "SELECT name FROM ", 0);
10278         appendText(&s, "SELECT ", 0);
10279         appendText(&s, zDbName, '\'');
10280         appendText(&s, "||'.'||name FROM ", 0);
10282       appendText(&s, zDbName, '"');
10283       appendText(&s, ".sqlite_schema ", 0);
10285         appendText(&s," WHERE type IN ('table','view')"
10289         appendText(&s," WHERE type='index'"
10295       appendText(&s, " ORDER BY 1", 0);