Python library to download data from Salesforce and synchronize with a relational database
Project description
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 ()
Project details
Release history Release notifications | RSS feed
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 salesforce_dbsync-1.3.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 33c7a6b6edc8d6cfd732a9aa513398daeab3f75102da112b82d422673fa1d729 |
|
MD5 | 84bb63fcb6bd0a0910d295ec46d9c49f |
|
BLAKE2b-256 | 61864f0e6e225ee1b4042e812e3f815a9bb3c1a2c2693e0b6b92e184b5e488f0 |