def _init_index(self):
l_table_name = self.db.get_table_names()
table_name = "log"
index_name = "log_index"
l_key = [db_common.tablekey("ltid", "integer"),
db_common.tablekey("dt", "datetime"),
db_common.tablekey("host", "text", (100, ))]
if not index_name in l_table_name:
sql = self.db.create_index_sql(table_name, index_name, l_key)
self.db.execute(sql)
table_name = "ltg"
index_name = "ltg_index"
l_key = [db_common.tablekey("ltgid", "integer")]
if not index_name in l_table_name:
sql = self.db.create_index_sql(table_name, index_name, l_key)
self.db.execute(sql)
table_name = "area"
index_name = "area_index"
l_key = [db_common.tablekey("area", "text", (100, ))]
if not index_name in l_table_name:
sql = self.db.create_index_sql(table_name, index_name, l_key)
self.db.execute(sql)
def _init_index(self):
l_table_name = self.db.get_table_names()
table_name = "log"
index_name = "log_index"
l_key = [db_common.tablekey("ltid", "integer"),
db_common.tablekey("dt", "datetime"),
db_common.tablekey("host", "text", (100, ))]
if not index_name in l_table_name:
sql = self.db.create_index_sql(table_name, index_name, l_key)
self.db.execute(sql)
table_name = "ltg"
index_name = "ltg_index"
l_key = [db_common.tablekey("ltgid", "integer")]
if not index_name in l_table_name:
sql = self.db.create_index_sql(table_name, index_name, l_key)
self.db.execute(sql)
table_name = "area"
index_name = "area_index"
l_key = [db_common.tablekey("area", "text", (100, ))]
if not index_name in l_table_name:
sql = self.db.create_index_sql(table_name, index_name, l_key)
self.db.execute(sql)
def _init_tables(self):
table_name = "log"
l_key = [db_common.tablekey("lid", "integer",
("primary_key", "auto_increment", "not_null")),
db_common.tablekey("ltid", "integer"),
db_common.tablekey("dt", "datetime"),
db_common.tablekey("host", "text"),
db_common.tablekey("words", "text")]
sql = self.db.create_table_sql(table_name, l_key)
self.db.execute(sql)
table_name = "lt"
l_key = [db_common.tablekey("ltid", "integer", ("primary_key",)),
db_common.tablekey("ltw", "text"),
db_common.tablekey("lts", "text"),
db_common.tablekey("count", "integer")]
sql = self.db.create_table_sql(table_name, l_key)
self.db.execute(sql)
table_name = "ltg"
l_key = [db_common.tablekey("ltid", "integer", ("primary_key",)),
db_common.tablekey("ltgid", "integer")]
sql = self.db.create_table_sql(table_name, l_key)
self.db.execute(sql)
table_name = "area"
l_key = [db_common.tablekey("defid", "integer",
("primary_key", "auto_increment", "not_null")),
db_common.tablekey("host", "text"),
db_common.tablekey("area", "text")]
sql = self.db.create_table_sql(table_name, l_key)
self.db.execute(sql)
self._init_index()
def _init_tables(self):
table_name = "log"
l_key = [db_common.tablekey("lid", "integer",
("primary_key", "auto_increment", "not_null")),
db_common.tablekey("ltid", "integer"),
db_common.tablekey("dt", "datetime"),
db_common.tablekey("host", "text"),
db_common.tablekey("words", "text")]
sql = self.db.create_table_sql(table_name, l_key)
self.db.execute(sql)
table_name = "lt"
l_key = [db_common.tablekey("ltid", "integer", ("primary_key",)),
db_common.tablekey("ltw", "text"),
db_common.tablekey("lts", "text"),
db_common.tablekey("count", "integer")]
sql = self.db.create_table_sql(table_name, l_key)
self.db.execute(sql)
table_name = "ltg"
l_key = [db_common.tablekey("ltid", "integer", ("primary_key",)),
db_common.tablekey("ltgid", "integer")]
sql = self.db.create_table_sql(table_name, l_key)
self.db.execute(sql)
table_name = "area"
l_key = [db_common.tablekey("defid", "integer",
("primary_key", "auto_increment", "not_null")),
db_common.tablekey("host", "text"),
db_common.tablekey("area", "text")]
sql = self.db.create_table_sql(table_name, l_key)
self.db.execute(sql)
self._init_index()
