日常の記録 (2024 年 2月)

• Here, I provide a Python3 sample code that uses 'pyodbc' library.
insert.py

import pyodbc
def main():
    SERVER = '192.168.0.100'
    DATABASE = 'TestDB'
    USERNAME = 'user'
    PASSWORD = 'password'

    connectionString = f'DRIVER={{ODBC Driver 18 for SQL Server}};SERVER={SERVER};DATABASE={DATABASE};UID={USERNAME};PWD={PASSWORD};Encrypt=no;'
    conn = pyodbc.connect(connectionString)

    SQL_STATEMENT = """
    insert into dbo.Inventory(id, name, quantity) values ('5', 'lucky-fruit', 220)
    """
    # Do the insert
    cursor = conn.cursor()
    cursor.execute(SQL_STATEMENT)
    # commit the transaction
    conn.commit()
    # close the connection
    conn.close()
    
main()

read.py

import pyodbc
def main():
    SERVER = '192.168.0.100'
    DATABASE = 'TestDB'
    USERNAME = 'user'
    PASSWORD = 'password'

    connectionString = f'DRIVER={{ODBC Driver 18 for SQL Server}};SERVER={SERVER};DATABASE={DATABASE};UID={USERNAME};PWD={PASSWORD};Encrypt=no;'
    conn = pyodbc.connect(connectionString)

    SQL_STATEMENT = """
    select * from dbo.Inventory
    """
    # Do the insert
    cursor = conn.cursor()
    cursor.execute(SQL_STATEMENT)
    # get the results
    rows = cursor.fetchall()
    for row in rows:
        print(row)
    # close the connection without any commits
    conn.close()

main()

• This is a picture of some kind of mountain.

One of my SNS's icons.