I suspect the answer to this is obvious, but it eludes me. I have
defined some SQlAlchemy table classes, using declarative_base, to
interact with some tables in an SQL Server database. I'm unsure that
the types I've chosen are correct.
I want to print the CREATE TABLE ddl, without executing it. How can I
do this?
With thanks, Alex
CONN_STR = 'mssql://user:p...@host/database'
engine = sqlalchemy.create_engine(CONN_STR)
Base = declarative_base()
class LVService(Base):
'''Map service for LocalView Intranet.
'''
__tablename__ = 'localview_Services'
ServiceId = Column(types.Integer,
Sequence('service_id', 1, 1),
primary_key=True,
)
ServiceServer = Column(types.String(50)) #nvarchar
ServiceType = Column(types.String(50)) #nvarchar
ServiceDataFrame = Column(types.String(50)) #nvarchar
ServiceUsername = Column(types.String(50)) #nvarchar
ServicePassword = Column(types.String(50)) #nvarchar
ServiceDomain = Column(types.String(50)) #nvarchar
ServiceLayerManager = \
Column(types.String(50)) #nvarchar
IsLive = Column(types.Integer, nullable=False,
default=1)
ServiceDisplayName = \
Column(types.String(50)) #nvarchar
...
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
