{ "info": { "author": "S Satapathy", "author_email": "shubhakant.satapathy@gmail.com", "bugtrack_url": null, "classifiers": [ "License :: OSI Approved :: MIT License", "Operating System :: OS Independent", "Programming Language :: Python :: 3" ], "description": "# salesforce-dbsync\nPython library to download data from Salesforce and synchronize with a relational database \n\n\n### Example ###\n\nThis example performs the following steps for Salesforce Object 'Account' when run for the first time:\n* Downloads Table Metadata from Salesforce\n* Downloads Table Data from Salesforce, limited to a maximum of 10000 rows\n* Creates a MySQL Database if one does not already exist\n* Creates Tables in MySQL alongwith Indexes if the Table does not already exist\n* Uploads the data into the MySQL Table\n\nIn the subsequent runs, it performs the following steps:\n* Downloads Table Data from Salesforce\n* Refreshes data in MySQL with new records or updates that from Salesforce\n* Note: Deletes in Salesforce are ignored\n\n```python\nimport sys\nfrom screenwriter import Screenwriter\nfrom salesforce_dbsync import Sync_Manager\n\ndef do_init ():\n\tglobal sw, sync_mgr\n\tsw = Screenwriter ()\n\tdb_creds = {'user':'mysql_uid', 'passwd':'mysql_pwd', 'db':'TESTDB'}\n\tsf_creds = {'user':'sf_uid', 'passwd':'pb_pwd', 'token':'sf_tok'}\n\tcontrol_map = {'min-SystemModstamp-date':'2019-01-01', 'dml-limit':10000}\n\tsync_mgr = Sync_Manager (sw, db_creds, sf_creds, control_map)\n\ndef do_main ():\n\tglobal sw, sync_mgr\n\tsync_mgr.add_sync_profile ('Account', ['Name','BillingStreet','BillingCountry'], [\"BillingCountry = 'Canada'\"])\n\tsync_mgr.init_mysql ()\n\tsync_mgr.init_sfdc ()\n\tsync_mgr.create_missing_db_tables ()\n\tsync_mgr.sync ()\n\ndo_init ()\ndo_main ()\n```\n\n\n", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/satapathy/pypi-salesforce-dbsync", "keywords": "", "license": "", "maintainer": "", "maintainer_email": "", "name": "salesforce-dbsync", "package_url": "https://pypi.org/project/salesforce-dbsync/", "platform": "", "project_url": "https://pypi.org/project/salesforce-dbsync/", "project_urls": { "Homepage": "https://github.com/satapathy/pypi-salesforce-dbsync" }, "release_url": "https://pypi.org/project/salesforce-dbsync/1.3.3/", "requires_dist": [ "simple-salesforce", "mysql.connector", "screenwriter" ], "requires_python": "", "summary": "Python library to download data from Salesforce and synchronize with a relational database", "version": "1.3.3" }, "last_serial": 5936514, "releases": { "1.0.0": [ { "comment_text": "", "digests": { "md5": "a90c17c5c6f8fdfd60c1dba47dca73d7", "sha256": "0fc02de3f305bc759e5e7c9fc42e4f8033ef9cd0a77b60061b699b2e11ab321f" }, "downloads": -1, "filename": "salesforce_dbsync-1.0.0-py3-none-any.whl", "has_sig": false, "md5_digest": "a90c17c5c6f8fdfd60c1dba47dca73d7", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7619, "upload_time": "2019-10-06T14:06:00", "url": "https://files.pythonhosted.org/packages/b3/8f/009ff2b740a2a676cd6c4187402d868b79b2bfdd457179b5d7046e91de23/salesforce_dbsync-1.0.0-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "72de4ad7501316c160ef36a2d200a715", "sha256": "e798dedb2bc688be743d8587c363b4933784e87aca4398957a01d4980bb2027d" }, "downloads": -1, "filename": "salesforce-dbsync-1.0.0.tar.gz", "has_sig": false, "md5_digest": "72de4ad7501316c160ef36a2d200a715", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5311, "upload_time": "2019-10-06T14:06:03", "url": "https://files.pythonhosted.org/packages/10/af/97d35869ba78f3ef9346a337d425769ffb26ab1fd961fd8d0762c4bd7f79/salesforce-dbsync-1.0.0.tar.gz" } ], "1.1.0": [ { "comment_text": "", "digests": { "md5": "89294e0434e72b2fc49b5abf0cc35d3b", "sha256": "bab58eee6779b4480196c3dae09191db20c57ff35a1bd6ca3e72c7b6b58950d3" }, "downloads": -1, "filename": "salesforce_dbsync-1.1.0-py3-none-any.whl", "has_sig": false, "md5_digest": "89294e0434e72b2fc49b5abf0cc35d3b", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7613, "upload_time": "2019-10-06T14:09:17", "url": "https://files.pythonhosted.org/packages/58/04/5b51fafb2cbff8ebb82f7d0b9a3a61a6fbcc12f08712b43bb987e2ccad69/salesforce_dbsync-1.1.0-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "9b5eb3234c12125f670ac8424f95c6ce", "sha256": "ca8df1706aab21170d940f32ecfe6aca4af0ae8a7a193d0302df31b0fbc79487" }, "downloads": -1, "filename": "salesforce-dbsync-1.1.0.tar.gz", "has_sig": false, "md5_digest": "9b5eb3234c12125f670ac8424f95c6ce", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5307, "upload_time": "2019-10-06T14:09:19", "url": "https://files.pythonhosted.org/packages/22/78/3d0456c4c80a6a38786c367f7f14c75c292ea31e1b21f12ce6307888db0f/salesforce-dbsync-1.1.0.tar.gz" } ], "1.2.0": [ { "comment_text": "", "digests": { "md5": "30a1b80a0f782b6339113b35a3269957", "sha256": "5acc981b26ab7e10fe670f7c2b624e7bc57e3f820a0a5e126a69756332050d1d" }, "downloads": -1, "filename": "salesforce_dbsync-1.2.0-py3-none-any.whl", "has_sig": false, "md5_digest": "30a1b80a0f782b6339113b35a3269957", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7604, "upload_time": "2019-10-06T15:31:07", "url": "https://files.pythonhosted.org/packages/0b/bf/1d2265c922291d77195f49c83e45b5de14378cbaf98e845c5d4c26ee49af/salesforce_dbsync-1.2.0-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "128d9b53bc20ba3e7bbae982e67472de", "sha256": "9971a5ac0a7395b8d4d50a4a593f1e155513cb3dd33bc4ba96dd7ca585e437f9" }, "downloads": -1, "filename": "salesforce-dbsync-1.2.0.tar.gz", "has_sig": false, "md5_digest": "128d9b53bc20ba3e7bbae982e67472de", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5323, "upload_time": "2019-10-06T15:31:10", "url": "https://files.pythonhosted.org/packages/26/6d/91bd3657aff187d560892478ac36c5a26807c3614684f1cc4703ce1c0d54/salesforce-dbsync-1.2.0.tar.gz" } ], "1.3.0": [ { "comment_text": "", "digests": { "md5": "48845fa01d12758ca84bab6d91eb5922", "sha256": "d724155ea016f4850f92fb56a0640955bb48740e302f2f4f8cfc07ea00b45c68" }, "downloads": -1, "filename": "salesforce_dbsync-1.3.0-py3-none-any.whl", "has_sig": false, "md5_digest": "48845fa01d12758ca84bab6d91eb5922", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7626, "upload_time": "2019-10-06T15:35:22", "url": "https://files.pythonhosted.org/packages/66/02/e5d9ef600bf83fb099ecb3819b6a3d3b9d61326c4bdd17a824a5680b3090/salesforce_dbsync-1.3.0-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "ece470fce64874a6145c5c166f7cd3ae", "sha256": "b20407df89dff278a89bb5febfd1a5e019f9e97b663136594b33df4da6e086e3" }, "downloads": -1, "filename": "salesforce-dbsync-1.3.0.tar.gz", "has_sig": false, "md5_digest": "ece470fce64874a6145c5c166f7cd3ae", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5319, "upload_time": "2019-10-06T15:35:26", "url": "https://files.pythonhosted.org/packages/4a/48/f0384dfc810b976b00a14dc86902d771a40937b7bddc4b1a192024d6977f/salesforce-dbsync-1.3.0.tar.gz" } ], "1.3.1": [ { "comment_text": "", "digests": { "md5": "84bb63fcb6bd0a0910d295ec46d9c49f", "sha256": "33c7a6b6edc8d6cfd732a9aa513398daeab3f75102da112b82d422673fa1d729" }, "downloads": -1, "filename": "salesforce_dbsync-1.3.1-py3-none-any.whl", "has_sig": false, "md5_digest": "84bb63fcb6bd0a0910d295ec46d9c49f", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7995, "upload_time": "2019-10-06T15:56:24", "url": "https://files.pythonhosted.org/packages/61/86/4f0e6e225ee1b4042e812e3f815a9bb3c1a2c2693e0b6b92e184b5e488f0/salesforce_dbsync-1.3.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "3663552c7ebc1232b19a4fb6dd18700f", "sha256": "08892732b91e3b9a66c17ca67322975aa37aa6e56216bbfa4d5485004d34e736" }, "downloads": -1, "filename": "salesforce-dbsync-1.3.1.tar.gz", "has_sig": false, "md5_digest": "3663552c7ebc1232b19a4fb6dd18700f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5761, "upload_time": "2019-10-06T15:56:27", "url": "https://files.pythonhosted.org/packages/8d/4e/36f5bb8c99387149021dda6050f9aba0ac8f3d2a2a0acd5c65a9d9d0ea6b/salesforce-dbsync-1.3.1.tar.gz" } ], "1.3.2": [ { "comment_text": "", "digests": { "md5": "5bd5a214d0a08cb447cea79dc800a98a", "sha256": "48c6932b55c4d19d319b360c77a6bf1282a69634825dbd5f05376ed0ed6e04cb" }, "downloads": -1, "filename": "salesforce_dbsync-1.3.2-py3-none-any.whl", "has_sig": false, "md5_digest": "5bd5a214d0a08cb447cea79dc800a98a", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 8007, "upload_time": "2019-10-06T16:09:05", "url": "https://files.pythonhosted.org/packages/29/b1/6dc8e8a3c55bfffe73b3da825945657bc20bf2236fac170106145713fe7a/salesforce_dbsync-1.3.2-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "c00fc2ab0b79ab32b827949193a34a51", "sha256": "2a8e7272bf37fddcd7da6c264f0bf0ae54ab05903e0c8ea69842c36e467337c6" }, "downloads": -1, "filename": "salesforce-dbsync-1.3.2.tar.gz", "has_sig": false, "md5_digest": "c00fc2ab0b79ab32b827949193a34a51", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5774, "upload_time": "2019-10-06T16:09:09", "url": "https://files.pythonhosted.org/packages/80/ce/218b5717f253c5a81c0658cfa0494b2625537c53163cf35149e582aea3f7/salesforce-dbsync-1.3.2.tar.gz" } ], "1.3.3": [ { "comment_text": "", "digests": { "md5": "cc34283f3720d5d9f21418966b9b899b", "sha256": "14484d2935efbb4c3e02938c914316adfe5784d0580ca5c4da037459d4e0a4d8" }, "downloads": -1, "filename": "salesforce_dbsync-1.3.3-py3-none-any.whl", "has_sig": false, "md5_digest": "cc34283f3720d5d9f21418966b9b899b", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 8052, "upload_time": "2019-10-07T01:11:00", "url": "https://files.pythonhosted.org/packages/50/d5/549254b0a0d48107d95fce254b45a1f3daca1e6d7847201b2aa6b273ba45/salesforce_dbsync-1.3.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "eb478143804d250e2fe88434766aa614", "sha256": "8fc63209866495e0775ec09c9bc9aec65caf9c7fc22d3004774e71e8d69ad319" }, "downloads": -1, "filename": "salesforce-dbsync-1.3.3.tar.gz", "has_sig": false, "md5_digest": "eb478143804d250e2fe88434766aa614", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5809, "upload_time": "2019-10-07T01:11:02", "url": "https://files.pythonhosted.org/packages/2a/77/4746fef2878bde2cddfc643ecf80e5de4215e4ab00ccb052b168818aa118/salesforce-dbsync-1.3.3.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "cc34283f3720d5d9f21418966b9b899b", "sha256": "14484d2935efbb4c3e02938c914316adfe5784d0580ca5c4da037459d4e0a4d8" }, "downloads": -1, "filename": "salesforce_dbsync-1.3.3-py3-none-any.whl", "has_sig": false, "md5_digest": "cc34283f3720d5d9f21418966b9b899b", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 8052, "upload_time": "2019-10-07T01:11:00", "url": "https://files.pythonhosted.org/packages/50/d5/549254b0a0d48107d95fce254b45a1f3daca1e6d7847201b2aa6b273ba45/salesforce_dbsync-1.3.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "eb478143804d250e2fe88434766aa614", "sha256": "8fc63209866495e0775ec09c9bc9aec65caf9c7fc22d3004774e71e8d69ad319" }, "downloads": -1, "filename": "salesforce-dbsync-1.3.3.tar.gz", "has_sig": false, "md5_digest": "eb478143804d250e2fe88434766aa614", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5809, "upload_time": "2019-10-07T01:11:02", "url": "https://files.pythonhosted.org/packages/2a/77/4746fef2878bde2cddfc643ecf80e5de4215e4ab00ccb052b168818aa118/salesforce-dbsync-1.3.3.tar.gz" } ] }