1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
|
# -*- coding: iso-8859-1 -*-
from sqlalchemy import *
import os
if os.path.exists('tutorial.db') : os.remove('tutorial.db')
db = create_engine('sqlite:///tutorial.db')
metadata = MetaData(db)
users = Table('users', metadata,
Column('user_id', Integer, primary_key=True),
Column('name', String(40)))
users.create()
i = users.insert()
i.execute(name='é'.decode('iso-8859-1')) #Si accent => Il n'y a plus de messages d'erreur
s = users.select()
rs = s.execute()
row = rs.fetchall()
for row in rs:
print row.name |
Partager