def _operate_database(self, sql_str):
try:
self.cursor.execute(sql_str)
except Exception as err:
pybaselog.error(err)
return False
return True
def _create_table(self):
try:
self.cursor.execute(self.create_table_str)
except Exception as err:
pybaselog.error(err)
return False
return True
def _cursor_execute(self, cursor):
try:
ret = cursor.execute("show databases like '%s'" %
self.database_name)
if not ret:
cursor.execute(self.create_str)
except Exception as err:
pybaselog.error(err)
return False
return True
def insert_item(self, col_names, data_value):
clom_str, value_str = self._get_insert_str(col_names)
sql = "insert into %s(%s) values(%s)" % (self.table_name, clom_str,
value_str)
try:
self.cursor.execute(sql, data_value)
self.conn.commit()
except Exception as err:
pybaselog.error("error:%s content:%s,sql:%s,table_create_str:%s" %
(err, data_value, sql, self.create_table_str))
return self.cursor.lastrowid
def test():
pybaselog.debug('debug test 测试')
pybaselog.info('info test 测试')
pybaselog.warning('warning test 测试')
pybaselog.error('error test 测试')
pybaselog.critical('critical test 测试')
def _create_database(self):
try:
db_name = '%s.db' % self.database_name
self.conn = sqlite3.connect(db_name)
except Exception as err:
pybaselog.error(err)