| Name | db-build JSON |
| Version |
0.1
JSON |
| download |
| home_page | |
| Summary | Tools for building SQLite databases from files and directories |
| upload_time | 2023-08-15 01:50:47 |
| maintainer | |
| docs_url | None |
| author | Simon Willison |
| requires_python | |
| license | Apache-2.0 |
| keywords |
|
| VCS |
 |
| bugtrack_url |
|
| requirements |
No requirements were recorded.
|
| Travis-CI |
No Travis.
|
| coveralls test coverage |
No coveralls.
|
# db-build
[](https://pypi.org/project/db-build/)
[](https://github.com/simonw/db-build/releases)
[](https://github.com/simonw/db-build/actions?query=workflow%3ATest)
[](https://github.com/simonw/db-build/blob/main/LICENSE)
Tools for building SQLite databases from files and directories
## Installation
Install using `pip` or `pipx`:
```bash
pip install db-build
```
If you have `sqlite-utils` installed as well, this will act as a plugin and add a `sqlite-utils build` command.
## Usage
`db-build` can build databases from a number of different flat file formats.
It is always called with a SQLite database as the first argument, which can be a file that does not exist yet.
Any subsequent arguments will be treated as files or directories that should be loaded into that database.
A simple initial example, adding all CSV files in the current directory:
```bash
db-build data.db *.csv
```
## Development
To set up this plugin locally, first checkout the code. Then create a new virtual environment:
```bash
cd db-build
python3 -m venv venv
source venv/bin/activate
```
Now install the dependencies and test dependencies:
```bash
pip install -e '.[test]'
```
To run the tests:
```bash
pytest
```
Raw data
{
"_id": null,
"home_page": "",
"name": "db-build",
"maintainer": "",
"docs_url": null,
"requires_python": "",
"maintainer_email": "",
"keywords": "",
"author": "Simon Willison",
"author_email": "",
"download_url": "https://files.pythonhosted.org/packages/26/05/1ddda20f0ac17c749fb2ccf09338a5b6730654ae03c04bf7cbde55861cca/db-build-0.1.tar.gz",
"platform": null,
"description": "# db-build\n\n[](https://pypi.org/project/db-build/)\n[](https://github.com/simonw/db-build/releases)\n[](https://github.com/simonw/db-build/actions?query=workflow%3ATest)\n[](https://github.com/simonw/db-build/blob/main/LICENSE)\n\nTools for building SQLite databases from files and directories\n\n## Installation\n\nInstall using `pip` or `pipx`:\n```bash\npip install db-build\n```\nIf you have `sqlite-utils` installed as well, this will act as a plugin and add a `sqlite-utils build` command.\n\n## Usage\n\n`db-build` can build databases from a number of different flat file formats.\n\nIt is always called with a SQLite database as the first argument, which can be a file that does not exist yet.\n\nAny subsequent arguments will be treated as files or directories that should be loaded into that database.\n\nA simple initial example, adding all CSV files in the current directory:\n\n```bash\ndb-build data.db *.csv\n```\n\n## Development\n\nTo set up this plugin locally, first checkout the code. Then create a new virtual environment:\n```bash\ncd db-build\npython3 -m venv venv\nsource venv/bin/activate\n```\nNow install the dependencies and test dependencies:\n```bash\npip install -e '.[test]'\n```\nTo run the tests:\n```bash\npytest\n```\n",
"bugtrack_url": null,
"license": "Apache-2.0",
"summary": "Tools for building SQLite databases from files and directories",
"version": "0.1",
"project_urls": {
"CI": "https://github.com/simonw/db-buld/actions",
"Changelog": "https://github.com/simonw/db-buld/releases",
"Homepage": "https://github.com/simonw/db-buld",
"Issues": "https://github.com/simonw/db-buld/issues"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "3e9497981ddfec963d998cb8f9bb36498663f65c8d7688bc9f2929d69d51d7e4",
"md5": "668b23dbf93540b9da446ad9b68be059",
"sha256": "f94c5290719744a506f14cfcbb7ff28c1bf22140eefe43ac07eba4a27a494f59"
},
"downloads": -1,
"filename": "db_build-0.1-py3-none-any.whl",
"has_sig": false,
"md5_digest": "668b23dbf93540b9da446ad9b68be059",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": null,
"size": 3095,
"upload_time": "2023-08-15T01:50:46",
"upload_time_iso_8601": "2023-08-15T01:50:46.175085Z",
"url": "https://files.pythonhosted.org/packages/3e/94/97981ddfec963d998cb8f9bb36498663f65c8d7688bc9f2929d69d51d7e4/db_build-0.1-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "26051ddda20f0ac17c749fb2ccf09338a5b6730654ae03c04bf7cbde55861cca",
"md5": "04a8ed1fd820c30077f8055817f225a7",
"sha256": "dee5b26c92e31239ff5a7bfd2adfc7816063b880cba578f28e4c2b73c467e2db"
},
"downloads": -1,
"filename": "db-build-0.1.tar.gz",
"has_sig": false,
"md5_digest": "04a8ed1fd820c30077f8055817f225a7",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 2794,
"upload_time": "2023-08-15T01:50:47",
"upload_time_iso_8601": "2023-08-15T01:50:47.639929Z",
"url": "https://files.pythonhosted.org/packages/26/05/1ddda20f0ac17c749fb2ccf09338a5b6730654ae03c04bf7cbde55861cca/db-build-0.1.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-08-15 01:50:47",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "simonw",
"github_project": "db-buld",
"github_not_found": true,
"lcname": "db-build"
}
