A text formatting package for salesforce data engineers
Project description
Salesforce text formatter for Big query and config files
Salesforce Text Formatter - Pypi
pip install Text-Formatter-sf
import salesforce_text_formatter as sf
SQL formatter
All you have to do is instantiate the SQLFormatter
class with the sql_object
argument.
sf.format.SqlFormatter(sql_object)
Please pass a dictionary in and you can use the pseudo code below as an example.
sql_object = {
'fields': ['List of fields : list'],
'object': "Object name here : str",
'object_abreviation': "object abreviation goes here (e.g. opp) : str"
}
Example
sql_object = {
'fields': ['lease_termination_one_off__c', 'lease_termination_due_rent__c', 'reverse_to_original_contiditons__c', 'cost_of_reversal__c', 'stock_transfer_cost__c', 'shrinkage_cost__c', 'personnel_costs__c', 'other_costs__c', 'additional_comments__c', 'equipment_relocated__c', 'equipment_stored__c', 'equipment_related_costs__c', 'closure_date__c', 'handover_date__c', 'closure_reason__c', 'reopening_date__c', 'is_temporarily_closing__c'],
'object': "AgentWork",
'object_abreviation': "a"
}
Yaml config formatter
All you have to do is instantiate the ConfigFormatter
class with the yaml_object
argument.
sf.format.ConfigFormatter(yaml_object)
Please pass a dictionary in and you can use the pseudo code below as an example.
yaml_object = {
'object_name' : "Object name here : str",
'table_description' : "Table Description goes here : str",
'filter_by_country_and_entity' : "True or False : Boolean",
'field_list' : ['List of fields : list']
}
Example
yaml_object = {
'object_name' : "AgentWork",
'table_description' : "Salesforce VRM AgentWork",
'filter_by_country_and_entity' : False,
'field_list' : ['lease_termination_one_off__c', 'lease_termination_due_rent__c', 'equipment_relocated__c', 'equipment_stored__c', 'equipment_related_costs__c', 'closure_date__c', 'handover_date__c', 'closure_reason__c', 'reopening_date__c', 'is_temporarily_closing__c']
}
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Close
Hashes for Text_Formatter_sf-1.0.3-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 46b07bde3f10c4c91c3771c845c92ef2c4d90b968e3b1b2b430b2435a8cdd7ec |
|
MD5 | f1cdc8ec77d667776dfaf131718180a2 |
|
BLAKE2b-256 | fddb578cb60876b7ea71c6072844d877984d44e23086bf59cc915331d8f86f11 |