用于大查询和配置文件的 Salesforce 文本格式化程序

Salesforce 文本格式化程序 - Pypi

pip install Text-Formatter-sf

导入 salesforce_text_formatter 作为 sf

SQL 格式化程序

您所要做的就是SQLFormatter使用参数实例化类sql_object。

sf.format.SqlFormatter(sql_object)

请传入一个字典，您可以使用下面的伪代码作为示例。

sql_object = {  
    'fields': ['List of fields : list'],  
    'object': "Object name here : str",  
    'object_abreviation': "object abreviation goes here (e.g. opp) : str"
    }

例子

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 配置格式化程序

您所要做的就是ConfigFormatter使用参数实例化类yaml_object。

sf.format.ConfigFormatter(yaml_object)

请传入一个字典，您可以使用下面的伪代码作为示例。

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']
}

例子

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']
}