diff options
| author | John Turner <jturner.usa@gmail.com> | 2025-09-14 21:28:32 -0400 |
|---|---|---|
| committer | John Turner <jturner.usa@gmail.com> | 2025-09-14 21:28:32 -0400 |
| commit | ef388c5e6848e7badb1d7e4ef44d571c9a2dbe94 (patch) | |
| tree | 3e23c444d5d5682c9fc010d56fc0bceccaca155a /scripts/mkdb.py | |
| parent | ffbf2ff8165e0f10115a14e2e23970b8225bcca9 (diff) | |
| download | sqlite-kv-bench-ef388c5e6848e7badb1d7e4ef44d571c9a2dbe94.tar.gz | |
add unique constraint to keys index
Diffstat (limited to 'scripts/mkdb.py')
| -rwxr-xr-x | scripts/mkdb.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/scripts/mkdb.py b/scripts/mkdb.py index 5e555b5..27e0b64 100755 --- a/scripts/mkdb.py +++ b/scripts/mkdb.py @@ -66,8 +66,8 @@ def main() -> int: with sqlite3.connect(args.database) as connection: connection.execute("PRAGMA jorunal_mode = WAL") - connection.execute("create table kv(key text, value text)") - connection.execute("create index keys on kv(key)") + connection.execute("create table kv(key text PRIMARY KEY, value text)") + connection.execute("create unique index keys on kv(key)") for i in range(args.num_records): key = generate_key(randrange(args.key_length.start, args.key_length.end)) |