def conflu(cls):
streams = [
cls.stream1_60301(), cls.stream2_60302(), cls.stream3_60303(), cls.stream4_60305(),
cls.stream5_60307(), cls.stream6_60309(), cls.stream7_60311(), cls.stream8_60308(),
cls.stream9_60310()
]
on = [FundTypeMappingImport.fund_id.name, FundTypeMappingImport.typestandard_code.name]
conflus = [base.Confluence(*streams[i: i+4], on=on) for i in range(0, len(streams), 4)]
c = base.Confluence(*conflus, on=on)
return c
def conflu(cls):
streams = [cls.stream1_60401(), cls.stream2_60401(), cls.stream3_60402(), cls.stream4_60403(),
cls.stream5_60404(), cls.stream6_60405(), cls.stream7_60406(), cls.stream8_60401(),
cls.stream9_60408(), cls.stream10_60401(), cls.stream11_60402(), cls.stream12_60403(),
cls.stream13_60404(), cls.stream14_60405(), cls.stream15_60406(), cls.stream16_60407(),
cls.stream17_60408(), cls.stream18_60409(), cls.stream19_60410()]
on = [FundTypeMappingImport.fund_id.name, FundTypeMappingImport.typestandard_code.name]
conflus = [base.Confluence(*streams[i:i+4]) for i in range(0, len(streams), 4)]
c = base.Confluence(*conflus, on=on)
return c
def conflu_ts104(cls):
s12 = cls.stream_010002_ts104()
s15 = cls.stream_010005_ts104()
s14 = cls.stream_010004_ts104()
s13 = cls.stream_010003_ts104()
c = base.Confluence(s12, s15, s14, s13)
return c
def conflu(cls):
streams = [
cls.stream1_60501(), cls.stream2_60502(), cls.stream3_60503(), cls.stream4_60504()
]
on = [FundTypeMappingImport.fund_id.name, FundTypeMappingImport.typestandard_code.name]
c = base.Confluence(*streams, on=on)
return c
def main():
s11 = stream_010001()
s21 = stream_020001()
s22 = stream_020002()
s21_op = stream_020001_op()
c = base.Confluence(s11, s21, s22, s21_op, on=[PersonInfo.person_id.name])
io.to_sql(PersonInfo.__schema_table__, ENGINE, c.dataframe)
def main():
s_12 = stream_010002() # 39855
s_14 = stream_010004() # 7125
s_15 = stream_010005() # 6428
# s_24 = stream_020004() # 30929
# s_25 = stream_020005() # 1933
# s_28 = stream_020008() # 1
c = base.Confluence(s_12, s_14, s_15, on=["fund_id"])
io.to_sql(FundAssetScale.__tablename__, ENGINE_B, c.dataframe)
def confluence():
s21 = stream_020001()
s22 = stream_020002()
s23 = stream_020003()
c = base.Confluence(s21,
s22,
s23,
on=[
OrgPersonMapping.person_id.name,
OrgPersonMapping.org_id.name,
OrgPersonMapping.duty.name
])
return c
def conflu_2(cls):
"""
合并数据源010101数据流和合流1
Returns:
base.Confluence
"""
c1 = cls.conflu_1()
s11 = cls.stream_010101()
c = base.Confluence(s11,
c1,
on=[
OrgPersonMapping.org_id.name,
OrgPersonMapping.person_id.name,
OrgPersonMapping.duty.name
])
return c
def conflu_1(cls):
"""
合并010001, 020001, 020002源数据流
Returns:
base.Confluence
"""
s11, s21, s22 = cls.stream_010001(), cls.stream_op_020001(
), cls.stream_op_020002()
c = base.Confluence(s11,
s21,
s22,
on=[
OrgPersonMapping.person_id.name,
OrgPersonMapping.org_id.name,
OrgPersonMapping.duty.name
])
return c
def conflu(cls):
c = cls.conflu_1()
ros = RemainOneSource()
sk = transform.MapSelectKeys({
"person_id":
FundManagerMapping.person_id.name,
"person_name":
FundManagerMapping.person_name.name,
"fund_id":
FundManagerMapping.fund_id.name,
"fund_name":
FundManagerMapping.fund_name.name,
"is_current":
FundManagerMapping.is_current.name,
FundManagerMapping.start_date.name:
None,
FundManagerMapping.end_date.name:
None,
})
s = base.Stream(c, [ros, sk])
c = base.Confluence(s)
return c
def conflu(cls):
s21, s22 = cls.stream_020001(), cls.stream_020002()
c = base.Confluence(s21, s22, on=[PersonDescription.person_id.name])
return c
def conflu(cls):
c123 = cls.conflu_123()
c4 = cls.stream_602_4(c123)
c = base.Confluence(c123, c4, on=[FundTypeMappingImport.fund_id.name, FundTypeMappingImport.typestandard_code.name])
return c
def conflu_123(cls):
s1, s2, s3 = cls.stream_602_1(), cls.stream_602_2(), cls.stream_602_3()
c = base.Confluence(s1, s2, s3, on=[FundTypeMappingImport.fund_id.name, FundTypeMappingImport.typestandard_code.name])
return c
def conflu(cls):
sc, s11 = cls.stream_desc(), cls.stream_010101()
c = base.Confluence(s11, sc, on=[PersonInfo.person_id.name])
return c
def conflu(cls):
streams = [cls.stream_020002(), cls.stream_020001()]
return base.Confluence(*streams, on=["fund_id", "statistic_date"])
def conflu_ts20X(cls):
s21, s24 = cls.stream_020004_ts201(), cls.stream_020004_ts204()
c = base.Confluence(s21, s24)
return c
def confluence():
s21 = stream_020001()
s22 = stream_020002()
s23 = stream_020003()
c = base.Confluence(s21, s22, s23)
return c
def main():
s11 = stream_x_org_info()
c = base.Confluence(s11)
io.to_sql(OrgAssetScale.__tablename__, ENGINE, c.dataframe)
def conflu_ts501(cls):
s51 = cls.stream_020003_ts501()
c = base.Confluence(s51)
return c
def conflu_ts40X(cls):
s41, s44 = cls.stream_020002_ts401(), cls.stream_020002_ts404()
c = base.Confluence(s41, s44)
return c
def conflu_ts30X(cls):
s31, s32, s34 = cls.stream_020001_ts301(), cls.stream_020001_ts302(
), cls.stream_020001_ts304()
c = base.Confluence(s31, s32, s34)
return c
def conflu_ts103(cls):
s12, s15, s14 = cls.stream_010002_ts103(), cls.stream_010005_ts103(), cls.stream_010004_ts103()
c = base.Confluence(s12, s15, s14,)
return c
def conflu_1(cls):
s21, s22 = cls.stream_020001(), cls.stream_020002()
c = base.Confluence(s22, s21)
return c
def confluence_merged():
s21 = stream_020001()
s22 = stream_020002()
s23 = stream_020003()
c = base.Confluence(s21, s22, s23, on=[FundInfo.fund_id.name])
return c
