Python DatabaseManager.execute_sql示例

示例#1

文件： click_entry.py 项目： Sneezi909/old_implementation

def run(ctx, sql):
    # TODO: add finer grained try-catch for SQLParser
    try:
        # execute_sql_line(ctx, sql)
        conn = DatabaseManager(ctx.obj)
        parser = SQLParser(conn)
        executable_sql = parser.parse(sql)
        # print executable_sql
        conn.execute_sql(executable_sql)

    except Exception as e:
        import traceback
        traceback.print_exc()
        click.secho(str(e), fg='red')

示例#2

文件： click_entry.py 项目： RUAN0007/implementation

def run(ctx, sql):
    # TODO: add finer grained try-catch for SQLParser
    try:
        # execute_sql_line(ctx, sql)
        begin = time.time()
        conn = DatabaseManager(ctx.obj)
        parser = SQLParser(conn)
        executable_sql = parser.parse(sql)
        # print executable_sql
        conn.execute_sql(executable_sql)
        end = time.time()
        print "\nRun Latency: %0.3f ms\n" % ((end - begin) * 1000.0)

    except Exception as e:
        import traceback
        traceback.print_exc()
        click.secho(str(e), fg='red')