Linux server1.dn-server.com 4.18.0-553.89.1.lve.el8.x86_64 #1 SMP Wed Dec 10 13:58:50 UTC 2025 x86_64
LiteSpeed
Server IP : 195.201.204.189 & Your IP : 216.73.217.130
Domains :
Cant Read [ /etc/named.conf ]
User : beriska1
Terminal
Auto Root
Create File
Create Folder
Localroot Suggester
Backdoor Destroyer
Readme
/
opt /
alt /
python39 /
lib64 /
python3.9 /
sqlite3 /
test /
Delete
Unzip
Name
Size
Permission
Date
Action
__pycache__
[ DIR ]
drwxr-xr-x
2026-05-01 04:20
__init__.py
0
B
-rw-r--r--
2025-06-19 15:40
backup.py
5.82
KB
-rw-r--r--
2025-06-03 22:17
dbapi.py
38.25
KB
-rw-r--r--
2025-06-03 22:17
dump.py
2.77
KB
-rw-r--r--
2025-06-03 22:17
factory.py
12.01
KB
-rw-r--r--
2025-06-03 22:17
hooks.py
10.62
KB
-rw-r--r--
2025-06-03 22:17
regression.py
16.91
KB
-rw-r--r--
2025-06-03 22:17
transactions.py
7.67
KB
-rw-r--r--
2025-06-03 22:17
types.py
16.09
KB
-rw-r--r--
2025-06-03 22:17
userfunctions.py
18.54
KB
-rw-r--r--
2025-06-03 22:17
Save
Rename
import sqlite3 as sqlite import unittest @unittest.skipIf(sqlite.sqlite_version_info < (3, 6, 11), "Backup API not supported") 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_none(self): with self.assertRaises(TypeError): self.cx.backup(None) 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( str(cm.exception), ['SQL logic error', 'SQL logic error or missing database', 'unknown database non-existing'] ) 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.makeSuite(BackupTests) if __name__ == "__main__": unittest.main()