I guess I'm kind of confused as to how it's supposed to create a table
that it doesn't even really know about yet. It hasn't successfully
reflected the table yet, so shouldn't know anything about its
structure. It seems like it'd just create an empty table at this
point.
engine = create_engine('CONNECTION STRING HERE')
meta = MetaData()
meta.bind = engine
# SQLAlchemy doesn't know about the remote table structure yet, how
will this do us any good?
meta.create_all()
# This is where I get that exception listed earlier. SQLAlche
artreqs = Table('tb_FSAR_Data_SampArtReq', meta, autoload=True,
autoload_with=engine)
On Jan 21, 1:14 am, Michael Bayer <mike...@zzzcomputing.com> wrote:
> yeah i meant send along the CREATE TABLE to the mailing list here.
> or a describe, whatever shows us what column type might be failing.
>
> On Jan 20, 2009, at 9:45 PM, Greg wrote:
>
>
>
> > How do I go about doing this? Showing the create table?
>
> > On Jan 20, 4:54 pm, Rick Morrison <rickmorri...@gmail.com> wrote:
> >>> I'm just trying to introspect an existing production database, not
> >>> create any new tables.
>
> >> The structure of the table is read when reflecting the table: it's
> >> likely
> >> that an unusual column definition would trigger an error like this,
> >> and it
> >> would be helpful to someone diagnosing the problem to get a better
> >> clue as
> >> to what might be happening.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
