F. Poirotte wrote:
Hi,
First, many thanks to everyone who helped make SQLAlchemy such a great
module.
I'm currently using the declarative syntax and I would like to know
weither it's possible or not to automatically add a prefix on all
tables, without having to specify it on each and every table
separately.
That is, I would like to define the tables using __tablename__ =
sometable, but the metadata to create the tables (and references in
foreign keys, etc.) as someprefix_sometable.
This seems similar to what .with_prefix() or column_prefix provide,
though it would operate on tables instead of columns.
I found this thread which seems to be similar to what I'm trying to
achieve, but would prefer a definitive answer (that thread has been
left unanswered) :
http://groups.google.com/group/sqlalchemy/browse_thread/thread/caf89246e8ca/b66ff46a0eaeb543
that thread has to do with copying tables which is not what you're looking
for here. Usually I tell people to create a Table object using a def
that passes in the new name. But since you want the table renamed using
declarative + __tablename__, you'd need to use a metaclass:
class RenameTables(DeclarativeMeta):
def __init__(cls, classname, bases, dict_):
if '__tablename__' in dict_:
cls.__tablename__ = dict_['__tablename__'] = prefix_ +
cls.__tablename__
return DeclarativeMeta.__init__(cls, classname, bases, dict_)
Base = declarative_base(metaclass=RenameTables)
class Usr(Base):
__tablename__ = 'users'
id = Column(Integer, primary_key = True)
name = Column(String)
you can also put RenameTables on individual classes with __metaclass__ if
thats what you want.
Thank you for your help.
Cheers,
François.
--
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 email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
--
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 email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.