head 1.15; access; symbols pkgsrc-2023Q4:1.15.0.16 pkgsrc-2023Q4-base:1.15 pkgsrc-2023Q3:1.15.0.14 pkgsrc-2023Q3-base:1.15 pkgsrc-2023Q2:1.15.0.12 pkgsrc-2023Q2-base:1.15 pkgsrc-2023Q1:1.15.0.10 pkgsrc-2023Q1-base:1.15 pkgsrc-2022Q4:1.15.0.8 pkgsrc-2022Q4-base:1.15 pkgsrc-2022Q3:1.15.0.6 pkgsrc-2022Q3-base:1.15 pkgsrc-2022Q2:1.15.0.4 pkgsrc-2022Q2-base:1.15 pkgsrc-2022Q1:1.15.0.2 pkgsrc-2022Q1-base:1.15 pkgsrc-2021Q4:1.13.0.30 pkgsrc-2021Q4-base:1.13 pkgsrc-2021Q3:1.13.0.28 pkgsrc-2021Q3-base:1.13 pkgsrc-2021Q2:1.13.0.26 pkgsrc-2021Q2-base:1.13 pkgsrc-2021Q1:1.13.0.24 pkgsrc-2021Q1-base:1.13 pkgsrc-2020Q4:1.13.0.22 pkgsrc-2020Q4-base:1.13 pkgsrc-2020Q3:1.13.0.20 pkgsrc-2020Q3-base:1.13 pkgsrc-2020Q2:1.13.0.18 pkgsrc-2020Q2-base:1.13 pkgsrc-2020Q1:1.13.0.14 pkgsrc-2020Q1-base:1.13 pkgsrc-2019Q4:1.13.0.16 pkgsrc-2019Q4-base:1.13 pkgsrc-2019Q3:1.13.0.12 pkgsrc-2019Q3-base:1.13 pkgsrc-2019Q2:1.13.0.10 pkgsrc-2019Q2-base:1.13 pkgsrc-2019Q1:1.13.0.8 pkgsrc-2019Q1-base:1.13 pkgsrc-2018Q4:1.13.0.6 pkgsrc-2018Q4-base:1.13 pkgsrc-2018Q3:1.13.0.4 pkgsrc-2018Q3-base:1.13 pkgsrc-2018Q2:1.13.0.2 pkgsrc-2018Q2-base:1.13 pkgsrc-2018Q1:1.12.0.50 pkgsrc-2018Q1-base:1.12 pkgsrc-2017Q4:1.12.0.48 pkgsrc-2017Q4-base:1.12 pkgsrc-2017Q3:1.12.0.46 pkgsrc-2017Q3-base:1.12 pkgsrc-2017Q2:1.12.0.42 pkgsrc-2017Q2-base:1.12 pkgsrc-2017Q1:1.12.0.40 pkgsrc-2017Q1-base:1.12 pkgsrc-2016Q4:1.12.0.38 pkgsrc-2016Q4-base:1.12 pkgsrc-2016Q3:1.12.0.36 pkgsrc-2016Q3-base:1.12 pkgsrc-2016Q2:1.12.0.34 pkgsrc-2016Q2-base:1.12 pkgsrc-2016Q1:1.12.0.32 pkgsrc-2016Q1-base:1.12 pkgsrc-2015Q4:1.12.0.30 pkgsrc-2015Q4-base:1.12 pkgsrc-2015Q3:1.12.0.28 pkgsrc-2015Q3-base:1.12 pkgsrc-2015Q2:1.12.0.26 pkgsrc-2015Q2-base:1.12 pkgsrc-2015Q1:1.12.0.24 pkgsrc-2015Q1-base:1.12 pkgsrc-2014Q4:1.12.0.22 pkgsrc-2014Q4-base:1.12 pkgsrc-2014Q3:1.12.0.20 pkgsrc-2014Q3-base:1.12 pkgsrc-2014Q2:1.12.0.18 pkgsrc-2014Q2-base:1.12 pkgsrc-2014Q1:1.12.0.16 pkgsrc-2014Q1-base:1.12 pkgsrc-2013Q4:1.12.0.14 pkgsrc-2013Q4-base:1.12 pkgsrc-2013Q3:1.12.0.12 pkgsrc-2013Q3-base:1.12 pkgsrc-2013Q2:1.12.0.10 pkgsrc-2013Q2-base:1.12 pkgsrc-2013Q1:1.12.0.8 pkgsrc-2013Q1-base:1.12 pkgsrc-2012Q4:1.12.0.6 pkgsrc-2012Q4-base:1.12 pkgsrc-2012Q3:1.12.0.4 pkgsrc-2012Q3-base:1.12 pkgsrc-2012Q2:1.12.0.2 pkgsrc-2012Q2-base:1.12 pkgsrc-2012Q1:1.10.0.6 pkgsrc-2012Q1-base:1.10 pkgsrc-2011Q4:1.10.0.4 pkgsrc-2011Q4-base:1.10 pkgsrc-2011Q3:1.10.0.2 pkgsrc-2011Q3-base:1.10 pkgsrc-2011Q2:1.9.0.4 pkgsrc-2011Q2-base:1.9 pkgsrc-2011Q1:1.9.0.2 pkgsrc-2011Q1-base:1.9 pkgsrc-2010Q4:1.8.0.4 pkgsrc-2010Q4-base:1.8 pkgsrc-2010Q3:1.8.0.2 pkgsrc-2010Q3-base:1.8 pkgsrc-2010Q2:1.6.0.10 pkgsrc-2010Q2-base:1.6 pkgsrc-2010Q1:1.6.0.8 pkgsrc-2010Q1-base:1.6 pkgsrc-2009Q4:1.6.0.6 pkgsrc-2009Q4-base:1.6 pkgsrc-2009Q3:1.6.0.4 pkgsrc-2009Q3-base:1.6 pkgsrc-2009Q2:1.6.0.2 pkgsrc-2009Q2-base:1.6 pkgsrc-2009Q1:1.5.0.8 pkgsrc-2009Q1-base:1.5 pkgsrc-2008Q4:1.5.0.6 pkgsrc-2008Q4-base:1.5 pkgsrc-2008Q3:1.5.0.4 pkgsrc-2008Q3-base:1.5 cube-native-xorg:1.5.0.2 cube-native-xorg-base:1.5 pkgsrc-2008Q2:1.2.0.14 pkgsrc-2008Q2-base:1.2 cwrapper:1.2.0.12 pkgsrc-2008Q1:1.2.0.10 pkgsrc-2008Q1-base:1.2 pkgsrc-2007Q4:1.2.0.8 pkgsrc-2007Q4-base:1.2 pkgsrc-2007Q3:1.2.0.6 pkgsrc-2007Q3-base:1.2 pkgsrc-2007Q2:1.2.0.4 pkgsrc-2007Q2-base:1.2 pkgsrc-2007Q1:1.2.0.2 pkgsrc-2007Q1-base:1.2 pkgsrc-2006Q4:1.1.1.1.0.8 pkgsrc-2006Q4-base:1.1.1.1 pkgsrc-2006Q3:1.1.1.1.0.6 pkgsrc-2006Q3-base:1.1.1.1 pkgsrc-2006Q2:1.1.1.1.0.4 pkgsrc-2006Q2-base:1.1.1.1 pkgsrc-2006Q1:1.1.1.1.0.2 pkgsrc-2006Q1-base:1.1.1.1 pkgsrc-base:1.1.1.1 TNF:1.1.1; locks; strict; comment @# @; 1.15 date 2022.01.14.17.51.52; author wiz; state Exp; branches; next 1.14; commitid qL8I7eLzKRTx0DoD; 1.14 date 2022.01.10.18.55.37; author wiz; state Exp; branches; next 1.13; commitid Q6G5KoO96J0uu7oD; 1.13 date 2018.04.04.11.40.34; author fhajny; state Exp; branches; next 1.12; commitid x99mpGuUyiDnl7xA; 1.12 date 2012.04.09.09.24.01; author obache; state Exp; branches; next 1.11; 1.11 date 2012.04.08.20.21.44; author wiz; state Exp; branches; next 1.10; 1.10 date 2011.09.29.08.35.18; author obache; state Exp; branches; next 1.9; 1.9 date 2011.01.27.16.49.32; author gdt; state Exp; branches; next 1.8; 1.8 date 2010.10.02.06.11.03; author obache; state Exp; branches 1.8.4.1; next 1.7; 1.7 date 2010.09.16.11.31.16; author adam; state Exp; branches; next 1.6; 1.6 date 2009.06.14.17.43.23; author joerg; state Exp; branches; next 1.5; 1.5 date 2008.09.10.10.47.31; author joerg; state Exp; branches; next 1.4; 1.4 date 2008.09.06.16.12.44; author wiz; state Exp; branches; next 1.3; 1.3 date 2008.09.06.16.03.09; author wiz; state Exp; branches; next 1.2; 1.2 date 2007.01.10.10.39.18; author drochner; state Exp; branches; next 1.1; 1.1 date 2006.03.14.20.17.59; author drochner; state Exp; branches 1.1.1.1; next ; 1.8.4.1 date 2011.01.27.15.14.54; author gdt; state Exp; branches; next 1.8.4.2; 1.8.4.2 date 2011.01.27.16.03.46; author gdt; state Exp; branches; next ; 1.1.1.1 date 2006.03.14.20.17.59; author drochner; state Exp; branches; next ; desc @@ 1.15 log @*: python2 egg files are back, add them to the PLISTs @ text @@@comment $NetBSD: PLIST,v 1.14 2022/01/10 18:55:37 wiz Exp $ ${PYSITELIB}/${EGG_INFODIR} ${PYSITELIB}/pysqlite2/__init__.py ${PYSITELIB}/pysqlite2/__init__.pyc ${PYSITELIB}/pysqlite2/__init__.pyo ${PYSITELIB}/pysqlite2/_sqlite.so ${PYSITELIB}/pysqlite2/dbapi2.py ${PYSITELIB}/pysqlite2/dbapi2.pyc ${PYSITELIB}/pysqlite2/dbapi2.pyo ${PYSITELIB}/pysqlite2/dump.py ${PYSITELIB}/pysqlite2/dump.pyc ${PYSITELIB}/pysqlite2/dump.pyo ${PYSITELIB}/pysqlite2/test/__init__.py ${PYSITELIB}/pysqlite2/test/__init__.pyc ${PYSITELIB}/pysqlite2/test/__init__.pyo ${PYSITELIB}/pysqlite2/test/dbapi.py ${PYSITELIB}/pysqlite2/test/dbapi.pyc ${PYSITELIB}/pysqlite2/test/dbapi.pyo ${PYSITELIB}/pysqlite2/test/dump.py ${PYSITELIB}/pysqlite2/test/dump.pyc ${PYSITELIB}/pysqlite2/test/dump.pyo ${PYSITELIB}/pysqlite2/test/factory.py ${PYSITELIB}/pysqlite2/test/factory.pyc ${PYSITELIB}/pysqlite2/test/factory.pyo ${PYSITELIB}/pysqlite2/test/hooks.py ${PYSITELIB}/pysqlite2/test/hooks.pyc ${PYSITELIB}/pysqlite2/test/hooks.pyo ${PYSITELIB}/pysqlite2/test/regression.py ${PYSITELIB}/pysqlite2/test/regression.pyc ${PYSITELIB}/pysqlite2/test/regression.pyo ${PYSITELIB}/pysqlite2/test/transactions.py ${PYSITELIB}/pysqlite2/test/transactions.pyc ${PYSITELIB}/pysqlite2/test/transactions.pyo ${PYSITELIB}/pysqlite2/test/types.py ${PYSITELIB}/pysqlite2/test/types.pyc ${PYSITELIB}/pysqlite2/test/types.pyo ${PYSITELIB}/pysqlite2/test/userfunctions.py ${PYSITELIB}/pysqlite2/test/userfunctions.pyc ${PYSITELIB}/pysqlite2/test/userfunctions.pyo @ 1.14 log @py-sqlite2: convert to egg.mk @ text @d1 2 a2 1 @@comment $NetBSD: PLIST,v 1.13 2018/04/04 11:40:34 fhajny Exp $ @ 1.13 log @databases/py-sqlite2: Update to 2.8.3. Version 2.8.3 ------------- - Fixed bug where cursor.description was an emtpy tuple instead of None for non-SELECT statements Version 2.8.2 ------------- - Make sure pysqlite compiles with Visual Studio, which does not support C99 - Switch to sqlite3_open_v2. The flags parameter is now exposed. You can use it to modify the behaviour of the opened database connection, for example opening a database file in read-only mode or enable URI mode. Version 2.8.1 ------------- BUG FIXES - Fixed multiple refcount problems. IMPROVEMENTS - Added versionchanged about changed transaction behaviour wrt DDL statements to documentation. - I was informed by Roger Binns that FTS5 is not stable yet. The amalgamation is now built with FTS3 and FTS4 instead. Version 2.8.0 ------------- NEW FEATURES - No new features, but tons of bugfixes. These mean that things now work that didn't before: - Transactional DDL now works - You can use SAVEPOINTs now BUILD PROCESS - Python 2.7.x is now required. If trying to use it with Python 3, print a useful error message. Integrated all fixes from the sqlite3 module in Python 2.7.10. MAJOR IMPROVEMENTS - Completety got rid of statement parsing. We now use SQLite functions to determine if a statement modifies the database or not. If a statement modifies the database, then we implicitly start a transaction. For backwards compatibility reasons, we do NOT implicitly start a transaction if we encounter a DDL statement. You can, however, now have transactional DDL if you want to: cur = con.cursor() cur.execute("begin") cur.execute("create table foo(bar)") con.rollback() This also means that people can now finally use SAVEPOINTS. - Use sqlite3_get_autocommit() to determine if we are within a transaction instead of trying to be smart. - Switch to v2 statement API. This simplified the code and will increase stability. MINOR IMPROVEMENTS - You can use unicode strings as index for Row objects. BUGFIXES - Fixed a regression: statements should not be reset after a commit. GENERAL CLEANUP AND DEPRECATIONS - Since december 2005, row_factory is a feature of the Connection class instead of the Cursor class. - DEPRECATE converters and adapters. - DEPRECATE text_factory. - Remove compatibility workarounds for old Python versions. - Remove workarounds for old SQLite versions. - Remove apsw related code. Version 2.7.0 ------------- NEW FEATURES - The limit functionality of SQLite is now wrapped. BUILD PROCESS - Instead of fts3, build fts5 extension when using amalgamation. - use pkg-config for finding SQLite if available - Removed the download/unpacking of SQLite amalgamation files. IMPROVEMENTS - Use toc.db file from the SQLite web site and a custom script to make sure that we have all integer constants mapped to Python. - Use Travis CI - Added Trove classifier to make sure Python 3 users do not accidentally try to install it. BUGFIXES - Fix for parsing fractional second part of timestamps. - Fixed bug where when using converters, empty strings ended up as None on the Python side. - SQLite can cope with text with embedded NUL. We can now, too. - many others @ text @d1 1 a1 2 @@comment $NetBSD$ ${PYSITELIB}/${EGG_FILE} @ 1.12 log @python24 had been removed, no need to take care about it anymore. @ text @d1 1 a1 1 @@comment $NetBSD: PLIST,v 1.11 2012/04/08 20:21:44 wiz Exp $ a27 6 ${PYSITELIB}/pysqlite2/test/py25/__init__.py ${PYSITELIB}/pysqlite2/test/py25/__init__.pyc ${PYSITELIB}/pysqlite2/test/py25/__init__.pyo ${PYSITELIB}/pysqlite2/test/py25/py25tests.py ${PYSITELIB}/pysqlite2/test/py25/py25tests.pyc ${PYSITELIB}/pysqlite2/test/py25/py25tests.pyo @ 1.11 log @All supported python versions in pkgsrc support eggs, so remove ${PLIST.eggfile} from PLISTs and support code from lang/python. @ text @d1 1 a1 1 @@comment $NetBSD: PLIST,v 1.10 2011/09/29 08:35:18 obache Exp $ d28 6 a33 6 ${PLIST.python25}${PYSITELIB}/pysqlite2/test/py25/__init__.py ${PLIST.python25}${PYSITELIB}/pysqlite2/test/py25/__init__.pyc ${PLIST.python25}${PYSITELIB}/pysqlite2/test/py25/__init__.pyo ${PLIST.python25}${PYSITELIB}/pysqlite2/test/py25/py25tests.py ${PLIST.python25}${PYSITELIB}/pysqlite2/test/py25/py25tests.pyc ${PLIST.python25}${PYSITELIB}/pysqlite2/test/py25/py25tests.pyo @ 1.10 log @conditional EGG_FILE installation, fixes for python24. @ text @d1 2 a2 2 @@comment $NetBSD: PLIST,v 1.9 2011/01/27 16:49:32 gdt Exp $ ${PLIST.eggfile}${PYSITELIB}/${EGG_FILE} @ 1.9 log @Use distutils.mk instead of extension.mk, so that egg file is installed. @ text @d1 2 a2 2 @@comment $NetBSD: PLIST,v 1.8.4.1 2011/01/27 15:14:54 gdt Exp $ ${PYSITELIB}/${EGG_FILE} @ 1.8 log @back conditional PLIST for python<2.5, it was lost at updated to 2.6.0. @ text @d1 2 a2 1 @@comment $NetBSD: PLIST,v 1.7 2010/09/16 11:31:16 adam Exp $ @ 1.8.4.1 log @Use distutils.mk instead of extension.mk, and add egg file to PLIST. (distutils.mk includes extension; this change simply adds the egg metadata file that other python programs expect to find.) @ text @d1 1 a1 2 @@comment $NetBSD: PLIST,v 1.8 2010/10/02 06:11:03 obache Exp $ ${PYSITELIB}/${EGG_FILE} @ 1.8.4.2 log @revert accidental commit to release branch @ text @d2 1 @ 1.7 log @Changes 2.6.0: No release notes available. @ text @d1 1 a1 1 @@comment $NetBSD: PLIST,v 1.6 2009/06/14 17:43:23 joerg Exp $ d27 6 a32 6 ${PYSITELIB}/pysqlite2/test/py25/__init__.py ${PYSITELIB}/pysqlite2/test/py25/__init__.pyc ${PYSITELIB}/pysqlite2/test/py25/__init__.pyo ${PYSITELIB}/pysqlite2/test/py25/py25tests.py ${PYSITELIB}/pysqlite2/test/py25/py25tests.pyc ${PYSITELIB}/pysqlite2/test/py25/py25tests.pyo @ 1.6 log @Remove @@dirrm entries from PLISTs @ text @d1 1 a1 1 @@comment $NetBSD: PLIST,v 1.5 2008/09/10 10:47:31 joerg Exp $ d27 6 a32 3 ${PLIST.python25}${PYSITELIB}/pysqlite2/test/py25tests.py ${PLIST.python25}${PYSITELIB}/pysqlite2/test/py25tests.pyc ${PLIST.python25}${PYSITELIB}/pysqlite2/test/py25tests.pyo @ 1.5 log @Don't try to build and install the Python 2.5+ tests on 2.3 and 2.4 to unbreak PLIST for those versions. Bump revision. @ text @d1 1 a1 1 @@comment $NetBSD: PLIST,v 1.4 2008/09/06 16:12:44 wiz Exp $ a41 2 @@dirrm ${PYSITELIB}/pysqlite2/test @@dirrm ${PYSITELIB}/pysqlite2 @ 1.4 log @Found a new homepage, and an even newer version, including changelogs: 2.5.0: - Windows binaries are now cross-built using mingw on Linux - import various fixes from Python 2.6 version - Connection has new method iterdump() that allows you to create a script file that can be used to clone a database - the docs are now built using Sphinx and were imported from Python 2.6's sqlite3 module - Connection.enable_load_extension(enabled) to allow/disallow extension loading. Allows you to use fulltext search extension, for example ;-) - Give the remaining C functions used in multiple .c source files the pysqlite_ prefix. - Release GIL during sqlite3_prepare() calls for better concurrency. - Automatically download the SQLite amalgamation when building statically. 2.4.1: - Made unicode strings for the database parameter in connect() work again - Removed bad defaults from setup.cfg 2.4.0: - Implemented context managers. pysqlite's connections can now be used as context managers with Python 2.5 or later: from __future__ import with_statement from pysqlite2 import dbapi2 as sqlite con = sqlite.connect(":memory:") con.execute("create table person (id integer primary key, firstname varchar unique)") # Successful, con.commit() is called automatically afterwards with con: con.execute("insert into person(firstname) values (?)", ("Joe",)) # con.rollback() is called after the with block finishes with an exception, the # exception is still raised and must be catched try: with con: con.execute("insert into person(firstname) values (?)", ("Joe",)) except sqlite.IntegrityError: print "couldn't add Joe twice" - pysqlite connections can now be created from APSW connections. This enables users to use APSW functionality in applications using the DB-API from pysqlite: from pysqlite2 import dbapi2 as sqlite import apsw apsw_con = apsw.Connection(":memory:") apsw_con.createscalarfunction("times_two", lambda x: 2*x, 1) # Create pysqlite connection from APSW connection con = sqlite.connect(apsw_con) result = con.execute("select times_two(15)").fetchone()[0] assert result == 30 con.close() Caveat: This will only work if both pysqlite and APSW are dynamically linked against the same SQLite shared library. Otherwise you will experience a segfault. - Fixed shuffled docstrings for fetchXXX methods. - Workaround for SQLite 3.5.x versions which apparently return NULL for "no-operation" statements. - Disable the test for rollback detection on old SQLite versions. This prevents test failures on systems that ship outdated SQLite libraries like MacOS X. - Implemented set_progress_handler for progress callbacks from SQLite. This is particularly useful to update GUIs during long-running queries. Thanks to exarkun for the original patch. @ text @d1 1 a1 1 @@comment $NetBSD: PLIST,v 1.3 2008/09/06 16:03:09 wiz Exp $ d27 3 a29 3 ${PYSITELIB}/pysqlite2/test/py25tests.py ${PYSITELIB}/pysqlite2/test/py25tests.pyc ${PYSITELIB}/pysqlite2/test/py25tests.pyo @ 1.3 log @Update to 2.4.1, changes undocumented. @ text @d1 1 a1 1 @@comment $NetBSD: PLIST,v 1.2 2007/01/10 10:39:18 drochner Exp $ d9 3 d18 3 @ 1.2 log @update to 2.3.2 This is a major update (since 2.0.7), involving an API rework add a bl3 file @ text @d1 1 a1 1 @@comment $NetBSD$ d21 3 @ 1.1 log @Initial revision @ text @d2 33 a34 1 ${PYSITELIB}/pysqlite-${PKGVERSION}-py2.4-${LOWER_OPSYS}-${OS_VERSION}-${MACHINE_ARCH}.egg @ 1.1.1.1 log @import pysqlite-2.0.7, an (incompatible) redesign of pysqlite @ text @@