# dojinvoice_db
[![Release Package](
<https://github.com/eggplants/dojinvoice_db/workflows/Release%20Package/badge.svg>
)](
<https://github.com/eggplants/dojinvoice_db/actions/runs/355419760>
) [![pre-commit.ci status](
<https://results.pre-commit.ci/badge/github/eggplants/dojinvoice_db/main.svg>
)](
<https://results.pre-commit.ci/latest/github/eggplants/dojinvoice_db/main>
)
[![PyPI version](
<https://badge.fury.io/py/dojinvoice-db.svg>
)](
<https://badge.fury.io/py/dojinvoice_db>
) [![Maintainability](
<https://api.codeclimate.com/v1/badges/f9942612576bc3a99dbd/maintainability>
)](
<https://codeclimate.com/github/eggplants/dojinvoice_db/maintainability>
) [![MIT License](
<http://img.shields.io/badge/license-MIT-blue.svg?style=flat>
)](LICENSE)
Dojinvoice (同人音声) DB
- DLsite
- <https://www.dlsite.com/maniax/works/voice>
## How to run
```bash
pip install dojinvoice-db
```
```shellsession
$ dvdb
Download pages? >> (`y` or Enter)
<int> work(s) have already been committed to existing db!
Now: ./dlsite/00001.html
Now: ./dlsite/00002.html
Now: ./dlsite/00003.html
...
```
## DB Schema
```python
create_table(
'''work (
work_id text primary key,
detail_link text not null,
title text not null,
circle text not null,
circle_link text not null,
category text not null,
sale_date integer not null,
age_zone text not null,
file_format text not null,
file_size text not null,
description str not null,
monopoly integer not null,
price integer not null
) '''
)
create_table(
'''option (
work_id text primary key,
thumbnail text,
cien_link text,
series text,
chobit_link text,
sales integer,
favorites integer,
trial_link text,
trial_size integer,
rating real
) '''
)
create_table(
'''writer (
work_id text,
writer text,
primary key (work_id, writer)
) '''
)
create_table(
'''scenario (
work_id text,
scenario text,
primary key (work_id, scenario)
) '''
)
create_table(
'''illustrator (
work_id text,
illustrator text,
primary key (work_id, illustrator)
) '''
)
create_table(
'''voice (
work_id text,
voice text,
primary key (work_id, voice)
) '''
)
create_table(
'''musician (
work_id text,
musician text,
primary key (work_id, musician)
) '''
)
create_table(
'''genre (
work_id text,
genre text,
primary key (work_id, genre)
) '''
)
```
Raw data
{
"_id": null,
"home_page": "https://github.com/eggplants/dojinvoice_db",
"name": "dojinvoice_db",
"maintainer": null,
"docs_url": null,
"requires_python": "<4.0,>=3.12",
"maintainer_email": null,
"keywords": "selenium, dlsite",
"author": "eggplants",
"author_email": "w10776e8w@yahoo.co.jp",
"download_url": "https://files.pythonhosted.org/packages/8a/5e/35f1d63a7bee7a5af0f64165547301bf704782bcf08e16fd77997bc0cf47/dojinvoice_db-2.0.0.tar.gz",
"platform": null,
"description": "# dojinvoice_db\n\n[![Release Package](\n <https://github.com/eggplants/dojinvoice_db/workflows/Release%20Package/badge.svg>\n)](\n <https://github.com/eggplants/dojinvoice_db/actions/runs/355419760>\n) [![pre-commit.ci status](\n <https://results.pre-commit.ci/badge/github/eggplants/dojinvoice_db/main.svg>\n)](\n <https://results.pre-commit.ci/latest/github/eggplants/dojinvoice_db/main>\n)\n\n[![PyPI version](\n <https://badge.fury.io/py/dojinvoice-db.svg>\n)](\n <https://badge.fury.io/py/dojinvoice_db>\n) [![Maintainability](\n <https://api.codeclimate.com/v1/badges/f9942612576bc3a99dbd/maintainability>\n)](\n <https://codeclimate.com/github/eggplants/dojinvoice_db/maintainability>\n) [![MIT License](\n <http://img.shields.io/badge/license-MIT-blue.svg?style=flat>\n)](LICENSE)\n\nDojinvoice (\u540c\u4eba\u97f3\u58f0) DB\n\n- DLsite\n - <https://www.dlsite.com/maniax/works/voice>\n\n## How to run\n\n```bash\npip install dojinvoice-db\n```\n\n```shellsession\n$ dvdb\nDownload pages? >> (`y` or Enter)\n<int> work(s) have already been committed to existing db!\nNow: ./dlsite/00001.html\nNow: ./dlsite/00002.html\nNow: ./dlsite/00003.html\n...\n```\n\n## DB Schema\n\n```python\ncreate_table(\n '''work (\n work_id text primary key,\n detail_link text not null,\n title text not null,\n circle text not null,\n circle_link text not null,\n category text not null,\n sale_date integer not null,\n age_zone text not null,\n file_format text not null,\n file_size text not null,\n description str not null,\n monopoly integer not null,\n price integer not null\n ) '''\n)\ncreate_table(\n '''option (\n work_id text primary key,\n thumbnail text,\n cien_link text,\n series text,\n chobit_link text,\n sales integer,\n favorites integer,\n trial_link text,\n trial_size integer,\n rating real\n ) '''\n)\ncreate_table(\n '''writer (\n work_id text,\n writer text,\n primary key (work_id, writer)\n ) '''\n)\ncreate_table(\n '''scenario (\n work_id text,\n scenario text,\n primary key (work_id, scenario)\n ) '''\n)\ncreate_table(\n '''illustrator (\n work_id text,\n illustrator text,\n primary key (work_id, illustrator)\n ) '''\n)\ncreate_table(\n '''voice (\n work_id text,\n voice text,\n primary key (work_id, voice)\n ) '''\n)\ncreate_table(\n '''musician (\n work_id text,\n musician text,\n primary key (work_id, musician)\n ) '''\n)\ncreate_table(\n '''genre (\n work_id text,\n genre text,\n primary key (work_id, genre)\n ) '''\n)\n```\n",
"bugtrack_url": null,
"license": "MIT",
"summary": "Make DB of Dojinvoice",
"version": "2.0.0",
"project_urls": {
"Homepage": "https://github.com/eggplants/dojinvoice_db",
"Repository": "https://github.com/eggplants/dojinvoice_db"
},
"split_keywords": [
"selenium",
" dlsite"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "63b3912c4b30cbb0febfe91fbd8e3b097e4636c44219f68cdf8a7777fed03717",
"md5": "82688d85c6408abb63b7c9643dcf4f50",
"sha256": "d78da4bd52d05839fc42d116130a043b2cce677739876420e3dbd819da7cd922"
},
"downloads": -1,
"filename": "dojinvoice_db-2.0.0-py3-none-any.whl",
"has_sig": false,
"md5_digest": "82688d85c6408abb63b7c9643dcf4f50",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": "<4.0,>=3.12",
"size": 10828,
"upload_time": "2024-12-10T01:50:04",
"upload_time_iso_8601": "2024-12-10T01:50:04.075800Z",
"url": "https://files.pythonhosted.org/packages/63/b3/912c4b30cbb0febfe91fbd8e3b097e4636c44219f68cdf8a7777fed03717/dojinvoice_db-2.0.0-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "8a5e35f1d63a7bee7a5af0f64165547301bf704782bcf08e16fd77997bc0cf47",
"md5": "0ac59a1535a4207ad588a0a817716211",
"sha256": "7022333eba6ea3db3bf997776158c0979d1e15e2ff29a87d6bb2638360c61e76"
},
"downloads": -1,
"filename": "dojinvoice_db-2.0.0.tar.gz",
"has_sig": false,
"md5_digest": "0ac59a1535a4207ad588a0a817716211",
"packagetype": "sdist",
"python_version": "source",
"requires_python": "<4.0,>=3.12",
"size": 9667,
"upload_time": "2024-12-10T01:50:05",
"upload_time_iso_8601": "2024-12-10T01:50:05.066975Z",
"url": "https://files.pythonhosted.org/packages/8a/5e/35f1d63a7bee7a5af0f64165547301bf704782bcf08e16fd77997bc0cf47/dojinvoice_db-2.0.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-12-10 01:50:05",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "eggplants",
"github_project": "dojinvoice_db",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "dojinvoice_db"
}