-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdatabase.py
More file actions
43 lines (42 loc) · 1.05 KB
/
Copy pathdatabase.py
File metadata and controls
43 lines (42 loc) · 1.05 KB
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
#!/usr/bin/python
import sqlite3
conn = sqlite3.connect("switchgear.db");
conn.execute('''CREATE TABLE TC100(
NAME CHAR(50) PRIMARY KEY NOT NULL,
ALARM INT NOT NULL,
TEMP INT NOT NULL
);''')
conn.execute('''CREATE TABLE NAME(
NAME CHAR(50) PRIMARY KEY NOT NULL
);''')
conn.execute('''CREATE TABLE PXM8000(
NAME CHAR(50) PRIMARY KEY NOT NULL,
LINE1C INT NOT NULL,
LINE1V INT NOT NULL,
LINE2C INT NOT NULL,
LINE2V INT NOT NULL,
LINE3C INT NOT NULL,
LINE3V INT NOT NULL
); ''')
conn.execute('''
CREATE TABLE METER(
NAME CHAR(50) PRIMARY KEY NOT NULL,
LINE1C INT NOT NULL,
LINE1V INT NOT NULL,
LINE2C INT NOT NULL,
LINE2V INT NOT NULL,
LINE3C INT NOT NULL,
LINE3V INT NOT NULL
); ''')
conn.execute('''
CREATE TABLE MAGNUM(
NAME CHAR(50) PRIMARY KEY NOT NULL,
REASON CHAR(200) NOT NULL,
MAINTENANCE INT NOT NULL,
STATUS INT NOT NULL,
LINE1C INT NOT NULL,
LINE2C INT NOT NULL,
LINE3C INT NOT NULL
); ''')
print "Table created successfully"
conn.close()