or more succinctly (note the comma at the end of the CheckConstraint
to indicate a tuple):
class Sites(Base):
__tablename__ = 'locations'
site_id = Column(Integer, primary_key=True)
site_name = Column(String(16), nullable=False)
data_type = Column(String(12), nullable=False)
source = Column(String(64))
lat = Column(String(9))
lon = Column(String(9))
stream = Column(String(32))
basin = Column(String(32))
comment = Column(String)
__table_args__ = (
CheckConstraint(
data_type.in_(
['Biogical', 'Chemical', 'Microbial', 'Physical', 'Multiple']
)
),
)
On Sun, May 6, 2018 at 5:49 PM, Mike Bayer <[email protected]> wrote:
> here is the correct way to construct and append the constraint:
>
> class Sites(Base):
> __tablename__ = 'locations'
>
> site_id = Column(Integer, primary_key=True)
> site_name = Column(String(16), nullable=False)
> data_type = Column(String(12), nullable=False)
> source = Column(String(64))
> lat = Column(String(9))
> lon = Column(String(9))
> stream = Column(String(32))
> basin = Column(String(32))
> comment = Column(String)
>
> Sites.__table__.append_constraint(
> CheckConstraint(Sites.data_type.in_(['Biogical', 'Chemical',
> 'Microbial', 'Physical', 'Multiple']))
> )
>
>
>
>
>
> On Sun, May 6, 2018 at 11:33 AM, Rich Shepard <[email protected]>
> wrote:
>> On Fri, 4 May 2018, Mike Bayer wrote:
>>
>>> you're looking for a table-level check constraint with IN:
>>> table.append_constraint(
>>> CheckConstraint(table.c.data_type.in_('A', 'B', 'C'))
>>> )
>>
>>
>> Mike,
>>
>> I'm missing how to properly use the above in my models.py module.
>>
>> For example:
>>
>> class Sites(Base):
>> __tablename__ = 'locations'
>>
>> site_id = Column(Integer, primary_key=True)
>> site_name = Column(String(16), nullable=False)
>> data_type = Column(String(12), nullable=False)
>> source = Column(String(64))
>> lat = Column(String(9))
>> lon = Column(String(9))
>> stream = Column(String(32))
>> basin = Column(String(32))
>> comment = Column(String)
>>
>> locations.append.constraint(
>> CheckConstraint(locations.data_type_in('Biogical', 'Chemical',
>> 'Microbial', 'Physical', 'Multiple'))
>> )
>>
>> Python shows me this error:
>>
>> Traceback (most recent call last):
>> File "./openEDMS.py", line 18, in <module>
>> import models
>> File "/home/rshepard/development/openEDMS/models.py", line 20, in <module>
>> class Sites(Base):
>> File "/home/rshepard/development/openEDMS/models.py", line 37, in Sites
>> CheckConstraint(locations.data_type_in('Biogical', 'Chemical',
>> 'Microbial', 'Physical', 'Multiple'))
>> NameError: name 'locations' is not defined
>>
>> If I change the table-level constraint from the tablename (locations) to
>> the class name (Sites) python gives me the equivalent NameError. What syntax
>> error have I made here?
>>
>> Regards,
>>
>>
>> Rich
>>
>> --
>> SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper
>>
>> http://www.sqlalchemy.org/
>>
>> To post example code, please provide an MCVE: Minimal, Complete, and
>> Verifiable Example. See http://stackoverflow.com/help/mcve for a full
>> description.
>> --- 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 [email protected].
>> To post to this group, send email to [email protected].
>> Visit this group at https://groups.google.com/group/sqlalchemy.
>> For more options, visit https://groups.google.com/d/optout.
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
