Python create_connection Examples

Example #1

def main():
    db = db_helper.create_connection()

    with open('create_tables.sql') as sqls:
        commands = str.split(sqls.read(), ';')

    for c in commands:
        try:
            db.execute(c)
        except Error as e:
            print("[ERROR]", e)

    db.commit()
    db_helper.close_connection(db)

    insert_movie_detail_api.main()
    insert_movie_detail_ranking_api.main()
    insert_movie_detail_credits_api.main()
    insert_my_collect_api.main()

Example #2

def main():
    db = db_helper.create_connection()
    data = helper.read_json('movie_detail_api')
    db_helper.close_connection(db)

Example #3

File: insert_movie_detail_credits_api.py Project: sugaE/quotesbot

def main():
    db = db_helper.create_connection()
    data = helper.read_json('movie_detail_credits_api')
    insert_movie_celeb(db, data)
    db_helper.close_connection(db)

Example #4

File: insert_movie_detail_ranking_api.py Project: sugaE/quotesbot

def main():
    db = db_helper.create_connection()
    data = helper.read_json('movie_detail_ranking_api')
    insert_ranking(db, data)
    db_helper.close_connection(db)

Example #5

File: insert_my_collect.py Project: sugaE/quotesbot

def main():
    db = db_helper.create_connection()
    data = helper.read_json()
    insert_table(db, data)
    db_helper.close_connection(db)