Lines Matching defs:const
216 extern FILE *popen(const char*,const char*);
244 extern char *sqlite3_win32_mbcs_to_utf8_v2(const char *, int);
245 extern char *sqlite3_win32_utf8_to_mbcs_v2(const char *, int);
246 extern LPWSTR sqlite3_win32_utf8_to_unicode(const char *zText);
273 static int cli_strcmp(const char *a, const char *b){
278 static int cli_strncmp(const char *a, const char *b, size_t n){
497 void utf8_printf(FILE *out, const char *zFormat, ...){
550 static void SQLITE_CDECL iotracePrintf(const char *zFormat, ...){
568 static void utf8_width_print(FILE *pOut, int w, const char *zUtf){
595 static int isNumber(const char *z, int *realnum){
623 static int strlen30(const char *z){
624 const char *z2 = z;
633 static int strlenChar(const char *z){
646 static FILE * openChrSource(const char *zFile){
779 static sqlite3_int64 integerValue(const char *zArg){
781 static const struct { char *zSuffix; int iMult; } aMult[] = {
851 static void appendText(ShellText *p, const char *zAppend, char quote){
895 static char quoteChar(const char *zName){
910 const char *zSchema, /* Schema of the database holding the vtab */
911 const char *zName /* The name of the virtual table */
935 const char *zCol = (const char*)sqlite3_column_text(pStmt, 1);
963 const char *zName;
966 zName = (const char*)sqlite3_value_text(apVal[0]);
999 static const char *aPrefix[] = {
1008 const char *zIn = (const char*)sqlite3_value_text(apVal[0]);
1009 const char *zSchema = (const char*)sqlite3_value_text(apVal[1]);
1010 const char *zName = (const char*)sqlite3_value_text(apVal[2]);
1205 extern const char *windirent_getenv(const char *name);
1212 extern LPDIR opendir(const char *dirname);
1243 const char *windirent_getenv(
1244 const char *name
1271 const char *dirname
1614 static const u64 RC[] = {
1962 const unsigned char *aData,
1968 if( (p->nLoaded % 8)==0 && ((aData - (const unsigned char*)0)&7)==0 ){
2003 const unsigned char c1 = 0x86;
2006 const unsigned char c2 = 0x06;
2007 const unsigned char c3 = 0x80;
2063 const char *zFormat,
2114 const char *zSql = (const char*)sqlite3_value_text(argv[0]);
2120 const char *z;
2163 SHA3Update(&cx,(const unsigned char*)"R",1);
2167 SHA3Update(&cx, (const unsigned char*)"N",1);
2200 const unsigned char *z2 = sqlite3_column_text(pStmt, i);
2207 const unsigned char *z2 = sqlite3_column_blob(pStmt, i);
2227 const sqlite3_api_routines *pApi
2296 int nKey1, const void *pKey1,
2297 int nKey2, const void *pKey2
2299 const unsigned char *zA = (const unsigned char*)pKey1;
2300 const unsigned char *zB = (const unsigned char*)pKey2;
2341 const sqlite3_api_routines *pApi
2417 const unsigned char *zAlt
2421 const unsigned char *zIn;
2609 static int decimal_cmp(const Decimal *pA, const Decimal *pB){
2615 const Decimal *pTemp = pA;
2764 int nKey1, const void *pKey1,
2765 int nKey2, const void *pKey2
2767 const unsigned char *zA = (const unsigned char*)pKey1;
2768 const unsigned char *zB = (const unsigned char*)pKey2;
2949 const sqlite3_api_routines *pApi
2952 static const struct {
2953 const char *zFuncName;
3104 const unsigned char *x = sqlite3_value_blob(argv[0]);
3214 const unsigned char *x = sqlite3_value_blob(argv[0]);
3253 const sqlite3_api_routines *pApi
3255 static const struct {
3393 int argcUnused, const char *const*argvUnused,
3542 int idxNum, const char *idxStrUnused,
3618 const struct sqlite3_index_constraint *pConstraint;
3729 const sqlite3_api_routines *pApi
3846 static const char *ReOpName[] = {
3887 const unsigned char *z; /* All text */
3898 const char *zErr; /* Error message to return */
3970 static int re_match(ReCompiled *pRe, const unsigned char *zIn, int nIn){
3983 in.mx = nIn>=0 ? nIn : (int)strlen((char const*)zIn);
3990 strncmp((const char*)zIn+in.i, (const char*)pRe->zInit, pRe->nInit)!=0)
4187 static const char zEsc[] = "afnrtv\\()*.+?[$^{|}]";
4188 static const char zTrans[] = "\a\f\n\r\t\v";
4194 const unsigned char *zIn = p->sIn.z + p->sIn.i;
4205 const unsigned char *zIn = p->sIn.z + p->sIn.i;
4224 static const char *re_subcompile_string(ReCompiled*);
4235 static const char *re_subcompile_re(ReCompiled *p){
4236 const char *zErr;
4257 static const char *re_subcompile_string(ReCompiled *p){
4261 const char *zErr;
4418 static const char *re_compile(ReCompiled **ppRe, const char *zIn, int noCase){
4420 const char *zErr;
4500 const char *zPattern; /* The regular expression */
4501 const unsigned char *zStr;/* String being searched */
4502 const char *zErr; /* Compile error message */
4508 zPattern = (const char*)sqlite3_value_text(argv[0]);
4522 zStr = (const unsigned char*)sqlite3_value_text(argv[1]);
4544 const char *zPattern;
4545 const char *zErr;
4552 zPattern = (const char*)sqlite3_value_text(argv[0]);
4602 const sqlite3_api_routines *pApi
4767 static void readFileContents(sqlite3_context *ctx, const char *zName){
4814 const char *zName;
4816 zName = (const char*)sqlite3_value_text(argv[0]);
4825 static void ctxErrorMsg(sqlite3_context *ctx, const char *zFmt, ...){
4868 LPWSTR utf8_to_utf16(const char *z){
4884 const char *zPath,
4890 extern LPWSTR sqlite3_win32_utf8_to_unicode(const char*);
4912 const char *zPath,
4930 const char *zPath,
4954 const char *zFile
4995 const char *zFile, /* File to write */
5003 const char *zTo = (const char*)sqlite3_value_text(pData);
5025 const char *z;
5029 z = (const char*)sqlite3_value_blob(pData);
5056 extern LPWSTR sqlite3_win32_utf8_to_unicode(const char*);
5113 const char *zFile;
5125 zFile = (const char*)sqlite3_value_text(argv[0]);
5207 const char *zBase;
5226 int argc, const char *const*argv,
5306 static void fsdirSetErrmsg(fsdir_cursor *pCur, const char *zFmt, ...){
5469 int idxNum, const char *idxStr,
5472 const char *zDir = 0;
5483 zDir = (const char*)sqlite3_value_text(argv[0]);
5489 pCur->zBase = (const char*)sqlite3_value_text(argv[1]);
5532 const struct sqlite3_index_constraint *pConstraint;
5630 const sqlite3_api_routines *pApi
5726 const char *zCurrentRow; /* Current output row */
5765 int argc, const char *const*argv,
5885 const char *zSep = "";
5888 const char *zDb = (const char*)sqlite3_column_text(pS2, 1);
5909 const char *zSep = "";
5912 const char *zDb = (const char*)sqlite3_column_text(pS2, 1);
5938 pCur->zCurrentRow = (const char*)sqlite3_column_text(pCur->pStmt, iCol);
6017 int idxNum, const char *idxStr,
6075 const struct sqlite3_index_constraint *pConstraint;
6154 const sqlite3_api_routines *pApi
6306 static int apndWrite(sqlite3_file*,const void*,int iAmt, sqlite3_int64 iOfst);
6326 static int apndOpen(sqlite3_vfs*, const char *, sqlite3_file*, int , int *);
6327 static int apndDelete(sqlite3_vfs*, const char *zName, int syncDir);
6328 static int apndAccess(sqlite3_vfs*, const char *zName, int flags, int *);
6329 static int apndFullPathname(sqlite3_vfs*, const char *zName, int, char *zOut);
6330 static void *apndDlOpen(sqlite3_vfs*, const char *zFilename);
6332 static void (*apndDlSym(sqlite3_vfs *pVfs, void *p, const char*zSym))(void);
6339 static int apndSetSystemCall(sqlite3_vfs*, const char*,sqlite3_syscall_ptr);
6340 static sqlite3_syscall_ptr apndGetSystemCall(sqlite3_vfs*, const char *z);
6341 static const char *apndNextSystemCall(sqlite3_vfs*, const char *zName);
6368 static const sqlite3_io_methods apnd_io_methods = {
6445 const void *zBuf,
6627 static const char apvfsSqliteHdr[] = "SQLite format 3";
6675 const char *zName,
6740 static int apndDelete(sqlite3_vfs *pVfs, const char *zPath, int dirSync){
6749 const char *zPath,
6757 const char *zPath,
6763 static void *apndDlOpen(sqlite3_vfs *pVfs, const char *zPath){
6769 static void (*apndDlSym(sqlite3_vfs *pVfs, void *p, const char *zSym))(void){
6792 const char *zName,
6799 const char *zName
6803 static const char *apndNextSystemCall(sqlite3_vfs *pVfs, const char *zName){
6818 const sqlite3_api_routines *pApi
6937 static const char ZIPFILE_SCHEMA[] =
7149 static void zipfileCtxErrorMsg(sqlite3_context *ctx, const char *zFmt, ...){
7189 int argc, const char *const*argv,
7195 const char *zFile = 0;
7339 static void zipfileTableErr(ZipfileTab *pTab, const char *zFmt, ...){
7346 static void zipfileCursorErr(ZipfileCsr *pCsr, const char *zFmt, ...){
7383 const u8 *aWrite,
7402 static u16 zipfileGetU16(const u8 *aBuf){
7409 static u32 zipfileGetU32(const u8 *aBuf){
7645 const u8 *aBlob, /* Pointer to in-memory file image */
7705 static const int szFix = ZIPFILE_LFH_FIXED_SZ;
7787 const u8 *aIn, /* Compressed data */
7834 const u8 *aIn, int nIn, /* Input */
7980 const u8 *aBlob, /* Pointer to in-memory file image */
8065 static int zipfileLoadDirectory(ZipfileTab *pTab, const u8 *aBlob, int nBlob){
8091 int idxNum, const char *idxStr,
8096 const char *zFile = 0; /* Zip file to scan */
8108 static const u8 aEmptyBlob = 0;
8109 const u8 *aBlob = (const u8*)sqlite3_value_blob(argv[0]);
8122 zFile = (const char*)sqlite3_value_text(argv[0]);
8162 const struct sqlite3_index_constraint *pCons = &pIdxInfo->aConstraint[i];
8181 static ZipfileEntry *zipfileNewEntry(const char *zPath){
8231 const u8 *pData,
8254 const char *z = (const char*)sqlite3_value_text(pVal);
8261 const char zTemplate[11] = "-rwxrwxrwx";
8290 ** Both (const char*) arguments point to nul-terminated strings. Argument
8293 static int zipfileComparePath(const char *zA, const char *zB, int nB){
8397 const char *zPath = 0; /* Path for new entry */
8399 const u8 *pData = 0; /* Pointer to buffer containing content */
8417 const char *zDelete = (const char*)sqlite3_value_text(apVal[0]);
8420 const char *zUpdate = (const char*)sqlite3_value_text(apVal[1]);
8451 const u8 *aIn = sqlite3_value_blob(apVal[7]);
8484 zPath = (const char*)sqlite3_value_text(apVal[2]);
8497 zPath = (const char*)zFree;
8740 const char *zName, /* Name of SQL function */
8806 const u8 *aData = 0; /* Possibly compressed data for new entry */
9050 const sqlite3_api_routines *pApi
9102 const Bytef *pData = sqlite3_value_blob(argv[0]);
9150 const Bytef *pData= sqlite3_value_blob(argv[0]);
9168 const sqlite3_api_routines *pApi
9271 const char *zSql, /* SQL statement(s) to add */
9337 const char *sqlite3_expert_report(sqlite3expert*, int iStmt, int eReport);
9573 static int idxHashString(const char *z, int n){
9590 const char *zKey,
9591 const char *zVal
9624 static IdxHashEntry *idxHashFind(IdxHash *pHash, const char *zKey, int nKey){
9644 static const char *idxHashSearch(IdxHash *pHash, const char *zKey, int nKey){
9654 static IdxConstraint *idxNewConstraint(int *pRc, const char *zColl){
9685 const char *zSql /* SQL statement to compile */
9702 const char *zFmt, /* printf() format of SQL statement */
9737 static char *expertDequote(const char *zIn){
9772 int argc, const char *const*argv,
9816 const int opmask =
9839 const char *zColl = sqlite3_vtab_collation(pIdxInfo, i);
9970 int idxNum, const char *idxStr,
10051 const char *zTab, /* Table name */
10070 const char *zCol = (const char*)sqlite3_column_text(p1, 1);
10071 const char *zColSeq = 0;
10100 const char *zCol = (const char*)sqlite3_column_text(p1, 1);
10101 const char *zColSeq = 0;
10146 static char *idxAppendText(int *pRc, char *zIn, const char *zFmt, ...){
10178 static int idxIdentifierRequiresQuotes(const char *zId){
10245 const char *zTbl = pScan->pTab->zName;
10259 const char *zIdx = (const char*)sqlite3_column_text(pIdxList, 1);
10269 const char *zColl = (const char*)sqlite3_column_text(pInfo, 4);
10333 const char *zFmt;
10344 const char *zTable = pScan->pTab->zName;
10565 const char *zDetail = (const char*)sqlite3_column_text(pExplain, 3);
10573 const char *zIdx = 0;
10582 const char *zSql;
10616 const char *z3,
10617 const char *z4,
10618 const char *zDb,
10619 const char *zTrigger
10656 static const char *zInt = UNIQUE_TABLE_NAME;
10657 static const char *zDrop = "DROP TABLE " UNIQUE_TABLE_NAME;
10659 const char *zTab = pTab->zName;
10660 const char *zSql =
10671 const char *zCreate = (const char*)sqlite3_column_text(pSelect, 0);
10771 const char *zType = (const char*)sqlite3_column_text(pSchema, 0);
10772 const char *zName = (const char*)sqlite3_column_text(pSchema, 1);
10773 const char *zSql = (const char*)sqlite3_column_text(pSchema, 2);
10914 const void *pData = 0;
10939 const char *zMax =
10961 const char *zTab,
10962 const char *zIdx,
10979 const char *zComma = zCols==0 ? "" : ", ";
10980 const char *zName = (const char*)sqlite3_column_text(pIndexXInfo, 0);
10981 const char *zColl = (const char*)sqlite3_column_text(pIndexXInfo, 1);
11057 static int idxBuildSampleTable(sqlite3expert *p, const char *zTab){
11092 const char *zAllIndex =
11097 const char *zIndexXInfo =
11099 const char *zWrite = "INSERT INTO sqlite_stat1 VALUES(?, ?, ?)";
11139 const char *zTab = (const char*)sqlite3_column_text(pAllIndex, 1);
11140 const char *zIdx = (const char*)sqlite3_column_text(pAllIndex, 2);
11214 const char *zSql = (const char*)sqlite3_column_text(pSql, 0);
11268 const char *zSql, /* SQL statement to add */
11274 const char *zStmt = zSql;
11284 const char *z = sqlite3_sql(pStmt);
11365 const char *sqlite3_expert_report(sqlite3expert *p, int iStmt, int eReport){
11366 const char *zRet = 0;
11575 int argc, const char *const*argv,
11764 const u8 *pCopy = sqlite3_column_blob(pStmt, 0);
11782 static int dbdataGetVarint(const u8 *z, sqlite3_int64 *pVal){
11799 static int dbdataGetVarintU32(const u8 *z, sqlite3_int64 *pVal){
12117 static int dbdataIsFunction(const char *zSchema){
12131 static int dbdataDbsize(DbdataCursor *pCsr, const char *zSchema){
12179 int idxNum, const char *idxStr,
12185 const char *zSchema = "main";
12190 zSchema = (const char*)sqlite3_value_text(argv[0]);
12351 const sqlite3_api_routines *pApi
12474 const char *zDb,
12475 const char *zUri
12479 const char *zDb,
12480 int (*xSql)(void*, const char*),
12587 const char *sqlite3_recover_errmsg(sqlite3_recover*);
12642 int sqlite3_dbdata_init(sqlite3*, char**, const sqlite3_api_routines*);
12810 int (*xSql)(void*,const char*); /* Pointer to SQL callback function */
12880 const sqlite3_io_methods *pMethods;
12927 static int recoverStrlen(const char *zStr){
12971 const char *zFmt, ...
13059 const char *zSql
13084 const char *zFmt, ...
13143 static int recoverExec(sqlite3_recover *p, sqlite3 *db, const char *zSql){
13184 static char *recoverMPrintf(sqlite3_recover *p, const char *zFmt, ...){
13235 const unsigned char *pBlob;
13241 pBlob = (const unsigned char*)sqlite3_value_blob(argv[0]);
13245 const unsigned char *a = &pBlob[iInt*4];
13317 const u8 *aPg;
13344 static const char *recoverUnusedString(
13345 const char *z, /* Result must not appear anywhere in z */
13346 const char *zA, const char *zB, /* Try these first */
13375 const char *zText = (const char*)sqlite3_value_text(argv[0]);
13381 const char *zNL = 0;
13382 const char *zCR = 0;
13488 static void recoverSqlCallback(sqlite3_recover *p, const char *zSql){
13508 const char *aPragma[] = {
13529 const char *zPrag = aPragma[ii];
13533 const char *zArg = (const char*)sqlite3_column_text(p1, 0);
13577 const char *zName;
13587 const int flags = SQLITE_OPEN_URI|SQLITE_OPEN_CREATE|SQLITE_OPEN_READWRITE;
13648 const char *zName, /* Name of table created in output db */
13684 const char *z = (const char*)sqlite3_column_text(pStmt, 1);
13685 const char *zType = (const char*)sqlite3_column_text(pStmt, 2);
13784 const char *zName = (const char*)sqlite3_column_text(pSelect, 3);
13785 const char *zSql = (const char*)sqlite3_column_text(pSelect, 4);
13790 zSql = (const char*)(zFree = recoverMPrintf(p,
13800 const char *zTbl = (const char*)sqlite3_column_text(pTblname, 0);
13844 const char *zSql = (const char*)sqlite3_column_text(pSelect, 1);
13899 const char *zSep = "";
13900 const char *zSqlSep = "";
14018 const char *zSep = 0;
14050 const char *zTab,
14066 const char *zSep = "";
14154 recoverSqlCallback(p, (const char*)sqlite3_column_text(pInsert, 0));
14407 const char *z = (const char*)sqlite3_column_text(pInsert, 0);
14648 static u32 recoverGetU16(const u8 *a){
14656 static u32 recoverGetU32(const u8 *a){
14664 static int recoverGetVarint(const u8 *a, i64 *pVal){
14682 static int recoverIsValidPage(u8 *aTmp, const u8 *a, int n){
14777 static int recoverVfsWrite(sqlite3_file*, const void*, int, sqlite3_int64);
14860 const int nMin = 512;
14861 const int nMax = 65536;
14862 const int nMaxBlk = 4;
14940 const int aPreserve[] = {32, 36, 52, 60, 64, 68};
15043 sqlite3_file *pFd, const void *aBuf, int nByte, i64 iOff
15295 const char *zDb,
15296 const char *zUri, /* Output URI for _recover_init() */
15297 int (*xSql)(void*, const char*),/* SQL callback for _recover_init_sql() */
15333 const char *zDb,
15334 const char *zUri
15345 const char *zDb,
15346 int (*xSql)(void*, const char*),
15355 const char *sqlite3_recover_errmsg(sqlite3_recover *p){
15388 const char *zArg = (const char*)pArg;
15583 const char *zDbFilename; /* Filename used to open the connection */
15599 const char * zInput; /* Input string from wasm/JS proxy */
15600 const char * zPos; /* Cursor pos into zInput */
15601 const char * zDefaultDbName; /* Default name for db file */
15685 static const char *modeDescr[] = {
15729 static void shellLog(void *pArg, int iErrCode, const char *zMsg){
15759 const char *zErrMsg,
15796 const char *zEditor;
15809 zEditor = (const char*)sqlite3_value_text(argv[1]);
15845 const char *z = (const char*)sqlite3_value_text(argv[0]);
15904 sqlite3_result_text64(context, (const char*)p, sz,
15936 static void output_hex_blob(FILE *out, const void *pBlob, int nBlob){
15944 static const char aHex[] = {
15964 static const char *unused_string(
15965 const char *z, /* Result must not appear anywhere in z */
15966 const char *zA, const char *zB, /* Try these first */
15983 static void output_quoted_string(FILE *out, const char *z){
16022 static void output_quoted_escaped_string(FILE *out, const char *z){
16030 const char *zNL = 0;
16031 const char *zCR = 0;
16083 static void output_c_string(FILE *out, const char *z){
16114 static void output_json_string(FILE *out, const char *z, i64 n){
16149 static void output_html_string(FILE *out, const char *z){
16184 static const char needCsvQuote[] = {
16209 static void output_csv(ShellState *p, const char *z, int bSep){
16267 const char *zA1,
16268 const char *zA2,
16269 const char *zA3,
16270 const char *zA4
16273 static const char *azProhibitedFunctions[] = {
16315 const char *zA1,
16316 const char *zA2,
16317 const char *zA3,
16318 const char *zA4
16321 static const char *azAction[] = { 0,
16335 const char *az[4];
16365 static void printSchemaLine(FILE *out, const char *z, const char *zTail){
16370 const char *zOrig = z;
16371 static const char *azTerm[] = { "", "*/", "\n" };
16392 static void printSchemaLineN(FILE *out, char *z, int n, const char *zTail){
16403 static int wsToEol(const char *z){
16417 static void eqp_append(ShellState *p, int iEqpId, int p2, const char *zText){
16528 const char zDash[] = "--------------------------------------------------";
16529 const int nDash = sizeof(zDash) - 1;
16543 const char *zSep
16593 static const int aExplainWidth[] = {4, 13, 4, 4, 4, 13, 2, 13};
16820 const void *pBlob = sqlite3_column_blob(p->pStmt, i);
16861 const void *pBlob = sqlite3_column_blob(p->pStmt, i);
16900 const void *pBlob = sqlite3_column_blob(p->pStmt, i);
17016 static void set_table_name(ShellState *p, const char *zName){
17050 static char *shell_error_context(const char *zSql, sqlite3 *db){
17096 const char *zSelect /* SELECT statement to extract content */
17102 const char *z;
17115 z = (const char*)sqlite3_column_text(pSelect, 0);
17143 const char *zPhase, /* When the error occcurs */
17145 const char *zSql /* SQL string, or NULL */
17175 static const struct {
17176 const char *zPattern;
17177 const char *zDesc;
17393 const char *zExplain;
17426 static int str_in_array(const char *zStr, const char **azArray){
17456 const char *zSql; /* The text of the SQL statement */
17457 const char *z; /* Used to check if this is an EXPLAIN */
17462 const char *azNext[] = { "Next", "Prev", "VPrev", "VNext", "SorterNext",
17464 const char *azYield[] = { "Yield", "SeekLT", "SeekGT", "RowSetRead",
17466 const char *azGoto[] = { "Goto", 0 };
17485 const char *zOp = (const char*)sqlite3_column_text(pSql, 1);
17500 static const char *explainCols[] = {
17611 const char *zVar = sqlite3_bind_parameter_name(pStmt, i);
17656 const char zDash[] =
17659 const int nDash = sizeof(zDash) - 1;
17674 const char *zSep1,
17675 const char *zSep2,
17676 const char *zSep3
17703 const unsigned char *z, /* Input text to be transformed */
17704 const unsigned char **pzTail, /* OUT: Tail of the input for next line */
17807 const unsigned char *a = sqlite3_column_blob(pStmt,i);
17839 const unsigned char *uz;
17840 const char *z;
17845 const char *colSep = 0;
17846 const char *rowSep = 0;
17847 const unsigned char **azNextLine = 0;
17851 const char *zEmpty = "";
17852 const char *zShowNull = p->nullValue;
17885 const unsigned char *zNotUsed;
17891 uz = (const unsigned char*)sqlite3_column_name(pStmt,i);
17918 uz = (const unsigned char*)azQuoted[i];
17920 uz = (const unsigned char*)sqlite3_column_text(pStmt,i);
18079 void *pData = sqlite3_malloc64(3*nCol*sizeof(const char*) + 1);
18147 const char *zSql,
18184 const char *zCand = sqlite3_expert_report(p,0,EXPERT_REPORT_CANDIDATES);
18189 const char *zSql = sqlite3_expert_report(p, i, EXPERT_REPORT_SQL);
18190 const char *zIdx = sqlite3_expert_report(p, i, EXPERT_REPORT_INDEXES);
18191 const char *zEQP = sqlite3_expert_report(p, i, EXPERT_REPORT_PLAN);
18277 const char *zSql, /* SQL to be evaluated */
18283 const char *zLeftover; /* Tail of unprocessed SQL */
18298 static const char *zStmtSql;
18336 const char *zEQPLine = (const char*)sqlite3_column_text(pExplain,3);
18451 static char **tableColumnList(ShellState *p, const char *zTab){
18478 && sqlite3_stricmp((const char*)sqlite3_column_text(pStmt,2),
18567 const char *zTable;
18568 const char *zType;
18569 const char *zSql;
18688 const char *zQuery
18726 static const char *(azHelp[]) = {
19021 static int showHelp(FILE *out, const char *zPattern){
19102 static char *readFile(const char *zName, int *pnByte){
19162 static int session_filter(void *pCtx, const char *zTab){
19181 int deduceDatabaseType(const char *zName, int dfltZip){
19231 const char *zDbFilename = p->pAuxDb->zDbFilename;
19316 const unsigned char *pBlob;
19322 pBlob = (const unsigned char*)sqlite3_value_blob(argv[0]);
19326 const unsigned char *a = &pBlob[iInt*4];
19344 const char *zName = (const char*)sqlite3_value_text(argv[0]);
19384 const char *zText = (const char*)sqlite3_value_text(argv[0]);
19391 const char *zNL = 0;
19392 const char *zCR = 0;
19476 const char *zDbFilename = p->pAuxDb->zDbFilename;
19617 static char *readline_completion_generator(const char *text, int state){
19630 const char *z = (const char*)sqlite3_column_text(pStmt,0);
19639 static char **readline_completion(const char *zText, int iStart, int iEnd){
19648 static void linenoise_completion(const char *zLine, linenoiseCompletions *lc){
19669 const char *zCompletion = (const char*)sqlite3_column_text(pStmt, 0);
19744 static int booleanValue(const char *zArg){
19766 static void setOrClearFlag(ShellState *p, unsigned mFlag, const char *zArg){
19786 static FILE *output_file_open(const char *zFile, int bTextMode){
19815 const char *zSql;
19822 if( mType!=SQLITE_TRACE_ROW && ((const char*)pX)[0]=='-' ){
19823 zSql = (const char*)pX;
19877 const char *zFile; /* Name of the input file */
20045 const char *zTable
20056 const int spinRate = 10000;
20103 (const char*)sqlite3_column_text(pQuery,i),
20157 const char *zWhere,
20158 void (*xForEach)(ShellState*,sqlite3*,const char*)
20163 const unsigned char *zName;
20164 const unsigned char *zSql;
20182 sqlite3_exec(newDb, (const char*)zSql, 0, 0, &zErrMsg);
20189 xForEach(p, newDb, (const char*)zName);
20211 sqlite3_exec(newDb, (const char*)zSql, 0, 0, &zErrMsg);
20218 xForEach(p, newDb, (const char*)zName);
20233 static void tryToClone(ShellState *p, const char *zNewDb){
20271 const char *zXdgOpenCmd =
20302 static int db_int(sqlite3 *db, const char *zSql){
20330 static const struct { const char *zName; int ofst; } aField[] = {
20344 static const struct { const char *zName; const char *zSql; } aQuery[] = {
20426 const char *zErr = sqlite3_errmsg(db);
20454 static int testcase_glob(const char *zGlob, const char *z){
20533 static int optionMatch(const char *zStr, const char *zOpt){
20543 int shellDeleteFile(const char *zFilename){
20570 static void newTempFile(ShellState *p, const char *zSuffix){
20621 const char *zParent;
20622 const char *zParentCol;
20623 const char *zParentSeq;
20624 const char *zChild;
20625 const char *zChildCol;
20626 const char *zChildSeq = 0; /* Initialize to avoid false-positive warning */
20630 zParent = (const char*)sqlite3_value_text(apVal[0]);
20631 zParentCol = (const char*)sqlite3_value_text(apVal[1]);
20632 zChild = (const char*)sqlite3_value_text(apVal[2]);
20633 zChildCol = (const char*)sqlite3_value_text(apVal[3]);
20666 const char *zIndent = ""; /* How much to indent CREATE INDEX by */
20705 const char *zSql =
20732 const char *zGlobIPK = "SEARCH * USING INTEGER PRIMARY KEY (rowid=?)";
20770 const char *zEQP = (const char*)sqlite3_column_text(pSql, 0);
20771 const char *zGlob = (const char*)sqlite3_column_text(pSql, 1);
20772 const char *zFrom = (const char*)sqlite3_column_text(pSql, 2);
20773 const char *zTarget = (const char*)sqlite3_column_text(pSql, 3);
20774 const char *zCI = (const char*)sqlite3_column_text(pSql, 4);
20775 const char *zParent = (const char*)sqlite3_column_text(pSql, 5);
20782 const char *zPlan = (const char*)sqlite3_column_text(pExplain, 3);
20853 const char *zSql,
20879 const char *zFmt,
20959 const char *zFile; /* --file argument, or NULL */
20960 const char *zDir; /* --directory argument, or NULL */
20978 static int arErrorMsg(ArCommand *pAr, const char *zFmt, ...){
21015 static int arProcessSwitch(ArCommand *pAr, int eSwitch, const char *zArg){
21065 const char *zLong;
21097 const char *zArg = 0;
21135 const char *zArg = 0;
21165 const char *zArg = 0; /* Argument for option, if any */
21169 const char *zLong = pOpt->zLong;
21216 const char *zSel = (pAr->bGlob)
21257 const char *zSameOp = (pAr->bGlob)? "GLOB" : "=";
21263 const char *zSep = "";
21265 const char *z = pAr->azArg[i];
21285 const char *zSql = "SELECT %s FROM %s WHERE %s";
21286 const char *azCols[] = {
21367 const char *zSql1 =
21374 const char *azExtraArg[] = {
21438 static int arExecSql(ArCommand *pAr, const char *zSql){
21478 const char *zCreate =
21486 const char *zDrop = "DROP TABLE IF EXISTS sqlar";
21487 const char *zInsertFmt[2] = {
21512 const char *zTab = 0; /* SQL table into which to insert */
21699 static int recoverSqlCb(void *pCtx, const char *zSql){
21712 const char *zRecoveryDb = ""; /* Name of "recovery" database. Debug only */
21713 const char *zLAF = "lost_and_found";
21761 const char *zErr = sqlite3_recover_errmsg(p);
21799 static const char *zCOL_DB = ":memory:";
21813 static char *zAutoColumn(const char *zColNew, sqlite3 **pDb, char **pzRenamed){
21815 static const char * const zTabMake = "\
21825 static const char * const zTabFill = "\
21829 static const char * const zHasDupes = "\
21834 static const char * const zDedoctor = "\
21843 static const char * const zSetReps = "\
21851 static const char * const zColDigits = "\
21856 static const char * const zColDigits = "\
21862 static const char * const zRenameRank =
21899 static const char * const zCollectVar = "\
21910 static const char * const zRenamesDone =
22070 const char *zDestFile = 0;
22071 const char *zDb = 0;
22076 const char *zVfs = 0;
22079 const char *z = azArg[j];
22241 const char *zFile = p->aAuxDb[i].zDbFilename;
22294 const char *zSchema = (const char *)sqlite3_column_text(pStmt,1);
22295 const char *zFile = (const char*)sqlite3_column_text(pStmt,2);
22308 const char *z = azName[i*2+1];
22322 static const struct DbConfigChoices {
22323 const char *zName;
22382 const char *z = azArg[i]+1;
22569 static const struct {
22570 const char *zCtrlName; /* Name of a test-control option */
22572 const char *zUsage; /* Usage notes */
22591 const char *zCmd = 0;
22592 const char *zSchema = 0;
23127 const char *zCol = (const char*)sqlite3_column_text(pStmt,2);
23181 SQLITE_API extern void (SQLITE_CDECL *sqlite3IoTrace)(const char*, ...);
23203 static const struct {
23204 const char *zLimitName; /* Name of a limit */
23268 const char *zFile, *zProc;
23295 const char *zFile = azArg[1];
23303 const char *zMode = 0;
23304 const char *zTabname = 0;
23308 const char *z = azArg[i];
23453 const char *zFN = 0; /* Pointer to constant filename */
23461 const char *z = azArg[iName];
23722 const char *zKey = azArg[2];
23723 const char *zValue = azArg[3];
23785 const char *z = azArg[i];
23877 const char *zSrcFile;
23878 const char *zDb;
23945 const char *zDiv = "(";
23946 const char *zName = 0;
24012 const char *zDb = (const char*)sqlite3_column_text(pStmt, 0);
24329 const char *z = azArg[i];
24376 const char *zOp = (const char*)sqlite3_column_text(pStmt, 1);
24377 const char *zSql = (const char*)sqlite3_column_text(pStmt, 2);
24378 const char *zAns = (const char*)sqlite3_column_text(pStmt, 3);
24440 const char *zLike = 0; /* Which table to checksum. 0 means everything */
24453 const char *z = azArg[i];
24502 const char *zTab = (const char*)sqlite3_column_text(pStmt,0);
24580 static const char *azBool[] = { "off", "on", "trigger", "full"};
24581 const char *zOut;
24676 const char *zDbName = (const char*)sqlite3_column_text(pStmt, 1);
24775 static const struct {
24776 const char *zCtrlName; /* Name of a test-control option */
24779 const char *zUsage; /* Usage notes */
24809 const char *zCmd = 0;
25031 const char *z = azArg[jj];
25091 sqlite3_drop_modules(p->db, nArg>2 ? (const char**)(azArg+2) : 0);
25183 const char *zDbName = nArg==2 ? azArg[1] : "main";
25215 const char *zDbName = nArg==2 ? azArg[1] : "main";
25404 const char *zErrorTail;
25405 const char *zErrorType;
25439 static void echo_group_input(ShellState *p, const char *zDo){
25451 const char *zBegin = shellState.wasm.zPos;
25452 const char *z = zBegin;
25668 const char *sqliterc_override /* Name of config file. NULL to use default */
25671 const char *sqliterc = sqliterc_override;
25706 static const char zOptions[] =
25815 static void printBold(const char *zText){
25830 static void printBold(const char *zText){
25876 const char *zInitFile = 0;
25883 const char *zVfs = 0; /* Value of -vfs command-line option */
25974 extern void SQLITE_SHELL_DBNAME_PROC(const char**);
26019 const char *zSize;
26060 const char *zTraceName,
26061 const char *zOldVfsName,
26062 int (*xOut)(const char*,void*),
26066 vfstrace_register("trace",0,(int(*)(const char*,void*))fputs,stderr,1);
26070 extern int sqlite3_multiple_initialize(const char*,int);
26480 sqlite3_vfs * fiddle_db_vfs(const char *zDbName){
26491 printf("fiddle_db_arg(%p)\n", (const void*)arg);
26509 const char * fiddle_db_filename(const char * zDbName){
26537 int fiddle_export_db( int (*xCallback)(unsigned const char *zOut, int n) ){
26575 void fiddle_exec(const char * zSql){