-
Notifications
You must be signed in to change notification settings - Fork 1
/
createTables.py
40 lines (35 loc) · 1.37 KB
/
createTables.py
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
import sqlite3 as db
import sys
import os
from config import *
def createTables(c):
frameTable = """CREATE TABLE FRAME( ID INT,
Name varchar(200))"""
luTable = """CREATE TABLE LU( ID INT,
Name varchar(200),
FrameID INT,
POS varchar(10),
AnnotatedSentences INT)"""
feTable = """CREATE TABLE FE( ID INT,
Name varchar(200),
FrameID INT,
CoreType varchar(200),
Abbrev varchar(100))"""
feAnnotationTable = """CREATE TABLE FEAnnotation( FrameID INT,
LUName varchar(200),
LUID INT,
FEID INT,
FEName varchar(200),
PT varchar(200),
GF varchar(200),
SentID INT,
start INT,
end INT,
WordCount INT)"""
sentTable = """CREATE TABLE Sent( ID INT,
Text varchar(2000))"""
c.execute(frameTable)
c.execute(luTable)
c.execute(feTable)
c.execute(feAnnotationTable)
c.execute(sentTable)