Python get_connection Examples

Example #1

File: example1.py Project: takenoco82/csv_to_db

def main():
    try:
        conn = database_connection.get_connection()
        result = select_example1_by_id(conn, 11)
        print(result)
    finally:
        conn.close()

Example #2

File: test_example1.py Project: takenoco82/csv_to_db

 def setUpClass(cls):
     cls.conn = database_connection.get_connection()
     # データ初期化
     csv_to_db.load(
         cls.conn,
         example1=
         'tests/data/test_example1/example1_test_select_example1_by_id.csv')
     cls.conn.commit()

Example #3

File: csv_to_db.py Project: takenoco82/csv_to_db

 def wrapper(*args, **kwargs):
     try:
         conn = database_connection.get_connection()
         conn.begin()
         load(conn, truncate=truncate, **targets)
         conn.commit()
     except Exception as e:
         conn.rollback()
         raise e
     finally:
         conn.close()
     return func(*args, **kwargs)

Example #4

File: csv_to_db.py Project: takenoco82/csv_to_db

def main():
    conn = database_connection.get_connection()
    conn.begin()
    try:
        init_db(conn, csv_dir="tests/data")
        conn.commit()
    except Exception as e:
        logger.error(e)
        conn.rollback()
        sys.exit(1)
    finally:
        conn.close()
    sys.exit(0)

Example #5

File: test_example1.py Project: takenoco82/csv_to_db

 def setUpClass(cls):
     cls.conn = database_connection.get_connection()