windows11编译安装pysqlcipher3

后端

152.5KB

33 需要积分: 1

立即下载

资源介绍:

windows11编译安装pysqlcipher3

/* connection.c - the connection type * * Copyright (C) 2004-2010 Gerhard Häring * * This file is part of pysqlite. * * This software is provided 'as-is', without any express or implied * warranty. In no event will the authors be held liable for any damages * arising from the use of this software. * * Permission is granted to anyone to use this software for any purpose, * including commercial applications, and to alter it and redistribute it * freely, subject to the following restrictions: * * 1. The origin of this software must not be misrepresented; you must not * claim that you wrote the original software. If you use this software * in a product, an acknowledgment in the product documentation would be * appreciated but is not required. * 2. Altered source versions must be plainly marked as such, and must not be * misrepresented as being the original software. * 3. This notice may not be removed or altered from any source distribution. */ #include "cache.h" #include "module.h" #include "structmember.h" #include "connection.h" #include "statement.h" #include "cursor.h" #include "prepare_protocol.h" #include "util.h" #include "pythread.h" #define ACTION_FINALIZE 1 #define ACTION_RESET 2 #if SQLITE_VERSION_NUMBER >= 3003008 #ifndef SQLITE_OMIT_LOAD_EXTENSION #define HAVE_LOAD_EXTENSION #endif #endif _Py_IDENTIFIER(cursor); static int pysqlite_connection_set_isolation_level(pysqlite_Connection* self, PyObject* isolation_level); static void _pysqlite_drop_unused_cursor_references(pysqlite_Connection* self); static void _sqlite3_result_error(sqlite3_context* ctx, const char* errmsg, int len) { /* in older SQLite versions, calling sqlite3_result_error in callbacks * triggers a bug in SQLite that leads either to irritating results or * segfaults, depending on the SQLite version */ #if SQLITE_VERSION_NUMBER >= 3003003 sqlite3_result_error(ctx, errmsg, len); #else PyErr_SetString(pysqlite_OperationalError, errmsg); #endif } int pysqlite_connection_init(pysqlite_Connection* self, PyObject* args, PyObject* kwargs) { static char *kwlist[] = { "database", "timeout", "detect_types", "isolation_level", "check_same_thread", "factory", "cached_statements", "uri", NULL }; char* database; int detect_types = 0; PyObject* isolation_level = NULL; PyObject* factory = NULL; int check_same_thread = 1; int cached_statements = 100; int uri = 0; double timeout = 5.0; int rc; if (!PyArg_ParseTupleAndKeywords(args, kwargs, "s|diOiOip", kwlist, &database, &timeout, &detect_types, &isolation_level, &check_same_thread, &factory, &cached_statements, &uri)) { return -1; } self->initialized = 1; self->begin_statement = NULL; self->statement_cache = NULL; self->statements = NULL; self->cursors = NULL; Py_INCREF(Py_None); self->row_factory = Py_None; Py_INCREF(&PyUnicode_Type); self->text_factory = (PyObject*)&PyUnicode_Type; #ifdef SQLITE_OPEN_URI Py_BEGIN_ALLOW_THREADS rc = sqlite3_open_v2(database, &self->db, SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE | (uri ? SQLITE_OPEN_URI : 0), NULL); #else if (uri) { PyErr_SetString(pysqlite_NotSupportedError, "URIs not supported"); return -1; } Py_BEGIN_ALLOW_THREADS rc = sqlite3_open(database, &self->db); #endif Py_END_ALLOW_THREADS if (rc != SQLITE_OK) { _pysqlite_seterror(self->db, NULL); return -1; } if (!isolation_level) { isolation_level = PyUnicode_FromString(""); if (!isolation_level) { return -1; } } else { Py_INCREF(isolation_level); } self->isolation_level = NULL; if (pysqlite_connection_set_isolation_level(self, isolation_level) < 0) { Py_DECREF(isolation_level); return -1; } Py_DECREF(isolation_level); self->statement_cache = (pysqlite_Cache*)PyObject_CallFunction((PyObject*)&pysqlite_CacheType, "Oi", self, cached_statements); if (PyErr_Occurred()) { return -1; } self->created_statements = 0; self->created_cursors = 0; /* Create lists of weak references to statements/cursors */ self->statements = PyList_New(0); self->cursors = PyList_New(0); if (!self->statements || !self->cursors) { return -1; } /* By default, the Cache class INCREFs the factory in its initializer, and * decrefs it in its deallocator method. Since this would create a circular * reference here, we're breaking it by decrementing self, and telling the * cache class to not decref the factory (self) in its deallocator. */ self->statement_cache->decref_factory = 0; Py_DECREF(self); self->inTransaction = 0; self->detect_types = detect_types; self->timeout = timeout; (void)sqlite3_busy_timeout(self->db, (int)(timeout*1000)); #ifdef WITH_THREAD self->thread_ident = PyThread_get_thread_ident(); #endif self->check_same_thread = check_same_thread; self->function_pinboard = PyDict_New(); if (!self->function_pinboard) { return -1; } self->collations = PyDict_New(); if (!self->collations) { return -1; } self->Warning = pysqlite_Warning; self->Error = pysqlite_Error; self->InterfaceError = pysqlite_InterfaceError; self->DatabaseError = pysqlite_DatabaseError; self->DataError = pysqlite_DataError; self->OperationalError = pysqlite_OperationalError; self->IntegrityError = pysqlite_IntegrityError; self->InternalError = pysqlite_InternalError; self->ProgrammingError = pysqlite_ProgrammingError; self->NotSupportedError = pysqlite_NotSupportedError; return 0; } /* Empty the entire statement cache of this connection */ void pysqlite_flush_statement_cache(pysqlite_Connection* self) { pysqlite_Node* node; pysqlite_Statement* statement; node = self->statement_cache->first; while (node) { statement = (pysqlite_Statement*)(node->data); (void)pysqlite_statement_finalize(statement); node = node->next; } Py_DECREF(self->statement_cache); self->statement_cache = (pysqlite_Cache*)PyObject_CallFunction((PyObject*)&pysqlite_CacheType, "O", self); Py_DECREF(self); self->statement_cache->decref_factory = 0; } /* action in (ACTION_RESET, ACTION_FINALIZE) */ void pysqlite_do_all_statements(pysqlite_Connection* self, int action, int reset_cursors) { int i; PyObject* weakref; PyObject* statement; pysqlite_Cursor* cursor; for (i = 0; i < PyList_Size(self->statements); i++) { weakref = PyList_GetItem(self->statements, i); statement = PyWeakref_GetObject(weakref); if (statement != Py_None) { Py_INCREF(statement); if (action == ACTION_RESET) { (void)pysqlite_statement_reset((pysqlite_Statement*)statement); } else { (void)pysqlite_statement_finalize((pysqlite_Statement*)statement); } Py_DECREF(statement); } } if (reset_cursors) { for (i = 0; i < PyList_Size(self->cursors); i++) { weakref = PyList_GetItem(self->cursors, i); cursor = (pysqlite_Cursor*)PyWeakref_GetObject(weakref); if ((PyObject*)cursor != Py_None) { cursor->reset = 1; } } } } void pysqlite_connection_dealloc(pysqlite_Connection* self) { Py_XDECREF(self->statement_cache); /* Clean up if user has not called .close() explicitly. */ if (self->db) { Py_BEGIN_ALLOW_THREADS sqlite3_close(self->db); Py_END_A

资源文件列表:

pysqlcipher3-master.zip 大约有77个文件

pysqlcipher3-master/
pysqlcipher3-master/.gitignore 698B
pysqlcipher3-master/LICENSE 991B
pysqlcipher3-master/MANIFEST.in 154B
pysqlcipher3-master/NEWS.rst 343B
pysqlcipher3-master/README.rst 4.68KB
pysqlcipher3-master/lib/
pysqlcipher3-master/lib/__init__.py 988B
pysqlcipher3-master/lib/dbapi2.py 3.08KB
pysqlcipher3-master/lib/dump.py 2.76KB
pysqlcipher3-master/lib/test/
pysqlcipher3-master/lib/test/__init__.py 1.25KB
pysqlcipher3-master/lib/test/python2/
pysqlcipher3-master/lib/test/python2/__init__.py 1.45KB
pysqlcipher3-master/lib/test/python2/dbapi.py 29.19KB
pysqlcipher3-master/lib/test/python2/dump.py 1.71KB
pysqlcipher3-master/lib/test/python2/factory.py 7.76KB
pysqlcipher3-master/lib/test/python2/hooks.py 6.42KB
pysqlcipher3-master/lib/test/python2/regression.py 9.46KB
pysqlcipher3-master/lib/test/python2/sqlcipher.py 3.68KB
pysqlcipher3-master/lib/test/python2/transactions.py 7.19KB
pysqlcipher3-master/lib/test/python2/types.py 14.49KB
pysqlcipher3-master/lib/test/python2/userfunctions.py 12.91KB
pysqlcipher3-master/lib/test/python3/
pysqlcipher3-master/lib/test/python3/__init__.py 1.45KB
pysqlcipher3-master/lib/test/python3/dbapi.py 30.68KB
pysqlcipher3-master/lib/test/python3/dump.py 2.79KB
pysqlcipher3-master/lib/test/python3/factory.py 9.41KB
pysqlcipher3-master/lib/test/python3/hooks.py 9.21KB
pysqlcipher3-master/lib/test/python3/regression.py 12.63KB
pysqlcipher3-master/lib/test/python3/sqlcipher.py 3.68KB
pysqlcipher3-master/lib/test/python3/transactions.py 7.18KB
pysqlcipher3-master/lib/test/python3/types.py 14.11KB
pysqlcipher3-master/lib/test/python3/userfunctions.py 14.68KB
pysqlcipher3-master/setup.cfg 32B
pysqlcipher3-master/setup.py 7.09KB
pysqlcipher3-master/src/
pysqlcipher3-master/src/python2/
pysqlcipher3-master/src/python2/backup.h 1.35KB
pysqlcipher3-master/src/python2/cache.c 12.63KB
pysqlcipher3-master/src/python2/cache.h 2.28KB
pysqlcipher3-master/src/python2/connection.c 49.25KB
pysqlcipher3-master/src/python2/connection.h 5.03KB
pysqlcipher3-master/src/python2/cursor.c 34.51KB
pysqlcipher3-master/src/python2/cursor.h 2.52KB
pysqlcipher3-master/src/python2/microprotocols.c 4.25KB
pysqlcipher3-master/src/python2/microprotocols.h 2.07KB
pysqlcipher3-master/src/python2/module.c 14.91KB
pysqlcipher3-master/src/python2/module.h 1.97KB
pysqlcipher3-master/src/python2/prepare_protocol.c 4.32KB
pysqlcipher3-master/src/python2/prepare_protocol.h 1.46KB
pysqlcipher3-master/src/python2/row.c 8.65KB
pysqlcipher3-master/src/python2/row.h 1.24KB
pysqlcipher3-master/src/python2/sqlitecompat.h 1.9KB
pysqlcipher3-master/src/python2/statement.c 17.9KB
pysqlcipher3-master/src/python2/statement.h 2.12KB
pysqlcipher3-master/src/python2/util.c 3.24KB
pysqlcipher3-master/src/python2/util.h 1.4KB
pysqlcipher3-master/src/python3/
pysqlcipher3-master/src/python3/cache.c 12.19KB
pysqlcipher3-master/src/python3/cache.h 2.28KB
pysqlcipher3-master/src/python3/connection.c 49.75KB
pysqlcipher3-master/src/python3/connection.h 4.76KB
pysqlcipher3-master/src/python3/cursor.c 34.53KB
pysqlcipher3-master/src/python3/cursor.h 2.54KB
pysqlcipher3-master/src/python3/microprotocols.c 4.34KB
pysqlcipher3-master/src/python3/microprotocols.h 2.07KB
pysqlcipher3-master/src/python3/module.c 15.14KB
pysqlcipher3-master/src/python3/module.h 1.93KB
pysqlcipher3-master/src/python3/prepare_protocol.c 4.3KB
pysqlcipher3-master/src/python3/prepare_protocol.h 1.77KB
pysqlcipher3-master/src/python3/row.c 9.23KB
pysqlcipher3-master/src/python3/row.h 1.24KB
pysqlcipher3-master/src/python3/statement.c 16.99KB
pysqlcipher3-master/src/python3/statement.h 2.08KB
pysqlcipher3-master/src/python3/util.c 5.11KB
pysqlcipher3-master/src/python3/util.h 1.51KB