from sqlalchemy import *

db = create_engine('sqlite:///test.db')
metadata = MetaData(db)

tblUsers = Table('users', metadata,
    Column('ID', Integer, primary_key = True),
    Column('UserName', String),
    Column('Password', String)
)

tblUsers.create()
i = tblUsers.insert()

i.execute(UserName = "Join", Password = "test")
i.execute(UserName = "Sam", Password = "1234")
i.execute(UserName = "Dukes", Password = "mypassword")

# Insert some data into table

s = tblUsers.select()
rs = s.execute()

# so how can i get the number of rows return by previous select statement??