askrobots / dbbasic-tsv
Public
A database in TSV text files: data you can read, fast inserts, and an optional Rust speed-up.
test_basic.py · 6.9 KB · 208 lines
| 1 | #!/usr/bin/env python3 |
| 2 | """ |
| 3 | Basic tests for dbbasic-tsv |
| 4 | """ |
| 5 | |
| 6 | import unittest |
| 7 | import tempfile |
| 8 | import shutil |
| 9 | from pathlib import Path |
| 10 | from dbbasic import TSV |
| 11 | |
| 12 | |
| 13 | class TestBasicOperations(unittest.TestCase): |
| 14 | """Test basic CRUD operations""" |
| 15 | |
| 16 | def setUp(self): |
| 17 | """Create temporary directory and test table""" |
| 18 | self.test_dir = Path(tempfile.mkdtemp(prefix="dbbasic_test_")) |
| 19 | self.db = TSV("test_users", ["id", "name", "email"], data_dir=self.test_dir) |
| 20 | |
| 21 | def tearDown(self): |
| 22 | """Clean up test directory""" |
| 23 | shutil.rmtree(self.test_dir, ignore_errors=True) |
| 24 | |
| 25 | def test_insert_single(self): |
| 26 | """Test single record insertion""" |
| 27 | result = self.db.insert({"id": "1", "name": "Alice", "email": "alice@example.com"}) |
| 28 | self.assertTrue(result) |
| 29 | self.assertEqual(self.db.count(), 1) |
| 30 | |
| 31 | def test_insert_many(self): |
| 32 | """Test batch insertion""" |
| 33 | records = [ |
| 34 | {"id": "1", "name": "Alice", "email": "alice@example.com"}, |
| 35 | {"id": "2", "name": "Bob", "email": "bob@example.com"}, |
| 36 | {"id": "3", "name": "Charlie", "email": "charlie@example.com"}, |
| 37 | ] |
| 38 | count = self.db.insert_many(records) |
| 39 | self.assertEqual(count, 3) |
| 40 | self.assertEqual(self.db.count(), 3) |
| 41 | |
| 42 | def test_query(self): |
| 43 | """Test querying records""" |
| 44 | self.db.insert({"id": "1", "name": "Alice", "email": "alice@example.com"}) |
| 45 | self.db.insert({"id": "2", "name": "Bob", "email": "bob@example.com"}) |
| 46 | |
| 47 | # Query by ID |
| 48 | results = self.db.query(id="1") |
| 49 | self.assertEqual(len(results), 1) |
| 50 | self.assertEqual(results[0]["name"], "Alice") |
| 51 | |
| 52 | # Query all |
| 53 | results = self.db.query() |
| 54 | self.assertEqual(len(results), 2) |
| 55 | |
| 56 | def test_query_one(self): |
| 57 | """Test querying single record""" |
| 58 | self.db.insert({"id": "1", "name": "Alice", "email": "alice@example.com"}) |
| 59 | |
| 60 | result = self.db.query_one(id="1") |
| 61 | self.assertIsNotNone(result) |
| 62 | self.assertEqual(result["name"], "Alice") |
| 63 | |
| 64 | # Non-existent record |
| 65 | result = self.db.query_one(id="999") |
| 66 | self.assertIsNone(result) |
| 67 | |
| 68 | def test_update(self): |
| 69 | """Test updating records""" |
| 70 | self.db.insert({"id": "1", "name": "Alice", "email": "alice@example.com"}) |
| 71 | |
| 72 | updated = self.db.update({"id": "1"}, {"email": "newalice@example.com"}) |
| 73 | self.assertEqual(updated, 1) |
| 74 | |
| 75 | result = self.db.query_one(id="1") |
| 76 | self.assertEqual(result["email"], "newalice@example.com") |
| 77 | |
| 78 | def test_delete(self): |
| 79 | """Test deleting records""" |
| 80 | self.db.insert({"id": "1", "name": "Alice", "email": "alice@example.com"}) |
| 81 | self.db.insert({"id": "2", "name": "Bob", "email": "bob@example.com"}) |
| 82 | |
| 83 | deleted = self.db.delete(id="1") |
| 84 | self.assertEqual(deleted, 1) |
| 85 | self.assertEqual(self.db.count(), 1) |
| 86 | |
| 87 | # Verify correct record was deleted |
| 88 | result = self.db.query_one(id="2") |
| 89 | self.assertIsNotNone(result) |
| 90 | self.assertEqual(result["name"], "Bob") |
| 91 | |
| 92 | def test_count(self): |
| 93 | """Test counting records""" |
| 94 | self.assertEqual(self.db.count(), 0) |
| 95 | |
| 96 | self.db.insert({"id": "1", "name": "Alice", "email": "alice@example.com"}) |
| 97 | self.assertEqual(self.db.count(), 1) |
| 98 | |
| 99 | self.db.insert({"id": "2", "name": "Bob", "email": "bob@example.com"}) |
| 100 | self.assertEqual(self.db.count(), 2) |
| 101 | |
| 102 | # Count with conditions |
| 103 | self.assertEqual(self.db.count(name="Alice"), 1) |
| 104 | |
| 105 | def test_all(self): |
| 106 | """Test getting all records""" |
| 107 | records = [ |
| 108 | {"id": str(i), "name": f"User{i}", "email": f"user{i}@example.com"} |
| 109 | for i in range(5) |
| 110 | ] |
| 111 | self.db.insert_many(records) |
| 112 | |
| 113 | all_records = list(self.db.all()) |
| 114 | self.assertEqual(len(all_records), 5) |
| 115 | |
| 116 | def test_truncate(self): |
| 117 | """Test truncating table""" |
| 118 | self.db.insert({"id": "1", "name": "Alice", "email": "alice@example.com"}) |
| 119 | self.db.insert({"id": "2", "name": "Bob", "email": "bob@example.com"}) |
| 120 | |
| 121 | self.db.truncate() |
| 122 | self.assertEqual(self.db.count(), 0) |
| 123 | |
| 124 | # Table should still be usable |
| 125 | self.db.insert({"id": "3", "name": "Charlie", "email": "charlie@example.com"}) |
| 126 | self.assertEqual(self.db.count(), 1) |
| 127 | |
| 128 | |
| 129 | class TestIndexing(unittest.TestCase): |
| 130 | """Test indexing functionality""" |
| 131 | |
| 132 | def setUp(self): |
| 133 | self.test_dir = Path(tempfile.mkdtemp(prefix="dbbasic_test_")) |
| 134 | self.db = TSV("test_indexed", ["id", "email", "status"], data_dir=self.test_dir) |
| 135 | |
| 136 | def tearDown(self): |
| 137 | shutil.rmtree(self.test_dir, ignore_errors=True) |
| 138 | |
| 139 | def test_primary_key_index(self): |
| 140 | """Test that primary key is automatically indexed""" |
| 141 | # Insert test data |
| 142 | for i in range(100): |
| 143 | self.db.insert({"id": str(i), "email": f"user{i}@example.com", "status": "active"}) |
| 144 | |
| 145 | # Query by ID should use index (fast) |
| 146 | import time |
| 147 | start = time.perf_counter() |
| 148 | result = self.db.query_one(id="50") |
| 149 | elapsed = time.perf_counter() - start |
| 150 | |
| 151 | self.assertIsNotNone(result) |
| 152 | self.assertLess(elapsed, 0.01) # Should be very fast with index |
| 153 | |
| 154 | def test_create_custom_index(self): |
| 155 | """Test creating custom index""" |
| 156 | # Insert test data |
| 157 | for i in range(100): |
| 158 | self.db.insert({"id": str(i), "email": f"user{i}@example.com", "status": "active"}) |
| 159 | |
| 160 | # Create index on email |
| 161 | self.db.create_index("email") |
| 162 | |
| 163 | # Query by email should now be fast |
| 164 | result = self.db.query_one(email="user50@example.com") |
| 165 | self.assertIsNotNone(result) |
| 166 | self.assertEqual(result["id"], "50") |
| 167 | |
| 168 | |
| 169 | class TestTransactions(unittest.TestCase): |
| 170 | """Test transaction support""" |
| 171 | |
| 172 | def setUp(self): |
| 173 | self.test_dir = Path(tempfile.mkdtemp(prefix="dbbasic_test_")) |
| 174 | self.db = TSV("test_tx", ["id", "value"], data_dir=self.test_dir) |
| 175 | |
| 176 | def tearDown(self): |
| 177 | shutil.rmtree(self.test_dir, ignore_errors=True) |
| 178 | |
| 179 | def test_successful_transaction(self): |
| 180 | """Test successful transaction commit""" |
| 181 | self.db.insert({"id": "1", "value": "100"}) |
| 182 | self.db.insert({"id": "2", "value": "200"}) |
| 183 | |
| 184 | with self.db.transaction() as tx: |
| 185 | tx.update({"id": "1"}, {"value": "150"}) |
| 186 | tx.update({"id": "2"}, {"value": "250"}) |
| 187 | |
| 188 | # Check values were updated |
| 189 | self.assertEqual(self.db.query_one(id="1")["value"], "150") |
| 190 | self.assertEqual(self.db.query_one(id="2")["value"], "250") |
| 191 | |
| 192 | def test_transaction_rollback(self): |
| 193 | """Test transaction rollback on error""" |
| 194 | self.db.insert({"id": "1", "value": "100"}) |
| 195 | |
| 196 | try: |
| 197 | with self.db.transaction() as tx: |
| 198 | tx.update({"id": "1"}, {"value": "200"}) |
| 199 | raise Exception("Simulated error") |
| 200 | except Exception: |
| 201 | pass |
| 202 | |
| 203 | # Value should not have changed |
| 204 | self.assertEqual(self.db.query_one(id="1")["value"], "100") |
| 205 | |
| 206 | |
| 207 | if __name__ == "__main__": |
| 208 | unittest.main() |