def create_fact(cls, logs, **data): # dims platform = save_platform(data, event='Storefront Subscription') territory = DimensionTerritory.insert(code=data['territory']) if exists('territory', data) else None client = DimensionClient.insert(client_id=data['client_id']) if exists('client_id', data) else None du = save_user(data, territory, client, event='Storefront Subscription') dst = DST.insert( period=data['subscription_period'] if exists('subscription_period', data) else None, recurrence=data['subscription_recurrence'] if exists('subscription_recurrence', data) else None ) if any([d in data for d in ['subscription_period', 'subscription_recurrence']]) else None dss_status, _ = DSS.insert(event=int(data['subscription_status'])) if exists('subscription_status', data) else None state, err = get_rule( status=data.get('subscription_status', None), current_state=FactServicesStorefrontSubscription.get_last_event( subscription_id=data.get('subscription_id', None) ), window_ongoing=bool(data.get('window_on_going', False)) ) dsse, _ = DSSe.objects.get_or_create(state=state) item = DimensionItem.insert(item_id=data.get('item_id')) if exists('item_id', data) else None product = DimensionProduct.insert(product_id=data.get('product_id')) if exists('product_id', data) else None usage_right = DimensionRight.insert( right_id=data.get('window_usage_right_id') ) if exists('window_usage_right_id', data) else None window = DimensionWindow.insert( window_id=data.get('window_id', None), item=item, product=product, start_date=data['window_start_date'], end_date=data['window_end_date'], pricing_id=data['window_pricing_id'], usage_right_id=usage_right, tier=data['window_tier'], deleted=data['window_deleted_date'], window_type=data['window_type'], on_going=data['window_on_going'], repeat_count=data['window_repeat_count'], auto_upgrade=data['window_auto_upgrade'], allow_repurchase=data['window_allow_repurchase'], apple_product_id=data['apple_product_id'], )if any([i in data for i in [ 'window_id', 'item_id', 'product_id', 'window_start_date', 'window_end_date', 'window_pricing_id', 'window_usage_right_id', 'window_tier', 'window_deleted_date', 'window_type', 'window_on_going', 'window_repeat_count', 'window_auto_upgrade', 'window_allow_repurchase', 'apple_product_id', ]]) else None # fact create fact = FactServicesStorefrontSubscription.objects.create( user=du, subscription_id=data.get('subscription_id', None), subscription_type=dst, subscription_status=dss_status, subscription_state=dsse, subscription_state_error=err, platform=platform, window=window, transaction_id=data.get('transaction_id', None), event_utc_date=DimensionUTCDate.date_from_datetime(datetime=data['event_time']), event_utc_datetime=data.get('event_time', None) ) try: FactServicesStorefrontSubscription.objects.get(pk=fact.pk) exist = True except FactServicesStorefrontSubscription.DoesNotExist: exist = False logs.completed = exist logs.save()
def create_fact(cls, logs, **data): # insert dims item = DimensionItem.insert( item_id=data.get('item_id')) if exists('item_id', data) else None product = DimensionProduct.insert( product_id=data.get('product_id')) if exists('product_id', data) else None right = DimensionRight.insert(right_id=data.get('right_id')) if exists( 'right_id', data) else None currency = DimensionCurrency.insert( code=data.get('currency')) if exists('currency', data) else None retail_model = DimensionRetailModel.insert( model=data.get('retail_model')) if exists('retail_model', data) else None definition = DimensionDefinition.insert( definition=data.get('definition')) if exists('definition', data) else None window = DimensionWindow.insert(window_id=data.get('window_id', None), product=product, usage_right=right, item=item) transaction_status = DimensionStoreTransactionStatus.insert( status=data.get('transaction_status')) if exists( 'transaction_status', data) else None platform = save_platform(data, event='Storefront Transaction') territory = DimensionTerritory.insert( code=data.get('territory')) if exists('territory', data) else None client = DimensionClient.insert( client_id=data.get('client_id')) if exists('client_id', data) else None user = save_user(data, territory, client, event='Storefront Transaction') account = DimensionAccount.insert(account_id=data.get( 'account_id', data.get('external_user_id', data.get('internal_user_id', None)))) try: device = DimensionDevice.insert( make=data.get('make', ''), model=data.get('model', ''), os=data.get('os', ''), os_version=data.get('version', ''), ) if any([d in data for d in ['make', 'model', 'os', 'version']]) else None except: log.exception('') try: trans = cls.objects.get( transaction_id=data.get('transaction_id', '')) trans.last_4_digits = data.get('last_4_digits', None) trans.event_utc_datetime = data.get('event_time', timezone.now().isoformat()) trans.event_utc_date = DimensionUTCDate.date_from_datetime( data.get('event_time', timezone.now().isoformat())) trans.save() except cls.DoesNotExist as e: trans = cls.objects.create( item=item, product=product, window=window, transaction_id=data.get('transaction_id', None), transaction_status=transaction_status, user=user, account=account, right=right, price=data.get('price', 0.00), currency=currency, retail_model=retail_model, definition=definition, client=client, territory=territory, platform=platform, device=device, mnc=data.get('MNC', None), mcc=data.get('MCC', None), last_4_digits=data.get('last_4_digits', None), event_utc_datetime=data.get('event_time', timezone.now().isoformat()), event_utc_date=DimensionUTCDate.date_from_datetime( data.get('event_time', timezone.now().isoformat())), ) try: cls.objects.get(pk=trans.pk) exist = True except cls.DoesNotExist: exist = False logs.completed = exist logs.save()
def create_fact(cls, logs, **data): # insert dims item = DimensionItem.insert(item_id=data.get('item_id')) if exists('item_id', data) else None product = DimensionProduct.insert(product_id=data.get('product_id')) if exists('product_id', data) else None right = DimensionRight.insert(right_id=data.get('right_id')) if exists('right_id', data) else None currency = DimensionCurrency.insert(code=data.get('currency')) if exists('currency', data) else None retail_model = DimensionRetailModel.insert( model=data.get('retail_model') ) if exists('retail_model', data) else None definition = DimensionDefinition.insert( definition=data.get('definition') ) if exists('definition', data) else None window = DimensionWindow.insert( window_id=data.get('window_id', None), product=product, usage_right=right, item=item ) transaction_status = DimensionStoreTransactionStatus.insert( status=data.get('transaction_status') ) if exists('transaction_status', data) else None platform = save_platform(data, event='Storefront Transaction') territory = DimensionTerritory.insert(code=data.get('territory')) if exists('territory', data) else None client = DimensionClient.insert(client_id=data.get('client_id')) if exists('client_id', data) else None user = save_user(data, territory, client, event='Storefront Transaction') account = DimensionAccount.insert( account_id=data.get( 'account_id', data.get( 'external_user_id', data.get( 'internal_user_id', None ) ) ) ) try: device = DimensionDevice.insert( make=data.get('make', ''), model=data.get('model', ''), os=data.get('os', ''), os_version=data.get('version', ''), )if any([ d in data for d in ['make', 'model', 'os', 'version'] ]) else None except: log.exception('') try: trans = cls.objects.get(transaction_id=data.get('transaction_id', '')) trans.last_4_digits = data.get('last_4_digits', None) trans.event_utc_datetime = data.get('event_time', timezone.now().isoformat()) trans.event_utc_date = DimensionUTCDate.date_from_datetime(data.get('event_time', timezone.now().isoformat())) trans.save() except cls.DoesNotExist as e: trans = cls.objects.create( item=item, product=product, window=window, transaction_id=data.get('transaction_id', None), transaction_status=transaction_status, user=user, account=account, right=right, price=data.get('price', 0.00), currency=currency, retail_model=retail_model, definition=definition, client=client, territory=territory, platform=platform, device=device, mnc=data.get('MNC', None), mcc=data.get('MCC', None), last_4_digits=data.get('last_4_digits', None), event_utc_datetime=data.get('event_time', timezone.now().isoformat()), event_utc_date=DimensionUTCDate.date_from_datetime(data.get('event_time', timezone.now().isoformat())), ) try: cls.objects.get(pk=trans.pk) exist = True except cls.DoesNotExist: exist = False logs.completed = exist logs.save()
def create_fact(cls, logs, **data): # dims platform = save_platform(data, event='Storefront Subscription') territory = DimensionTerritory.insert( code=data['territory']) if exists('territory', data) else None client = DimensionClient.insert( client_id=data['client_id']) if exists('client_id', data) else None du = save_user(data, territory, client, event='Storefront Subscription') dst = DST.insert( period=data['subscription_period'] if exists( 'subscription_period', data) else None, recurrence=data['subscription_recurrence'] if exists('subscription_recurrence', data) else None) if any([ d in data for d in ['subscription_period', 'subscription_recurrence'] ]) else None dss_status, _ = DSS.insert( event=int(data['subscription_status'])) if exists( 'subscription_status', data) else None state, err = get_rule( status=data.get('subscription_status', None), current_state=FactServicesStorefrontSubscription.get_last_event( subscription_id=data.get('subscription_id', None)), window_ongoing=bool(data.get('window_on_going', False))) dsse, _ = DSSe.objects.get_or_create(state=state) item = DimensionItem.insert( item_id=data.get('item_id')) if exists('item_id', data) else None product = DimensionProduct.insert( product_id=data.get('product_id')) if exists('product_id', data) else None usage_right = DimensionRight.insert( right_id=data.get('window_usage_right_id')) if exists( 'window_usage_right_id', data) else None window = DimensionWindow.insert( window_id=data.get('window_id', None), item=item, product=product, start_date=data['window_start_date'], end_date=data['window_end_date'], pricing_id=data['window_pricing_id'], usage_right_id=usage_right, tier=data['window_tier'], deleted=data['window_deleted_date'], window_type=data['window_type'], on_going=data['window_on_going'], repeat_count=data['window_repeat_count'], auto_upgrade=data['window_auto_upgrade'], allow_repurchase=data['window_allow_repurchase'], apple_product_id=data['apple_product_id'], ) if any([ i in data for i in [ 'window_id', 'item_id', 'product_id', 'window_start_date', 'window_end_date', 'window_pricing_id', 'window_usage_right_id', 'window_tier', 'window_deleted_date', 'window_type', 'window_on_going', 'window_repeat_count', 'window_auto_upgrade', 'window_allow_repurchase', 'apple_product_id', ] ]) else None # fact create fact = FactServicesStorefrontSubscription.objects.create( user=du, subscription_id=data.get('subscription_id', None), subscription_type=dst, subscription_status=dss_status, subscription_state=dsse, subscription_state_error=err, platform=platform, window=window, transaction_id=data.get('transaction_id', None), event_utc_date=DimensionUTCDate.date_from_datetime( datetime=data['event_time']), event_utc_datetime=data.get('event_time', None)) try: FactServicesStorefrontSubscription.objects.get(pk=fact.pk) exist = True except FactServicesStorefrontSubscription.DoesNotExist: exist = False logs.completed = exist logs.save()