import re

import os

def check_disallow_instantiation(testcase, tp, *args, **kwds):

"""

Check that given type cannot be instantiated using *args and **kwds.

See bpo-43916: Add Py_TPFLAGS_DISALLOW_INSTANTIATION type flag.

"""

mod = tp.__module__

name = tp.__name__

if mod != 'builtins':

qualname = f"{mod}.{name}"

else:

qualname = f"{name}"

msg = f"cannot create '{re.escape(qualname)}' instances"

testcase.assertRaisesRegex(TypeError, msg, tp, *args, **kwds)

def gc_collect():

"""Force as many objects as possible to be collected.

In non-CPython implementations of Python, this is needed because timely

deallocation is not guaranteed by the garbage collector. (Even in CPython

this can be the case in case of reference cycles.) This means that __del__

methods may be called later than expected and weakrefs may remain alive for

longer than expected. This function tries its best to force all garbage

objects to disappear.

"""

import gc

gc.collect()

gc.collect()

gc.collect()

def unlink(filename):

try:

os.unlink(filename)

except (FileNotFoundError, NotADirectoryError):

pass

SHORT_TIMEOUT = 30.0

TESTFN = "{}_{}_tmp".format('@test', os.getpid())

test_suite_list = []

"""

/*jslint-disable*/

/*

shRollupFetch

{

"fetchList": [

{

"comment": true,

"url": "https://github.com/python/cpython/blob/v3.10.11/LICENSE"

},

{

"footer": "\n\"\"\"\n",

"header": "\n\"\"\"\nif __name__ != \"__main__\":\n",

"replaceList": [

{

"aa": "^.+\n",

"bb": " $&",

"flags": "gm",

"substr": ""

}

],

"url": "https://github.com/python/cpython/blob/v3.10.11/Lib/sqlite3/dbapi2.py"

},

{

"footer": "\n\"\"\"\n",

"header": "\n\"\"\"\n",

"url": "https://github.com/python/cpython/blob/v3.10.11/Lib/sqlite3/test/backup.py"

},

{

"footer": "\n\"\"\"\n",

"header": "\n\"\"\"\n",

"url": "https://github.com/python/cpython/blob/v3.10.11/Lib/sqlite3/test/dbapi.py"

},

{

"footer": "\n\"\"\"\n",

"header": "\n\"\"\"\n",

"url": "https://github.com/python/cpython/blob/v3.10.11/Lib/sqlite3/test/dump.py"

},

{

"footer": "\n\"\"\"\n",

"header": "\n\"\"\"\n",

"url": "https://github.com/python/cpython/blob/v3.10.11/Lib/sqlite3/test/factory.py"

},

{

"footer": "\n\"\"\"\n",

"header": "\n\"\"\"\n",

"url": "https://github.com/python/cpython/blob/v3.10.11/Lib/sqlite3/test/hooks.py"

},

{

"footer": "\n\"\"\"\n",

"header": "\n\"\"\"\n",

"url": "https://github.com/python/cpython/blob/v3.10.11/Lib/sqlite3/test/regression.py"

},

{

"footer": "\n\"\"\"\n",

"header": "\n\"\"\"\n",

"url": "https://github.com/python/cpython/blob/v3.10.11/Lib/sqlite3/test/types.py"

},

{

"footer": "\n\"\"\"\n",

"header": "\n\"\"\"\n",

"url": "https://github.com/python/cpython/blob/v3.10.11/Lib/sqlite3/test/userfunctions.py"

}

],

"replaceList": [

{

"aa": "@unittest.skipIf.*?\\n *?def test_shared_cache_deprecated\\([\\S\\s]*? def ",

"bb": "def ",

"flags": "g",

"substr": ""

},

{

"aa": "\\b_sqlite3\\b",

"bb": "_sqlmath",

"flags": "g",

"substr": ""

},

{

"aa": "\\nif __name__ == .__main__.:\\n .*?test.*?\\n",

"bb": "\n# hack-python - append test-suite\ntest_suite_list.append(suite)\n",

"flags": "g",

"substr": ""

},

{

"aa": "def test_optimized_unicode\\([\\S\\s]*? def ",

"bb": "def ",

"flags": "g",

"substr": ""

},

{

"aa": "from test.support",

"bb": "# hack-python - fix test for win32\n# $&",

"flags": "g",

"substr": ""

},

{

"aa": "import sqlite3 as sqlite",

"bb": "from . import sqlmath_dbapi2 as sqlite",

"flags": "g",

"substr": ""

}

]

}

- import sqlite3

+# hack-python - fix import

+ import sqlmath as sqlite3

- support.gc_collect()

+ # hack-python - fix test for win32

+ gc_collect()

- from _sqlmath import *

+# hack-python - fix import

+ from ._sqlmath import *

-from test import support

+# hack-python - fix test for win32

+# from test import support

*/

/*

repo https://github.com/python/cpython/tree/v3.10.11

committed 2023-04-04T21:57:15Z

*/

/*

file https://github.com/python/cpython/blob/v3.10.11/LICENSE

*/

/*

A. HISTORY OF THE SOFTWARE

==========================

Python was created in the early 1990s by Guido van Rossum at Stichting

Mathematisch Centrum (CWI, see https://www.cwi.nl) in the Netherlands

as a successor of a language called ABC. Guido remains Python's

principal author, although it includes many contributions from others.

In 1995, Guido continued his work on Python at the Corporation for

National Research Initiatives (CNRI, see https://www.cnri.reston.va.us)

in Reston, Virginia where he released several versions of the

software.

In May 2000, Guido and the Python core development team moved to

BeOpen.com to form the BeOpen PythonLabs team. In October of the same

year, the PythonLabs team moved to Digital Creations, which became

Zope Corporation. In 2001, the Python Software Foundation (PSF, see

https://www.python.org/psf/) was formed, a non-profit organization

created specifically to own Python-related Intellectual Property.

Zope Corporation was a sponsoring member of the PSF.

All Python releases are Open Source (see https://opensource.org for

the Open Source Definition). Historically, most, but not all, Python

releases have also been GPL-compatible; the table below summarizes

the various releases.

Release Derived Year Owner GPL-

from compatible? (1)

0.9.0 thru 1.2 1991-1995 CWI yes

1.3 thru 1.5.2 1.2 1995-1999 CNRI yes

1.6 1.5.2 2000 CNRI no

2.0 1.6 2000 BeOpen.com no

1.6.1 1.6 2001 CNRI yes (2)

2.1 2.0+1.6.1 2001 PSF no

2.0.1 2.0+1.6.1 2001 PSF yes

2.1.1 2.1+2.0.1 2001 PSF yes

2.1.2 2.1.1 2002 PSF yes

2.1.3 2.1.2 2002 PSF yes

2.2 and above 2.1.1 2001-now PSF yes

Footnotes:

(1) GPL-compatible doesn't mean that we're distributing Python under

the GPL. All Python licenses, unlike the GPL, let you distribute

a modified version without making your changes open source. The

GPL-compatible licenses make it possible to combine Python with

other software that is released under the GPL; the others don't.

(2) According to Richard Stallman, 1.6.1 is not GPL-compatible,

because its license has a choice of law clause. According to

CNRI, however, Stallman's lawyer has told CNRI's lawyer that 1.6.1

is "not incompatible" with the GPL.

Thanks to the many outside volunteers who have worked under Guido's

direction to make these releases possible.

B. TERMS AND CONDITIONS FOR ACCESSING OR OTHERWISE USING PYTHON

===============================================================

Python software and documentation are licensed under the

Python Software Foundation License Version 2.

Starting with Python 3.8.6, examples, recipes, and other code in

the documentation are dual licensed under the PSF License Version 2

and the Zero-Clause BSD license.

Some software incorporated into Python is under different licenses.

The licenses are listed with code falling under that license.

PYTHON SOFTWARE FOUNDATION LICENSE VERSION 2

--------------------------------------------

1. This LICENSE AGREEMENT is between the Python Software Foundation

("PSF"), and the Individual or Organization ("Licensee") accessing and

otherwise using this software ("Python") in source or binary form and

its associated documentation.

2. Subject to the terms and conditions of this License Agreement, PSF hereby

grants Licensee a nonexclusive, royalty-free, world-wide license to reproduce,

analyze, test, perform and/or display publicly, prepare derivative works,

distribute, and otherwise use Python alone or in any derivative version,

provided, however, that PSF's License Agreement and PSF's notice of copyright,

i.e., "Copyright (c) 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010,

2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023 Python Software Foundation;

All Rights Reserved" are retained in Python alone or in any derivative version

prepared by Licensee.

3. In the event Licensee prepares a derivative work that is based on

or incorporates Python or any part thereof, and wants to make

the derivative work available to others as provided herein, then

Licensee hereby agrees to include in any such work a brief summary of

the changes made to Python.

4. PSF is making Python available to Licensee on an "AS IS"

basis. PSF MAKES NO REPRESENTATIONS OR WARRANTIES, EXPRESS OR

IMPLIED. BY WAY OF EXAMPLE, BUT NOT LIMITATION, PSF MAKES NO AND

DISCLAIMS ANY REPRESENTATION OR WARRANTY OF MERCHANTABILITY OR FITNESS

FOR ANY PARTICULAR PURPOSE OR THAT THE USE OF PYTHON WILL NOT

INFRINGE ANY THIRD PARTY RIGHTS.

5. PSF SHALL NOT BE LIABLE TO LICENSEE OR ANY OTHER USERS OF PYTHON

FOR ANY INCIDENTAL, SPECIAL, OR CONSEQUENTIAL DAMAGES OR LOSS AS

A RESULT OF MODIFYING, DISTRIBUTING, OR OTHERWISE USING PYTHON,

OR ANY DERIVATIVE THEREOF, EVEN IF ADVISED OF THE POSSIBILITY THEREOF.

6. This License Agreement will automatically terminate upon a material

breach of its terms and conditions.

7. Nothing in this License Agreement shall be deemed to create any

relationship of agency, partnership, or joint venture between PSF and

Licensee. This License Agreement does not grant permission to use PSF

trademarks or trade name in a trademark sense to endorse or promote

products or services of Licensee, or any third party.

8. By copying, installing or otherwise using Python, Licensee

agrees to be bound by the terms and conditions of this License

Agreement.

BEOPEN.COM LICENSE AGREEMENT FOR PYTHON 2.0

-------------------------------------------

BEOPEN PYTHON OPEN SOURCE LICENSE AGREEMENT VERSION 1

1. This LICENSE AGREEMENT is between BeOpen.com ("BeOpen"), having an

office at 160 Saratoga Avenue, Santa Clara, CA 95051, and the

Individual or Organization ("Licensee") accessing and otherwise using

this software in source or binary form and its associated

documentation ("the Software").

2. Subject to the terms and conditions of this BeOpen Python License

Agreement, BeOpen hereby grants Licensee a non-exclusive,

royalty-free, world-wide license to reproduce, analyze, test, perform

and/or display publicly, prepare derivative works, distribute, and

otherwise use the Software alone or in any derivative version,

provided, however, that the BeOpen Python License is retained in the

Software, alone or in any derivative version prepared by Licensee.

3. BeOpen is making the Software available to Licensee on an "AS IS"

basis. BEOPEN MAKES NO REPRESENTATIONS OR WARRANTIES, EXPRESS OR

IMPLIED. BY WAY OF EXAMPLE, BUT NOT LIMITATION, BEOPEN MAKES NO AND

DISCLAIMS ANY REPRESENTATION OR WARRANTY OF MERCHANTABILITY OR FITNESS

FOR ANY PARTICULAR PURPOSE OR THAT THE USE OF THE SOFTWARE WILL NOT

INFRINGE ANY THIRD PARTY RIGHTS.

4. BEOPEN SHALL NOT BE LIABLE TO LICENSEE OR ANY OTHER USERS OF THE

SOFTWARE FOR ANY INCIDENTAL, SPECIAL, OR CONSEQUENTIAL DAMAGES OR LOSS

AS A RESULT OF USING, MODIFYING OR DISTRIBUTING THE SOFTWARE, OR ANY

DERIVATIVE THEREOF, EVEN IF ADVISED OF THE POSSIBILITY THEREOF.

5. This License Agreement will automatically terminate upon a material

breach of its terms and conditions.

6. This License Agreement shall be governed by and interpreted in all

respects by the law of the State of California, excluding conflict of

law provisions. Nothing in this License Agreement shall be deemed to

create any relationship of agency, partnership, or joint venture

between BeOpen and Licensee. This License Agreement does not grant

permission to use BeOpen trademarks or trade names in a trademark

sense to endorse or promote products or services of Licensee, or any

third party. As an exception, the "BeOpen Python" logos available at

http://www.pythonlabs.com/logos.html may be used according to the

permissions granted on that web page.

7. By copying, installing or otherwise using the software, Licensee

agrees to be bound by the terms and conditions of this License

Agreement.

CNRI LICENSE AGREEMENT FOR PYTHON 1.6.1

---------------------------------------

1. This LICENSE AGREEMENT is between the Corporation for National

Research Initiatives, having an office at 1895 Preston White Drive,

Reston, VA 20191 ("CNRI"), and the Individual or Organization

("Licensee") accessing and otherwise using Python 1.6.1 software in

source or binary form and its associated documentation.

2. Subject to the terms and conditions of this License Agreement, CNRI

hereby grants Licensee a nonexclusive, royalty-free, world-wide

license to reproduce, analyze, test, perform and/or display publicly,

prepare derivative works, distribute, and otherwise use Python 1.6.1

alone or in any derivative version, provided, however, that CNRI's

License Agreement and CNRI's notice of copyright, i.e., "Copyright (c)

1995-2001 Corporation for National Research Initiatives; All Rights

Reserved" are retained in Python 1.6.1 alone or in any derivative

version prepared by Licensee. Alternately, in lieu of CNRI's License

Agreement, Licensee may substitute the following text (omitting the

quotes): "Python 1.6.1 is made available subject to the terms and

conditions in CNRI's License Agreement. This Agreement together with

Python 1.6.1 may be located on the internet using the following

unique, persistent identifier (known as a handle): 1895.22/1013. This

Agreement may also be obtained from a proxy server on the internet

using the following URL: http://hdl.handle.net/1895.22/1013".

3. In the event Licensee prepares a derivative work that is based on

or incorporates Python 1.6.1 or any part thereof, and wants to make

the derivative work available to others as provided herein, then

Licensee hereby agrees to include in any such work a brief summary of

the changes made to Python 1.6.1.

4. CNRI is making Python 1.6.1 available to Licensee on an "AS IS"

basis. CNRI MAKES NO REPRESENTATIONS OR WARRANTIES, EXPRESS OR

IMPLIED. BY WAY OF EXAMPLE, BUT NOT LIMITATION, CNRI MAKES NO AND

DISCLAIMS ANY REPRESENTATION OR WARRANTY OF MERCHANTABILITY OR FITNESS

FOR ANY PARTICULAR PURPOSE OR THAT THE USE OF PYTHON 1.6.1 WILL NOT

INFRINGE ANY THIRD PARTY RIGHTS.

5. CNRI SHALL NOT BE LIABLE TO LICENSEE OR ANY OTHER USERS OF PYTHON

1.6.1 FOR ANY INCIDENTAL, SPECIAL, OR CONSEQUENTIAL DAMAGES OR LOSS AS

A RESULT OF MODIFYING, DISTRIBUTING, OR OTHERWISE USING PYTHON 1.6.1,

OR ANY DERIVATIVE THEREOF, EVEN IF ADVISED OF THE POSSIBILITY THEREOF.

6. This License Agreement will automatically terminate upon a material

breach of its terms and conditions.

7. This License Agreement shall be governed by the federal

intellectual property law of the United States, including without

limitation the federal copyright law, and, to the extent such

U.S. federal law does not apply, by the law of the Commonwealth of

Virginia, excluding Virginia's conflict of law provisions.

Notwithstanding the foregoing, with regard to derivative works based

on Python 1.6.1 that incorporate non-separable material that was

previously distributed under the GNU General Public License (GPL), the

law of the Commonwealth of Virginia shall govern this License

Agreement only as to issues arising under or with respect to

Paragraphs 4, 5, and 7 of this License Agreement. Nothing in this

License Agreement shall be deemed to create any relationship of

agency, partnership, or joint venture between CNRI and Licensee. This

License Agreement does not grant permission to use CNRI trademarks or

trade name in a trademark sense to endorse or promote products or

services of Licensee, or any third party.

8. By clicking on the "ACCEPT" button where indicated, or by copying,

installing or otherwise using Python 1.6.1, Licensee agrees to be

bound by the terms and conditions of this License Agreement.

ACCEPT

CWI LICENSE AGREEMENT FOR PYTHON 0.9.0 THROUGH 1.2

--------------------------------------------------

Copyright (c) 1991 - 1995, Stichting Mathematisch Centrum Amsterdam,

The Netherlands. All rights reserved.

Permission to use, copy, modify, and distribute this software and its

documentation for any purpose and without fee is hereby granted,

provided that the above copyright notice appear in all copies and that

both that copyright notice and this permission notice appear in

supporting documentation, and that the name of Stichting Mathematisch

Centrum or CWI not be used in advertising or publicity pertaining to

distribution of the software without specific, written prior

permission.

STICHTING MATHEMATISCH CENTRUM DISCLAIMS ALL WARRANTIES WITH REGARD TO

THIS SOFTWARE, INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY AND

FITNESS, IN NO EVENT SHALL STICHTING MATHEMATISCH CENTRUM BE LIABLE

FOR ANY SPECIAL, INDIRECT OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES

WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN

ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT

OF OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.

ZERO-CLAUSE BSD LICENSE FOR CODE IN THE PYTHON DOCUMENTATION

----------------------------------------------------------------------

Permission to use, copy, modify, and/or distribute this software for any

purpose with or without fee is hereby granted.

THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES WITH

REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY

AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY SPECIAL, DIRECT,

INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM

LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR

OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR

PERFORMANCE OF THIS SOFTWARE.

*/

/*

file https://github.com/python/cpython/blob/v3.10.11/Lib/sqlite3/dbapi2.py

*/

"""

if __name__ != "__main__":

# pysqlite2/dbapi2.py: the DB-API 2.0 interface

#

# Copyright (C) 2004-2005 Gerhard Häring <gh@ghaering.de>

#

# 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.

import datetime

import time

import collections.abc

# hack-python - fix import

from ._sqlmath import *

paramstyle = "qmark"

threadsafety = 1

apilevel = "2.0"

Date = datetime.date

Time = datetime.time

Timestamp = datetime.datetime

def DateFromTicks(ticks):

return Date(*time.localtime(ticks)[:3])

def TimeFromTicks(ticks):

return Time(*time.localtime(ticks)[3:6])

def TimestampFromTicks(ticks):

return Timestamp(*time.localtime(ticks)[:6])

version_info = tuple([int(x) for x in version.split(".")])

sqlite_version_info = tuple([int(x) for x in sqlite_version.split(".")])

Binary = memoryview

collections.abc.Sequence.register(Row)

def register_adapters_and_converters():

def adapt_date(val):

return val.isoformat()

def adapt_datetime(val):

return val.isoformat(" ")

def convert_date(val):

return datetime.date(*map(int, val.split(b"-")))

def convert_timestamp(val):

datepart, timepart = val.split(b" ")

year, month, day = map(int, datepart.split(b"-"))

timepart_full = timepart.split(b".")

hours, minutes, seconds = map(int, timepart_full[0].split(b":"))

if len(timepart_full) == 2:

microseconds = int('{:0<6.6}'.format(timepart_full[1].decode()))

else:

microseconds = 0

val = datetime.datetime(year, month, day, hours, minutes, seconds, microseconds)

return val

register_adapter(datetime.date, adapt_date)

register_adapter(datetime.datetime, adapt_datetime)

register_converter("date", convert_date)

register_converter("timestamp", convert_timestamp)

register_adapters_and_converters()

# bpo-24464: enable_shared_cache was deprecated in Python 3.10. It's

# scheduled for removal in Python 3.12.

def enable_shared_cache(enable):

from _sqlmath import enable_shared_cache as _old_enable_shared_cache

import warnings

msg = (

"enable_shared_cache is deprecated and will be removed in Python 3.12. "

"Shared cache is strongly discouraged by the SQLite 3 documentation. "

"If shared cache must be used, open the database in URI mode using"

"the cache=shared query parameter."

)

warnings.warn(msg, DeprecationWarning, stacklevel=2)

return _old_enable_shared_cache(enable)

# Clean up namespace

del(register_adapters_and_converters)

"""

/*

file https://github.com/python/cpython/blob/v3.10.11/Lib/sqlite3/test/backup.py

*/

"""

from . import sqlmath_dbapi2 as sqlite

import unittest

class BackupTests(unittest.TestCase):

def setUp(self):

cx = self.cx = sqlite.connect(":memory:")

cx.execute('CREATE TABLE foo (key INTEGER)')

cx.executemany('INSERT INTO foo (key) VALUES (?)', [(3,), (4,)])

cx.commit()

def tearDown(self):

self.cx.close()

def verify_backup(self, bckcx):

result = bckcx.execute("SELECT key FROM foo ORDER BY key").fetchall()

self.assertEqual(result[0][0], 3)

self.assertEqual(result[1][0], 4)

def test_bad_target(self):

with self.assertRaises(TypeError):

self.cx.backup(None)

with self.assertRaises(TypeError):

self.cx.backup()

def test_bad_target_filename(self):

with self.assertRaises(TypeError):

self.cx.backup('some_file_name.db')

def test_bad_target_same_connection(self):

with self.assertRaises(ValueError):

self.cx.backup(self.cx)

def test_bad_target_closed_connection(self):

bck = sqlite.connect(':memory:')

bck.close()

with self.assertRaises(sqlite.ProgrammingError):

self.cx.backup(bck)

def test_bad_source_closed_connection(self):

bck = sqlite.connect(':memory:')

source = sqlite.connect(":memory:")

source.close()

with self.assertRaises(sqlite.ProgrammingError):

source.backup(bck)

def test_bad_target_in_transaction(self):

bck = sqlite.connect(':memory:')

bck.execute('CREATE TABLE bar (key INTEGER)')

bck.executemany('INSERT INTO bar (key) VALUES (?)', [(3,), (4,)])

with self.assertRaises(sqlite.OperationalError) as cm:

self.cx.backup(bck)

if sqlite.sqlite_version_info < (3, 8, 8):

self.assertEqual(str(cm.exception), 'target is in transaction')

def test_keyword_only_args(self):

with self.assertRaises(TypeError):

with sqlite.connect(':memory:') as bck:

self.cx.backup(bck, 1)

def test_simple(self):

with sqlite.connect(':memory:') as bck:

self.cx.backup(bck)

self.verify_backup(bck)

def test_progress(self):

journal = []

def progress(status, remaining, total):

journal.append(status)

with sqlite.connect(':memory:') as bck:

self.cx.backup(bck, pages=1, progress=progress)

self.verify_backup(bck)

self.assertEqual(len(journal), 2)

self.assertEqual(journal[0], sqlite.SQLITE_OK)

self.assertEqual(journal[1], sqlite.SQLITE_DONE)

def test_progress_all_pages_at_once_1(self):

journal = []

def progress(status, remaining, total):

journal.append(remaining)

with sqlite.connect(':memory:') as bck:

self.cx.backup(bck, progress=progress)

self.verify_backup(bck)

self.assertEqual(len(journal), 1)

self.assertEqual(journal[0], 0)

def test_progress_all_pages_at_once_2(self):

journal = []

def progress(status, remaining, total):

journal.append(remaining)

with sqlite.connect(':memory:') as bck:

self.cx.backup(bck, pages=-1, progress=progress)

self.verify_backup(bck)

self.assertEqual(len(journal), 1)

self.assertEqual(journal[0], 0)

def test_non_callable_progress(self):

with self.assertRaises(TypeError) as cm:

with sqlite.connect(':memory:') as bck:

self.cx.backup(bck, pages=1, progress='bar')

self.assertEqual(str(cm.exception), 'progress argument must be a callable')

def test_modifying_progress(self):

journal = []

def progress(status, remaining, total):

if not journal:

self.cx.execute('INSERT INTO foo (key) VALUES (?)', (remaining+1000,))

self.cx.commit()

journal.append(remaining)

with sqlite.connect(':memory:') as bck:

self.cx.backup(bck, pages=1, progress=progress)

self.verify_backup(bck)

result = bck.execute("SELECT key FROM foo"

" WHERE key >= 1000"

" ORDER BY key").fetchall()

self.assertEqual(result[0][0], 1001)

self.assertEqual(len(journal), 3)

self.assertEqual(journal[0], 1)

self.assertEqual(journal[1], 1)

self.assertEqual(journal[2], 0)

def test_failing_progress(self):

def progress(status, remaining, total):

raise SystemError('nearly out of space')

with self.assertRaises(SystemError) as err:

with sqlite.connect(':memory:') as bck:

self.cx.backup(bck, progress=progress)

self.assertEqual(str(err.exception), 'nearly out of space')

def test_database_source_name(self):

with sqlite.connect(':memory:') as bck:

self.cx.backup(bck, name='main')

with sqlite.connect(':memory:') as bck:

self.cx.backup(bck, name='temp')

with self.assertRaises(sqlite.OperationalError) as cm:

with sqlite.connect(':memory:') as bck:

self.cx.backup(bck, name='non-existing')

self.assertIn("unknown database", str(cm.exception))

self.cx.execute("ATTACH DATABASE ':memory:' AS attached_db")

self.cx.execute('CREATE TABLE attached_db.foo (key INTEGER)')

self.cx.executemany('INSERT INTO attached_db.foo (key) VALUES (?)', [(3,), (4,)])

self.cx.commit()

with sqlite.connect(':memory:') as bck:

self.cx.backup(bck, name='attached_db')

self.verify_backup(bck)

def suite():

return unittest.TestLoader().loadTestsFromTestCase(BackupTests)

# hack-python - append test-suite

test_suite_list.append(suite)

"""

/*

file https://github.com/python/cpython/blob/v3.10.11/Lib/sqlite3/test/dbapi.py

*/

"""

# pysqlite2/test/dbapi.py: tests for DB-API compliance

#

# Copyright (C) 2004-2010 Gerhard Häring <gh@ghaering.de>

#

# 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.

import subprocess

import threading

import unittest

from . import sqlmath_dbapi2 as sqlite

import sys

# hack-python - fix test for win32

# from test.support import check_disallow_instantiation, SHORT_TIMEOUT

# hack-python - fix test for win32

# from test.support.os_helper import TESTFN, unlink

class ModuleTests(unittest.TestCase):

def test_api_level(self):

self.assertEqual(sqlite.apilevel, "2.0",

"apilevel is %s, should be 2.0" % sqlite.apilevel)

def test_thread_safety(self):

self.assertEqual(sqlite.threadsafety, 1,

"threadsafety is %d, should be 1" % sqlite.threadsafety)

def test_param_style(self):

self.assertEqual(sqlite.paramstyle, "qmark",

"paramstyle is '%s', should be 'qmark'" %

sqlite.paramstyle)

def test_warning(self):

self.assertTrue(issubclass(sqlite.Warning, Exception),

"Warning is not a subclass of Exception")

def test_error(self):

self.assertTrue(issubclass(sqlite.Error, Exception),

"Error is not a subclass of Exception")

def test_interface_error(self):

self.assertTrue(issubclass(sqlite.InterfaceError, sqlite.Error),

"InterfaceError is not a subclass of Error")

def test_database_error(self):

self.assertTrue(issubclass(sqlite.DatabaseError, sqlite.Error),

"DatabaseError is not a subclass of Error")

def test_data_error(self):

self.assertTrue(issubclass(sqlite.DataError, sqlite.DatabaseError),

"DataError is not a subclass of DatabaseError")

def test_operational_error(self):

self.assertTrue(issubclass(sqlite.OperationalError, sqlite.DatabaseError),

"OperationalError is not a subclass of DatabaseError")

def test_integrity_error(self):

self.assertTrue(issubclass(sqlite.IntegrityError, sqlite.DatabaseError),

"IntegrityError is not a subclass of DatabaseError")

def test_internal_error(self):

self.assertTrue(issubclass(sqlite.InternalError, sqlite.DatabaseError),

"InternalError is not a subclass of DatabaseError")

def test_programming_error(self):

self.assertTrue(issubclass(sqlite.ProgrammingError, sqlite.DatabaseError),

"ProgrammingError is not a subclass of DatabaseError")

def test_not_supported_error(self):

self.assertTrue(issubclass(sqlite.NotSupportedError,

sqlite.DatabaseError),

"NotSupportedError is not a subclass of DatabaseError")

# sqlite3_enable_shared_cache() is deprecated on macOS and calling it may raise

# OperationalError on some buildbots.

def test_disallow_instantiation(self):

cx = sqlite.connect(":memory:")

check_disallow_instantiation(self, type(cx("select 1")))

class ConnectionTests(unittest.TestCase):

def setUp(self):

self.cx = sqlite.connect(":memory:")

cu = self.cx.cursor()

cu.execute("create table test(id integer primary key, name text)")

cu.execute("insert into test(name) values (?)", ("foo",))

def tearDown(self):

self.cx.close()

def test_commit(self):

self.cx.commit()

def test_commit_after_no_changes(self):

"""

A commit should also work when no changes were made to the database.

"""

self.cx.commit()

self.cx.commit()

def test_rollback(self):

self.cx.rollback()

def test_rollback_after_no_changes(self):

"""

A rollback should also work when no changes were made to the database.

"""

self.cx.rollback()

self.cx.rollback()

def test_cursor(self):

cu = self.cx.cursor()

def test_failed_open(self):

YOU_CANNOT_OPEN_THIS = "/foo/bar/bla/23534/mydb.db"

with self.assertRaises(sqlite.OperationalError):

con = sqlite.connect(YOU_CANNOT_OPEN_THIS)

def test_close(self):

self.cx.close()

def test_exceptions(self):

# Optional DB-API extension.

self.assertEqual(self.cx.Warning, sqlite.Warning)

self.assertEqual(self.cx.Error, sqlite.Error)

self.assertEqual(self.cx.InterfaceError, sqlite.InterfaceError)

self.assertEqual(self.cx.DatabaseError, sqlite.DatabaseError)

self.assertEqual(self.cx.DataError, sqlite.DataError)

self.assertEqual(self.cx.OperationalError, sqlite.OperationalError)

self.assertEqual(self.cx.IntegrityError, sqlite.IntegrityError)

self.assertEqual(self.cx.InternalError, sqlite.InternalError)

self.assertEqual(self.cx.ProgrammingError, sqlite.ProgrammingError)

self.assertEqual(self.cx.NotSupportedError, sqlite.NotSupportedError)

def test_in_transaction(self):

# Can't use db from setUp because we want to test initial state.

cx = sqlite.connect(":memory:")

cu = cx.cursor()

self.assertEqual(cx.in_transaction, False)

cu.execute("create table transactiontest(id integer primary key, name text)")

self.assertEqual(cx.in_transaction, False)

cu.execute("insert into transactiontest(name) values (?)", ("foo",))

self.assertEqual(cx.in_transaction, True)

cu.execute("select name from transactiontest where name=?", ["foo"])

row = cu.fetchone()

self.assertEqual(cx.in_transaction, True)

cx.commit()

self.assertEqual(cx.in_transaction, False)

cu.execute("select name from transactiontest where name=?", ["foo"])

row = cu.fetchone()

self.assertEqual(cx.in_transaction, False)

def test_in_transaction_ro(self):

with self.assertRaises(AttributeError):

self.cx.in_transaction = True

def test_open_with_path_like_object(self):

""" Checks that we can successfully connect to a database using an object that

is PathLike, i.e. has __fspath__(). """

self.addCleanup(unlink, TESTFN)

class Path:

def __fspath__(self):

return TESTFN

path = Path()

with sqlite.connect(path) as cx:

cx.execute('create table test(id integer)')

def test_open_uri(self):

self.addCleanup(unlink, TESTFN)

with sqlite.connect(TESTFN) as cx:

cx.execute('create table test(id integer)')

with sqlite.connect('file:' + TESTFN, uri=True) as cx:

cx.execute('insert into test(id) values(0)')

with sqlite.connect('file:' + TESTFN + '?mode=ro', uri=True) as cx:

with self.assertRaises(sqlite.OperationalError):

cx.execute('insert into test(id) values(1)')

class UninitialisedConnectionTests(unittest.TestCase):

def setUp(self):

self.cx = sqlite.Connection.__new__(sqlite.Connection)

def test_uninit_operations(self):

funcs = (

lambda: self.cx.isolation_level,

lambda: self.cx.total_changes,

lambda: self.cx.in_transaction,

lambda: self.cx.iterdump(),

lambda: self.cx.cursor(),

lambda: self.cx.close(),

)

for func in funcs:

with self.subTest(func=func):

self.assertRaisesRegex(sqlite.ProgrammingError,

"Base Connection.__init__ not called",

func)

class CursorTests(unittest.TestCase):

def setUp(self):

self.cx = sqlite.connect(":memory:")

self.cu = self.cx.cursor()

self.cu.execute(

"create table test(id integer primary key, name text, "

"income number, unique_test text unique)"

)

self.cu.execute("insert into test(name) values (?)", ("foo",))

def tearDown(self):

self.cu.close()

self.cx.close()

def test_execute_no_args(self):

self.cu.execute("delete from test")

def test_execute_illegal_sql(self):

with self.assertRaises(sqlite.OperationalError):

self.cu.execute("select asdf")

def test_execute_too_much_sql(self):

with self.assertRaises(sqlite.Warning):

self.cu.execute("select 5+4; select 4+5")

def test_execute_too_much_sql2(self):

self.cu.execute("select 5+4; -- foo bar")

def test_execute_too_much_sql3(self):

self.cu.execute("""

select 5+4;