The NetBSD Project

CVS log for pkgsrc/databases/py-sqlite2/Attic/PLIST

[BACK] Up to [cvs.NetBSD.org] / pkgsrc / databases / py-sqlite2

Request diff between arbitrary revisions


Keyword substitution: kv
Default branch: MAIN


Revision 1.16
Sun Jan 25 12:12:41 2026 UTC (9 months, 2 weeks ago) by adam
Branches: MAIN
CVS tags: HEAD
FILE REMOVED
Changes since revision 1.15: +1 -1 lines
py-sqlite2: removed; last update: 2016-08-30

Revision 1.15: download - view: text, markup, annotated - select for diffs
Fri Jan 14 17:51:52 2022 UTC (4 years, 10 months ago) by wiz
Branches: MAIN
CVS tags: pkgsrc-2025Q4-base, pkgsrc-2025Q4, pkgsrc-2025Q3-base, pkgsrc-2025Q3, pkgsrc-2025Q2-base, pkgsrc-2025Q2, pkgsrc-2025Q1-base, pkgsrc-2025Q1, pkgsrc-2024Q4-base, pkgsrc-2024Q4, pkgsrc-2024Q3-base, pkgsrc-2024Q3, pkgsrc-2024Q2-base, pkgsrc-2024Q2, pkgsrc-2024Q1-base, pkgsrc-2024Q1, pkgsrc-2023Q4-base, pkgsrc-2023Q4, pkgsrc-2023Q3-base, pkgsrc-2023Q3, pkgsrc-2023Q2-base, pkgsrc-2023Q2, pkgsrc-2023Q1-base, pkgsrc-2023Q1, pkgsrc-2022Q4-base, pkgsrc-2022Q4, pkgsrc-2022Q3-base, pkgsrc-2022Q3, pkgsrc-2022Q2-base, pkgsrc-2022Q2, pkgsrc-2022Q1-base, pkgsrc-2022Q1
Diff to: previous 1.14: preferred, colored
Changes since revision 1.14: +2 -1 lines
*: python2 egg files are back, add them to the PLISTs

Revision 1.14: download - view: text, markup, annotated - select for diffs
Mon Jan 10 18:55:37 2022 UTC (4 years, 10 months ago) by wiz
Branches: MAIN
Diff to: previous 1.13: preferred, colored
Changes since revision 1.13: +1 -2 lines
py-sqlite2: convert to egg.mk

Revision 1.13: download - view: text, markup, annotated - select for diffs
Wed Apr 4 11:40:34 2018 UTC (8 years, 7 months ago) by fhajny
Branches: MAIN
CVS tags: pkgsrc-2021Q4-base, pkgsrc-2021Q4, pkgsrc-2021Q3-base, pkgsrc-2021Q3, pkgsrc-2021Q2-base, pkgsrc-2021Q2, pkgsrc-2021Q1-base, pkgsrc-2021Q1, pkgsrc-2020Q4-base, pkgsrc-2020Q4, pkgsrc-2020Q3-base, pkgsrc-2020Q3, pkgsrc-2020Q2-base, pkgsrc-2020Q2, pkgsrc-2020Q1-base, pkgsrc-2020Q1, pkgsrc-2019Q4-base, pkgsrc-2019Q4, pkgsrc-2019Q3-base, pkgsrc-2019Q3, pkgsrc-2019Q2-base, pkgsrc-2019Q2, pkgsrc-2019Q1-base, pkgsrc-2019Q1, pkgsrc-2018Q4-base, pkgsrc-2018Q4, pkgsrc-2018Q3-base, pkgsrc-2018Q3, pkgsrc-2018Q2-base, pkgsrc-2018Q2
Diff to: previous 1.12: preferred, colored
Changes since revision 1.12: +1 -7 lines
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

Revision 1.12: download - view: text, markup, annotated - select for diffs
Mon Apr 9 09:24:01 2012 UTC (14 years, 7 months ago) by obache
Branches: MAIN
CVS tags: pkgsrc-2018Q1-base, pkgsrc-2018Q1, pkgsrc-2017Q4-base, pkgsrc-2017Q4, pkgsrc-2017Q3-base, pkgsrc-2017Q3, pkgsrc-2017Q2-base, pkgsrc-2017Q2, pkgsrc-2017Q1-base, pkgsrc-2017Q1, pkgsrc-2016Q4-base, pkgsrc-2016Q4, pkgsrc-2016Q3-base, pkgsrc-2016Q3, pkgsrc-2016Q2-base, pkgsrc-2016Q2, pkgsrc-2016Q1-base, pkgsrc-2016Q1, pkgsrc-2015Q4-base, pkgsrc-2015Q4, pkgsrc-2015Q3-base, pkgsrc-2015Q3, pkgsrc-2015Q2-base, pkgsrc-2015Q2, pkgsrc-2015Q1-base, pkgsrc-2015Q1, pkgsrc-2014Q4-base, pkgsrc-2014Q4, pkgsrc-2014Q3-base, pkgsrc-2014Q3, pkgsrc-2014Q2-base, pkgsrc-2014Q2, pkgsrc-2014Q1-base, pkgsrc-2014Q1, pkgsrc-2013Q4-base, pkgsrc-2013Q4, pkgsrc-2013Q3-base, pkgsrc-2013Q3, pkgsrc-2013Q2-base, pkgsrc-2013Q2, pkgsrc-2013Q1-base, pkgsrc-2013Q1, pkgsrc-2012Q4-base, pkgsrc-2012Q4, pkgsrc-2012Q3-base, pkgsrc-2012Q3, pkgsrc-2012Q2-base, pkgsrc-2012Q2
Diff to: previous 1.11: preferred, colored
Changes since revision 1.11: +7 -7 lines
python24 had been removed, no need to take care about it anymore.

Revision 1.11: download - view: text, markup, annotated - select for diffs
Sun Apr 8 20:21:44 2012 UTC (14 years, 7 months ago) by wiz
Branches: MAIN
Diff to: previous 1.10: preferred, colored
Changes since revision 1.10: +2 -2 lines
All supported python versions in pkgsrc support eggs, so remove
${PLIST.eggfile} from PLISTs and support code from lang/python.

Revision 1.10: download - view: text, markup, annotated - select for diffs
Thu Sep 29 08:35:18 2011 UTC (15 years, 1 month ago) by obache
Branches: MAIN
CVS tags: pkgsrc-2012Q1-base, pkgsrc-2012Q1, pkgsrc-2011Q4-base, pkgsrc-2011Q4, pkgsrc-2011Q3-base, pkgsrc-2011Q3
Diff to: previous 1.9: preferred, colored
Changes since revision 1.9: +2 -2 lines
conditional EGG_FILE installation, fixes for python24.

Revision 1.9: download - view: text, markup, annotated - select for diffs
Thu Jan 27 16:49:32 2011 UTC (15 years, 9 months ago) by gdt
Branches: MAIN
CVS tags: pkgsrc-2011Q2-base, pkgsrc-2011Q2, pkgsrc-2011Q1-base, pkgsrc-2011Q1
Diff to: previous 1.8: preferred, colored
Changes since revision 1.8: +2 -1 lines
Use distutils.mk instead of extension.mk, so that egg file is installed.

Revision 1.8.4.2: download - view: text, markup, annotated - select for diffs
Thu Jan 27 16:03:46 2011 UTC (15 years, 9 months ago) by gdt
Branches: pkgsrc-2010Q4
Diff to: previous 1.8.4.1: preferred, colored; branchpoint 1.8: preferred, colored; next MAIN 1.9: preferred, colored
Changes since revision 1.8.4.1: +0 -1 lines
revert accidental commit to release branch

Revision 1.8.4.1: download - view: text, markup, annotated - select for diffs
Thu Jan 27 15:14:54 2011 UTC (15 years, 9 months ago) by gdt
Branches: pkgsrc-2010Q4
Diff to: previous 1.8: preferred, colored
Changes since revision 1.8: +2 -1 lines
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.)

Revision 1.8: download - view: text, markup, annotated - select for diffs
Sat Oct 2 06:11:03 2010 UTC (16 years, 1 month ago) by obache
Branches: MAIN
CVS tags: pkgsrc-2010Q4-base, pkgsrc-2010Q3-base, pkgsrc-2010Q3
Branch point for: pkgsrc-2010Q4
Diff to: previous 1.7: preferred, colored
Changes since revision 1.7: +7 -7 lines
back conditional PLIST for python<2.5, it was lost at updated to 2.6.0.

Revision 1.7: download - view: text, markup, annotated - select for diffs
Thu Sep 16 11:31:16 2010 UTC (16 years, 2 months ago) by adam
Branches: MAIN
Diff to: previous 1.6: preferred, colored
Changes since revision 1.6: +7 -4 lines
Changes 2.6.0:
No release notes available.

Revision 1.6: download - view: text, markup, annotated - select for diffs
Sun Jun 14 17:43:23 2009 UTC (17 years, 5 months ago) by joerg
Branches: MAIN
CVS tags: pkgsrc-2010Q2-base, pkgsrc-2010Q2, pkgsrc-2010Q1-base, pkgsrc-2010Q1, pkgsrc-2009Q4-base, pkgsrc-2009Q4, pkgsrc-2009Q3-base, pkgsrc-2009Q3, pkgsrc-2009Q2-base, pkgsrc-2009Q2
Diff to: previous 1.5: preferred, colored
Changes since revision 1.5: +1 -3 lines
Remove @dirrm entries from PLISTs

Revision 1.5: download - view: text, markup, annotated - select for diffs
Wed Sep 10 10:47:31 2008 UTC (18 years, 2 months ago) by joerg
Branches: MAIN
CVS tags: pkgsrc-2009Q1-base, pkgsrc-2009Q1, pkgsrc-2008Q4-base, pkgsrc-2008Q4, pkgsrc-2008Q3-base, pkgsrc-2008Q3, cube-native-xorg-base, cube-native-xorg
Diff to: previous 1.4: preferred, colored
Changes since revision 1.4: +4 -4 lines
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.

Revision 1.4: download - view: text, markup, annotated - select for diffs
Sat Sep 6 16:12:44 2008 UTC (18 years, 2 months ago) by wiz
Branches: MAIN
Diff to: previous 1.3: preferred, colored
Changes since revision 1.3: +7 -1 lines
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.

Revision 1.3: download - view: text, markup, annotated - select for diffs
Sat Sep 6 16:03:09 2008 UTC (18 years, 2 months ago) by wiz
Branches: MAIN
Diff to: previous 1.2: preferred, colored
Changes since revision 1.2: +4 -1 lines
Update to 2.4.1, changes undocumented.

Revision 1.2: download - view: text, markup, annotated - select for diffs
Wed Jan 10 10:39:18 2007 UTC (19 years, 10 months ago) by drochner
Branches: MAIN
CVS tags: pkgsrc-2008Q2-base, pkgsrc-2008Q2, pkgsrc-2008Q1-base, pkgsrc-2008Q1, pkgsrc-2007Q4-base, pkgsrc-2007Q4, pkgsrc-2007Q3-base, pkgsrc-2007Q3, pkgsrc-2007Q2-base, pkgsrc-2007Q2, pkgsrc-2007Q1-base, pkgsrc-2007Q1, cwrapper
Diff to: previous 1.1: preferred, colored
Changes since revision 1.1: +33 -1 lines
update to 2.3.2
This is a major update (since 2.0.7), involving an API rework

add a bl3 file

Revision 1.1.1.1 (vendor branch): download - view: text, markup, annotated - select for diffs
Tue Mar 14 20:17:59 2006 UTC (20 years, 8 months ago) by drochner
Branches: TNF
CVS tags: pkgsrc-base, pkgsrc-2006Q4-base, pkgsrc-2006Q4, pkgsrc-2006Q3-base, pkgsrc-2006Q3, pkgsrc-2006Q2-base, pkgsrc-2006Q2, pkgsrc-2006Q1-base, pkgsrc-2006Q1
Diff to: previous 1.1: preferred, colored
Changes since revision 1.1: +0 -0 lines
import pysqlite-2.0.7, an (incompatible) redesign of pysqlite

Revision 1.1: download - view: text, markup, annotated - select for diffs
Tue Mar 14 20:17:59 2006 UTC (20 years, 8 months ago) by drochner
Branches: MAIN
Initial revision

Diff request

This form allows you to request diffs between any two revisions of a file. You may select a symbolic revision name using the selection box or you may type in a numeric name using the type-in text box.

Log view options

CVSweb <webmaster@jp.NetBSD.org>