[Sqlalchemy-users] text & sqlite

[Sandro Dentella]

hi all,

  bind parameters with text() seem to work in postgresql but not in sqlite,
  is that normal/documented?

r = text("SELECT * FROM users WHERE user_name LIKE :user_name ", engine=eng)
ret = r.execute({'user_name' : 'S%'})
  

TIA
sandro
*:-)


-- 
Sandro Dentella  *:-)
e-mail: [EMAIL PROTECTED] 
http://www.tksql.org                    TkSQL Home page - My GPL work
from sqlalchemy import *

eng = create_engine("sqlite://", echo=False)

users = Table('users', eng,
              Column('user_id', Integer, primary_key = True),
              Column('user_name', String(30), nullable = False)
              )
users.create()

users.insert().execute(
    {'user_name': 'Sam'},
    {'user_name': 'Sid'}
    )

eng.echo = True

r = text("SELECT * FROM users WHERE user_name LIKE :user_name ", engine=eng)
ret = r.execute({'user_name' : 'S%'})
for R in ret: 
    print R.user_id, R.user_name