README.md

doonroom_db

• A Building Tool for 同人音声の部屋 Unofficial DB
• Separate table for each category in DB
  • 同人音声 (Dojin Voice) and 催眠音声 (Hypno Voice)

Install

pip install doonroom-db

Build DB

$ ddb
Download pages? >> y
...

Log

log: issued sql statements are written

SQL Schema (SQLite3)

create table page {
  page_id integer,
  article_link text,
  post_date text,
  title text,
  body text,
  rating integer, -- `99` when the page is unrated
  category text,
  type text -- [dojin|hypno|other]
}
create table link {
  page_id integer,
  buy_link text,
  type text -- [dlsite|fanza|other]
}
create table tag {
  page_id integer,
  tag text
}
create table play {
  page_id integer,
  play text
}