Coverage for add_accounts.py: 0%

1import sqlite3 

2c = sqlite3.connect('db.sqlite3') 

3cur = c.cursor() 

4 

5# Create erp_account table 

6cur.execute(""" 

7CREATE TABLE IF NOT EXISTS erp_account ( 

8 id VARCHAR(36) PRIMARY KEY, 

9 created_at DATETIME NOT NULL, 

10 updated_at DATETIME NOT NULL, 

11 tenant_id VARCHAR(36) NOT NULL, 

12 code VARCHAR(32) NOT NULL, 

13 name VARCHAR(128) NOT NULL, 

14 type VARCHAR(32) NOT NULL, 

15 currency VARCHAR(3) NOT NULL DEFAULT 'PHP', 

16 is_active INTEGER NOT NULL DEFAULT 1, 

17 UNIQUE (tenant_id, code) 

18) 

19""") 

20c.commit() 

21print("erp_account table created") 

22 

23# Verify 

24cur.execute("SELECT name FROM sqlite_master WHERE type='table' AND name LIKE 'erp_%'") 

25print("ERP tables:", [r[0] for r in cur.fetchall()])