agate_sql_table_write_and_read_with_sqlalchemy_sqlite.py

1import agate
2import agate_sql
3from sqlalchemy import create_engine
4
5# Create a sample table
6table = agate.Table([
7    ('a', 1, 'oh my'),
8    ('b', 2, 'well then'),
9    ('c', 3, 'gosh golly')
10], ['letter', 'number', 'phrase'])
11
12# Create a SQLAlchemy engine
13engine = create_engine('sqlite:///example.db')
14
15# Write the table to the database
16table.to_sql(engine, 'my_table')
17
18# Read the table back from the database
19new_table = agate.Table.from_sql(engine, 'SELECT * FROM my_table')
20
21# Verify the data
22new_table.print_table()