日常の記録 (2024 年 2月)
前月 、翌月 | 一覧 |
トップページ
2024/2/5 (月)
- 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.
|