salesforce-dbsync 1.3.1

Python library to download data from Salesforce and synchronize with a relational database

salesforce-dbsync

Python library to download data from Salesforce and synchronize with a relational database

Example

This example performs the following steps for Salesforce Object 'Account' when run for the first time:

• Download Table Metadata from Salesforce
• Downloads Table Data from Salesforce
• Creates a MySQL Database if it does not already exists
• Creates Tables in MySQL alongwith Indexes if the Table does not already exist
• Uploads the data into the MySQL Tables

In the subsequent runs, it will perform the following steps:

• Downloads Table Data from Salesforce
• Refreshes data in MySQL with any new records or updates that were detected in Salesforce. Note: Deletes in Salesforce are ignored

from salesforce-dbsync import Screenwriter
import sys
from screenwriter import Screenwriter
from salesforce_dbsync import Sync_Manager

def do_init ():
        global sw, sync_mgr

        sw = Screenwriter ()

        db_creds = {'user':'mysql_uid', 'passwd':'mysql_pwd', 'db':'TESTDB'}
        sf_creds = {'user':'sf_uid',    'passwd':'pb_pwd',    'token':'sf_tok'}
        control_map = {'min-SystemModstamp-date':'2019-01-01', 'dml-limit':10000}
        sync_mgr = Sync_Manager (sw, db_creds, sf_creds, control_map)

def do_main ():
        global sw, sync_mgr
	sync_mgr.add_sync_profile ('Account', ['Name','BillingStreet'], [])
        sync_mgr.init_mysql ()
        sync_mgr.init_sfdc ()
        sync_mgr.create_missing_db_tables ()
        sync_mgr.sync ()

do_init ()
do_main ()