Lines Matching defs:db
525 sqlite3 *db; /* The database */
1161 rc = sqlite3_prepare_v2(p->db, zSelect, -1, &pSelect, 0);
1163 fprintf(p->out, "/**** ERROR: (%d) %s *****/\n", rc, sqlite3_errmsg(p->db));
1190 fprintf(p->out, "/**** ERROR: (%d) %s *****/\n", rc, sqlite3_errmsg(p->db));
1200 sqlite3 *db /* Database to query */
1202 int nErrMsg = 1+strlen30(sqlite3_errmsg(db));
1205 memcpy(zErrMsg, sqlite3_errmsg(db), nErrMsg);
1214 sqlite3 *db, /* Database to query */
1275 if( pArg && pArg->out && db ){
1278 sqlite3_db_status(db, SQLITE_DBSTATUS_LOOKASIDE_USED,
1282 sqlite3_db_status(db, SQLITE_DBSTATUS_LOOKASIDE_HIT,
1285 sqlite3_db_status(db, SQLITE_DBSTATUS_LOOKASIDE_MISS_SIZE,
1288 sqlite3_db_status(db, SQLITE_DBSTATUS_LOOKASIDE_MISS_FULL,
1293 sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_USED, &iCur, &iHiwtr, bReset);
1296 sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_HIT, &iCur, &iHiwtr, 1);
1299 sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_MISS, &iCur, &iHiwtr, 1);
1302 sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_WRITE, &iCur, &iHiwtr, 1);
1305 sqlite3_db_status(db, SQLITE_DBSTATUS_SCHEMA_USED, &iCur, &iHiwtr, bReset);
1308 sqlite3_db_status(db, SQLITE_DBSTATUS_STMT_USED, &iCur, &iHiwtr, bReset);
1312 if( pArg && pArg->out && db && pArg->pStmt ){
1331 sqlite3 *db, /* Database to query */
1482 sqlite3 *db, /* An open database */
1499 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, &zLeftover);
1502 *pzErrMsg = save_err_msg(db);
1529 rc = sqlite3_prepare_v2(db, zEQP, -1, &pExplain, 0);
1609 display_stats(db, pArg, 0);
1614 display_scanstats(db, pArg);
1626 *pzErrMsg = save_err_msg(db);
1694 rc = sqlite3_prepare_v2(p->db, zTableInfo, -1, &pTableInfo, 0);
1753 rc = sqlite3_exec(p->db, zQuery, dump_callback, p, &zErr);
1766 rc = sqlite3_exec(p->db, zQ2, dump_callback, p, &zErr);
1782 ".backup ?DB? FILE Backup DB (default \"main\") to FILE\n"
1787 ".dbinfo ?DB? Show status information about the database\n"
1829 ".restore ?DB? FILE Restore content of DB (default \"main\") from FILE\n"
1920 if( p->db==0 ){
1922 sqlite3_open(p->zDbFilename, &p->db);
1923 globalDb = p->db;
1924 if( p->db && sqlite3_errcode(p->db)==SQLITE_OK ){
1925 sqlite3_create_function(p->db, "shellstatic", 0, SQLITE_UTF8, 0,
1928 if( p->db==0 || SQLITE_OK!=sqlite3_errcode(p->db) ){
1930 p->zDbFilename, sqlite3_errmsg(p->db));
1935 sqlite3_enable_load_extension(p->db, 1);
1937 sqlite3_create_function(p->db, "readfile", 1, SQLITE_UTF8, 0,
1939 sqlite3_create_function(p->db, "writefile", 2, SQLITE_UTF8, 0,
2294 rc = sqlite3_prepare_v2(p->db, zQuery, -1, &pQuery, 0);
2297 sqlite3_extended_errcode(p->db), sqlite3_errmsg(p->db),
2369 rc = sqlite3_prepare_v2(p->db, zQuery, -1, &pQuery, 0);
2405 rc = sqlite3_prepare_v2(p->db, zQuery, -1, &pQuery, 0);
2408 sqlite3_extended_errcode(p->db), sqlite3_errmsg(p->db),
2432 rc = sqlite3_prepare_v2(p->db, zQuery, -1, &pQuery, 0);
2435 sqlite3_extended_errcode(p->db), sqlite3_errmsg(p->db),
2477 sqlite3_exec(p->db, "PRAGMA writable_schema=ON;", 0, 0, 0);
2482 sqlite3_exec(p->db, "PRAGMA writable_schema=OFF;", 0, 0, 0);
2508 sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
2564 if( p->db==0 ) return 1;
2565 sqlite3_file_control(p->db, zDb, SQLITE_FCNTL_FILE_POINTER, &pFile);
2692 pBackup = sqlite3_backup_init(pDest, "main", p->db, zDb);
2758 sqlite3_exec(p->db, "PRAGMA database_list; ", callback, &data, &zErrMsg);
2783 sqlite3_exec(p->db, "SAVEPOINT dump; PRAGMA writable_schema=ON", 0, 0, 0);
2819 sqlite3_exec(p->db, "PRAGMA writable_schema=OFF;", 0, 0, 0);
2820 sqlite3_exec(p->db, "RELEASE dump;", 0, 0, 0);
2895 rc = sqlite3_exec(p->db,
2906 rc = sqlite3_prepare_v2(p->db,
2917 sqlite3_exec(p->db, "SELECT 'ANALYZE sqlite_master'",
2921 shell_exec(p->db, "SELECT * FROM sqlite_stat1",
2924 shell_exec(p->db, "SELECT * FROM sqlite_stat3",
2927 shell_exec(p->db, "SELECT * FROM sqlite_stat4",
3030 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
3032 if( rc && sqlite3_strglob("no such table: *", sqlite3_errmsg(p->db))==0 ){
3048 rc = sqlite3_exec(p->db, zCreate, 0, 0, 0);
3052 sqlite3_errmsg(p->db));
3057 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
3062 fprintf(stderr,"Error: %s\n", sqlite3_errmsg(p->db));
3084 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
3087 fprintf(stderr, "Error: %s\n", sqlite3_errmsg(p->db));
3092 needCommit = sqlite3_get_autocommit(p->db);
3093 if( needCommit ) sqlite3_exec(p->db, "BEGIN", 0, 0, 0);
3132 sqlite3_errmsg(p->db));
3140 if( needCommit ) sqlite3_exec(p->db, "COMMIT", 0, 0, 0);
3152 rc = sqlite3_exec(p->db,
3163 rc = sqlite3_exec(p->db,
3233 sqlite3_limit(p->db, aLimit[i].limitCode, -1));
3261 sqlite3_limit(p->db, aLimit[iLimit].limitCode,
3265 sqlite3_limit(p->db, aLimit[iLimit].limitCode, -1));
3281 rc = sqlite3_load_extension(p->db, zFile, zProc, &zErrMsg);
3348 sqlite3 *savedDb = p->db;
3351 p->db = 0;
3356 if( p->db!=0 ){
3362 p->db = savedDb;
3469 fprintf(stderr, "Usage: .restore ?DB? FILE\n");
3480 pBackup = sqlite3_backup_init(p->db, zDb, pSrc, "main");
3482 fprintf(stderr, "Error: %s\n", sqlite3_errmsg(p->db));
3500 fprintf(stderr, "Error: %s\n", sqlite3_errmsg(p->db));
3559 rc = sqlite3_exec(p->db,
3571 rc = sqlite3_exec(p->db,
3711 rc = sqlite3_prepare_v2(p->db, "PRAGMA database_list", -1, &pStmt, 0);
3739 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
3835 /* sqlite3_test_control(int, db, int) */
3840 rc2 = sqlite3_test_control(testctrl, p->db, opt);
3903 rc2 = sqlite3_test_control(testctrl, p->db,
3927 sqlite3_busy_timeout(p->db, nArg>=2 ? (int)integerValue(azArg[1]) : 0);
3954 sqlite3_trace(p->db, 0, 0);
3956 sqlite3_trace(p->db, sql_trace_callback, p->traceOut);
3975 rc = sqlite3_user_authenticate(p->db, azArg[2], azArg[3],
3987 rc = sqlite3_user_add(p->db, azArg[2],
4000 rc = sqlite3_user_change(p->db, azArg[2],
4013 rc = sqlite3_user_delete(p->db, azArg[2]);
4034 if( p->db ){
4035 sqlite3_file_control(p->db, zDbName, SQLITE_FCNTL_VFSNAME, &zVfsName);
4217 rc = shell_exec(p->db, zSql, shell_callback, p, &zErrMsg);
4232 fprintf(stderr, "%s %s\n", zPrefix, sqlite3_errmsg(p->db));
4732 rc = shell_exec(data.db, z, shell_callback, &data, &zErrMsg);
4759 rc = shell_exec(data.db, azCmd[i], shell_callback, &data, &zErrMsg);
4807 if( data.db ){
4808 sqlite3_close(data.db);
