Perfect. Thank you!

On Friday, June 30, 2017 at 5:41:33 PM UTC-4, Mike Bayer wrote:
>
>
> from sqlalchemy import Column, String, Integer, create_engine 
> from sqlalchemy.orm import Session 
> from sqlalchemy.ext.declarative import declarative_base 
> from sqlalchemy import event 
>
> Base = declarative_base() 
>
>
> @event.listens_for(Column, "before_parent_attach") 
> def _attach_column(column, table, **kw): 
>     column.name = column.name.lower() 
>
>
> class A(Base): 
>     __tablename__ = 'a' 
>     myId = Column(Integer, primary_key=True) 
>     someData = Column(String) 
>     maxInterval = Column(Integer) 
>
>
> e = create_engine("sqlite://", echo=True) 
> Base.metadata.create_all(e) 
>
> s = Session(e) 
>
> s.add(A(someData='sasefd', maxInterval=5)) 
> s.commit() 
>
> print(s.query(A.someData, A.maxInterval)).all() 
>
>

-- 
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 sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.

Reply via email to