python数据转换后台.zip

# coding: utf-8 from sqlalchemy import CHAR, Column, Numeric, String, text from sqlalchemy.ext.declarative import declarative_base Base = declarative_base() metadata = Base.metadata class INVMB(Base): __tablename__ = 'INVMB' COMPANY = Column(CHAR(10, 'Chinese_PRC_BIN')) CREATOR = Column(CHAR(10, 'Chinese_PRC_BIN')) USR_GROUP = Column(CHAR(10, 'Chinese_PRC_BIN')) CREATE_DATE = Column(CHAR(17, 'Chinese_PRC_BIN')) MODIFIER = Column(CHAR(10, 'Chinese_PRC_BIN')) MODI_DATE = Column(CHAR(17, 'Chinese_PRC_BIN')) FLAG = Column(Numeric(3, 0)) MB001 = Column(CHAR(20, 'Chinese_PRC_BIN'), primary_key=True ) MB002 = Column(String(60, 'Chinese_PRC_BIN'), index=True) MB003 = Column(String(60, 'Chinese_PRC_BIN')) MB004 = Column(CHAR(4, 'Chinese_PRC_BIN'), server_default=text("('')")) MB005 = Column(CHAR(6, 'Chinese_PRC_BIN'), server_default=text("('')")) MB006 = Column(CHAR(6, 'Chinese_PRC_BIN'), server_default=text("('')")) MB007 = Column(CHAR(6, 'Chinese_PRC_BIN'), server_default=text("('')")) MB008 = Column(CHAR(6, 'Chinese_PRC_BIN'), server_default=text("('')")) MB009 = Column(String(255, 'Chinese_PRC_BIN')) MB010 = Column(CHAR(20, 'Chinese_PRC_BIN'), server_default=text("('')")) MB011 = Column(CHAR(4, 'Chinese_PRC_BIN'), server_default=text("('')")) MB012 = Column(CHAR(10, 'Chinese_PRC_BIN'), server_default=text("('')")) MB013 = Column(CHAR(20, 'Chinese_PRC_BIN'), server_default=text("('')")) MB014 = Column(Numeric(16, 6), server_default=text("(0)")) MB015 = Column(CHAR(4, 'Chinese_PRC_BIN'), server_default=text("('')")) MB016 = Column(CHAR(4, 'Chinese_PRC_BIN'), server_default=text("('')")) MB017 = Column(CHAR(10, 'Chinese_PRC_BIN'), server_default=text("('')")) MB018 = Column(CHAR(10, 'Chinese_PRC_BIN'), server_default=text("('')")) MB019 = Column(CHAR(1, 'Chinese_PRC_BIN'), server_default=text("('')")) MB020 = Column(CHAR(1, 'Chinese_PRC_BIN'), server_default=text("('')")) MB021 = Column(CHAR(4, 'Chinese_PRC_BIN'), server_default=text("('')")) MB022 = Column(CHAR(1, 'Chinese_PRC_BIN'), server_default=text("('')")) MB023 = Column(Numeric(4, 0), server_default=text("(0)")) MB024 = Column(Numeric(4, 0), server_default=text("(0)")) MB025 = Column(CHAR(1, 'Chinese_PRC_BIN'), index=True, server_default=text("('')")) MB026 = Column(CHAR(2, 'Chinese_PRC_BIN'), index=True, server_default=text("('')")) MB027 = Column(CHAR(1, 'Chinese_PRC_BIN'), server_default=text("('')")) MB028 = Column(String(255, 'Chinese_PRC_BIN')) MB029 = Column(CHAR(20, 'Chinese_PRC_BIN'), server_default=text("('')")) MB030 = Column(CHAR(8, 'Chinese_PRC_BIN'), server_default=text("('')")) MB031 = Column(CHAR(8, 'Chinese_PRC_BIN'), server_default=text("('')")) MB032 = Column(CHAR(10, 'Chinese_PRC_BIN'), server_default=text("('')")) MB033 = Column(CHAR(1, 'Chinese_PRC_BIN'), server_default=text("('')")) MB034 = Column(CHAR(1, 'Chinese_PRC_BIN'), server_default=text("('')")) MB035 = Column(CHAR(4, 'Chinese_PRC_BIN'), server_default=text("('')")) MB036 = Column(Numeric(16, 6), server_default=text("(0)")) MB037 = Column(Numeric(16, 6), server_default=text("(0)")) MB038 = Column(Numeric(16, 6), server_default=text("(0)")) MB039 = Column(Numeric(16, 6), server_default=text("(0)")) MB040 = Column(Numeric(16, 6), server_default=text("(0)")) MB041 = Column(Numeric(16, 6), server_default=text("(0)")) MB042 = Column(CHAR(1, 'Chinese_PRC_BIN'), server_default=text("('')")) MB043 = Column(CHAR(1, 'Chinese_PRC_BIN'), server_default=text("('')")) MB044 = Column(CHAR(1, 'Chinese_PRC_BIN'), server_default=text("('')")) MB045 = Column(Numeric(5, 4), server_default=text("(0)")) MB046 = Column(Numeric(17, 8), server_default=text("(0)")) MB047 = Column(Numeric(17, 8), server_default=text("(0)")) MB048 = Column(CHAR(4, 'Chinese_PRC_BIN'), server_default=text("('')")) MB049 = Column(Numeric(17, 8), server_default=text("(0)")) MB050 = Column(Numeric(17, 8), server_default=text("(0)")) MB051 = Column(Numeric(17, 8), server_default=text("(0)")) MB052 = Column(CHAR(1, 'Chinese_PRC_BIN'), server_default=text("('')")) MB053 = Column(Numeric(17, 8), server_default=text("(0)")) MB054 = Column(Numeric(17, 8), server_default=text("(0)")) MB055 = Column(Numeric(17, 8), server_default=text("(0)")) MB056 = Column(Numeric(17, 8), server_default=text("(0)")) MB057 = Column(Numeric(17, 8), server_default=text("(0)")) MB058 = Column(Numeric(17, 8), server_default=text("(0)")) MB059 = Column(Numeric(17, 8), server_default=text("(0)")) MB060 = Column(Numeric(17, 8), server_default=text("(0)")) MB061 = Column(Numeric(17, 8), server_default=text("(0)")) MB062 = Column(Numeric(17, 8), server_default=text("(0)")) MB063 = Column(Numeric(17, 8), server_default=text("(0)")) MB064 = Column(Numeric(17, 6), server_default=text("(0)")) MB065 = Column(Numeric(16, 2), server_default=text("(0)")) MB066 = Column(CHAR(1, 'Chinese_PRC_BIN'), server_default=text("('')")) MB067 = Column(CHAR(10, 'Chinese_PRC_BIN'), server_default=text("('')")) MB068 = Column(CHAR(10, 'Chinese_PRC_BIN'), server_default=text("('')")) MB069 = Column(Numeric(17, 8), server_default=text("(0)")) MB070 = Column(Numeric(17, 8), server_default=text("(0)")) MB071 = Column(Numeric(16, 6), server_default=text("(0)")) MB072 = Column(CHAR(4, 'Chinese_PRC_BIN'), server_default=text("('')")) MB073 = Column(Numeric(16, 6), server_default=text("(0)")) MB074 = Column(Numeric(16, 6), server_default=text("(0)")) MB075 = Column(Numeric(16, 6), server_default=text("(0)")) MB076 = Column(Numeric(3, 0), server_default=text("(0)")) MB077 = Column(CHAR(6, 'Chinese_PRC_BIN'), server_default=text("('')")) MB078 = Column(Numeric(3, 0), server_default=text("(0)")) MB079 = Column(Numeric(3, 0), server_default=text("(0)")) MB080 = Column(CHAR(20, 'Chinese_PRC_BIN'), server_default=text("('')")) MB081 = Column(CHAR(4, 'Chinese_PRC_BIN'), server_default=text("('')")) MB082 = Column(Numeric(7, 4), server_default=text("(0)")) MB083 = Column(CHAR(1, 'Chinese_PRC_BIN'), server_default=text("('N')")) MB084 = Column(Numeric(5, 4), server_default=text("(0)")) MB085 = Column(CHAR(1, 'Chinese_PRC_BIN'), server_default=text("('N')")) MB086 = Column(Numeric(5, 4), server_default=text("(0)")) MB087 = Column(CHAR(1, 'Chinese_PRC_BIN'), server_default=text("('N')")) MB088 = Column(Numeric(5, 4), server_default=text("(0)")) MB089 = Column(Numeric(17, 6), server_default=text("(0)")) MB090 = Column(CHAR(4, 'Chinese_PRC_BIN'), server_default=text("('')")) MB091 = Column(CHAR(1, 'Chinese_PRC_BIN'), server_default=text("('N')")) MB092 = Column(CHAR(1, 'Chinese_PRC_BIN'), server_default=text("('N')")) MB093 = Column(Numeric(16, 6), server_default=text("(0)")) MB094 = Column(Numeric(16, 6), server_default=text("(0)")) MB095 = Column(Numeric(16, 6), server_default=text("(0)")) MB096 = Column(Numeric(7, 4), server_default=text("(0)")) MB100 = Column(CHAR(1, 'Chinese_PRC_BIN'), server_default=text("('N')")) MB101 = Column(CHAR(1, 'Chinese_PRC_BIN'), server_default=text("('N')")) MB102 = Column(CHAR(1, 'Chinese_PRC_BIN'), server_default=text("('')")) MB103 = Column(CHAR(1, 'Chinese_PRC_BIN'), server_default=text("('N')")) MB104 = Column(CHAR(1, 'Chinese_PRC_BIN'), server_default=text("('N')")) MB105 = Column(CHAR(1, 'Chinese_PRC_BIN'), server_default=text("('N')")) MB106 = Column(CHAR(1, 'Chinese_PRC_BIN'), server_default=text("('N')")) MB107 = Column(CHAR(1, 'Chinese_PRC_BIN'), server_default=text("('N')")) MB108 = Column(CHAR(1, 'Chinese_PRC_BIN'), server_default=