stfg 0.1.0

a tool that converts sqlite to/from git-friendly format
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84

import os
import shutil
import sqlite3
import subprocess
import sys

test_name = sys.argv[1]

# if create_script exists, it resets the db
db_path = f"{test_name}.db"
db_path2 = f"{test_name}-2.db"

create_script = f"{test_name}-create.sql"
insert_script = f"{test_name}-insert.sql"
delete_script = f"{test_name}-delete.sql"

if os.path.exists(create_script):
    if os.path.exists(db_path):
        os.remove(db_path)

    conn = sqlite3.connect(db_path)

    with open(create_script, "r") as f:
        conn.executescript(f.read())

    conn.commit()

if os.path.exists(insert_script):
    with open(insert_script, "r") as f:
        insert_query = f.read()

else:
    insert_query = None

if os.path.exists(delete_script):
    with open(delete_script, "r") as f:
        delete_query = f.read()

else:
    delete_query = None

# initialize git
subprocess.run(["cargo", "run", "--release", "--", "to-git", db_path, "-o", "test-dir/db/"], check=True)
subprocess.run(["git", "-C", "test-dir", "init"], check=True, capture_output=True)
subprocess.run(["git", "-C", "test-dir", "add", "--all"], check=True)
subprocess.run(["git", "-C", "test-dir", "commit", "-m", "test"], check=True, capture_output=True)

# re-construct the sqlite db from the git data
subprocess.run(["cargo", "run", "--release", "--", "from-git", "test-dir/db", "-o", db_path2], check=True)

# re-construct the git data with the new db
subprocess.run(["cargo", "run", "--release", "--", "to-git", db_path2, "-o", "test-dir/db/"], check=True)
subprocess.run(["git", "-C", "test-dir", "add", "--all"], check=True)

# It must fail because I haven't updated the db.
assert subprocess.run(["git", "-C", "test-dir", "commit", "-m", "test"], capture_output=True).returncode != 0

os.remove(db_path2)

# re-construct sqlite db from the git data, again
subprocess.run(["cargo", "run", "--release", "--", "from-git", "test-dir/db", "-o", db_path2], check=True)

# update the db and commit the changes to git
if insert_query is not None:
    conn = sqlite3.connect(db_path2)
    conn.executescript(insert_query)
    conn.commit()
    subprocess.run(["cargo", "run", "--release", "--", "to-git", db_path2, "-o", "test-dir/db/"], check=True)
    subprocess.run(["git", "-C", "test-dir", "add", "--all"], check=True)

    # there must be something to commit
    subprocess.run(["git", "-C", "test-dir", "commit", "-m", "test"], check=True)

if delete_query is not None:
    conn = sqlite3.connect(db_path2)
    conn.executescript(delete_query)
    conn.commit()
    subprocess.run(["cargo", "run", "--release", "--", "to-git", db_path2, "-o", "test-dir/db/"], check=True)
    subprocess.run(["git", "-C", "test-dir", "add", "--all"], check=True)

    # there must be something to commit
    subprocess.run(["git", "-C", "test-dir", "commit", "-m", "test"], check=True)

shutil.rmtree("test-dir")