def render(self):
met = ' metadata,' if _flask_prepend == '' else ''
text = 't_{0} = {1}Table(\n {0!r},{2}\n'.format(
self.table.name, _flask_prepend, met)
for column in self.table.columns:
text += ' {0},\n'.format(_render_column(column, True))
for constraint in sorted(self.table.constraints,
key=_get_constraint_sort_key):
if isinstance(constraint, PrimaryKeyConstraint):
continue
if isinstance(constraint,
(ForeignKeyConstraint, UniqueConstraint)) and len(
constraint.columns) == 1:
continue
text += ' {0},\n'.format(_render_constraint(constraint))
for index in self.table.indexes:
if len(index.columns) > 1:
text += ' {0},\n'.format(_render_index(index))
if self.schema:
text += " schema='{0}',\n".format(self.schema)
return text.rstrip('\n,') + '\n)'
def render_no_relationship(self):
met = ' metadata,' if _flask_prepend == '' else ''
# if str(self.table.name).endswith(self.suffix) is True \
# or str(self.table.name) in self._has_clone:
# return "#"
if self.is_clone == True:
return "#"
text = 't_{0} = {1}Table(\n {0!r},{2}\n'.format(self.table.name + self.suffix, _flask_prepend, met)
for column in self.table.columns:
text += ' {0},\n'.format(_render_column(column, True, has_fk=False))
# for constraint in sorted(self.table.constraints, key=_get_constraint_sort_key):
# if isinstance(constraint, PrimaryKeyConstraint):
# continue
# if isinstance(constraint, (ForeignKeyConstraint, UniqueConstraint)) and len(constraint.columns) == 1:
# continue
# text += ' {0},\n'.format(_render_constraint(constraint))
# for index in self.table.indexes:
# if len(index.columns) > 1:
# text += ' {0},\n'.format(_render_index(index))
if self.schema:
text += " schema='{0}',\n".format(self.schema)
return text.rstrip('\n,') + '\n)'
def render(self):
text = 't_{0} = Table(\n {0!r}, metadata,\n'.format(self.table.name)
for column in self.table.columns:
text += ' {0},\n'.format(_render_column(column, True))
for constraint in sorted(self.table.constraints, key=_get_constraint_sort_key):
if isinstance(constraint, PrimaryKeyConstraint):
continue
if isinstance(constraint, (ForeignKeyConstraint, UniqueConstraint)) and len(constraint.columns) == 1:
continue
text += ' {0},\n'.format(_render_constraint(constraint))
for index in self.table.indexes:
if len(index.columns) > 1:
text += ' {0},\n'.format(_render_index(index))
if self.schema:
text += " schema='{0}',\n".format(self.schema)
return text.rstrip('\n,') + '\n)'
def render(self, db_comments_map=None):
text = 't_{0} = Table(\n {0!r}, metadata,\n'.format(self.table.name)
for column in self.table.columns:
text += ' {0},\n'.format(_render_column(column, True))
for constraint in sorted(self.table.constraints,
key=_get_constraint_sort_key):
if isinstance(constraint, PrimaryKeyConstraint):
continue
if isinstance(constraint,
(ForeignKeyConstraint, UniqueConstraint)) and len(
constraint.columns) == 1:
continue
text += ' {0},\n'.format(_render_constraint(constraint))
for index in self.table.indexes:
if len(index.columns) > 1:
text += ' {0},\n'.format(_render_index(index))
if self.schema:
text += " schema='{0}',\n".format(self.schema)
return text.rstrip('\n,') + '\n)'
