test bulk database insertion

import sqlalchemy
from sqlalchemy import create_engine, MetaData, Column, Integer


engine = create_engine('mysql://test:test@localhost/test')
meta = MetaData()
table = sqlalchemy.Table(
    'test_table',
    meta,
    Column('test_col', Integer),
)
meta.create_all(engine)

events = [ 
    { 
        'test_col': i,
    } 
    for i in range(100000)
]

insert = table.insert(values=events)
engine.execute(insert)