25 августа 2021
class AmplitudeLogger:
def __init__(self, api_key, api_uri="https://api2.amplitude.com/identify"):
self.api_key = api_key
self.api_uri = api_uri
self.is_logging = True
event_type = kwargs.get('event_type', None)
if self._is_None_or_not_str(event_type):
return None
event["event_type"] = event_type
#event_type = kwargs.get('event_type', None)
#if self._is_None_or_not_str(event_type):
#return None
#event["event_type"] = event_type
event_properties = kwargs.get('event_properties', None)
if event_properties is not None and type(event_properties) == dict:
event["event_properties"] = event_properties
user_properties = kwargs.get('user_properties', None)
event["user_properties"] = user_properties
amplitude_logger = amplitude.AmplitudeLogger(api_key = "Ключик")
# собираем событие на примере обогащения CRM категорий
event_args = {"user_id": str(USERID),
"user_properties":{"CRM_Segment":str(SEGMENT), "CRM_Group": str(GROUP), "CRM_Level": str(LEVEL)}}
event = amplitude_logger.create_event(**event_args)
# отправляем в Amplitude
amplitude_logger.log_event(event)
conn = pymssql.connect(server, user, password, database)
cursor = conn.cursor()
query = "СЕЛЕКТ таблицы или ВЫЗОВ процедуры"
cursor.execute(query)
for row in cursor:
USERID = row[0]
SEGMENT = row[1]
LEVEL = row[2]
GROUP = row[3]
conn.commit()
conn.close()