GeezerVisonThe World Wide Web, restored to 800 pixels of glory. |
| Home|About|Gaming cabinet|Archives|How it works|Starter sites |
GeezerVison is showing github.com — sqlautocode/sqlautocode/constants.py at master · unalloc/sqlautocode Expand file tree/ Copy pathconstants.pyMore file actions 98 lines (77 loc) · 2.31 KB / Copy pathconstants.pyFile metadata and controls98 lines (77 loc) · 2.31 KB 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 # Nice print stuff TAB = 4*' ' NLTAB = ',\n'+TAB HEADER = """\ # -*- coding: %(encoding)s -*- ## File autogenerated by SQLAutoCode ## see http://code.google.com/p/sqlautocode/ from sqlalchemy import * %(dialect)s metadata = MetaData() """ HEADER_Z3C = """\ # -*- coding: %(encoding)s -*- ## File autogenerated by SQLAutoCode ## see http://code.google.com/p/sqlautocode/ ## Export type: z3c.sqlalchemy from sqlalchemy import * %(dialect)s from z3c.sqlalchemy import Model from z3c.sqlalchemy.mapper import MappedClassBase def getModel(metadata): model = Model() """ PG_IMPORT = """\ try: from sqlalchemy.dialects.postgresql import * except ImportError: from sqlalchemy.databases.postgres import * """ FOOTER_Z3C = """ return model """ FOOTER_EXAMPLE = """ # some example usage if __name__ == '__main__': db = create_engine(%(url)r) metadata.bind = db # fetch first 10 items from %(tablename)s s = %(tablename)s.select().limit(10) rs = s.execute() for row in rs: print row """ #I suppose you wondering why here we use list for columns and constraints #python have a maximum number of arguments set to 255 ;( TABLE = """Table('%(name)s', metadata,*[%(columns)s,%(constraints)s]%(schema)s)""" COLUMN = """Column(%(name)r, %(type)s%(constraints)s%(args)s)""" FOREIGN_KEY = """ForeignKeyConstraint(%(names)s, %(specs)s, name=%(name)s)""" INDEX = """Index(%(name)s, %(columns)s, unique=%(unique)s)""" HEADER_DECL = """#autogenerated by sqlautocode from sqlalchemy import * from sqlalchemy.ext.declarative import declarative_base from sqlalchemy.orm import relation engine = create_engine('%s') DeclarativeBase = declarative_base() metadata = DeclarativeBase.metadata metadata.bind = engine """ EXAMPLE_DECL = """#example on how to query your Schema from sqlalchemy.orm import sessionmaker session = sessionmaker(bind=engine)() objs = session.query(%s).all() print 'All %s objects: %%s'%%objs """ INTERACTIVE = """ print 'Trying to start IPython shell...', try: from IPython.Shell import IPShellEmbed print 'Success! Press <ctrl-d> to exit.' print 'Available models:%%s'%%%s print '\\nTry something like: session.query(%s).all()' ipshell = IPShellEmbed() ipshell() except: 'Failed. please easy_install ipython' """ CHECK_CONSTRAINT = """CheckConstraint('%(sqltext)s')""" |
| You are visitor 01402520 — GeezerVison does not store the pages you look up. Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required. |