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)'