def create_fact(cls, **data): client = DimensionClient.insert(client_id=data['client_id']) item = DimensionItem.insert(item_id=data['item_id']) data_role = DimensionDataRole.insert(role=data['data_role']) definition = DimensionDefinition.insert(definition=data['definition']) processing_state = DimensionProcessingState.insert(processing_state=data['processing_state']) territory = DimensionTerritory.insert(code=data['territory']) asset = DimensionAssets.insert( asset_id=data['asset_id'], type=data['asset_type'] ) provider = DimensionItemProvider.insert( True, provider_id=data['provider_item_id'], provider_name=data['provider'], ) delivery_date = datetime.datetime.strptime(str(data['delivery_date']), settings.DATETIME_FORMAT) event_date = datetime.datetime.strptime(data['event_time'], settings.DATETIME_FORMAT) event_utc_datetime = datetime.datetime.strptime(data['event_time'], settings.DATETIME_FORMAT) fact = FactServicesBackstageAssetMatch.objects.create( client=client, item=item, asset=asset, data_role=data_role, processing_state=processing_state, provider=provider, territory=territory, spec_name=data['spec_name'], delivery_date=delivery_date, definition=definition, file_size=data['file_size'], duration=data['duration'], event_date=event_date.date(), event_utc_date=DimensionUTCDate.date_from_datetime(datetime=data['event_time']), event_utc_datetime=event_utc_datetime ) fact.save() if data['used_asset_ids']: for asset_id in data['used_asset_ids']: asset_dim = DimensionAssets.objects.get_or_create(asset_id=asset_id) fact.used_asset_ids.add(asset_dim[0].id) else: fact.used_asset_ids = '' if data['languages']: for language in data['languages']: lang_dim = DimensionLanguage.objects.get_or_create(iso_code=language) fact.languages.add(lang_dim[0].id) else: fact.languages = '' return fact
def create_fact(cls, **data): asset = DimensionAssets.insert(asset_id=data['asset_id'], type=data['asset_type']) unique_studio_item = DimensionStudioItem.insert( unique_studio_item_id=data['unique_studio_item_id']) studio = DimensionStudio.insert(name=data['studio']) data_role = DimensionDataRole.insert(role=data['data_role']) definition = DimensionDefinition.insert(definition=data['definition']) language = DimensionLanguage.insert(iso_code=data['language']) audio_channel = DimensionAudioChannels.insert( channel=data['audio_channel']) client = DimensionClient.insert(client_id=data['client_id']) vendor = DimensionVendor.insert(name=data['vendor']) fact = FactServicesAggregatorAggregation.objects.create( asset=asset, unique_studio_item=unique_studio_item, studio=studio, file_name=data['file_name'], start_time=data['start_time'], end_time=data['end_time'], file_size=data['file_size'], checksum=data['checksum'], data_role=data_role, content_duration=data['content_duration'], definition=definition, language=language, audio_channel=audio_channel, client=client, vendor=vendor, event_utc_date=DimensionUTCDate.date_from_datetime( datetime=data['event_time']), event_utc_datetime=data['event_time']) return fact
def create_fact(cls, **data): asset = DimensionAssets.insert( asset_id=data['asset_id'], type=data['asset_type'] ) unique_studio_item = DimensionStudioItem.insert(unique_studio_item_id=data['unique_studio_item_id']) studio = DimensionStudio.insert(name=data['studio']) data_role = DimensionDataRole.insert(role=data['data_role']) definition = DimensionDefinition.insert(definition=data['definition']) language = DimensionLanguage.insert(iso_code=data['language']) audio_channel = DimensionAudioChannels.insert(channel=data['audio_channel']) client = DimensionClient.insert(client_id=data['client_id']) vendor = DimensionVendor.insert(name=data['vendor']) fact = FactServicesAggregatorAggregation.objects.create( asset=asset, unique_studio_item=unique_studio_item, studio=studio, file_name=data['file_name'], start_time=data['start_time'], end_time=data['end_time'], file_size=data['file_size'], checksum=data['checksum'], data_role=data_role, content_duration=data['content_duration'], definition=definition, language=language, audio_channel=audio_channel, client=client, vendor=vendor, event_utc_date=DimensionUTCDate.date_from_datetime(datetime=data['event_time']), event_utc_datetime=data['event_time'] ) return fact
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()