Lines Matching defs:db
531 sqlite3 *db; /* The database */
1167 rc = sqlite3_prepare_v2(p->db, zSelect, -1, &pSelect, 0);
1169 fprintf(p->out, "/**** ERROR: (%d) %s *****/\n", rc, sqlite3_errmsg(p->db));
1196 fprintf(p->out, "/**** ERROR: (%d) %s *****/\n", rc, sqlite3_errmsg(p->db));
1206 sqlite3 *db /* Database to query */
1208 int nErrMsg = 1+strlen30(sqlite3_errmsg(db));
1211 memcpy(zErrMsg, sqlite3_errmsg(db), nErrMsg);
1220 sqlite3 *db, /* Database to query */
1281 if( pArg && pArg->out && db ){
1284 sqlite3_db_status(db, SQLITE_DBSTATUS_LOOKASIDE_USED,
1288 sqlite3_db_status(db, SQLITE_DBSTATUS_LOOKASIDE_HIT,
1291 sqlite3_db_status(db, SQLITE_DBSTATUS_LOOKASIDE_MISS_SIZE,
1294 sqlite3_db_status(db, SQLITE_DBSTATUS_LOOKASIDE_MISS_FULL,
1299 sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_USED, &iCur, &iHiwtr, bReset);
1302 sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_HIT, &iCur, &iHiwtr, 1);
1305 sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_MISS, &iCur, &iHiwtr, 1);
1308 sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_WRITE, &iCur, &iHiwtr, 1);
1311 sqlite3_db_status(db, SQLITE_DBSTATUS_SCHEMA_USED, &iCur, &iHiwtr, bReset);
1314 sqlite3_db_status(db, SQLITE_DBSTATUS_STMT_USED, &iCur, &iHiwtr, bReset);
1318 if( pArg && pArg->out && db && pArg->pStmt ){
1337 sqlite3 *db, /* Database to query */
1488 sqlite3 *db, /* An open database */
1505 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, &zLeftover);
1508 *pzErrMsg = save_err_msg(db);
1535 rc = sqlite3_prepare_v2(db, zEQP, -1, &pExplain, 0);
1615 display_stats(db, pArg, 0);
1620 display_scanstats(db, pArg);
1632 *pzErrMsg = save_err_msg(db);
1700 rc = sqlite3_prepare_v2(p->db, zTableInfo, -1, &pTableInfo, 0);
1759 rc = sqlite3_exec(p->db, zQuery, dump_callback, p, &zErr);
1772 rc = sqlite3_exec(p->db, zQ2, dump_callback, p, &zErr);
1788 ".backup ?DB? FILE Backup DB (default \"main\") to FILE\n"
1793 ".dbinfo ?DB? Show status information about the database\n"
1835 ".restore ?DB? FILE Restore content of DB (default \"main\") from FILE\n"
1926 if( p->db==0 ){
1928 sqlite3_open(p->zDbFilename, &p->db);
1929 globalDb = p->db;
1930 if( p->db && sqlite3_errcode(p->db)==SQLITE_OK ){
1931 sqlite3_create_function(p->db, "shellstatic", 0, SQLITE_UTF8, 0,
1934 if( p->db==0 || SQLITE_OK!=sqlite3_errcode(p->db) ){
1936 p->zDbFilename, sqlite3_errmsg(p->db));
1941 sqlite3_enable_load_extension(p->db, 1);
1943 sqlite3_create_function(p->db, "readfile", 1, SQLITE_UTF8, 0,
1945 sqlite3_create_function(p->db, "writefile", 2, SQLITE_UTF8, 0,
1951 int err = register_localized_collators(p->db, "en_US", 0);
1956 err = register_android_functions(p->db, 0);
2316 rc = sqlite3_prepare_v2(p->db, zQuery, -1, &pQuery, 0);
2319 sqlite3_extended_errcode(p->db), sqlite3_errmsg(p->db),
2391 rc = sqlite3_prepare_v2(p->db, zQuery, -1, &pQuery, 0);
2427 rc = sqlite3_prepare_v2(p->db, zQuery, -1, &pQuery, 0);
2430 sqlite3_extended_errcode(p->db), sqlite3_errmsg(p->db),
2454 rc = sqlite3_prepare_v2(p->db, zQuery, -1, &pQuery, 0);
2457 sqlite3_extended_errcode(p->db), sqlite3_errmsg(p->db),
2499 sqlite3_exec(p->db, "PRAGMA writable_schema=ON;", 0, 0, 0);
2504 sqlite3_exec(p->db, "PRAGMA writable_schema=OFF;", 0, 0, 0);
2530 sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
2586 if( p->db==0 ) return 1;
2587 sqlite3_file_control(p->db, zDb, SQLITE_FCNTL_FILE_POINTER, &pFile);
2714 pBackup = sqlite3_backup_init(pDest, "main", p->db, zDb);
2780 sqlite3_exec(p->db, "PRAGMA database_list; ", callback, &data, &zErrMsg);
2805 sqlite3_exec(p->db, "SAVEPOINT dump; PRAGMA writable_schema=ON", 0, 0, 0);
2841 sqlite3_exec(p->db, "PRAGMA writable_schema=OFF;", 0, 0, 0);
2842 sqlite3_exec(p->db, "RELEASE dump;", 0, 0, 0);
2917 rc = sqlite3_exec(p->db,
2928 rc = sqlite3_prepare_v2(p->db,
2939 sqlite3_exec(p->db, "SELECT 'ANALYZE sqlite_master'",
2943 shell_exec(p->db, "SELECT * FROM sqlite_stat1",
2946 shell_exec(p->db, "SELECT * FROM sqlite_stat3",
2949 shell_exec(p->db, "SELECT * FROM sqlite_stat4",
3052 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
3054 if( rc && sqlite3_strglob("no such table: *", sqlite3_errmsg(p->db))==0 ){
3070 rc = sqlite3_exec(p->db, zCreate, 0, 0, 0);
3074 sqlite3_errmsg(p->db));
3079 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
3084 fprintf(stderr,"Error: %s\n", sqlite3_errmsg(p->db));
3106 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
3109 fprintf(stderr, "Error: %s\n", sqlite3_errmsg(p->db));
3114 needCommit = sqlite3_get_autocommit(p->db);
3115 if( needCommit ) sqlite3_exec(p->db, "BEGIN", 0, 0, 0);
3154 sqlite3_errmsg(p->db));
3162 if( needCommit ) sqlite3_exec(p->db, "COMMIT", 0, 0, 0);
3174 rc = sqlite3_exec(p->db,
3185 rc = sqlite3_exec(p->db,
3255 sqlite3_limit(p->db, aLimit[i].limitCode, -1));
3283 sqlite3_limit(p->db, aLimit[iLimit].limitCode,
3287 sqlite3_limit(p->db, aLimit[iLimit].limitCode, -1));
3303 rc = sqlite3_load_extension(p->db, zFile, zProc, &zErrMsg);
3370 sqlite3 *savedDb = p->db;
3373 p->db = 0;
3378 if( p->db!=0 ){
3384 p->db = savedDb;
3491 fprintf(stderr, "Usage: .restore ?DB? FILE\n");
3502 pBackup = sqlite3_backup_init(p->db, zDb, pSrc, "main");
3504 fprintf(stderr, "Error: %s\n", sqlite3_errmsg(p->db));
3522 fprintf(stderr, "Error: %s\n", sqlite3_errmsg(p->db));
3581 rc = sqlite3_exec(p->db,
3593 rc = sqlite3_exec(p->db,
3733 rc = sqlite3_prepare_v2(p->db, "PRAGMA database_list", -1, &pStmt, 0);
3761 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
3857 /* sqlite3_test_control(int, db, int) */
3862 rc2 = sqlite3_test_control(testctrl, p->db, opt);
3925 rc2 = sqlite3_test_control(testctrl, p->db,
3949 sqlite3_busy_timeout(p->db, nArg>=2 ? (int)integerValue(azArg[1]) : 0);
3976 sqlite3_trace(p->db, 0, 0);
3978 sqlite3_trace(p->db, sql_trace_callback, p->traceOut);
3997 rc = sqlite3_user_authenticate(p->db, azArg[2], azArg[3],
4009 rc = sqlite3_user_add(p->db, azArg[2],
4022 rc = sqlite3_user_change(p->db, azArg[2],
4035 rc = sqlite3_user_delete(p->db, azArg[2]);
4056 if( p->db ){
4057 sqlite3_file_control(p->db, zDbName, SQLITE_FCNTL_VFSNAME, &zVfsName);
4239 rc = shell_exec(p->db, zSql, shell_callback, p, &zErrMsg);
4254 fprintf(stderr, "%s %s\n", zPrefix, sqlite3_errmsg(p->db));
4754 rc = shell_exec(data.db, z, shell_callback, &data, &zErrMsg);
4781 rc = shell_exec(data.db, azCmd[i], shell_callback, &data, &zErrMsg);
4829 if( data.db ){
4830 sqlite3_close(data.db);
