1
# -*- coding: UTF-8 -*-
3
from sqlite3 import connect
6
def newGroBase(corpusFileName):
7
db = connect(corpusFileName)
9
# cursor.execute('''CREATE VIRTUAL TABLE information USING fts3( name, comments, nbPages, nbSentences, nbWords, config file ) ;''')
10
cursor.execute('''CREATE VIRTUAL TABLE sources USING fts3( url, source, linkOrigin, ts) ;''') #,link origin: page index or config
11
# cursor.execute('''CREATE VIRTUAL TABLE texts USING fts3(sourceIndex, text) ;''') # TODO: think how many of these tables i need and when to create them
15
print "created", corpusFileName