Make DB of Dojinvoice
Project description
dojinvoice_db
- 同人音声 DB
動かす
$ pip install dojinvoice-db
$ dvdb
Download pages? >> (`y` or Enter)
<int> ids was committed work ids to existed db!
Now: ./dlsite/00001.html
Now: ./dlsite/00002.html
Now: ./dlsite/00003.html
...
注意: DB を一から構築するとかなり時間がかかります
スキーマ
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)
) '''
)
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
dojinvoice_db-0.3.tar.gz
(9.2 kB
view hashes)
Built Distribution
Close
Hashes for dojinvoice_db-0.3-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 662d2977bbc0c1ae33be79d82118a0ce7579325c34984224bd7aee3c8ed3ef63 |
|
MD5 | 1a677cd16c0c528c43776fb72255153e |
|
BLAKE2b-256 | 372aee7ac3ffeb178cdff4578f22051bc4ed2698f67a2725ae2dddba471d4aa3 |