python
import pyodbc
conn = pyodbc.connect('DSN=Virtuoso;UID=username;PWD=password')
cursor = conn.cursor()
cursor.execute('CREATE TABLE data (id INT, name VARCHAR(255), age INT)')
with open('data.csv', 'r') as file:
rows = file.readlines()
for row in rows:
values = row.split(',')
cursor.execute('INSERT INTO data (id, name, age) VALUES (?, ?, ?)', (values[0], values[1], values[2]))
conn.commit()
conn.close()
python
import pyodbc
conn = pyodbc.connect('DSN=Virtuoso;UID=username;PWD=password')
cursor = conn.cursor()
cursor.execute('SELECT * FROM data WHERE age > ?', (30,))
rows = cursor.fetchall()
for row in rows:
print(row)
conn.close()
