def check_env(config): """check runtime env""" try: backup_path = config.get("database", "backup_path") if not os.path.exists(backup_path): os.makedirs(backup_path) except Exception as err: shell.err("check_env error %s" % repr(err))
def check_env(config): """check runtime env""" try: backup_path = config.get('database', 'backup_path') if not os.path.exists(backup_path): os.makedirs(backup_path) except Exception as err: shell.err("check_env error %s" % repr(err))
def execute_sqls(config,sqlstr): sh.info('exec sql >> %s'%sqlstr) results = [] with get_engine(config).begin() as conn: try: results = conn.execute(_sql(sqlstr)) except Exception as err: return sh.err('exec sql error: %s'%str(err)) sh.info('exec sql done') print_result(results)
def execute_sqls(config, sqlstr): sh.info("exec sql >> %s" % sqlstr) results = [] with get_engine(config).begin() as conn: try: results = conn.execute(_sql(sqlstr)) except Exception as err: return sh.err("exec sql error: %s" % str(err)) sh.info("exec sql done") print_result(results)
def execute_sqlf(config, sqlfile): sh.info('exec sql file >> %s' % sqlfile) if not os.path.exists(sqlfile): return sh.warn('sqlfile not exists') conn = get_engine(config).raw_connection() try: for line in open(sqlfile): sh.info(line) conn.execute(line) except Exception as err: return sh.err('exec sql file error: %s' % str(err)) finally: conn.close() sh.info('exec sql file done')
def execute_sqlf(config, sqlfile): sh.info("exec sql file >> %s" % sqlfile) if not os.path.exists(sqlfile): return sh.warn("sqlfile not exists") conn = get_engine(config).raw_connection() try: for line in open(sqlfile): sh.info(line) conn.execute(line) except Exception as err: return sh.err("exec sql file error: %s" % str(err)) finally: conn.close() sh.info("exec sql file done")