def fix_nulls(apps, schema):
# Change null values in these fields to empty strings
fix_null_values(apps.get_model('reports.appliedindicator'), [
'assumptions',
'cluster_indicator_title',
'cluster_name',
'context_code',
'means_of_verification',
'response_plan_name',
])
fix_null_values(apps.get_model('reports.indicator'), [
'assumptions',
'baseline',
'code',
'target',
])
fix_null_values(apps.get_model('reports.indicatorblueprint'), [
'description',
'subdomain',
])
fix_null_values(apps.get_model('reports.result'), [
'activity_focus_code',
'activity_focus_name',
'code',
'gic_code',
'gic_name',
'sic_code',
'sic_name',
'vision_id',
])
fix_null_values(apps.get_model('reports.sector'), [
'alternate_name',
'color',
'description',
])
def fix_nulls(apps, schema):
# Change null values in these fields to empty strings
fix_null_values(apps.get_model('locations.cartodbtable'), [
'color',
'display_name',
'parent_code_col',
])
fix_null_values(apps.get_model('locations.location'), [
'p_code',
])
def fix_nulls(apps, schema):
# Change null values in these fields to empty strings
fix_null_values(apps.get_model('purchase_order.auditorfirm'), [
'city',
'country',
'email',
'phone_number',
'postal_code',
'street_address',
'vendor_number',
])
def fix_nulls(apps, schema):
# Change null values in these fields to empty strings
fix_null_values(
apps.get_model('funds.fundscommitmentheader'),
[
'document_text',
'exchange_rate',
'fc_type',
'responsible_person',
'currency',
]
)
fix_null_values(
apps.get_model('funds.fundscommitmentitem'),
[
'fc_ref_number',
'fr_number',
'fund',
'gl_account',
'grant_number',
'line_item_text',
'wbs',
]
)
fix_null_values(
apps.get_model('funds.fundsreservationheader'),
[
'document_text',
'fr_type',
'currency',
]
)
fix_null_values(
apps.get_model('funds.fundsreservationitem'),
[
'fr_ref_number',
'fund',
'grant_number',
'line_item_text',
'wbs',
]
)
fix_null_values(
apps.get_model('funds.grant'),
[
'description',
]
)
def fix_nulls(apps, schema):
# Change null values in these fields to empty strings
fix_null_values(
apps.get_model('users.country'),
[
'business_area_code',
'country_short_code',
'long_name',
]
)
fix_null_values(
apps.get_model('users.userprofile'),
[
'job_title',
'org_unit_code',
'org_unit_name',
'phone_number',
'post_number',
'post_title',
'section_code',
]
)
def fix_nulls(apps, schema):
# Change null values in these fields to empty strings
fix_null_values(apps.get_model('publics.country'), [
'dsa_code',
'iso_2',
'iso_3',
])
fix_null_values(apps.get_model('publics.dsarateupload'), [
'status',
])
fix_null_values(apps.get_model('publics.travelagent'), [
'city',
])
def fix_nulls(apps, schema):
# Change null values in these fields to empty strings
fix_null_values(apps.get_model('attachments.attachment'), [
'hyperlink',
])
def fix_nulls(apps, schema):
# Change null values in these fields to empty strings
fix_null_values(apps.get_model('audit.audit'), [
'audit_opinion',
])
def fix_nulls(apps, schema):
# Change null values in these fields to empty strings
fix_null_values(apps.get_model('vision.visionsynclog'), [
'details',
'exception_message',
])
def fix_nulls(apps, schema):
# Change null values in these fields to empty strings
fix_null_values(apps.get_model('t2f.actionpoint'), [
'actions_taken',
'comments',
'status',
])
fix_null_values(apps.get_model('t2f.invoice'), [
'vision_fi_id',
])
fix_null_values(apps.get_model('t2f.invoice'), [
'messages',
], [])
fix_null_values(apps.get_model('t2f.itineraryitem'), [
'mode_of_travel',
])
fix_null_values(apps.get_model('t2f.travel'), [
'additional_note',
'cancellation_note',
'certification_note',
'misc_expenses',
'purpose',
'rejection_note',
'report_note',
])
fix_null_values(apps.get_model('t2f.travelactivity'), [
'travel_type',
])