**SQLite code:**
СОЗДАТЬ ТАБЛИЦУ B_SS00_SS01_04_TT_TCURR AS
С РЕКУРСИВНЫМ B_SS00_SS01_03_TT_TCURR_WHILE AS (
SELECT
*,
ZF_PRE_TCURR_GDATU_DAYSTART AS ZF_TCURR_GDATU
FROM B_SS00_SS01 _03_TT_TCURR_DAYSTART
СОЮЗ ВСЕ
SELECT
TCURR_FCURR,
TCURR_FFACT,
TCURR_GDATU,
TCURR_KURST,
TCURR_TCURR,
TCURR_TFACT,
ZF_TCURR_SORT_KEY,
/>ZF_TCURR_FCURR_BEGD,
ZF_TCURR_FCURR_ENDD,
TCURR_UKURS,
ZF_PRE_TCURR_FCURR,
ZF_PRE_TCURR_TCURR,
ZF_PRE_TCURR_GDATU,
ZF_PRE_TCURR_UKURS,
Z F_PRE_TCURR_GDATU_DAYSTART,
TCURR_GDATU_DAYSTART,
IIF(TCURR_FCURR = ZF_PRE_TCURR_FCURR AND TCURR_TCURR = ZF_PRE_TCURR_TCURR, DATE(ZF_TCURR_GDATU, «+1 день»),'')
FROM B_SS00_SS01_03_TT_TCURR_WHILE
WHERE ZF_TC URR_GDATU < ДАТА(TCURR_GDATU_DAYSTART, '-1 дней')
И TCURR_FCURR = ZF_PRE_TCURR_FCURR
И TCURR_TCURR = ZF_PRE_TCURR_TCURR
)
ВЫБЕРИТЕ ОТЛИЧНЫЕ * ИЗ B_SS00_SS01_03_TT_TCURR_WHILE;
**This is my python code:**
def create_table_B_SS00_SS01_04_TT_TCURR(B_SS00_SS01_03_TT_TCURR_DAYSTART):
recursive_df = B_SS00_SS01_03_TT_TCURR_DAYSTART.copy()
recursive_df['ZF_TCURR_GDATU'] = recursive_d f['ZF_PRE_TCURR_GDATU_DAYSTART']
result_df = pd.DataFrame()
while not recursive_df.empty:
result_df = pd.concat([result_df, recursive_df])
recursive_df['ZF_TCURR_GDATU'] = pd.to_datetime(recursive_df['ZF_TCURR_GDATU']) + pd.Timedelta(days=1)
recursive_df = recursive_df[(recursive_df['ZF_TCURR_GDATU'] < pd.to_datetime(recursive_df['TCURR_GDATU_DAYSTART']) - pd.Timedelta(days=1)) &
(recursive_df['TCURR_FCURR'] == recursive_df['ZF_PRE_TCURR_FCURR']) &
(recursive_df['TCURR_TCURR'] == recursive_df['ZF_PRE_TCURR_TCURR'])].copy()
recursive_df['new_column'] = np.where(
(recursive_df['TCURR_FCURR'] == recursive_df['ZF_PRE_TCURR_FCURR']) & (recursive_df['TCURR_TCURR'] == recursive_df['ZF_PRE_TCURR_TCURR']),
pd.to_datetime(recursive_df['ZF_TCURR_GDATU']) + pd.Timedelta(days=1),
np.nan
)
return result_df.drop_duplicates(inplace=True)
Подробнее здесь: https://stackoverflow.com/questions/782 ... ing-pandas
