The question is probably very simple, but I can't find an answer anywhere... Suppose I already have some tables declarad in a declarative way, as below, how do I create the database schema from them?
I usually always did with the meta.create_all() after defining the various "Table('name', meta...)" in this way it should be even easier but I can't find the magic instruction.. class TestStatus(Base): __tablename__ = 'TestStatus' id = Column(String, primary_key=True) done = Column(Boolean, default=False) def __init__(self, testid): self.testid = testid class AreaTests(Base): __tablename__ = 'AreaTests' area = Column(String, primary_key=True) test = Column(String, ForeignKey('TestStatus.id')) def __init__(self, area, test): self.area = area self.test = test class Results: """Keep track of the results of the test that have been run, using an temporary sqlite database to store """ def __init__(self): db_path = 'sqlite:///%s' % SQLITE_TEMP eng = create_engine(db_path) meta = MetaData(bind=eng) # must first create the schema if not present already self.session = sessionmaker(bind=eng)() def add_area(self, area, testid): """Add an area and a testid to this simple database """ test_obj = TestStatus(testid) if test_obj not in self.session: self.session.add(test_obj) self.session.add(AreaTests(area, testid)) self.session.commit() -- 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.