잠토의 잠망경

1. pymysql install pymysql 2. 첫번째 행 갖고 오기 github data = cursor.fetchone() def sample01(ip:str, port:int, user:str, passwd:str, db:str, query:str)->tuple: """mariadb 첫번째 행 갖고 오기 Args: ip: ip port: port user: id passwd: password db: 기본 db Returns: 없음 """ import pymysql db = pymysql.connect(host = ip, port = port, user = user, passwd = passwd, db = db, charset='utf8', autocommit=True) cursor = db.c..

1. Maria DB - 사전 준비 저장할 DB를 만든다. create table mellowlee.splunk_test_db( MASTER_ID BIGINT not null AUTO_INCREMENT, C_NAME VARCHAR(30), SUM_S_VOLUME BIGINT, IN_TIME DATE, PRIMARY KEY (MASTER_ID) ) COMMIT insert into mellowlee.splunk_test_db (C_NAME, SUM_S_VOLUME, IN_TIME) values("test1", 1323, CURRENT_TIMESTAMP) insert into mellowlee.splunk_test_db (C_NAME, SUM_S_VOLUME) values("test3", 1323) COMM..