doonroom_db

Install

pip install doonroom-db

Build DB

$ ddb
Download pages? >> y
...

Log

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
}