I am trying to ensure that my table doesn't allow duplicate rows.
The table is defined (in SqlAlchemy 0.8):
class User(Base):
__tablename__ = 'user'
id = Column(Integer, primary_key=True)
lname = Column(String)
fname = Column(String)
email = Column(String)
dateentered = Column(DateTime, default=datetime.now())
UniqueConstraint('lname','fname',name='full_name')
~~~~~ etc. ~~~~
I have tried with using the above and with adding the unique constraint
to the relevant field definitions. Using the unique constraint on
individual fields makes a table that requires both the lname and the
fname field to be unique. Using the code above there seems to be no
constraints whatsoever, a session.commit() simply adds the duplicate
rows. What I am going for is something like this (using an sqlite3
database):
CREATE TABLE user (lname string, fname string, email string,
unique(lname, fname) ON CONFLICT REPLACE);
This will allow me to add multiple rows with the same lname as long as
the fnames are different for each. Is there a way to define such unique
constraints in SqlAlchemy?
thomas
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
