python SQLAlchemy对象映射和json.dumps无法序列化问题解决
- 作者: 五速梦信息网
- 时间: 2026年04月04日 13:33
from flask import Flask
from flask_sqlalchemy import SQLAlchemy
import Config2
import pymysql
import numpy as np
import json
pymysql.install_as_MySQLdb()
app = Flask(name)
app.config.from_object(Config2)
db = SQLAlchemy(app)
class Basic(object):
"""企业照面（基本）信息(行内客户) model"""
def init(self,
prmsn_oprt_prj_dsc=np.nan,<br/>
lout_dt=np.nan,<br/>
rvk_dt=np.nan,<br/>
idy_tpcd=np.nan,<br/>
bsnlcns_no=np.nan,<br/>
old_bsnlcns_no=np.nan,<br/>
lgl_rprs_nm=np.nan,<br/>
entp_info_idr=np.nan,<br/>
orgacinccptl_amt=np.nan,<br/>
rgst_cpamt=np.nan,<br/>
rgst_cptl_ccycd=np.nan,<br/>
oprt_stcd=np.nan,<br/>
org_char_cd=np.nan,<br/>
org_estb_dt=np.nan,<br/>
oprt_trm_stdt=np.nan,<br/>
dtl_adr=np.nan,<br/>
issuctf_aht_nm=np.nan,<br/>
entnm=np.nan,<br/>
unn_soc_cr_cd=np.nan):<br/>
self.prmsn_oprt_prj_dsc = prmsn_oprt_prj_dsc<br/>
self.lout_dt = lout_dt<br/>
self.rvk_dt = rvk_dt<br/>
self.idy_tpcd = idy_tpcd<br/>
self.bsnlcns_no = bsnlcns_no<br/>
self.old_bsnlcns_no = old_bsnlcns_no<br/>
self.lgl_rprs_nm = lgl_rprs_nm<br/>
self.entp_info_idr = entp_info_idr<br/>
self.orgacinccptl_amt = orgacinccptl_amt<br/>
self.rgst_cpamt = rgst_cpamt<br/>
self.rgst_cptl_ccycd = rgst_cptl_ccycd<br/>
self.oprt_stcd = oprt_stcd<br/>
self.org_char_cd = org_char_cd<br/>
self.org_estb_dt = org_estb_dt<br/>
self.oprt_trm_stdt = oprt_trm_stdt<br/>
self.dtl_adr = dtl_adr<br/>
self.issuctf_aht_nm = issuctf_aht_nm<br/>
self.entnm = entnm<br/>
self.unn_soc_cr_cd = unn_soc_cr_cd
def repr(self):
return repr((self.<br/>
self.prmsn_oprt_prj_dsc,<br/>
self.lout_dt,<br/>
self.rvk_dt,<br/>
self.idy_tpcd,<br/>
self.bsnlcns_no,<br/>
self.old_bsnlcns_no,<br/>
self.lgl_rprs_nm,<br/>
self.entp_info_idr,<br/>
self.orgacinccptl_amt,<br/>
self.rgst_cpamt,<br/>
self.rgst_cptl_ccycd,<br/>
self.oprt_stcd,<br/>
self.org_char_cd,<br/>
self.org_estb_dt,<br/>
self.oprt_trm_stdt,<br/>
self.dtl_adr,<br/>
self.issuctf_aht_nm,<br/>
self.entnm,<br/>
self.unn_soc_cr_cd))
class Alter:
"""企业历史变更信息 Model"""
def init(self,
mdf_bfr_cntnt=np.nan,<br/>
mdf_dt=np.nan,<br/>
mdf_itm=np.nan,<br/>
afmd_cntnt=np.nan,<br/>
):<br/>
self.mdf_bfr_cntnt = mdf_bfr_cntnt<br/>
self.mdf_dt = mdf_dt<br/>
self.mdf_itm = mdf_itm<br/>
self.afmd_cntnt = afmd_cntnt
def repr(self):
return repr((self.mdf_bfr_cntnt, self.mdf_dt, self.mdf_itm, self.afmd_cntnt))
class Person:
"""主要管理人员(行内客户)"""
def init(self,
ip_nm=np.nan,<br/>
post_tp_cd=np.nan,<br/>
gnd_cd=np.nan):<br/>
self.ip_nm = ip_nm<br/>
self.post_tp_cd = post_tp_cd<br/>
self.gnd_cd = gnd_cd
def repr(self):
return repr((self.<br/>
self.ip_nm,<br/>
self.post_tp_cd,<br/>
self.gnd_cd))
class Punished:
"""被执行人信息 Punished"""
def init(self, punished_cnt=np.nan,
court_putonrcrd_fsttapp=np.nan,<br/>
court_putonrcrd_lsttapp=np.nan,<br/>
cs_stdsc1_cnt=np.nan,<br/>
cs_stdsc2_cnt=np.nan,<br/>
cs_stdsc3_cnt=np.nan,<br/>
cs_stdsc1_r6mcnt=np.nan,<br/>
cs_stdsc2_r6mcnt=np.nan,<br/>
cs_stdsc3_r6mcnt=np.nan,<br/>
cs_stdsc3_tapp=np.nan,<br/>
cs_stdsc2_tapp=np.nan,<br/>
cs_stdsc1_tapp=np.nan,<br/>
acs_fcs_cnt_inf_min=np.nan,<br/>
acs_fcs_cnt_inf_max=np.nan,<br/>
acs_fcs_cnt_inf_r6mmin=np.nan,<br/>
acs_fcs_cnt_inf_r6mmax=np.nan):<br/>
self.punished_cnt = punished_cnt # 被执行人信息记录数<br/>
self.court_putonrcrd_fsttapp = court_putonrcrd_fsttapp # 最早法院立案日期距离申请日期月份<br/>
self.court_putonrcrd_lsttapp = court_putonrcrd_lsttapp # 最近法院立案日期距离申请日期月份<br/>
self.cs_stdsc1_cnt = cs_stdsc1_cnt # 不披露的案件数<br/>
self.cs_stdsc2_cnt = cs_stdsc2_cnt # 已结案的案件数<br/>
self.cs_stdsc3_cnt = cs_stdsc3_cnt # 执行中的案件数<br/>
self.cs_stdsc1_r6mcnt = cs_stdsc1_r6mcnt # 最近6个月不披露的案件数<br/>
self.cs_stdsc2_r6mcnt = cs_stdsc2_r6mcnt # 最近6个月已结案的案件数<br/>
self.cs_stdsc3_r6mcnt = cs_stdsc3_r6mcnt # 最近6个月执行中的案件数<br/>
self.cs_stdsc3_tapp = cs_stdsc3_tapp # 最近一次执行中的案件距离申请时间点的月份<br/>
self.cs_stdsc2_tapp = cs_stdsc2_tapp # 最近一次已结案的案件距离申请时间点的月份<br/>
self.cs_stdsc1_tapp = cs_stdsc1_tapp # 最近一次不披露的案件距离申请时间点的月份<br/>
self.acs_fcs_cnt_inf_min = acs_fcs_cnt_inf_min # 被执行人关注次数最小值<br/>
self.acs_fcs_cnt_inf_max = acs_fcs_cnt_inf_max # 被执行人关注次数最大值<br/>
self.acs_fcs_cnt_inf_r6mmin = acs_fcs_cnt_inf_r6mmin # 最近6个月被执行人关注次数最小值<br/>
self.acs_fcs_cnt_inf_r6mmax = acs_fcs_cnt_inf_r6mmax # 最近6个月被执行人关注次数最大值
def repr(self):
return repr((self.punished_cnt,<br/>
self.court_putonrcrd_fsttapp,<br/>
self.court_putonrcrd_lsttapp,<br/>
self.cs_stdsc1_cnt,<br/>
self.cs_stdsc2_cnt,<br/>
self.cs_stdsc3_cnt,<br/>
self.cs_stdsc1_r6mcnt,<br/>
self.cs_stdsc2_r6mcnt,<br/>
self.cs_stdsc3_r6mcnt,<br/>
self.cs_stdsc3_tapp,<br/>
self.cs_stdsc2_tapp,<br/>
self.cs_stdsc1_tapp,<br/>
self.acs_fcs_cnt_inf_min,<br/>
self.acs_fcs_cnt_inf_max,<br/>
self.acs_fcs_cnt_inf_r6mmin,<br/>
self.acs_fcs_cnt_inf_r6mmax))
class RefereeDoc:
"""民商事裁判文书 model"""
def init(self, hfw_cnt=np.nan, # 民商事裁判文书记录数
jdgmt_exec_cnt=np.nan, # 执行案件数<br/>
jdgmt_exec_cntr6m=np.nan, # 最近6个月执行案件数<br/>
admnpnshmainilgfctdsc_cnt=np.nan, # 行政处罚主要违法事实描述数<br/>
admnpnshmainilgfctdsc_cntr6m=np.nan, # 最近6个月行政处罚主要违法事实描述数<br/>
admnpnshmainilg_cnt=np.nan, # 行政处罚为合同纠纷数<br/>
admnpnshmainilg_cntr6m=np.nan, # 最近6个月行政处罚为合同纠纷数<br/>
admnpnshmainilg_rt=np.nan, # 行政处罚为合同纠纷数占比<br/>
case_obj_amt_r6m_cnt=np.nan, # 案件标的金额次数<br/>
case_obj_amt_max=np.nan, # 案件标的金额最大值<br/>
case_obj_amt_min=np.nan, # 案件标的金额最小值<br/>
case_obj_amt_avg=np.nan, # 案件表的金额平均值<br/>
case_obj_amt_p50=np.nan, # 案件标的金额中位数<br/>
hfw_ltgtn_obj_dsc_cnt=np.nan, # 诉讼标的描述类型数<br/>
hfw_ltgtn_obj_dsc_cntr6m=np.nan, # 最近6个月诉讼标的描述类型数<br/>
hfw_ltgtn_obj_dsc_tapp=np.nan, # 最近一次诉讼的描述为被告距离贷款申请月份数<br/>
hfw_ltgtn_obj_dsc_rt=np.nan, # 被告案件数占比<br/>
hfw_endcs_dt_fsttapp=np.nan, # 最早结案日期距离申请日期月份<br/>
hfw_endcs_dt_lsttapp=np.nan,<br/>
idmt_exec_fileno=np.nan,<br/>
admnpnshmainilgfctdsc=np.nan,<br/>
case_obj_amt=np.nan,<br/>
hfw_ltgtn_obj_dsc=np.nan,<br/>
endcs_dt=np.nan): # 最近结案日期距离申请日期月份<br/>
self.hfw_cnt = hfw_cnt<br/>
self.jdgmt_exec_cnt = jdgmt_exec_cnt<br/>
self.jdgmt_exec_cntr6m = jdgmt_exec_cntr6m<br/>
self.admnpnshmainilgfctdsc_cnt = admnpnshmainilgfctdsc_cnt<br/>
self.admnpnshmainilgfctdsc_cntr6m = admnpnshmainilgfctdsc_cntr6m<br/>
self.admnpnshmainilg_cnt = admnpnshmainilg_cnt<br/>
self.admnpnshmainilg_cntr6m = admnpnshmainilg_cntr6m<br/>
self.admnpnshmainilg_rt = admnpnshmainilg_rt<br/>
self.case_obj_amt_r6m_cnt = case_obj_amt_r6m_cnt<br/>
self.case_obj_amt_max = case_obj_amt_max<br/>
self.case_obj_amt_min = case_obj_amt_min<br/>
self.case_obj_amt_avg = case_obj_amt_avg<br/>
self.case_obj_amt_p50 = case_obj_amt_p50<br/>
self.hfw_ltgtn_obj_dsc_cnt = hfw_ltgtn_obj_dsc_cnt<br/>
self.hfw_ltgtn_obj_dsc_cntr6m = hfw_ltgtn_obj_dsc_cntr6m<br/>
self.hfw_ltgtn_obj_dsc_tapp = hfw_ltgtn_obj_dsc_tapp<br/>
self.hfw_ltgtn_obj_dsc_rt = hfw_ltgtn_obj_dsc_rt<br/>
self.hfw_endcs_dt_fsttapp = hfw_endcs_dt_fsttapp<br/>
self.hfw_endcs_dt_lsttapp = hfw_endcs_dt_lsttapp
self.idmt_exec_fileno = idmt_exec_fileno
self.admnpnshmainilgfctdsc = admnpnshmainilgfctdsc<br/>
self.case_obj_amt = case_obj_amt<br/>
self.hfw_ltgtn_obj_dsc = hfw_ltgtn_obj_dsc<br/>
self.endcs_dt = endcs_dt
def repr(self):
return repr((self.hfw_cnt,<br/>
self.jdgmt_exec_cnt,<br/>
self.jdgmt_exec_cntr6m,<br/>
self.admnpnshmainilgfctdsc_cnt,<br/>
self.admnpnshmainilgfctdsc_cntr6m,<br/>
self.admnpnshmainilg_cnt,<br/>
self.admnpnshmainilg_cntr6m,<br/>
self.admnpnshmainilg_rt,<br/>
self.case_obj_amt_r6m_cnt,<br/>
self.case_obj_amt_max,<br/>
self.case_obj_amt_min,<br/>
self.case_obj_amt_avg,<br/>
self.case_obj_amt_p50,<br/>
self.hfw_ltgtn_obj_dsc_cnt,<br/>
self.hfw_ltgtn_obj_dsc_cntr6m,<br/>
self.hfw_ltgtn_obj_dsc_tapp,<br/>
self.hfw_ltgtn_obj_dsc_rt,<br/>
self.hfw_endcs_dt_fsttapp,<br/>
self.hfw_endcs_dt_lsttapp,<br/>
self.idmt_exec_fileno,<br/>
self.admnpnshmainilgfctdsc,<br/>
self.case_obj_amt,<br/>
self.hfw_ltgtn_obj_dsc,<br/>
self.endcs_dt))
class Shareholder:
"""企业股东及出资信息类"""
def init(self,
bsnlcns=np.nan,<br/>
shrh_nm=np.nan,<br/>
ivs_amt=np.nan,<br/>
ivs_dt=np.nan,<br/>
fndd_pctg_dsc=np.nan):<br/>
self.bsnlcns = bsnlcns<br/>
self.shrh_nm = shrh_nm<br/>
self.ivs_amt = ivs_amt<br/>
self.ivs_dt = ivs_dt<br/>
self.fndd_pctg_dsc = fndd_pctg_dsc
def repr(self):
return repr((self.bsnlcns,<br/>
self.shrh_nm,<br/>
self.ivs_amt,<br/>
self.ivs_dt,<br/>
self.fndd_pctg_dsc))
class Frposition:
"""法定代表人其他公司任职类"""
def init(self,
lgl_rprs_nm=np.nan,<br/>
org_char_cd=np.nan,<br/>
rgst_cpamt=np.nan,<br/>
bsnlcns_no=np.nan,<br/>
oprt_stcd=np.nan,<br/>
lout_dt=np.nan,<br/>
rvk_dt=np.nan,<br/>
post_stcd=np.nan,<br/>
wthr_lgl_rprs=np.nan,<br/>
org_estb_dt=np.nan,<br/>
):<br/>
self.lgl_rprs_nm = lgl_rprs_nm<br/>
self.org_char_cd = org_char_cd<br/>
self.rgst_cpamt = rgst_cpamt<br/>
self.bsnlcns_no = bsnlcns_no<br/>
self.oprt_stcd = oprt_stcd<br/>
self.lout_dt = lout_dt<br/>
self.rvk_dt = rvk_dt<br/>
self.post_stcd = post_stcd<br/>
self.wthr_lgl_rprs = wthr_lgl_rprs<br/>
self.org_estb_dt = org_estb_dt
def repr(self):
return repr((self.lgl_rprs_nm,<br/>
self.org_char_cd,<br/>
self.rgst_cpamt,<br/>
self.bsnlcns_no,<br/>
self.oprt_stcd,<br/>
self.lout_dt,<br/>
self.rvk_dt,<br/>
self.post_stcd,<br/>
self.wthr_lgl_rprs,<br/>
self.org_estb_dt))
class Frinv:
def __init__(self,<br/>
lgl_rprs_nm=np.nan,<br/>
org_char_cd=np.nan,<br/>
rgst_cpamt=np.nan,<br/>
bsnlcns_no=np.nan,<br/>
oprt_stcd=np.nan,<br/>
lout_dt=np.nan,<br/>
rvk_dt=np.nan,<br/>
ivs_amt=np.nan,<br/>
fndd_mod_dsc=np.nan,<br/>
fndd_pctg_dsc=np.nan,<br/>
org_estb_dt=np.nan):<br/>
self.lgl_rprs_nm = lgl_rprs_nm<br/>
self.org_char_cd = org_char_cd<br/>
self.rgst_cpamt = rgst_cpamt<br/>
self.bsnlcns_no = bsnlcns_no<br/>
self.oprt_stcd = oprt_stcd<br/>
self.lout_dt = lout_dt<br/>
self.rvk_dt = rvk_dt<br/>
self.ivs_amt = ivs_amt<br/>
self.fndd_mod_dsc = fndd_mod_dsc<br/>
self.fndd_pctg_dsc = fndd_pctg_dsc<br/>
self.org_estb_dt = org_estb_dt
def repr(self):
return repr((self.lgl_rprs_nm,<br/>
self.org_char_cd,<br/>
self.rgst_cpamt,<br/>
self.bsnlcns_no,<br/>
self.oprt_stcd,<br/>
self.lout_dt,<br/>
self.rvk_dt,<br/>
self.ivs_amt,<br/>
self.fndd_mod_dsc,<br/>
self.fndd_pctg_dsc,<br/>
self.org_estb_dt<br/>
))
class fn_list(db.Model):
__tablename__ = 'fn_list'<br/>
id = db.Column(db.Integer, primary_key=True, autoincrement=True)<br/>
column1 = db.Column(db.Text, nullable=True)<br/>
column2 = db.Column(db.Text, nullable=True)<br/>
column3 = db.Column(db.Text, nullable=True)<br/>
column4 = db.Column(db.Text, nullable=True)<br/>
column5 = db.Column(db.Text, nullable=True)<br/>
column6 = db.Column(db.Text, nullable=True)<br/>
column7 = db.Column(db.Text, nullable=True)<br/>
column8 = db.Column(db.Text, nullable=True)<br/>
column9 = db.Column(db.Text, nullable=True)<br/>
column10 = db.Column(db.Text, nullable=True)
column11 = db.Column(db.Text, nullable=True)
column12 = db.Column(db.Text, nullable=True)<br/>
column13 = db.Column(db.Text, nullable=True)<br/>
column14 = db.Column(db.Text, nullable=True)<br/>
column15 = db.Column(db.Text, nullable=True)<br/>
column16 = db.Column(db.Text, nullable=True)<br/>
column17 = db.Column(db.Text, nullable=True)<br/>
column18 = db.Column(db.Text, nullable=True)<br/>
column19 = db.Column(db.Text, nullable=True)<br/>
column20 = db.Column(db.Text, nullable=True)
column21 = db.Column(db.Text, nullable=True)
column22 = db.Column(db.Text, nullable=True)<br/>
column23 = db.Column(db.Text, nullable=True)<br/>
column24 = db.Column(db.Text, nullable=True)<br/>
column25 = db.Column(db.Text, nullable=True)<br/>
column26 = db.Column(db.Text, nullable=True)<br/>
column27 = db.Column(db.Text, nullable=True)<br/>
column28 = db.Column(db.Text, nullable=True)<br/>
column29 = db.Column(db.Text, nullable=True)<br/>
column30 = db.Column(db.Text, nullable=True)
db.create_all()
def insert_fn_list():
fn = fn_list(<br/>
column1="basic",<br/>
column2="b1",<br/>
column3="b3",<br/>
column4="b4",<br/>
column5="b5",<br/>
column6="b6",<br/>
column7="b7",<br/>
column8="b8",<br/>
column9="b9",<br/>
column10="b10",<br/>
column11="b11",<br/>
column12="b12",<br/>
column13="b13",<br/>
column14="b14",<br/>
column15="b15",<br/>
column16="b16",<br/>
column17="b17",<br/>
column18="b18",<br/>
column19="b19",<br/>
column20="b20",<br/>
column21="b21",<br/>
column22="b22",<br/>
column23="b23",<br/>
column24="b24",<br/>
column25="b25",<br/>
column26="b26",<br/>
column27="b27",<br/>
column28="b28",<br/>
column29="b29",<br/>
column30="b30",<br/>
)<br/>
db.session.add(fn)
fn = fn_list(column1=“alter”,
column2="a1",<br/>
column3="a3",<br/>
column4="a4",<br/>
column5="a5",<br/>
column6="a6",<br/>
column7="a7",<br/>
column8="a8",<br/>
column9="a9",<br/>
column10="a10",<br/>
column11="aa11",<br/>
column12="a12",<br/>
column13="a13",<br/>
column14="a14",<br/>
column15="a15",<br/>
column16="a16",<br/>
column17="a17",<br/>
column18="a18",<br/>
column19="a19",<br/>
column20="a20",<br/>
column21="a21",<br/>
column22="a22",<br/>
column23="a23",<br/>
column24="a24",<br/>
column25="a25",<br/>
column26="a26",<br/>
column27="a27",<br/>
column28="a28",<br/>
column29="a29",<br/>
column30="a30",<br/>
)<br/>
db.session.add(fn)
fn = fn_list(column1=“alter”,
column2="a31",<br/>
column3="a32",<br/>
column4="a33",<br/>
column5="a34",<br/>
column6="a35",<br/>
column7="a36",<br/>
column8="a37",<br/>
column9="a38",<br/>
column10="a39",<br/>
column11="aa40",<br/>
column12="a41",<br/>
column13="a42",<br/>
column14="a43",<br/>
column15="a44",<br/>
column16="a45",<br/>
column17="a46",<br/>
column18="a47",<br/>
column19="a48",<br/>
column20="a49",<br/>
column21="a50",<br/>
column22="a51",<br/>
column23="a52",<br/>
column24="a53",<br/>
column25="a54",<br/>
column26="a55",<br/>
column27="a56",<br/>
column28="a57",<br/>
column29="a58",<br/>
column30="a59",<br/>
)<br/>
db.session.add(fn)
fn = fn_list(column1=“person”,
column2="p1",<br/>
column3="p3",<br/>
column4="p4",<br/>
column5="p5",<br/>
column6="p6",<br/>
column7="p7",<br/>
column8="p8",<br/>
column9="p9",<br/>
column10="p10",<br/>
column11="p11",<br/>
column12="p12",<br/>
column13="p13",<br/>
column14="p14",<br/>
column15="p15",<br/>
column16="p16",<br/>
column17="p17",<br/>
column18="p18",<br/>
column19="p19",<br/>
column20="p20",<br/>
column21="p21",<br/>
column22="p22",<br/>
column23="p23",<br/>
column24="p24",<br/>
column25="p25",<br/>
column26="p26",<br/>
column27="p27",<br/>
column28="p28",<br/>
column29="p29",<br/>
column30="p30",<br/>
)<br/>
db.session.add(fn)
fn = fn_list(column1=“person”,
column2="p31",<br/>
column3="p32",<br/>
column4="p33p",<br/>
column5="p34",<br/>
column6="p35",<br/>
column7="p36",<br/>
column8="p37",<br/>
column9="p38",<br/>
column10="p39",<br/>
column11="p40",<br/>
column12="p41",<br/>
column13="p42",<br/>
column14="p43",<br/>
column15="p44",<br/>
column16="p45",<br/>
column17="p46",<br/>
column18="p47",<br/>
column19="p48",<br/>
column20="p49",<br/>
column21="p50",<br/>
column22="p51",<br/>
column23="p52",<br/>
column24="p53",<br/>
column25="p54",<br/>
column26="p55",<br/>
column27="p56",<br/>
column28="p57",<br/>
column29="p58",<br/>
column30="p59",<br/>
)<br/>
db.session.add(fn)
fn = fn_list(column1=“shareholder”,
column2="s1",<br/>
column3="s3",<br/>
column4="s4",<br/>
column5="s5",<br/>
column6="s6",<br/>
column7="s7",<br/>
column8="s8",<br/>
column9="s9",<br/>
column10="s10",<br/>
column11="s11",<br/>
column12="b12",<br/>
column13="b13",<br/>
column14="b14",<br/>
column15="b15",<br/>
column16="b16",<br/>
column17="b17",<br/>
column18="b18",<br/>
column19="b19",<br/>
column20="b20",<br/>
column21="b21",<br/>
column22="b22",<br/>
column23="b23",<br/>
column24="b24",<br/>
column25="b25",<br/>
column26="b26",<br/>
column27="b27",<br/>
column28="b28",<br/>
column29="b29",<br/>
column30="b30",<br/>
)<br/>
db.session.add(fn)
fn = fn_list(column1=“shareholder”,
column2="s31",<br/>
column3="s33",<br/>
column4="s34",<br/>
column5="s35",<br/>
column6="s36",<br/>
column7="s37",<br/>
column8="s38",<br/>
column9="s39",<br/>
column10="s40",<br/>
column11="s41",<br/>
column12="b42",<br/>
column13="b43",<br/>
column14="b44",<br/>
column15="b45",<br/>
column16="b46",<br/>
column17="b47",<br/>
column18="b48",<br/>
column19="b49",<br/>
column20="b50",<br/>
column21="b51",<br/>
column22="b52",<br/>
column23="b53",<br/>
column24="b54",<br/>
column25="b55",<br/>
column26="b56",<br/>
column27="b57",<br/>
column28="b58",<br/>
column29="b59",<br/>
column30="b60",<br/>
)<br/>
db.session.add(fn)
fn = fn_list(column1=“referee”, column2=“referee1”)
db.session.add(fn)
fn = fn_list(column1=“referee”, column2=“referee2”)
db.session.add(fn)
fn = fn_list(column1=“frinv”, column2=“frinv1”)
db.session.add(fn)
fn = fn_list(column1=“frinv”, column2=“frinv2”)
db.session.add(fn)
fn = fn_list(column1=“frposition”, column2=“frposition1”)
db.session.add(fn)
fn = fn_list(column1=“frposition”, column2=“frposition2”)
db.session.add(fn)<br/>
db.session.commit()<br/>
pass
class fetch_list:
def __init__(self,<br/>
basic_list=[],<br/>
alter_list=[],<br/>
person_list=[],<br/>
shareholder_list=[],<br/>
referee_list=[],<br/>
frinv_list=[],<br/>
frposition_list=[]):<br/>
self.basic_list = basic_list<br/>
self.alter_list = alter_list<br/>
self.person_list = person_list<br/>
self.shareholder_list = shareholder_list<br/>
self.referee_list = referee_list<br/>
self.frinv_list = frinv_list<br/>
self.frposition_list = frposition_list
def repr(self):
return repr((self.basic_list,<br/>
self.alter_list,<br/>
self.person_list,<br/>
self.shareholder_list,<br/>
self.referee_list,<br/>
self.frinv_list,<br/>
self.frposition_list))<br/>
# basic_list = []<br/>
# alter_list = []<br/>
# person_list = []<br/>
# shareholder_list = []<br/>
# referee_list = []<br/>
# frinv_list = []<br/>
# frposition_list = []
class basic_mapper:
def obj_mapper2_list(self, data, list):<br/>
b = Basic()<br/>
b.prmsn_oprt_prj_dsc = data.column2<br/>
b.lout_dt = data.column3<br/>
b.rvk_dt = data.column4<br/>
b.idy_tpcd = data.column5<br/>
b.bsnlcns_no = data.column6<br/>
b.old_bsnlcns_no = data.column7<br/>
b.lgl_rprs_nm = data.column8<br/>
b.entp_info_idr = data.column9<br/>
b.orgacinccptl_amt = data.column10<br/>
b.rgst_cpamt = data.column11<br/>
b.rgst_cptl_ccycd = data.column12<br/>
b.oprt_stcd = data.column13<br/>
b.org_char_cd = data.column14<br/>
b.org_estb_dt = data.column15<br/>
b.oprt_trm_stdt = data.column16<br/>
b.dtl_adr = data.column17<br/>
b.issuctf_aht_nm = data.column18<br/>
b.entnm = data.column19<br/>
b.unn_soc_cr_cd = data.column20<br/>
list.append(b)<br/>
return list<br/>
pass
class alter_mapper:
def obj_mapper2_list(self, data, list):<br/>
a = Alter()<br/>
a.mdf_bfr_cntnt = data.column2<br/>
a.mdf_dt = data.column3<br/>
a.mdf_itm = data.column4<br/>
a.afmd_cntnt = data.column5<br/>
list.append(a)<br/>
pass
class person_mapper:
def obj_mapper2_list(self, data, list):<br/>
p = Person()<br/>
p.ip_nm = data.column2<br/>
p.post_tp_cd = data.column3<br/>
p.gnd_cd = data.column4<br/>
list.append(p)<br/>
pass
class shareholder_mapper:
def obj_mapper2_list(self, data, list):<br/>
s = Shareholder()<br/>
s.bsnlcns = data.column2<br/>
s.shrh_nm = data.column3<br/>
s.ivs_amt = data.column4<br/>
s.ivs_dt = data.column5<br/>
s.fndd_pctg_dsc = data.column6<br/>
list.append(s)<br/>
pass
class referee_mapper:
def obj_mapper2_list(self, data, list):<br/>
r = RefereeDoc()<br/>
r.idmt_exec_fileno = data.column2<br/>
r.admnpnshmainilgfctdsc = data.column3<br/>
r.case_obj_amt = data.column4<br/>
r.hfw_ltgtn_obj_dsc = data.column5<br/>
r.endcs_dt = data.column6<br/>
list.append(r)<br/>
pass
class frinv_mapper:
def obj_mapper2_list(self, data, list):<br/>
f = Frinv()<br/>
f.lgl_rprs_nm = data.column2<br/>
f.org_char_cd = data.column3<br/>
f.rgst_cpamt = data.column4<br/>
f.bsnlcns_no = data.column5<br/>
f.oprt_stcd = data.column6<br/>
f.lout_dt = data.column7<br/>
f.rvk_dt = data.column8<br/>
f.ivs_amt = data.column9<br/>
f.fndd_mod_dsc = data.column10<br/>
f.fndd_pctg_dsc = data.column11<br/>
f.org_estb_dt = data.column12<br/>
list.append(f)<br/>
pass
class frposition_mapper:
def obj_mapper2_list(self, data, list):<br/>
f = Frposition()<br/>
f.lgl_rprs_nm = data.column2<br/>
f.org_char_cd = data.column3<br/>
f.rgst_cpamt = data.column4<br/>
f.bsnlcns_no = data.column5<br/>
f.oprt_stcd = data.column6<br/>
f.lout_dt = data.column7<br/>
f.rvk_dt = data.column8<br/>
f.post_stcd = data.column9<br/>
f.wthr_lgl_rprs = data.column10<br/>
f.org_estb_dt = data.column11<br/>
list.append(f)<br/>
pass
def select_fn_list():
bm = basic_mapper()<br/>
am = alter_mapper()<br/>
pm = person_mapper()<br/>
sm = shareholder_mapper()<br/>
rm = referee_mapper()<br/>
frinvm = frinv_mapper()<br/>
frpositionm = frposition_mapper()<br/>
fli = fetch_list()<br/>
type_list = {"basic": fli.basic_list, "alter": fli.alter_list, "person": fli.person_list,<br/>
"shareholder": fli.shareholder_list, "referee": fli.referee_list, "frinv": fli.frinv_list,<br/>
"frposition": fli.frposition_list}<br/>
pro_list = {"basic": bm, "alter": am, "person": pm,<br/>
"shareholder": sm, "referee": rm, "frinv": frinvm,<br/>
"frposition": frpositionm}<br/>
list = fn_list.query<br/>
for obj in list:<br/>
key = obj.column1<br/>
pro_list[key].obj_mapper2_list(obj, type_list[key])<br/>
ii =<br/>
json_str = json.dumps(fli, default=lambda o: o.__dict__, sort_keys=True, indent=)<br/>
print(json_str)
insert_fn_list()
select_fn_list()
@app.route(‘/’)
def index():
return 'index db'
相关文章
-
Python SQLAlchemy基本操作和常用技巧包含大量实例,非常好python
Python SQLAlchemy基本操作和常用技巧包含大量实例,非常好python
- 互联网
- 2026年04月04日
-
Python SqlAlchemy使用方法
Python SqlAlchemy使用方法
- 互联网
- 2026年04月04日
-
python sqllite 日志
python sqllite 日志
- 互联网
- 2026年04月04日
-
Python SQLalchemy的学习与使用
Python SQLalchemy的学习与使用
- 互联网
- 2026年04月04日
-
Python SQLAlchemy
Python SQLAlchemy
- 互联网
- 2026年04月04日
-
Python Scrapy 爬虫框架实例（一）
Python Scrapy 爬虫框架实例（一）
- 互联网
- 2026年04月04日
