Lines Matching refs:db
529 sqlite3 *db; /* The database */
1165 rc = sqlite3_prepare_v2(p->db, zSelect, -1, &pSelect, 0);
1167 fprintf(p->out, "/**** ERROR: (%d) %s *****/\n", rc, sqlite3_errmsg(p->db));
1194 fprintf(p->out, "/**** ERROR: (%d) %s *****/\n", rc, sqlite3_errmsg(p->db));
1204 sqlite3 *db /* Database to query */
1206 int nErrMsg = 1+strlen30(sqlite3_errmsg(db));
1209 memcpy(zErrMsg, sqlite3_errmsg(db), nErrMsg);
1218 sqlite3 *db, /* Database to query */
1279 if( pArg && pArg->out && db ){
1282 sqlite3_db_status(db, SQLITE_DBSTATUS_LOOKASIDE_USED,
1286 sqlite3_db_status(db, SQLITE_DBSTATUS_LOOKASIDE_HIT,
1289 sqlite3_db_status(db, SQLITE_DBSTATUS_LOOKASIDE_MISS_SIZE,
1292 sqlite3_db_status(db, SQLITE_DBSTATUS_LOOKASIDE_MISS_FULL,
1297 sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_USED, &iCur, &iHiwtr, bReset);
1300 sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_HIT, &iCur, &iHiwtr, 1);
1303 sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_MISS, &iCur, &iHiwtr, 1);
1306 sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_WRITE, &iCur, &iHiwtr, 1);
1309 sqlite3_db_status(db, SQLITE_DBSTATUS_SCHEMA_USED, &iCur, &iHiwtr, bReset);
1312 sqlite3_db_status(db, SQLITE_DBSTATUS_STMT_USED, &iCur, &iHiwtr, bReset);
1316 if( pArg && pArg->out && db && pArg->pStmt ){
1337 sqlite3 *db, /* Database to query */
1341 UNUSED_PARAMETER(db);
1491 sqlite3 *db, /* An open database */
1508 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, &zLeftover);
1511 *pzErrMsg = save_err_msg(db);
1538 rc = sqlite3_prepare_v2(db, zEQP, -1, &pExplain, 0);
1618 display_stats(db, pArg, 0);
1623 display_scanstats(db, pArg);
1635 *pzErrMsg = save_err_msg(db);
1703 rc = sqlite3_prepare_v2(p->db, zTableInfo, -1, &pTableInfo, 0);
1762 rc = sqlite3_exec(p->db, zQuery, dump_callback, p, &zErr);
1775 rc = sqlite3_exec(p->db, zQ2, dump_callback, p, &zErr);
1791 ".backup ?DB? FILE Backup DB (default \"main\") to FILE\n"
1796 ".dbinfo ?DB? Show status information about the database\n"
1838 ".restore ?DB? FILE Restore content of DB (default \"main\") from FILE\n"
1931 if( p->db==0 ){
1933 sqlite3_open(p->zDbFilename, &p->db);
1934 globalDb = p->db;
1935 if( p->db && sqlite3_errcode(p->db)==SQLITE_OK ){
1936 sqlite3_create_function(p->db, "shellstatic", 0, SQLITE_UTF8, 0,
1939 if( p->db==0 || SQLITE_OK!=sqlite3_errcode(p->db) ){
1941 p->zDbFilename, sqlite3_errmsg(p->db));
1946 sqlite3_enable_load_extension(p->db, 1);
1948 sqlite3_create_function(p->db, "readfile", 1, SQLITE_UTF8, 0,
1950 sqlite3_create_function(p->db, "writefile", 2, SQLITE_UTF8, 0,
1956 int err = register_localized_collators(p->db, "en_US", 0);
1961 err = register_android_functions(p->db, 0);
2321 rc = sqlite3_prepare_v2(p->db, zQuery, -1, &pQuery, 0);
2324 sqlite3_extended_errcode(p->db), sqlite3_errmsg(p->db),
2396 rc = sqlite3_prepare_v2(p->db, zQuery, -1, &pQuery, 0);
2432 rc = sqlite3_prepare_v2(p->db, zQuery, -1, &pQuery, 0);
2435 sqlite3_extended_errcode(p->db), sqlite3_errmsg(p->db),
2459 rc = sqlite3_prepare_v2(p->db, zQuery, -1, &pQuery, 0);
2462 sqlite3_extended_errcode(p->db), sqlite3_errmsg(p->db),
2504 sqlite3_exec(p->db, "PRAGMA writable_schema=ON;", 0, 0, 0);
2509 sqlite3_exec(p->db, "PRAGMA writable_schema=OFF;", 0, 0, 0);
2535 sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
2591 if( p->db==0 ) return 1;
2592 sqlite3_file_control(p->db, zDb, SQLITE_FCNTL_FILE_POINTER, &pFile);
2640 static int shellDatabaseError(sqlite3 *db){
2641 const char *zErr = sqlite3_errmsg(db);
2735 pBackup = sqlite3_backup_init(pDest, "main", p->db, zDb);
2801 sqlite3_exec(p->db, "PRAGMA database_list; ", callback, &data, &zErrMsg);
2826 sqlite3_exec(p->db, "SAVEPOINT dump; PRAGMA writable_schema=ON", 0, 0, 0);
2862 sqlite3_exec(p->db, "PRAGMA writable_schema=OFF;", 0, 0, 0);
2863 sqlite3_exec(p->db, "RELEASE dump;", 0, 0, 0);
2938 rc = sqlite3_exec(p->db,
2949 rc = sqlite3_prepare_v2(p->db,
2960 sqlite3_exec(p->db, "SELECT 'ANALYZE sqlite_master'",
2964 shell_exec(p->db, "SELECT * FROM sqlite_stat1",
2967 shell_exec(p->db, "SELECT * FROM sqlite_stat3",
2970 shell_exec(p->db, "SELECT * FROM sqlite_stat4",
3073 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
3075 if( rc && sqlite3_strglob("no such table: *", sqlite3_errmsg(p->db))==0 ){
3091 rc = sqlite3_exec(p->db, zCreate, 0, 0, 0);
3095 sqlite3_errmsg(p->db));
3100 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
3105 fprintf(stderr,"Error: %s\n", sqlite3_errmsg(p->db));
3127 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
3130 fprintf(stderr, "Error: %s\n", sqlite3_errmsg(p->db));
3135 needCommit = sqlite3_get_autocommit(p->db);
3136 if( needCommit ) sqlite3_exec(p->db, "BEGIN", 0, 0, 0);
3175 sqlite3_errmsg(p->db));
3183 if( needCommit ) sqlite3_exec(p->db, "COMMIT", 0, 0, 0);
3195 rc = sqlite3_exec(p->db,
3206 rc = sqlite3_exec(p->db,
3276 sqlite3_limit(p->db, aLimit[i].limitCode, -1));
3304 sqlite3_limit(p->db, aLimit[iLimit].limitCode,
3308 sqlite3_limit(p->db, aLimit[iLimit].limitCode, -1));
3324 rc = sqlite3_load_extension(p->db, zFile, zProc, &zErrMsg);
3391 sqlite3 *savedDb = p->db;
3394 p->db = 0;
3398 if( p->db!=0 ){
3404 p->db = savedDb;
3511 fprintf(stderr, "Usage: .restore ?DB? FILE\n");
3522 pBackup = sqlite3_backup_init(p->db, zDb, pSrc, "main");
3524 fprintf(stderr, "Error: %s\n", sqlite3_errmsg(p->db));
3542 fprintf(stderr, "Error: %s\n", sqlite3_errmsg(p->db));
3601 rc = sqlite3_exec(p->db,
3613 rc = sqlite3_exec(p->db,
3753 rc = sqlite3_prepare_v2(p->db, "PRAGMA database_list", -1, &pStmt, 0);
3754 if( rc ) return shellDatabaseError(p->db);
3786 if( zSql ) rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
3790 if( rc ) return shellDatabaseError(p->db);
3821 rc = shellDatabaseError(p->db);
3896 /* sqlite3_test_control(int, db, int) */
3901 rc2 = sqlite3_test_control(testctrl, p->db, opt);
3964 rc2 = sqlite3_test_control(testctrl, p->db,
3988 sqlite3_busy_timeout(p->db, nArg>=2 ? (int)integerValue(azArg[1]) : 0);
4015 sqlite3_trace(p->db, 0, 0);
4017 sqlite3_trace(p->db, sql_trace_callback, p->traceOut);
4036 rc = sqlite3_user_authenticate(p->db, azArg[2], azArg[3],
4048 rc = sqlite3_user_add(p->db, azArg[2],
4061 rc = sqlite3_user_change(p->db, azArg[2],
4074 rc = sqlite3_user_delete(p->db, azArg[2]);
4095 if( p->db ){
4096 sqlite3_file_control(p->db, zDbName, SQLITE_FCNTL_VFSNAME, &zVfsName);
4278 rc = shell_exec(p->db, zSql, shell_callback, p, &zErrMsg);
4293 fprintf(stderr, "%s %s\n", zPrefix, sqlite3_errmsg(p->db));
4793 rc = shell_exec(data.db, z, shell_callback, &data, &zErrMsg);
4820 rc = shell_exec(data.db, azCmd[i], shell_callback, &data, &zErrMsg);
4868 if( data.db ){
4869 sqlite3_close(data.db);
