Python_FastAPI : MSSQL 연동

MSSQL 연동을 위해, pymssql 설치한다.

- pip install pymssql

import pymssql

server = 'IP:PORT'
username = 'username'
password = 'password'
database = 'db'

# MSSQL CONNECT
conn = pymssql.connect(server, username, password, database)
cursor = conn.cursor()

# SELECT
cursor.execute('SELECT * from TABLE_NAME;')
for row in cursor:
	print("id=%s, pw=%s" % (row[0].encode('ISO-8859-1').decode('euc-kr'), row[1].encode('ISO-8859-1').decode('euc-kr')))
# 한글 깨지는 문제가 발생하여, encode('ISO-8859-1').decode('euc-kr')를 추가하여 해결함

# INSERT
data = 'ABC!!'
# syntax error 발생을 막기 위해, 쌍따옴표로 감싸줌
query = "INSERT INTO POST (CONTENTS) VALUES ('" + str(data) + "')"
cursor.execute(query)
conn.commit()

# UPDATE
data = 'ABC!!'
query = "UPDATE POST set CONTENTS = '" + str(data) + "'  where POST_NO = 11"
cursor.execute(query)
conn.commit()

# DELETE
data = 'ABC!!'
query = "DELETE FROM POST WHERE CONTENTS = '" + str(data) + "'" 
cursor.execute(query)
conn.commit()

# Connect 종료
conn.close()