Hi Matrigo,
SQLite does not support foreign key constraints and SQLAlchemy dose not
check the integrity of the database. You can use
http://code.google.com/p/sqlitefktg4sa/ to generate triggers for SQLite
in SQLAlchemy. These triggers are emulating the foreign key behavior
(IntegrityError on bad inserts/updates/deletes).
Marko
matigro schrieb:
> Hi, I'm new in TG2 and new in SQLAlchemy. I've some experience
> developing in TG1 and SQLObject. I'm using SQLite.
>
> The problem is that I could create an instance without given data to
> an attribute that is a foreign key to another instance.
>
> My model.py is:
> class Document(DeclarativeBase):
> __tablename__ = 'documents'
>
> document_id = Column(Integer, autoincrement=True,
> primary_key=True) # id Documento
> path = Column(Unicode(255))
>
> revisions = relation('Revision', backref='documents')
>
> class Revision(DeclarativeBase):
> __tablename__='revisions'
>
> revision_id = Column(Integer, autoincrement=True,
> primary_key=True) # id Revision
> description = Column(Unicode(255))
> document_id = Column(Integer, ForeignKey('documents.document_id'))
>
> Then, I've started a shell and did this:
>
>>>> rev1 = model.Revision(description = u"Revision Nro 1")
>>>> model.DBSession.add(rev1)
>>>> model.DBSession.flush()
>>>>
> 17:05:17,250 INFO [sqlalchemy.engine.base.Engine.0x...2570]
> [u'Revision Nro 1', None]
>
>>>> for i in model.DBSession.query(model.Revision).all():
>>>>
> ... print i.revision_id, i.description, i.document_id
> ...
> 1 Revision Nro 1 None
>
> Why document_id is None? In SQLObject I could have an Exception
> telling that document_id is needed. An another one if I wanted to
> relate to a document that doesn't exists. Here I din't have this
> error.
>
>>>> rev2 = model.Revision(description = u"Revision Nro 2", document_id = 10)
>>>> model.DBSession.add(rev2)
>>>> model.DBSession.flush()
>>>> for i in model.DBSession.query(model.Revision).all():
>>>>
> ... print i.revision_id, i.description, i.document_id
> ...
> 1 Revision Nro 1 None
> 2 Revision Nro 2 10
>
>
> I couldn't find my error, I was trying to do same as in Movie tutorial
> in TG2 documentation.
> Thanks, MatÃas
> >
>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---
