Lines Matching refs:db
523 sqlite3 *db; /* The database */
1159 rc = sqlite3_prepare_v2(p->db, zSelect, -1, &pSelect, 0);
1161 fprintf(p->out, "/**** ERROR: (%d) %s *****/\n", rc, sqlite3_errmsg(p->db));
1188 fprintf(p->out, "/**** ERROR: (%d) %s *****/\n", rc, sqlite3_errmsg(p->db));
1198 sqlite3 *db /* Database to query */
1200 int nErrMsg = 1+strlen30(sqlite3_errmsg(db));
1203 memcpy(zErrMsg, sqlite3_errmsg(db), nErrMsg);
1212 sqlite3 *db, /* Database to query */
1273 if( pArg && pArg->out && db ){
1276 sqlite3_db_status(db, SQLITE_DBSTATUS_LOOKASIDE_USED,
1280 sqlite3_db_status(db, SQLITE_DBSTATUS_LOOKASIDE_HIT,
1283 sqlite3_db_status(db, SQLITE_DBSTATUS_LOOKASIDE_MISS_SIZE,
1286 sqlite3_db_status(db, SQLITE_DBSTATUS_LOOKASIDE_MISS_FULL,
1291 sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_USED, &iCur, &iHiwtr, bReset);
1294 sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_HIT, &iCur, &iHiwtr, 1);
1297 sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_MISS, &iCur, &iHiwtr, 1);
1300 sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_WRITE, &iCur, &iHiwtr, 1);
1303 sqlite3_db_status(db, SQLITE_DBSTATUS_SCHEMA_USED, &iCur, &iHiwtr, bReset);
1306 sqlite3_db_status(db, SQLITE_DBSTATUS_STMT_USED, &iCur, &iHiwtr, bReset);
1310 if( pArg && pArg->out && db && pArg->pStmt ){
1331 sqlite3 *db, /* Database to query */
1335 UNUSED_PARAMETER(db);
1485 sqlite3 *db, /* An open database */
1502 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, &zLeftover);
1505 *pzErrMsg = save_err_msg(db);
1532 rc = sqlite3_prepare_v2(db, zEQP, -1, &pExplain, 0);
1612 display_stats(db, pArg, 0);
1617 display_scanstats(db, pArg);
1629 *pzErrMsg = save_err_msg(db);
1697 rc = sqlite3_prepare_v2(p->db, zTableInfo, -1, &pTableInfo, 0);
1756 rc = sqlite3_exec(p->db, zQuery, dump_callback, p, &zErr);
1769 rc = sqlite3_exec(p->db, zQ2, dump_callback, p, &zErr);
1785 ".backup ?DB? FILE Backup DB (default \"main\") to FILE\n"
1790 ".dbinfo ?DB? Show status information about the database\n"
1832 ".restore ?DB? FILE Restore content of DB (default \"main\") from FILE\n"
1925 if( p->db==0 ){
1927 sqlite3_open(p->zDbFilename, &p->db);
1928 globalDb = p->db;
1929 if( p->db && sqlite3_errcode(p->db)==SQLITE_OK ){
1930 sqlite3_create_function(p->db, "shellstatic", 0, SQLITE_UTF8, 0,
1933 if( p->db==0 || SQLITE_OK!=sqlite3_errcode(p->db) ){
1935 p->zDbFilename, sqlite3_errmsg(p->db));
1940 sqlite3_enable_load_extension(p->db, 1);
1942 sqlite3_create_function(p->db, "readfile", 1, SQLITE_UTF8, 0,
1944 sqlite3_create_function(p->db, "writefile", 2, SQLITE_UTF8, 0,
2299 rc = sqlite3_prepare_v2(p->db, zQuery, -1, &pQuery, 0);
2302 sqlite3_extended_errcode(p->db), sqlite3_errmsg(p->db),
2374 rc = sqlite3_prepare_v2(p->db, zQuery, -1, &pQuery, 0);
2410 rc = sqlite3_prepare_v2(p->db, zQuery, -1, &pQuery, 0);
2413 sqlite3_extended_errcode(p->db), sqlite3_errmsg(p->db),
2437 rc = sqlite3_prepare_v2(p->db, zQuery, -1, &pQuery, 0);
2440 sqlite3_extended_errcode(p->db), sqlite3_errmsg(p->db),
2482 sqlite3_exec(p->db, "PRAGMA writable_schema=ON;", 0, 0, 0);
2487 sqlite3_exec(p->db, "PRAGMA writable_schema=OFF;", 0, 0, 0);
2513 sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
2569 if( p->db==0 ) return 1;
2570 sqlite3_file_control(p->db, zDb, SQLITE_FCNTL_FILE_POINTER, &pFile);
2618 static int shellDatabaseError(sqlite3 *db){
2619 const char *zErr = sqlite3_errmsg(db);
2713 pBackup = sqlite3_backup_init(pDest, "main", p->db, zDb);
2779 sqlite3_exec(p->db, "PRAGMA database_list; ", callback, &data, &zErrMsg);
2804 sqlite3_exec(p->db, "SAVEPOINT dump; PRAGMA writable_schema=ON", 0, 0, 0);
2840 sqlite3_exec(p->db, "PRAGMA writable_schema=OFF;", 0, 0, 0);
2841 sqlite3_exec(p->db, "RELEASE dump;", 0, 0, 0);
2916 rc = sqlite3_exec(p->db,
2927 rc = sqlite3_prepare_v2(p->db,
2938 sqlite3_exec(p->db, "SELECT 'ANALYZE sqlite_master'",
2942 shell_exec(p->db, "SELECT * FROM sqlite_stat1",
2945 shell_exec(p->db, "SELECT * FROM sqlite_stat3",
2948 shell_exec(p->db, "SELECT * FROM sqlite_stat4",
3051 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
3053 if( rc && sqlite3_strglob("no such table: *", sqlite3_errmsg(p->db))==0 ){
3069 rc = sqlite3_exec(p->db, zCreate, 0, 0, 0);
3073 sqlite3_errmsg(p->db));
3078 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
3083 fprintf(stderr,"Error: %s\n", sqlite3_errmsg(p->db));
3105 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
3108 fprintf(stderr, "Error: %s\n", sqlite3_errmsg(p->db));
3113 needCommit = sqlite3_get_autocommit(p->db);
3114 if( needCommit ) sqlite3_exec(p->db, "BEGIN", 0, 0, 0);
3153 sqlite3_errmsg(p->db));
3161 if( needCommit ) sqlite3_exec(p->db, "COMMIT", 0, 0, 0);
3173 rc = sqlite3_exec(p->db,
3184 rc = sqlite3_exec(p->db,
3254 sqlite3_limit(p->db, aLimit[i].limitCode, -1));
3282 sqlite3_limit(p->db, aLimit[iLimit].limitCode,
3286 sqlite3_limit(p->db, aLimit[iLimit].limitCode, -1));
3302 rc = sqlite3_load_extension(p->db, zFile, zProc, &zErrMsg);
3369 sqlite3 *savedDb = p->db;
3372 p->db = 0;
3376 if( p->db!=0 ){
3382 p->db = savedDb;
3489 fprintf(stderr, "Usage: .restore ?DB? FILE\n");
3500 pBackup = sqlite3_backup_init(p->db, zDb, pSrc, "main");
3502 fprintf(stderr, "Error: %s\n", sqlite3_errmsg(p->db));
3520 fprintf(stderr, "Error: %s\n", sqlite3_errmsg(p->db));
3579 rc = sqlite3_exec(p->db,
3591 rc = sqlite3_exec(p->db,
3731 rc = sqlite3_prepare_v2(p->db, "PRAGMA database_list", -1, &pStmt, 0);
3732 if( rc ) return shellDatabaseError(p->db);
3764 if( zSql ) rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
3768 if( rc ) return shellDatabaseError(p->db);
3799 rc = shellDatabaseError(p->db);
3874 /* sqlite3_test_control(int, db, int) */
3879 rc2 = sqlite3_test_control(testctrl, p->db, opt);
3942 rc2 = sqlite3_test_control(testctrl, p->db,
3966 sqlite3_busy_timeout(p->db, nArg>=2 ? (int)integerValue(azArg[1]) : 0);
3993 sqlite3_trace(p->db, 0, 0);
3995 sqlite3_trace(p->db, sql_trace_callback, p->traceOut);
4014 rc = sqlite3_user_authenticate(p->db, azArg[2], azArg[3],
4026 rc = sqlite3_user_add(p->db, azArg[2],
4039 rc = sqlite3_user_change(p->db, azArg[2],
4052 rc = sqlite3_user_delete(p->db, azArg[2]);
4073 if( p->db ){
4074 sqlite3_file_control(p->db, zDbName, SQLITE_FCNTL_VFSNAME, &zVfsName);
4256 rc = shell_exec(p->db, zSql, shell_callback, p, &zErrMsg);
4271 fprintf(stderr, "%s %s\n", zPrefix, sqlite3_errmsg(p->db));
4771 rc = shell_exec(data.db, z, shell_callback, &data, &zErrMsg);
4798 rc = shell_exec(data.db, azCmd[i], shell_callback, &data, &zErrMsg);
4846 if( data.db ){
4847 sqlite3_close(data.db);
