[python][mssql] query module, example

import pymssql

def execute(query):
    conn = pymssql.connect(server='{{SERVER_IP}}', user='{{USER_ID}}', password='{{PASSWORD}}', database='{{DB_NAME}}', charset='utf8')
    cursor = conn.cursor(as_dict=True)

    result_data = []

    if conn:
        cursor.execute(query)
        index = 0
        for row in cursor:
            result_data.insert(index, row)
            index = index + 1
    else:
        pass    
   
    conn.close()
    conn = None

    return result_data


sql = "SELECT * FROM {{TABLE_NAME}} WHERE IDX=1"

result = execute(sql)

print(result)