3 =h@s ddZdS)c Csd}|ddkr|S|ddkr$|S|ddkrF|d|dd7}n&|dd krh|d |dd7}n|S|d 7}|d dkr|d |dd7}n |d dkr|d|dd7}d}d3}xp|dD]d}|d7}d||dkrd}Pd4}x:|dD].}|d7}d|d||dkrd}PqWqW|r|dt|dddd7}|ddkr|djdd|dDd7}n.|dd kr|djdd|dDd7}|d7}n |d7}x|dD]}|ddkr*|d |dd!|d"dd#sd$|d"dd%dnd&d 7}n<|dd krf|d |dd'd(jd)d|d"Dd*7}d}x0|dD]$}|d+|dd,|d-d7}qtW|d.|d d5d07}qW|d1d6d2}|S)7zF INPUT: dd: subpartition data dict RERURN: ddl: subpartion ddl partition_typez/*!50100 PARTITION BY RANGE (partition_expression_utf8)z/*!50100 PARTITION BY LIST ( subpartition_typezSUBPARTITION BY HASH (subpartition_expression_utf8zSUBPARTITION BY KEY (T partitionspnameFZ subpartitionsspz SUBPARTITIONS z (z, cSsHg|]@}d|dd|ddds)sz!SUB_PARTITION..c Ss6g|].}d|dddjdd|dDdqS)z PARTITION rz VALUES IN (,cSsg|] }|dqS)rr)rZ_xrrrr+sz,SUB_PARTITION...rr)join)rrrrrr+sz */z( z PARTITION z VALUES LESS THAN rrrrrz VALUES in (rcSsg|] }|dqS)rr)rrrrrr3sz) z SUBPARTITION z ENGINE = enginez (z), Nz)*/rr )lenr)ddddlZISAUTOZpnr ZspnrZ_ddlrrr SUB_PARTITIONs^        "  F.$r$N)r$rrrrs