File size: 1,379 Bytes
6ea020b
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
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
import sqlite3

def migrate():
    # Connect to the main database
    conn = sqlite3.connect('lab_database.db')
    cursor = conn.cursor()
    
    print("Starting database migration for Double Authorisation...")
    
    try:
        cursor.execute("ALTER TABLE result ADD COLUMN double_authorized BOOLEAN DEFAULT 0")
        print("Added double_authorized to result")
    except sqlite3.OperationalError as e:
        print(f"double_authorized column might already exist: {e}")
        
    try:
        cursor.execute("ALTER TABLE result ADD COLUMN double_authorized_by INTEGER")
        print("Added double_authorized_by to result")
    except sqlite3.OperationalError as e:
        print(f"double_authorized_by column might already exist: {e}")

    try:
        cursor.execute("ALTER TABLE result ADD COLUMN double_authorized_at DATETIME")
        print("Added double_authorized_at to result")
    except sqlite3.OperationalError as e:
        print(f"double_authorized_at column might already exist: {e}")

    try:
        cursor.execute("ALTER TABLE result ADD COLUMN unauth_reason VARCHAR")
        print("Added unauth_reason to result")
    except sqlite3.OperationalError as e:
        print(f"unauth_reason column might already exist: {e}")

    conn.commit()
    conn.close()
    print("Migration completed successfully.")

if __name__ == "__main__":
    migrate()