· 7 years ago · Aug 13, 2018, 02:48 PM
1# -*- coding: utf-8 -*-
2
3# con_str = "Driver={SQL Server};Server=spb-s-dwh1;Database=dwh;Trusted_Connection=yes;"
4con_str = "Driver={SQL Server};Server=spb-s-dwh1;Database=dwh;Uid=kim.lestat;Pwd=q3dm12"
5url = "https://api.mindbox.ru/v3/operations/sync?endpointId=zoloto585.analytics&operation=zoloto585"
6key = 'Mindbox secretKey="HLFkT5sjA1SIsiX5wpCb"'
7insert_promo = """
8INSERT INTO stg.mindbox.Promo (Id, Name, MindBoxId, Channel, SendDate, ClientGroup, firstMindboxId)
9 VALUES
10"""
11insert_client """
12INSERT INTO stg.mindbox.Client (MindBoxId, SapId, CardNumber, PhoneNumber)
13 VALUES
14"""