[Python]2 Python 으로 MariaDB 연동(2)- 엑셀 데이터 DB 자동 입력 [chatbot_data_excel.py 생성] import openpyxl from utils.DBConnector import MariaDBConnector import utils.DBConnector import os config=utils.DBConnector.config db = MariaDBConnector(config) conn=db.connect() def all_clear_train_data(db): sql=''' delete from chatbot_train_data ''' with conn.cursor() as cursor: cursor.execute(sql) sql=''' ALTER TABLE chatbot_train_data AUTO_INCREMENT=1 ''' with conn... 2023. 12. 6. Python 으로 MariaDB 연동(1) [DBConnector.py 생성] import mariadb import sys class MariaDBConnector: def __init__(self, config): self.config = config self.conn = None def connect(self): try: self.conn = mariadb.connect(**self.config) return self.conn except mariadb.Error as e: print(f"마리아디비 연결시 에러: {e}") sys.exit(1) def close(self): if self.conn: self.conn.close() config = { 'host': '127.0.0.1', 'port': 3306, 'user': 'admin',.. 2023. 12. 6. 이전 1 다음