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/caf89dddd246e8ca/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.
