Re: [sqlalchemy] Misunderstanding of session or inspect

2019-02-09 Thread Jim Steil
Mike - Thanks for such a great explanation. It is truly appreciated. -Jim On Fri, Feb 8, 2019 at 4:53 PM Mike Bayer wrote: > changes to attributes are only significant until the next flush > occurs. flushing is described at : > https://docs.sqlalchemy.org/en/latest/orm/session_basics.html#fl

Re: [sqlalchemy] Re: Boolean column represented in DB as a string 'T' or 'F'

2019-01-09 Thread Jim Steil
k_ends It is working for all my use cases now. I can query the 'current' flag using either boolean values or 'T' / 'F' I can update the value using boolean or 'T'/'F' Anyone see anything I'm missing? -Jim On Wednesday, January 9, 2019 at 2:45

Re: [sqlalchemy] Re: Boolean column represented in DB as a string 'T' or 'F'

2019-01-09 Thread Jim Steil
Jonathon You and me both! To make matters worse, I'm the one that did it. The web framework I used does that by default. Thanks for the link, looking through it now. -Jim On Wed, Jan 9, 2019 at 2:26 PM Jonathan Vanasco wrote: > I'm sorry the database was implemented like this. > > I believ

[sqlalchemy] Boolean column represented in DB as a string 'T' or 'F'

2019-01-09 Thread Jim Steil
Hi Brand new to SA. The database I'm using uses a string field to represent boolean values, using T or F. I want to use the SA boolean type but can't figure out how to get it to let me. Here is what I'm doing so far: class RequisitionPeriod(Base): __tablename__ = 'requisition_period'

Re: [sqlalchemy] Self-referencing relation

2010-10-12 Thread Jim Steil
Thanks, just what I needed. -Jim On 10/12/2010 9:38 AM, Conor wrote: On 10/12/2010 09:20 AM, Jim Steil wrote: Hi Using SQLAlchemy 0.5.8. I have the following model... class Link(DeclarativeBase): __tablename__ = 'link' linkId = Column(Integer, autoincr

[sqlalchemy] Self-referencing relation

2010-10-12 Thread Jim Steil
Hi Using SQLAlchemy 0.5.8. I have the following model... class Link(DeclarativeBase): __tablename__ = 'link' linkId = Column(Integer, autoincrement=True, primary_key=True) name = Column(Unicode(50), nullable=False) parentLinkId = Column(Integer, ForeignKey('link.linkId'))

Re: [sqlalchemy] Re: Support for IBM AS/400 database

2010-02-24 Thread Jim Steil
x for it? Lucas On Wed, Feb 24, 2010 at 1:51 PM, st...@mailbag.com wrote: Does anyone have a clue on this error? Is it due to a change in SQLAlchemy between 0.4.0 and 0.5.8? -Jim On Feb 19, 5:02 pm, Jim Steil wrote: Here is the traceback I get when following that recipe...

Re: [sqlalchemy] Support for IBM AS/400 database

2010-02-19 Thread Jim Steil
Table('users', metadata, autoload=True, autoload_with=db2) users_table IBM_DB DB-API wrapper sanity test Question is wether IBM_DB wrapper supports your as400 version. You could try. I never found enough time to test the "read" functionality. If you get it done then tha

Re: [sqlalchemy] Support for IBM AS/400 database

2010-02-19 Thread Jim Steil
here using SQLAlchemy with DB2 on an AS/400? -Jim On 2/19/2010 3:13 PM, Michael Bayer wrote: On Feb 18, 2010, at 10:36 AM, Jim Steil wrote: Hi Just wondering if there is support for the IBM AS/400 database using SQLAlchemy. IBM produces a DB2 driver, dont know if that overlaps w

[sqlalchemy] Support for IBM AS/400 database

2010-02-18 Thread Jim Steil
Hi Just wondering if there is support for the IBM AS/400 database using SQLAlchemy. -Jim -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send

[sqlalchemy] Re: Access to AS/400 data

2008-05-16 Thread Jim Steil
Carlos Hanson wrote: > On Fri, May 16, 2008 at 8:14 AM, Michael Bayer <[EMAIL PROTECTED]> wrote: > >> On May 16, 2008, at 10:55 AM, Carlos Hanson wrote: >> >> >>> On Fri, May 16, 2008 at 6:13 AM, Jim Steil <[EMAIL PROTECTED]> wrote: >>>

[sqlalchemy] Re: Access to AS/400 data

2008-05-16 Thread Jim Steil
Carlos Hanson wrote: > On Fri, May 16, 2008 at 6:13 AM, Jim Steil <[EMAIL PROTECTED]> wrote: > >> Hi: >> >> Can anyone tell me if it is possible to access data on an AS/400 through >> SQLAlchemy? >> >>-Jim >> > > I'm conn

[sqlalchemy] Access to AS/400 data

2008-05-16 Thread Jim Steil
Hi: Can anyone tell me if it is possible to access data on an AS/400 through SQLAlchemy? -Jim --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchem