Duke Dougal <[email protected]> wrote:
> I'm trying to find if a row with a given primary key exists.
>
> Is this the "right" way to do it?
it looks fine and if you’re just starting out, by all means do what works
and makes sense to you.
> I'm using Python 3.4 and Sqlite 3.8.2
>
>
> from sqlalchemy.ext.automap import automap_base
> from sqlalchemy import create_engine, exists
> from sqlalchemy.schema import Table
> from sqlalchemy.schema import MetaData
> from sqlalchemy.sql import select
>
> Base = automap_base()
> engine = create_engine("sqlite:////archives.db")
> conn = engine.connect()
> # reflect the tables
> Base.prepare(engine, reflect=True)
> meta = MetaData()
> messages = Table('messages', meta, autoload=True, autoload_with=engine)
> s =
> select([messages.c.message_id_hash]).where(messages.c.message_id_hash=='GQWMEJ3DJYPFDH2NJEDOIDZ3W2YBUFYP')
> result = conn.execute(s)
> print(result.first())
>
>
>
> --
> 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 http://groups.google.com/group/sqlalchemy.
> For more options, visit https://groups.google.com/d/optout.
--
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 http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
