url = 'http://loco-proxy.itclover.ru:8123'
user = 'loco_user'
password = 'A7qoFxdH8PadW5B'

loco_num_val = '0335'
section_val = 'B'
datetime_start_val = '2018-05-06 10:00:02'
datetime_end_val = '2018-05-06 14:59:59'

model = Model()
query = f"""
                SELECT DISTINCT
                    date_time as dt,
                    loco_id as loco_id,
                    PositionFuelRods as PositionFuelRods,
                    SpeedEngine as SpeedEngine,
                    PosKM as PosKM,
                    PAirTurbocharger as PAirTurbocharger,
                    SpeedTurbocharger as SpeedTurbocharger,
                    Pboost as Pboost,
                    PowerPolling as PowerPolling

                FROM default.TE116U_062
                WHERE loco_num='0335' AND
                      section='{section_val}' AND
                      dt BETWEEN '{datetime_start_val}' AND '{datetime_end_val}'


                order by dt
                """

df = read_clickhouse(query, connection={'host': url,
                                        'database': 'default',
                                        'user': user,
                                        'password': password})

new_df = model.predict(df)
new_df.to_csv('test.csv')