def insertByLine(self, line):
fieldConfig = {
# key S E V
'text' : ['#', '/*', ''],
'cate' : ['Cate=', ';', ''],
'seg' : ['Seg=', ';', ''],
'infos' : ['infos=', ';', ''],
'types' : ['Value=onto_value:prop=', ';', ''],
'from_where' : ['from_where=', ';', '']
}
drawFieldFromLine(line, fieldConfig)
if fieldConfig['types'][2] is not None:
inheritType = InheritType(None, db = self.db)
for type in fieldConfig['types'][2].split('|'):
typeRow = inheritType.selectByLabel(type)
if typeRow is None:
inheritType.insert(type)
typeRow = inheritType.selectByLabel(type)
type_id = typeRow['id']
try:
self.db.insert_ignore(self.__tableName,
{'type_id':type_id, 'text':fieldConfig['text'][2], 'cate':fieldConfig['cate'][2], 'seg':fieldConfig['seg'][2],
'infos':fieldConfig['infos'][2], 'from_where':fieldConfig['from_where'][2],'create_date':None})
self.db.commit()
except:
# Rollback in case there is any error
self.db.rollback()
def deleteByLine(self, line):
fieldConfig = {
# key S E V
'text' : ['#', '/*', None],
'types' : ['Value=onto_value:prop=', ';', None]
}
drawFieldFromLine(line, fieldConfig)
if fieldConfig['types'][2] is not None:
inheritType = InheritType(None, db = self.db)
for type in fieldConfig['types'][2].split('|'):
typeRow = inheritType.selectByLabel(type)
if typeRow is None:
continue
type_id = typeRow['id']
try:
self.db.delete(self.__tableName, {'type_id':type_id, 'text':fieldConfig['text'][2]})
self.db.commit()
except:
# Rollback in case there is any error
self.db.rollback()
