Exemplo n.º 1
0
 def execute(self, sql):
     try:
         if getattr(config_db, 'debug') and config_db.debug == True:
             log.info(sql)
         return self.db_cursor.execute(sql)
     except Exception as e:
         log.error(e)
         return False
Exemplo n.º 2
0
 def __init__(self):
     if hasattr(config_db, self.db_connect):
         config_params = getattr(config_db, self.db_connect)
         if self.db == None:
             self.db = mysqlDb()
         self.db_instance = self.db.db_connect(**config_params)
         self.db_cursor = self.db_instance.cursor()
         log.info(config_params['host'] + ':connect database')
     else:
         log.error("There is no " + db_connect + " db's config ")
Exemplo n.º 3
0
 def transaction(self, kw):
     if len(kw) > 0:
         try:
             self.db_instance.begin()
             for i in kw:
                 log.info(i)
                 self.execute(i)
                 #self.db_cursor.execute(i)
             self.db_instance.commit()
             return True
         except Exception as e:
             log.error(e)
             self.db_instance.rollback()
             return False
Exemplo n.º 4
0
 def run(self):
     module = 'core.Module.' + self.params['m']
     module_class = self.params['c'] + '_module'
     module_method = self.params['a']
     self.module = create_object_class(module, module_class)
     self.module.params = self.params
     log.warn("start")
     try:
         func = getattr(self.module, module_method)
         try:
             func()
         except TypeError as ty_e:
             log.error(ty_e)
             pass
     except AttributeError as e:
         log.error(e)
         print(e)
         pass
     log.warn("end")
Exemplo n.º 5
0
 def insert_many(self, params, *kw):
     if len(kw) == 0 or len(params) == 0:
         return False
     tag = '%s,' * len(params)
     tag = tag[:len(tag) - 1]
     fields = ','.join(params)
     sql = 'insert into ' + self.db_table + '(' + fields + ') values(' + tag + ')'
     try:
         if getattr(config_db, 'debug') and config_db.debug == True:
             log.info(sql)
             log.info(kw)
         self.db_cursor.executemany(sql, list(kw))
         return True
     except Exception as e:
         log.error(e)
         log.error(sql)
         log.error(kw)
         return False