保存数据到mysql

最新推荐文章于 2023-04-14 00:32:02 发布

原创最新推荐文章于 2023-04-14 00:32:02 发布 · 228 阅读

0 ·

CC 4.0 BY-SA版权

sql 专栏收录该内容

91 篇文章

订阅专栏


import pymysql
import datetime
db = pymysql.connect(host='localhost',user='debian-sys-maint', password='7GU8x4UG5k2oDYbX', port=3306, db='adv')
cursor = db.cursor()


def save_mysql(msg,player_id,label):
    
    if not label:
        label=0
    else:
        label=1
    data = {
        'player_id': player_id,
          'is_adv': label,
        'message': msg,
        'predict_time':datetime.datetime.now()
        
    }   
    table = 'mesg'
    keys = ', '.join(data.keys())
    values = ', '.join(['%s'] * len(data))
    sql = 'INSERT INTO {table}({keys}) VALUES ({values})'.format(table=table, keys=keys, values=values)
    try:
       cursor.execute(sql, tuple(data.values()))
       print('Successful')
       db.commit()
    except:
       print('Failed')
       db.rollback()
#    cursor.close()
#    db.close()