{ "info": { "author": "Ferran Pegueroles Forcadell", "author_email": "ferran@pegueroles.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 5 - Production/Stable", "Environment :: Console", "Intended Audience :: End Users/Desktop", "Intended Audience :: Information Technology", "Intended Audience :: System Administrators", "License :: OSI Approved :: GNU General Public License (GPL)", "Programming Language :: Python", "Topic :: Database", "Topic :: Text Processing", "Topic :: Utilities" ], "description": ".. -*- restructuredtext -*-\n\n====================\n README for loadcsv\n====================\n \n*loadcsv* is a programa and a library to load CSV files to databases and for \nconverting CSV files to SQL inserrt or update statements.\n\nThe utility gets the names of the columns from the first row of the CSV file. \n\nI wrote this utility because I was tired of doing always small scripts for \ndoing this kind os loads.\n\nBy now the utility suport MySQL, PostgresSQL and sqlite, but can be used with \nother SQL databases using the utility to generate the SQL statements and sending \nthem to the database::\n\n\n Usage: loadcsv [options] filename.csv\n If no database provided, display SQL to stdout\n\n Options::\n -h, --help show this help message and exit\n -D DRIVER, --driver=DRIVER\n database driver mysql, pgsql, sqlite\n -H HOSTNAME, --hostname=HOSTNAME\n database server hostname,defaults to localhost\n -d DBNAME, --dbname=DBNAME\n database name (filename on sqlite)\n -u USER, --user=USER database username\n -p PASSWORD, --password=PASSWORD\n database password\n -P PORT, --port=PORT database port\n -t TABLE, --table=TABLE\n database table to load\n --test run text, do no commit to the database\n --delimiter=DELIMITER\n CSV file field delimiter, by default semi-colon\n\n\nhe project code and bugtracker is hosted on \n`Bitbucket `_. \n\nInstall\n=======\n\nUsing pip::\n\n pip install loadcsv\n\nOs download and use ``setup`` ::\n\n python setup.py install\n\n\nLinks\n=====\n\n * `Project site `_. \n * `Freshmeat project page `_. \n * `Python package index page `_. \n\n\n\n", "description_content_type": "", "docs_url": null, "download_url": "https://bitbucket.org/ferranp/loadcsv/downloads", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://bitbucket.org/ferranp/loadcsv", "keywords": "", "license": "GPL", "maintainer": "", "maintainer_email": "", "name": "loadcsv", "package_url": "https://pypi.org/project/loadcsv/", "platform": "linux", "project_url": "https://pypi.org/project/loadcsv/", "project_urls": { "Download": "https://bitbucket.org/ferranp/loadcsv/downloads", "Homepage": "https://bitbucket.org/ferranp/loadcsv" }, "release_url": "https://pypi.org/project/loadcsv/0.5/", "requires_dist": null, "requires_python": "", "summary": "Load a csv file into a database", "version": "0.5" }, "last_serial": 3745546, "releases": { "0.1": [], "0.3": [ { "comment_text": "", "digests": { "md5": "ab301093cae8c4ab765016dc4052e7ee", "sha256": "8f5195ddaf61fc05dc2fe1ddcc147654d0758b501336f11092aae3c0a3ca92d1" }, "downloads": -1, "filename": "loadcsv-0.3.tar.gz", "has_sig": false, "md5_digest": "ab301093cae8c4ab765016dc4052e7ee", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4222, "upload_time": "2012-11-04T10:13:59", "url": "https://files.pythonhosted.org/packages/79/8a/cf4aec4148ff250380d47786a6a387cb6bf2b4f6fc1c172936e594c66858/loadcsv-0.3.tar.gz" } ], "0.4": [ { "comment_text": "", "digests": { "md5": "55c61d1b690ac78df6c6c1a2229ff9e3", "sha256": "5a58d0047b4a59f5ff99ccb5b7ec8871c8fcdcf4f720d22f1fd763a9acfb1753" }, "downloads": -1, "filename": "loadcsv-0.4.tar.gz", "has_sig": false, "md5_digest": "55c61d1b690ac78df6c6c1a2229ff9e3", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4569, "upload_time": "2012-11-14T15:44:52", "url": "https://files.pythonhosted.org/packages/de/c9/eacc8d97652ad9f27718cfa648aaaa886062600609f89fd457a380c590aa/loadcsv-0.4.tar.gz" } ], "0.5": [ { "comment_text": "", "digests": { "md5": "42400c0d9d60f3ae91b364e9f9830761", "sha256": "b944a6fefbefee53e2d48b41ab5dc0f6b34fe32629cf13a58d23413208aa87ba" }, "downloads": -1, "filename": "loadcsv-0.5.tar.gz", "has_sig": false, "md5_digest": "42400c0d9d60f3ae91b364e9f9830761", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4788, "upload_time": "2018-04-08T10:42:28", "url": "https://files.pythonhosted.org/packages/ad/2b/52067eb252ae1ffefb41ceb0058bb92a3fdeb782ad7af7335432406c92a5/loadcsv-0.5.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "42400c0d9d60f3ae91b364e9f9830761", "sha256": "b944a6fefbefee53e2d48b41ab5dc0f6b34fe32629cf13a58d23413208aa87ba" }, "downloads": -1, "filename": "loadcsv-0.5.tar.gz", "has_sig": false, "md5_digest": "42400c0d9d60f3ae91b364e9f9830761", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4788, "upload_time": "2018-04-08T10:42:28", "url": "https://files.pythonhosted.org/packages/ad/2b/52067eb252ae1ffefb41ceb0058bb92a3fdeb782ad7af7335432406c92a5/loadcsv-0.5.tar.gz" } ] }