On Fri, Sep 18, 2009 at 6:20 AM, Crusty <[email protected]> wrote:
>
> Alright there, second try Lukasz ;)
>
> the first thing you need to do, according to SA docs is having
> metadata bound to a session:
>
> "To use autoload=True, the table's MetaData object need be bound to an
> Engine or Connection, or alternatively the autoload_with=<some
> connectable> argument can be passed."
>
> you can do this in 2 ways, first is like this:
>
>
> http://www.sqlalchemy.org/docs/05/metadata.html?highlight=metadata#binding-metadata-to-an-engine-or-connection
>
> engine = create_engine('sqlite://', **kwargs)
>
> # create MetaData
> meta = MetaData()
>
> # bind to an engine
> meta.bind = engine
>
> and second is: you simply go with the autoload_with parameter, as
> specified in the comments of /models/__init__.py:
>
> t_reflected = Table("Reflected", metadata, autoload=True,
> autoload_with=engine)
>
> According to the SA docs:
>
> http://www.sqlalchemy.org/docs/05/reference/sqlalchemy/schema.html?highlight=table#sqlalchemy.schema.Table
> Names which contain no upper case characters will be treated as case
> insensitive names, and will not be quoted unless they are a reserved
> word. Names with any number of upper case characters will be quoted
> and sent exactly. Note that this behavior applies even for databases
> which standardize upper case names as case insensitive such as Oracle.
>
> So "Reflected" is simply a case sensitive table name.
>
> My guess: like so many other TG things, the example would simply not
> work as it is presented.
>
> You should be right about your question "where does Reflected come
> from", because I think, it didnt come from anywhere, it would throw a
> syntax error.
> Just try writing:
>
> class Reflected(objec): pass
>
> t_reflected = Table("Reflected", metadata, autoload=True,
> autoload_with=engine)
>
> mapper(Reflected, t_reflected)
>
>
What you are really saying is that you cannot autoload a table in any
other file except for __init__.py
You can define new tables but not autolaod them.
Here is what finally works. How would I make this a declarative
autoload? Since there is no examples I can't really tell.
Before init_model:
from sqlalchemy import Table
from sqlalchemy.orm import mapper, relation
Inside the init_model do:
recall_table = Table('recall_db', metadata,
autoload=True,autoload_with=engine)
class Recall(object):
def __init__(self, **kw):
"""automatically mapping attributes"""
for key, value in kw.iteritems():
setattr(self, key, value)
#Mapping of Table to Python Object Class
mapper(Recall, recall_table,primary_key=[recall_table.c.RECORD_ID])
I'm not sure what the global portion of the example code is referring
to? What is the declarative version?
Question 2:
How to autoload 129 tables in the database?
#for name in engine.execute("SHOW TABLES"):
# tables[name] = sqlalchemy.Table(name, metadata, autoload=True)
But how do I get the python class, and mappers for all these tables?
Thanks,
Lucas
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---
