csv-to-sqlite
=============
This is a simple, **datatype-guessing** script that takes CSV files as input and copies their contents into a SQLite database.
(Column names are taken from the headers (first row) in the csv file.)
Intended for **Python 3**. (I know it *did* run on Py2 as some people tried, but I haven't tested it.)
## Links
* [Source on GitHub](https://github.com/zblesk/csv-to-sqlite)
* [PyPI page](https://pypi.org/project/csv-to-sqlite/)
* [Introductory blog post with basic intro + a how-to](http://zblesk.net/blog/csv-to-sqlite/)
* [Other related blog posts](https://zblesk.net/blog/tag/csv-to-sqlite/)
## Overview
Installs via
```
pip install csv-to-sqlite
```
To find out more, run
```
csv-to-sqlite --help
```
If you've installed the package as a dependency for your own script, you can use it like this:
```python
import csv_to_sqlite
# all the usual options are supported
options = csv_to_sqlite.CsvOptions(typing_style="full", encoding="windows-1250")
input_files = ["abilities.csv", "moves.csv"] # pass in a list of CSV files
csv_to_sqlite.write_csv(input_files, "output.sqlite", options)
```
Raw data
{
"_id": null,
"home_page": "https://github.com/zblesk/csv-to-sqlite",
"name": "csv-to-sqlite",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3",
"maintainer_email": null,
"keywords": "csv sqlite conversion copy tool",
"author": "Ladislav Benc",
"author_email": "ladislav.benc@proton.me",
"download_url": null,
"platform": null,
"description": "csv-to-sqlite\n=============\n\nThis is a simple, **datatype-guessing** script that takes CSV files as input and copies their contents into a SQLite database. \n(Column names are taken from the headers (first row) in the csv file.) \nIntended for **Python 3**. (I know it *did* run on Py2 as some people tried, but I haven't tested it.)\n\n## Links \n\n* [Source on GitHub](https://github.com/zblesk/csv-to-sqlite) \n* [PyPI page](https://pypi.org/project/csv-to-sqlite/) \n* [Introductory blog post with basic intro + a how-to](http://zblesk.net/blog/csv-to-sqlite/)\n* [Other related blog posts](https://zblesk.net/blog/tag/csv-to-sqlite/) \n\n## Overview\n\nInstalls via \n\n```\n pip install csv-to-sqlite\n```\n\nTo find out more, run\n\n```\n csv-to-sqlite --help\n```\n\nIf you've installed the package as a dependency for your own script, you can use it like this:\n\n```python\nimport csv_to_sqlite \n\n# all the usual options are supported\noptions = csv_to_sqlite.CsvOptions(typing_style=\"full\", encoding=\"windows-1250\") \ninput_files = [\"abilities.csv\", \"moves.csv\"] # pass in a list of CSV files\ncsv_to_sqlite.write_csv(input_files, \"output.sqlite\", options)\n```\n\n",
"bugtrack_url": null,
"license": null,
"summary": "A script that processes the input CSV files and copies them into a SQLite database.",
"version": "2.1.3",
"split_keywords": [
"csv",
"sqlite",
"conversion",
"copy",
"tool"
],
"urls": [
{
"comment_text": null,
"digests": {
"md5": "b55583a502c228f151e91c86ef7b481b",
"sha256": "f3f9fcd857f58beefce711beba8dad51ef151ff82876858ee9da9cbd4463613f"
},
"downloads": -1,
"filename": "csv_to_sqlite-2.1.3-py3-none-any.whl",
"has_sig": false,
"md5_digest": "b55583a502c228f151e91c86ef7b481b",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3",
"size": 5668,
"upload_time": "2022-12-13T18:57:35",
"upload_time_iso_8601": "2022-12-13T18:57:35.489980Z",
"url": "https://files.pythonhosted.org/packages/a8/7f/2f1f9740df3d37ce358fbdfa50db068ed6b087d28a4f2a426f119c042487/csv_to_sqlite-2.1.3-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2022-12-13 18:57:35",
"github": true,
"gitlab": false,
"bitbucket": false,
"github_user": "zblesk",
"github_project": "csv-to-sqlite",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"requirements": [],
"lcname": "csv-to-sqlite"
}
JSON
