A database in TSV text files: data you can read, fast inserts, and an optional Rust speed-up.

0 downloads

dbbasic-tsv/tests/test_basic.py
Download zip
Clone
Clone with git
git clone https://gitstable.com/git/askrobots/dbbasic-tsv.git
HTTPS
https://gitstable.com/git/askrobots/dbbasic-tsv.git
SSH
ssh://git@gitstable.com:2222/askrobots/dbbasic-tsv.git

Cloning needs no sign-in. Pushing over HTTPS asks for your username and an access token. SSH needs your key under SSH keys.

danq9 Add launch announcement for dbbasic-tsv v1.0.1 1c9b0b8 1 year, 1 month ago History
test_basic.py · 6.9 KB · 208 lines
1#!/usr/bin/env python3
2"""
3Basic tests for dbbasic-tsv
4"""
5
6import unittest
7import tempfile
8import shutil
9from pathlib import Path
10from dbbasic import TSV
11
12
13class 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
129class 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
169class 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
207if __name__ == "__main__":
208 unittest.main()