def generate_one(tbl, args, table_name=None, file=None): """ Prints code (SQL, SQLAlchemy, etc.) to define a table. """ table = Table(tbl, table_name=table_name, varying_length_text=args.text, uniques=args.uniques, pk_name=args.key, force_pk=args.force_key, reorder=args.reorder, data_size_cushion=args.cushion, save_metadata_to=args.save_metadata_to, metadata_source=args.use_metadata_from, loglevel=args.log, limit=args.limit) if args.dialect.startswith('sqla'): if not args.no_creates: print(table.sqlalchemy(), file=file) if args.inserts: print("\n".join(table.inserts(dialect=args.dialect)), file=file) elif args.dialect.startswith('dj'): table.django_models() else: print(table.sql(dialect=args.dialect, inserts=args.inserts, creates=(not args.no_creates), drops=args.drops, metadata_source=args.use_metadata_from), file=file) return table
def test_django(self): tbl = Table(self.merovingians) generated = tbl.django_models() #print("generated") #print(generated) #self.assertIn("(models.Model):", generated) #self.assertIn("name_name_id =", generated) tbl = Table(self.canada) generated = tbl.django_models()
def generate_one(datafile, args, table_name=None): table = Table(datafile, table_name=table_name, varying_length_text=args.text, uniques=args.uniques, pk_name = args.key, force_pk=args.force_key, reorder=args.reorder, data_size_cushion=args.cushion, save_metadata_to=args.save_metadata_to, metadata_source=args.use_metadata_from, loglevel=args.log, limit=args.limit) if args.dialect.startswith('sqla'): print(table.sqlalchemy()) if args.inserts: print("\n".join(table.inserts(dialect=args.dialect))) #inserter.compile().bindtemplate elif args.dialect.startswith('dj'): table.django_models() else: print(table.sql(dialect=args.dialect, inserts=args.inserts, creates=(not args.no_creates), drops=args.drops, metadata_source=args.use_metadata_from))
def generate_one(tbl, args, table_name=None, file=None): """ Prints code (SQL, SQLAlchemy, etc.) to define a table. """ table = Table(tbl, table_name=table_name, varying_length_text=args.text, uniques=args.uniques, pk_name = args.key, force_pk=args.force_key, reorder=args.reorder, data_size_cushion=args.cushion, save_metadata_to=args.save_metadata_to, metadata_source=args.use_metadata_from, loglevel=args.log, limit=args.limit) if args.dialect.startswith('sqla'): if not args.no_creates: print(table.sqlalchemy(), file=file) if args.inserts: print("\n".join(table.inserts(dialect=args.dialect)), file=file) elif args.dialect.startswith('dj'): table.django_models() else: print(table.sql(dialect=args.dialect, inserts=args.inserts, creates=(not args.no_creates), drops=args.drops, metadata_source=args.use_metadata_from), file=file) return table