Lines Matching refs:pDb
506 Sqlite *pDb, in sqlite_error() argument
509 pErr->rc = sqlite3_errcode(pDb->db); in sqlite_error()
511 "sqlite3_%s() - %s (%d)", zFunc, sqlite3_errmsg(pDb->db), in sqlite_error()
512 sqlite3_extended_errcode(pDb->db) in sqlite_error()
546 Sqlite *pDb, /* OUT: Database handle */ in opendb_x() argument
554 rc = sqlite3_open_v2(zFile, &pDb->db, flags, 0); in opendb_x()
556 sqlite_error(pErr, pDb, "open"); in opendb_x()
557 sqlite3_close(pDb->db); in opendb_x()
558 pDb->db = 0; in opendb_x()
561 pDb->db, "md5sum", -1, SQLITE_UTF8, 0, 0, md5step, md5finalize in opendb_x()
563 sqlite3_busy_handler(pDb->db, busyhandler, 0); in opendb_x()
564 sqlite3_exec(pDb->db, "PRAGMA synchronous=OFF", 0, 0, 0); in opendb_x()
571 Sqlite *pDb /* OUT: Database handle */ in closedb_x() argument
577 for(pIter=pDb->pCache; pIter; pIter=pNext){ in closedb_x()
582 for(i=0; i<pDb->nText; i++){ in closedb_x()
583 sqlite3_free(pDb->aText[i]); in closedb_x()
585 sqlite3_free(pDb->aText); in closedb_x()
586 rc = sqlite3_close(pDb->db); in closedb_x()
588 pErr->zErr = sqlite3_mprintf("%s", sqlite3_errmsg(pDb->db)); in closedb_x()
590 memset(pDb, 0, sizeof(Sqlite)); in closedb_x()
595 Sqlite *pDb, /* Database handle */ in sql_script_x() argument
599 pErr->rc = sqlite3_exec(pDb->db, zSql, 0, 0, &pErr->zErr); in sql_script_x()
605 Sqlite *pDb, /* Database handle */ in sql_script_printf_x() argument
613 pErr->rc = sqlite3_exec(pDb->db, zSql, 0, 0, &pErr->zErr); in sql_script_printf_x()
621 Sqlite *pDb, /* Database handle */ in getSqlStatement() argument
627 for(pRet=pDb->pCache; pRet; pRet=pRet->pNext){ in getSqlStatement()
634 rc = sqlite3_prepare_v2(pDb->db, zSql, -1, &pRet->pStmt, 0); in getSqlStatement()
636 sqlite_error(pErr, pDb, "prepare_v2"); in getSqlStatement()
641 pRet->pNext = pDb->pCache; in getSqlStatement()
642 pDb->pCache = pRet; in getSqlStatement()
648 Sqlite *pDb, /* Database handle */ in getAndBindSqlStatement() argument
655 pStatement = getSqlStatement(pErr, pDb, va_arg(ap, const char *)); in getAndBindSqlStatement()
680 Sqlite *pDb, /* Database handle */ in execsql_i64_x() argument
687 va_start(ap, pDb); in execsql_i64_x()
688 pStmt = getAndBindSqlStatement(pErr, pDb, ap); in execsql_i64_x()
698 sqlite_error(pErr, pDb, "reset"); in execsql_i64_x()
708 Sqlite *pDb, /* Database handle */ in execsql_text_x() argument
714 if( iSlot>=pDb->nText ){ in execsql_text_x()
716 pDb->aText = (char **)sqlite3_realloc(pDb->aText, nByte); in execsql_text_x()
717 memset(&pDb->aText[pDb->nText], 0, sizeof(char*)*(iSlot+1-pDb->nText)); in execsql_text_x()
718 pDb->nText = iSlot+1; in execsql_text_x()
725 pStmt = getAndBindSqlStatement(pErr, pDb, ap); in execsql_text_x()
731 sqlite3_free(pDb->aText[iSlot]); in execsql_text_x()
732 pDb->aText[iSlot] = zRet; in execsql_text_x()
737 sqlite_error(pErr, pDb, "reset"); in execsql_text_x()
748 Sqlite *pDb /* Database handle */ in integrity_check_x() argument
754 pStatement = getSqlStatement(pErr, pDb, "PRAGMA integrity_check"); in integrity_check_x()
1315 static void cgt_pager_1_populate(Error *pErr, Sqlite *pDb){ in cgt_pager_1_populate() argument
1318 sql_script(pErr, pDb, "BEGIN"); in cgt_pager_1_populate()
1321 execsql(pErr, pDb, zInsert, &iRow, &iBlob); in cgt_pager_1_populate()
1323 sql_script(pErr, pDb, "COMMIT"); in cgt_pager_1_populate()
1325 static void cgt_pager_1_update(Error *pErr, Sqlite *pDb){ in cgt_pager_1_update() argument
1328 sql_script(pErr, pDb, "BEGIN"); in cgt_pager_1_update()
1331 execsql(pErr, pDb, zUpdate, &iBlob, &iRow); in cgt_pager_1_update()
1333 sql_script(pErr, pDb, "COMMIT"); in cgt_pager_1_update()
1335 static void cgt_pager_1_read(Error *pErr, Sqlite *pDb){ in cgt_pager_1_read() argument
1337 sql_script(pErr, pDb, "BEGIN"); in cgt_pager_1_read()
1339 execsql(pErr, pDb, "SELECT * FROM t1 WHERE a = :iRow", &iRow); in cgt_pager_1_read()
1341 sql_script(pErr, pDb, "COMMIT"); in cgt_pager_1_read()