| Name | csv-sqlite-converter JSON |
| Version |
0.0.1
JSON |
| download |
| home_page | |
| Summary | A convenient tool for transferring files between SQLite database and csv files and vice versa. |
| upload_time | 2023-03-26 07:24:34 |
| maintainer | |
| docs_url | None |
| author | |
| requires_python | >=3.10 |
| license | |
| keywords |
csv
sqlite
converter
|
| VCS |
|
| bugtrack_url |
|
| requirements |
No requirements were recorded.
|
| Travis-CI |
No Travis.
|
| coveralls test coverage |
No coveralls.
|
# CSV-SQLite Converter
The CSV-SQLite Convert allows to store data both from SQLite database in csv files and from csv files in a SQLite database.
## Installation
You can install CSV-SQLite Converter from PyPi (in the future).
python -m pip install csv_sqlite_converter
The converter supports Python 3.10 and higher.
## How to use
The converter is a command line tool. To use it, run:
python -m csv_sqlite_converter
And the following should appear:
>>> Choose one of the following:
"db" to transfer data from a database to csv files
"csv" to transfer data from csv files to a database
"stop" to stop
>
where:
### "db"
allows to transfer data from a database to csv files. **It needs two paths**: to the database and folder where csv files can be stored. After choosing this option the following appears:
>>> Copy path to database: <provide/here/path/to/database.db>
>>> Copy path to directory where folder with csv files will be stored: <provide/path/to/a/folder>
>>> Data from [name_of_table] table are now stored in [name_of_table].csv.
>>> Data from [name_of_another_table] table are now stored in [name_of_another_table].csv.
>>> ...
### "csv"
allows to transfer data from csv files to a database. **It needs two paths**: to csv files with data and the database to write to. However, csv files **must follow a very precise structure**:
```
.
+-- csv1.csv
+-- csv2.csv
+-- csv3.csv
```
where:
1. the name of the root folder matches the name of the database file
2. names of csv files match names of tables in the database files (ex. students.csv holds data for a table named students)
After choosing this option the following appears:
>>> Copy path to database: <provide/here/path/to/database.db>
>>> Copy path to directory with csv files: <provide/path/to/a/folder/with/csv/files>
>>> File [name_of_csv_file] processed successfully.
>>> File [name_of_another_csv_file] processed successfully.
>>> ...
### "stop"
stops the execution of the package.
Raw data
{
"_id": null,
"home_page": "",
"name": "csv-sqlite-converter",
"maintainer": "",
"docs_url": null,
"requires_python": ">=3.10",
"maintainer_email": "",
"keywords": "csv,sqlite,converter",
"author": "",
"author_email": "undeMalum <polakwmc@gazeta.pl>",
"download_url": "https://files.pythonhosted.org/packages/bd/cd/2975095b2f108a99d1c15b963c74b4ceb3f0c8dc0fc08608b10aa120b691/csv-sqlite-converter-0.0.1.tar.gz",
"platform": null,
"description": "# CSV-SQLite Converter\r\nThe CSV-SQLite Convert allows to store data both from SQLite database in csv files and from csv files in a SQLite database.\r\n\r\n## Installation\r\nYou can install CSV-SQLite Converter from PyPi (in the future).\r\n \r\n python -m pip install csv_sqlite_converter\r\n\r\nThe converter supports Python 3.10 and higher.\r\n\r\n## How to use\r\nThe converter is a command line tool. To use it, run:\r\n\r\n python -m csv_sqlite_converter\r\n\r\nAnd the following should appear:\r\n \r\n >>> Choose one of the following:\r\n \"db\" to transfer data from a database to csv files\r\n \"csv\" to transfer data from csv files to a database\r\n \"stop\" to stop\r\n > \r\n\r\nwhere:\r\n\r\n### \"db\" \r\nallows to transfer data from a database to csv files. **It needs two paths**: to the database and folder where csv files can be stored. After choosing this option the following appears:\r\n \r\n >>> Copy path to database: <provide/here/path/to/database.db>\r\n >>> Copy path to directory where folder with csv files will be stored: <provide/path/to/a/folder>\r\n >>> Data from [name_of_table] table are now stored in [name_of_table].csv.\r\n >>> Data from [name_of_another_table] table are now stored in [name_of_another_table].csv.\r\n >>> ...\r\n\r\n### \"csv\"\r\nallows to transfer data from csv files to a database. **It needs two paths**: to csv files with data and the database to write to. However, csv files **must follow a very precise structure**:\r\n```\r\n.\r\n+-- csv1.csv\r\n+-- csv2.csv\r\n+-- csv3.csv\r\n```\r\nwhere: \r\n1. the name of the root folder matches the name of the database file\r\n2. names of csv files match names of tables in the database files (ex. students.csv holds data for a table named students)\r\n\r\nAfter choosing this option the following appears:\r\n\r\n >>> Copy path to database: <provide/here/path/to/database.db>\r\n >>> Copy path to directory with csv files: <provide/path/to/a/folder/with/csv/files>\r\n >>> File [name_of_csv_file] processed successfully.\r\n >>> File [name_of_another_csv_file] processed successfully.\r\n >>> ... \r\n\r\n### \"stop\"\r\nstops the execution of the package.\r\n",
"bugtrack_url": null,
"license": "",
"summary": "A convenient tool for transferring files between SQLite database and csv files and vice versa.",
"version": "0.0.1",
"split_keywords": [
"csv",
"sqlite",
"converter"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "3b0a7660c27c3e3149a39395ac566488e2aeab0c7bf673581902d164ef0d9445",
"md5": "4128a77882bbf707e7c10553db25aa53",
"sha256": "9a12c44ebf341df1d64cfe2f76570be6c529fedb093e99a683c96bb2dd9d05f2"
},
"downloads": -1,
"filename": "csv_sqlite_converter-0.0.1-py3-none-any.whl",
"has_sig": false,
"md5_digest": "4128a77882bbf707e7c10553db25aa53",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.10",
"size": 9546,
"upload_time": "2023-03-26T07:24:32",
"upload_time_iso_8601": "2023-03-26T07:24:32.315453Z",
"url": "https://files.pythonhosted.org/packages/3b/0a/7660c27c3e3149a39395ac566488e2aeab0c7bf673581902d164ef0d9445/csv_sqlite_converter-0.0.1-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "bdcd2975095b2f108a99d1c15b963c74b4ceb3f0c8dc0fc08608b10aa120b691",
"md5": "62883f3b0c14118f712f66a39ff974ad",
"sha256": "9ab06e36596238c1c0e8deadc83d8c2c858c8c0eaefb2e1ad696e153ede75bd6"
},
"downloads": -1,
"filename": "csv-sqlite-converter-0.0.1.tar.gz",
"has_sig": false,
"md5_digest": "62883f3b0c14118f712f66a39ff974ad",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.10",
"size": 8521,
"upload_time": "2023-03-26T07:24:34",
"upload_time_iso_8601": "2023-03-26T07:24:34.923642Z",
"url": "https://files.pythonhosted.org/packages/bd/cd/2975095b2f108a99d1c15b963c74b4ceb3f0c8dc0fc08608b10aa120b691/csv-sqlite-converter-0.0.1.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-03-26 07:24:34",
"github": false,
"gitlab": false,
"bitbucket": false,
"lcname": "csv-sqlite-converter"
}
