dojinvoice_db

PyPI version CI

DLSite Dojinvoice Database CLI

Install

# mise
mise use -g pipx:dojinvoice-db

# pipx
pipx install dojinvoice-db

# pip
pip install dojinvoice-db

CLI

dvdb crawl --full
dvdb crawl
dvdb details
dvdb refresh --stale-days 7
dvdb show RJ01234567
dvdb stats

dvdb crawl --sex-category male --sex-category female
dvdb crawl --work-type SOU --work-type MUS

Prebuilt database

The data workflow runs once a month (00:00 JST) and publishes a snapshot as dojinvoice.db.zip on a vX.Y.Z+YYYYMMDD release — the package version plus the JST run date. Each run restores the previous snapshot and only crawls what DLsite has published since, so the releases form a continuous history of one database.

gh release download --pattern dojinvoice.db.zip
unzip dojinvoice.db.zip
dvdb stats

Schema

Regenerate with mise run tbls.

Database schema (generated by tbls doc)

Description

SQLite database of DLsite doujin voice works

Tables

Name Columns Comment Type
work 25 table
work_stat 13 table
work_stat_history 8 table
work_creator 3 table
work_genre 2 table
work_file_format 2 table
work_event 2 table
work_sample_image 3 table
fetch_error 4 table
crawl_state 2 table
work_full 35 view

Relations

erDiagram

"work_stat" |o--o| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_stat_history" }o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_creator" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_genre" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_file_format" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_event" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_sample_image" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"

"work" {
  TEXT product_id PK
  TEXT site_id
  TEXT maker_id
  TEXT work_name
  TEXT work_name_masked
  INTEGER age_category
  TEXT work_type
  TEXT book_type
  TEXT work_image
  TEXT regist_date
  TEXT announce_date
  TEXT modified_date
  TEXT series
  TEXT circle
  TEXT brand
  TEXT publisher
  TEXT label
  TEXT description
  TEXT file_size
  INTEGER file_size_bytes
  INTEGER page_count
  TEXT work_url
  TEXT first_seen_at
  TEXT summary_fetched_at
  TEXT detail_fetched_at
}
"work_stat" {
  TEXT product_id PK
  INTEGER price
  INTEGER price_without_tax
  INTEGER official_price
  INTEGER discount_rate
  INTEGER dl_count
  INTEGER wishlist_count
  REAL rate_average
  INTEGER rate_count
  INTEGER review_count
  INTEGER is_sale
  INTEGER is_discount
  TEXT fetched_at
}
"work_stat_history" {
  TEXT product_id FK
  TEXT fetched_at
  INTEGER price
  INTEGER dl_count
  INTEGER wishlist_count
  REAL rate_average
  INTEGER rate_count
  INTEGER review_count
}
"work_creator" {
  TEXT product_id PK
  TEXT role PK
  TEXT name PK
}
"work_genre" {
  TEXT product_id PK
  TEXT genre PK
}
"work_file_format" {
  TEXT product_id PK
  TEXT file_format PK
}
"work_event" {
  TEXT product_id PK
  TEXT event PK
}
"work_sample_image" {
  TEXT product_id PK
  INTEGER idx PK
  TEXT url
}
"fetch_error" {
  TEXT product_id PK
  INTEGER attempts
  TEXT last_error
  TEXT last_attempt_at
}
"crawl_state" {
  TEXT key PK
  TEXT value
}
"work_full" {
  TEXT product_id
  TEXT site_id
  TEXT maker_id
  TEXT work_name
  TEXT work_name_masked
  INTEGER age_category
  TEXT work_type
  TEXT book_type
  TEXT work_image
  TEXT regist_date
  TEXT announce_date
  TEXT modified_date
  TEXT series
  TEXT circle
  TEXT brand
  TEXT publisher
  TEXT label
  TEXT description
  TEXT file_size
  INTEGER file_size_bytes
  INTEGER page_count
  TEXT work_url
  TEXT first_seen_at
  TEXT summary_fetched_at
  TEXT detail_fetched_at
  INTEGER price
  INTEGER dl_count
  INTEGER wishlist_count
  REAL rate_average
  INTEGER rate_count
  INTEGER review_count
   voice_actors
   scenarios
   illustrations
   genres
}

work

Description

Table Definition 
CREATE TABLE work (
    product_id         text primary key,
    site_id            text,
    maker_id           text,
    work_name          text not null,
    work_name_masked   text,
    age_category       integer,
    work_type          text,
    book_type          text,
    work_image         text,
    regist_date        text,
    announce_date      text,
    modified_date      text,
    series             text,
    circle             text,
    brand              text,
    publisher          text,
    label              text,
    description        text,
    file_size          text,
    file_size_bytes    integer,
    page_count         integer,
    work_url           text,
    first_seen_at      text not null,
    summary_fetched_at text,
    detail_fetched_at  text
)

Columns

Name Type Default Nullable Children Parents Comment
product_id TEXT true work_stat work_stat_history work_creator work_genre work_file_format work_event work_sample_image
site_id TEXT true
maker_id TEXT true
work_name TEXT false
work_name_masked TEXT true
age_category INTEGER true
work_type TEXT true
book_type TEXT true
work_image TEXT true
regist_date TEXT true
announce_date TEXT true
modified_date TEXT true
series TEXT true
circle TEXT true
brand TEXT true
publisher TEXT true
label TEXT true
description TEXT true
file_size TEXT true
file_size_bytes INTEGER true
page_count INTEGER true
work_url TEXT true
first_seen_at TEXT false
summary_fetched_at TEXT true
detail_fetched_at TEXT true

Constraints

Name Type Definition
product_id PRIMARY KEY PRIMARY KEY (product_id)
sqlite_autoindex_work_1 PRIMARY KEY PRIMARY KEY (product_id)

Indexes

Name Definition
work_detail_pending_idx CREATE INDEX work_detail_pending_idx on work (detail_fetched_at)
work_type_idx CREATE INDEX work_type_idx on work (work_type)
work_maker_idx CREATE INDEX work_maker_idx on work (maker_id)
work_regist_date_idx CREATE INDEX work_regist_date_idx on work (regist_date desc)
sqlite_autoindex_work_1 PRIMARY KEY (product_id)

Relations

erDiagram

"work_stat" |o--o| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_stat_history" }o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_creator" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_genre" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_file_format" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_event" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_sample_image" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"

"work" {
  TEXT product_id PK
  TEXT site_id
  TEXT maker_id
  TEXT work_name
  TEXT work_name_masked
  INTEGER age_category
  TEXT work_type
  TEXT book_type
  TEXT work_image
  TEXT regist_date
  TEXT announce_date
  TEXT modified_date
  TEXT series
  TEXT circle
  TEXT brand
  TEXT publisher
  TEXT label
  TEXT description
  TEXT file_size
  INTEGER file_size_bytes
  INTEGER page_count
  TEXT work_url
  TEXT first_seen_at
  TEXT summary_fetched_at
  TEXT detail_fetched_at
}
"work_stat" {
  TEXT product_id PK
  INTEGER price
  INTEGER price_without_tax
  INTEGER official_price
  INTEGER discount_rate
  INTEGER dl_count
  INTEGER wishlist_count
  REAL rate_average
  INTEGER rate_count
  INTEGER review_count
  INTEGER is_sale
  INTEGER is_discount
  TEXT fetched_at
}
"work_stat_history" {
  TEXT product_id FK
  TEXT fetched_at
  INTEGER price
  INTEGER dl_count
  INTEGER wishlist_count
  REAL rate_average
  INTEGER rate_count
  INTEGER review_count
}
"work_creator" {
  TEXT product_id PK
  TEXT role PK
  TEXT name PK
}
"work_genre" {
  TEXT product_id PK
  TEXT genre PK
}
"work_file_format" {
  TEXT product_id PK
  TEXT file_format PK
}
"work_event" {
  TEXT product_id PK
  TEXT event PK
}
"work_sample_image" {
  TEXT product_id PK
  INTEGER idx PK
  TEXT url
}

work_stat

Description

Table Definition 
CREATE TABLE work_stat (
    product_id        text primary key references work (product_id) on delete cascade,
    price             integer,
    price_without_tax integer,
    official_price    integer,
    discount_rate     integer,
    dl_count          integer,
    wishlist_count    integer,
    rate_average      real,
    rate_count        integer,
    review_count      integer,
    is_sale           integer,
    is_discount       integer,
    fetched_at        text not null
)

Columns

Name Type Default Nullable Children Parents Comment
product_id TEXT true work
price INTEGER true
price_without_tax INTEGER true
official_price INTEGER true
discount_rate INTEGER true
dl_count INTEGER true
wishlist_count INTEGER true
rate_average REAL true
rate_count INTEGER true
review_count INTEGER true
is_sale INTEGER true
is_discount INTEGER true
fetched_at TEXT false

Constraints

Name Type Definition
product_id PRIMARY KEY PRIMARY KEY (product_id)
- (Foreign key ID: 0) FOREIGN KEY FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE
sqlite_autoindex_work_stat_1 PRIMARY KEY PRIMARY KEY (product_id)

Indexes

Name Definition
sqlite_autoindex_work_stat_1 PRIMARY KEY (product_id)

Relations

erDiagram

"work_stat" |o--o| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_stat_history" }o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_creator" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_genre" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_file_format" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_event" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_sample_image" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"

"work_stat" {
  TEXT product_id PK
  INTEGER price
  INTEGER price_without_tax
  INTEGER official_price
  INTEGER discount_rate
  INTEGER dl_count
  INTEGER wishlist_count
  REAL rate_average
  INTEGER rate_count
  INTEGER review_count
  INTEGER is_sale
  INTEGER is_discount
  TEXT fetched_at
}
"work" {
  TEXT product_id PK
  TEXT site_id
  TEXT maker_id
  TEXT work_name
  TEXT work_name_masked
  INTEGER age_category
  TEXT work_type
  TEXT book_type
  TEXT work_image
  TEXT regist_date
  TEXT announce_date
  TEXT modified_date
  TEXT series
  TEXT circle
  TEXT brand
  TEXT publisher
  TEXT label
  TEXT description
  TEXT file_size
  INTEGER file_size_bytes
  INTEGER page_count
  TEXT work_url
  TEXT first_seen_at
  TEXT summary_fetched_at
  TEXT detail_fetched_at
}
"work_stat_history" {
  TEXT product_id FK
  TEXT fetched_at
  INTEGER price
  INTEGER dl_count
  INTEGER wishlist_count
  REAL rate_average
  INTEGER rate_count
  INTEGER review_count
}
"work_creator" {
  TEXT product_id PK
  TEXT role PK
  TEXT name PK
}
"work_genre" {
  TEXT product_id PK
  TEXT genre PK
}
"work_file_format" {
  TEXT product_id PK
  TEXT file_format PK
}
"work_event" {
  TEXT product_id PK
  TEXT event PK
}
"work_sample_image" {
  TEXT product_id PK
  INTEGER idx PK
  TEXT url
}

work_stat_history

Description

Table Definition 
CREATE TABLE work_stat_history (
    product_id     text not null references work (product_id) on delete cascade,
    fetched_at     text not null,
    price          integer,
    dl_count       integer,
    wishlist_count integer,
    rate_average   real,
    rate_count     integer,
    review_count   integer
)

Columns

Name Type Default Nullable Children Parents Comment
product_id TEXT false work
fetched_at TEXT false
price INTEGER true
dl_count INTEGER true
wishlist_count INTEGER true
rate_average REAL true
rate_count INTEGER true
review_count INTEGER true

Constraints

Name Type Definition
- (Foreign key ID: 0) FOREIGN KEY FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE

Indexes

Name Definition
work_stat_history_idx CREATE INDEX work_stat_history_idx on work_stat_history (product_id, fetched_at)

Relations

erDiagram

"work_stat_history" }o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_stat" |o--o| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_creator" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_genre" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_file_format" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_event" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_sample_image" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"

"work_stat_history" {
  TEXT product_id FK
  TEXT fetched_at
  INTEGER price
  INTEGER dl_count
  INTEGER wishlist_count
  REAL rate_average
  INTEGER rate_count
  INTEGER review_count
}
"work" {
  TEXT product_id PK
  TEXT site_id
  TEXT maker_id
  TEXT work_name
  TEXT work_name_masked
  INTEGER age_category
  TEXT work_type
  TEXT book_type
  TEXT work_image
  TEXT regist_date
  TEXT announce_date
  TEXT modified_date
  TEXT series
  TEXT circle
  TEXT brand
  TEXT publisher
  TEXT label
  TEXT description
  TEXT file_size
  INTEGER file_size_bytes
  INTEGER page_count
  TEXT work_url
  TEXT first_seen_at
  TEXT summary_fetched_at
  TEXT detail_fetched_at
}
"work_stat" {
  TEXT product_id PK
  INTEGER price
  INTEGER price_without_tax
  INTEGER official_price
  INTEGER discount_rate
  INTEGER dl_count
  INTEGER wishlist_count
  REAL rate_average
  INTEGER rate_count
  INTEGER review_count
  INTEGER is_sale
  INTEGER is_discount
  TEXT fetched_at
}
"work_creator" {
  TEXT product_id PK
  TEXT role PK
  TEXT name PK
}
"work_genre" {
  TEXT product_id PK
  TEXT genre PK
}
"work_file_format" {
  TEXT product_id PK
  TEXT file_format PK
}
"work_event" {
  TEXT product_id PK
  TEXT event PK
}
"work_sample_image" {
  TEXT product_id PK
  INTEGER idx PK
  TEXT url
}

work_creator

Description

Table Definition 
CREATE TABLE work_creator (
    product_id text not null references work (product_id) on delete cascade,
    role       text not null,
    name       text not null,
    primary key (product_id, role, name)
)

Columns

Name Type Default Nullable Children Parents Comment
product_id TEXT false work
role TEXT false
name TEXT false

Constraints

Name Type Definition
product_id PRIMARY KEY PRIMARY KEY (product_id)
role PRIMARY KEY PRIMARY KEY (role)
name PRIMARY KEY PRIMARY KEY (name)
- (Foreign key ID: 0) FOREIGN KEY FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE
sqlite_autoindex_work_creator_1 PRIMARY KEY PRIMARY KEY (product_id, role, name)

Indexes

Name Definition
work_creator_name_idx CREATE INDEX work_creator_name_idx on work_creator (name)
sqlite_autoindex_work_creator_1 PRIMARY KEY (product_id, role, name)

Relations

erDiagram

"work_creator" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_stat" |o--o| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_stat_history" }o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_genre" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_file_format" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_event" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_sample_image" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"

"work_creator" {
  TEXT product_id PK
  TEXT role PK
  TEXT name PK
}
"work" {
  TEXT product_id PK
  TEXT site_id
  TEXT maker_id
  TEXT work_name
  TEXT work_name_masked
  INTEGER age_category
  TEXT work_type
  TEXT book_type
  TEXT work_image
  TEXT regist_date
  TEXT announce_date
  TEXT modified_date
  TEXT series
  TEXT circle
  TEXT brand
  TEXT publisher
  TEXT label
  TEXT description
  TEXT file_size
  INTEGER file_size_bytes
  INTEGER page_count
  TEXT work_url
  TEXT first_seen_at
  TEXT summary_fetched_at
  TEXT detail_fetched_at
}
"work_stat" {
  TEXT product_id PK
  INTEGER price
  INTEGER price_without_tax
  INTEGER official_price
  INTEGER discount_rate
  INTEGER dl_count
  INTEGER wishlist_count
  REAL rate_average
  INTEGER rate_count
  INTEGER review_count
  INTEGER is_sale
  INTEGER is_discount
  TEXT fetched_at
}
"work_stat_history" {
  TEXT product_id FK
  TEXT fetched_at
  INTEGER price
  INTEGER dl_count
  INTEGER wishlist_count
  REAL rate_average
  INTEGER rate_count
  INTEGER review_count
}
"work_genre" {
  TEXT product_id PK
  TEXT genre PK
}
"work_file_format" {
  TEXT product_id PK
  TEXT file_format PK
}
"work_event" {
  TEXT product_id PK
  TEXT event PK
}
"work_sample_image" {
  TEXT product_id PK
  INTEGER idx PK
  TEXT url
}

work_genre

Description

Table Definition 
CREATE TABLE work_genre (
    product_id text not null references work (product_id) on delete cascade,
    genre      text not null,
    primary key (product_id, genre)
)

Columns

Name Type Default Nullable Children Parents Comment
product_id TEXT false work
genre TEXT false

Constraints

Name Type Definition
product_id PRIMARY KEY PRIMARY KEY (product_id)
genre PRIMARY KEY PRIMARY KEY (genre)
- (Foreign key ID: 0) FOREIGN KEY FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE
sqlite_autoindex_work_genre_1 PRIMARY KEY PRIMARY KEY (product_id, genre)

Indexes

Name Definition
work_genre_idx CREATE INDEX work_genre_idx on work_genre (genre)
sqlite_autoindex_work_genre_1 PRIMARY KEY (product_id, genre)

Relations

erDiagram

"work_genre" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_stat" |o--o| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_stat_history" }o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_creator" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_file_format" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_event" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_sample_image" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"

"work_genre" {
  TEXT product_id PK
  TEXT genre PK
}
"work" {
  TEXT product_id PK
  TEXT site_id
  TEXT maker_id
  TEXT work_name
  TEXT work_name_masked
  INTEGER age_category
  TEXT work_type
  TEXT book_type
  TEXT work_image
  TEXT regist_date
  TEXT announce_date
  TEXT modified_date
  TEXT series
  TEXT circle
  TEXT brand
  TEXT publisher
  TEXT label
  TEXT description
  TEXT file_size
  INTEGER file_size_bytes
  INTEGER page_count
  TEXT work_url
  TEXT first_seen_at
  TEXT summary_fetched_at
  TEXT detail_fetched_at
}
"work_stat" {
  TEXT product_id PK
  INTEGER price
  INTEGER price_without_tax
  INTEGER official_price
  INTEGER discount_rate
  INTEGER dl_count
  INTEGER wishlist_count
  REAL rate_average
  INTEGER rate_count
  INTEGER review_count
  INTEGER is_sale
  INTEGER is_discount
  TEXT fetched_at
}
"work_stat_history" {
  TEXT product_id FK
  TEXT fetched_at
  INTEGER price
  INTEGER dl_count
  INTEGER wishlist_count
  REAL rate_average
  INTEGER rate_count
  INTEGER review_count
}
"work_creator" {
  TEXT product_id PK
  TEXT role PK
  TEXT name PK
}
"work_file_format" {
  TEXT product_id PK
  TEXT file_format PK
}
"work_event" {
  TEXT product_id PK
  TEXT event PK
}
"work_sample_image" {
  TEXT product_id PK
  INTEGER idx PK
  TEXT url
}

work_file_format

Description

Table Definition 
CREATE TABLE work_file_format (
    product_id  text not null references work (product_id) on delete cascade,
    file_format text not null,
    primary key (product_id, file_format)
)

Columns

Name Type Default Nullable Children Parents Comment
product_id TEXT false work
file_format TEXT false

Constraints

Name Type Definition
product_id PRIMARY KEY PRIMARY KEY (product_id)
file_format PRIMARY KEY PRIMARY KEY (file_format)
- (Foreign key ID: 0) FOREIGN KEY FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE
sqlite_autoindex_work_file_format_1 PRIMARY KEY PRIMARY KEY (product_id, file_format)

Indexes

Name Definition
sqlite_autoindex_work_file_format_1 PRIMARY KEY (product_id, file_format)

Relations

erDiagram

"work_file_format" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_stat" |o--o| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_stat_history" }o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_creator" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_genre" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_event" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_sample_image" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"

"work_file_format" {
  TEXT product_id PK
  TEXT file_format PK
}
"work" {
  TEXT product_id PK
  TEXT site_id
  TEXT maker_id
  TEXT work_name
  TEXT work_name_masked
  INTEGER age_category
  TEXT work_type
  TEXT book_type
  TEXT work_image
  TEXT regist_date
  TEXT announce_date
  TEXT modified_date
  TEXT series
  TEXT circle
  TEXT brand
  TEXT publisher
  TEXT label
  TEXT description
  TEXT file_size
  INTEGER file_size_bytes
  INTEGER page_count
  TEXT work_url
  TEXT first_seen_at
  TEXT summary_fetched_at
  TEXT detail_fetched_at
}
"work_stat" {
  TEXT product_id PK
  INTEGER price
  INTEGER price_without_tax
  INTEGER official_price
  INTEGER discount_rate
  INTEGER dl_count
  INTEGER wishlist_count
  REAL rate_average
  INTEGER rate_count
  INTEGER review_count
  INTEGER is_sale
  INTEGER is_discount
  TEXT fetched_at
}
"work_stat_history" {
  TEXT product_id FK
  TEXT fetched_at
  INTEGER price
  INTEGER dl_count
  INTEGER wishlist_count
  REAL rate_average
  INTEGER rate_count
  INTEGER review_count
}
"work_creator" {
  TEXT product_id PK
  TEXT role PK
  TEXT name PK
}
"work_genre" {
  TEXT product_id PK
  TEXT genre PK
}
"work_event" {
  TEXT product_id PK
  TEXT event PK
}
"work_sample_image" {
  TEXT product_id PK
  INTEGER idx PK
  TEXT url
}

work_event

Description

Table Definition 
CREATE TABLE work_event (
    product_id text not null references work (product_id) on delete cascade,
    event      text not null,
    primary key (product_id, event)
)

Columns

Name Type Default Nullable Children Parents Comment
product_id TEXT false work
event TEXT false

Constraints

Name Type Definition
product_id PRIMARY KEY PRIMARY KEY (product_id)
event PRIMARY KEY PRIMARY KEY (event)
- (Foreign key ID: 0) FOREIGN KEY FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE
sqlite_autoindex_work_event_1 PRIMARY KEY PRIMARY KEY (product_id, event)

Indexes

Name Definition
sqlite_autoindex_work_event_1 PRIMARY KEY (product_id, event)

Relations

erDiagram

"work_event" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_stat" |o--o| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_stat_history" }o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_creator" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_genre" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_file_format" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_sample_image" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"

"work_event" {
  TEXT product_id PK
  TEXT event PK
}
"work" {
  TEXT product_id PK
  TEXT site_id
  TEXT maker_id
  TEXT work_name
  TEXT work_name_masked
  INTEGER age_category
  TEXT work_type
  TEXT book_type
  TEXT work_image
  TEXT regist_date
  TEXT announce_date
  TEXT modified_date
  TEXT series
  TEXT circle
  TEXT brand
  TEXT publisher
  TEXT label
  TEXT description
  TEXT file_size
  INTEGER file_size_bytes
  INTEGER page_count
  TEXT work_url
  TEXT first_seen_at
  TEXT summary_fetched_at
  TEXT detail_fetched_at
}
"work_stat" {
  TEXT product_id PK
  INTEGER price
  INTEGER price_without_tax
  INTEGER official_price
  INTEGER discount_rate
  INTEGER dl_count
  INTEGER wishlist_count
  REAL rate_average
  INTEGER rate_count
  INTEGER review_count
  INTEGER is_sale
  INTEGER is_discount
  TEXT fetched_at
}
"work_stat_history" {
  TEXT product_id FK
  TEXT fetched_at
  INTEGER price
  INTEGER dl_count
  INTEGER wishlist_count
  REAL rate_average
  INTEGER rate_count
  INTEGER review_count
}
"work_creator" {
  TEXT product_id PK
  TEXT role PK
  TEXT name PK
}
"work_genre" {
  TEXT product_id PK
  TEXT genre PK
}
"work_file_format" {
  TEXT product_id PK
  TEXT file_format PK
}
"work_sample_image" {
  TEXT product_id PK
  INTEGER idx PK
  TEXT url
}

work_sample_image

Description

Table Definition 
CREATE TABLE work_sample_image (
    product_id text not null references work (product_id) on delete cascade,
    idx        integer not null,
    url        text not null,
    primary key (product_id, idx)
)

Columns

Name Type Default Nullable Children Parents Comment
product_id TEXT false work
idx INTEGER false
url TEXT false

Constraints

Name Type Definition
product_id PRIMARY KEY PRIMARY KEY (product_id)
idx PRIMARY KEY PRIMARY KEY (idx)
- (Foreign key ID: 0) FOREIGN KEY FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE
sqlite_autoindex_work_sample_image_1 PRIMARY KEY PRIMARY KEY (product_id, idx)

Indexes

Name Definition
sqlite_autoindex_work_sample_image_1 PRIMARY KEY (product_id, idx)

Relations

erDiagram

"work_sample_image" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_stat" |o--o| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_stat_history" }o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_creator" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_genre" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_file_format" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"work_event" |o--|| "work" : "FOREIGN KEY (product_id) REFERENCES work (product_id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"

"work_sample_image" {
  TEXT product_id PK
  INTEGER idx PK
  TEXT url
}
"work" {
  TEXT product_id PK
  TEXT site_id
  TEXT maker_id
  TEXT work_name
  TEXT work_name_masked
  INTEGER age_category
  TEXT work_type
  TEXT book_type
  TEXT work_image
  TEXT regist_date
  TEXT announce_date
  TEXT modified_date
  TEXT series
  TEXT circle
  TEXT brand
  TEXT publisher
  TEXT label
  TEXT description
  TEXT file_size
  INTEGER file_size_bytes
  INTEGER page_count
  TEXT work_url
  TEXT first_seen_at
  TEXT summary_fetched_at
  TEXT detail_fetched_at
}
"work_stat" {
  TEXT product_id PK
  INTEGER price
  INTEGER price_without_tax
  INTEGER official_price
  INTEGER discount_rate
  INTEGER dl_count
  INTEGER wishlist_count
  REAL rate_average
  INTEGER rate_count
  INTEGER review_count
  INTEGER is_sale
  INTEGER is_discount
  TEXT fetched_at
}
"work_stat_history" {
  TEXT product_id FK
  TEXT fetched_at
  INTEGER price
  INTEGER dl_count
  INTEGER wishlist_count
  REAL rate_average
  INTEGER rate_count
  INTEGER review_count
}
"work_creator" {
  TEXT product_id PK
  TEXT role PK
  TEXT name PK
}
"work_genre" {
  TEXT product_id PK
  TEXT genre PK
}
"work_file_format" {
  TEXT product_id PK
  TEXT file_format PK
}
"work_event" {
  TEXT product_id PK
  TEXT event PK
}

fetch_error

Description

Table Definition 
CREATE TABLE fetch_error (
    product_id      text primary key,
    attempts        integer not null default 0,
    last_error      text,
    last_attempt_at text
)

Columns

Name Type Default Nullable Children Parents Comment
product_id TEXT true
attempts INTEGER 0 false
last_error TEXT true
last_attempt_at TEXT true

Constraints

Name Type Definition
product_id PRIMARY KEY PRIMARY KEY (product_id)
sqlite_autoindex_fetch_error_1 PRIMARY KEY PRIMARY KEY (product_id)

Indexes

Name Definition
sqlite_autoindex_fetch_error_1 PRIMARY KEY (product_id)

Relations

erDiagram


"fetch_error" {
  TEXT product_id PK
  INTEGER attempts
  TEXT last_error
  TEXT last_attempt_at
}

crawl_state

Description

Table Definition 
CREATE TABLE crawl_state (
    key   text primary key,
    value text
)

Columns

Name Type Default Nullable Children Parents Comment
key TEXT true
value TEXT true

Constraints

Name Type Definition
key PRIMARY KEY PRIMARY KEY (key)
sqlite_autoindex_crawl_state_1 PRIMARY KEY PRIMARY KEY (key)

Indexes

Name Definition
sqlite_autoindex_crawl_state_1 PRIMARY KEY (key)

Relations

erDiagram


"crawl_state" {
  TEXT key PK
  TEXT value
}

work_full

Description

Table Definition 
CREATE VIEW work_full as
select
    w.*,
    s.price,
    s.dl_count,
    s.wishlist_count,
    s.rate_average,
    s.rate_count,
    s.review_count,
    (select group_concat(c.name, ', ') from work_creator c
      where c.product_id = w.product_id and c.role = 'voice_actor') as voice_actors,
    (select group_concat(c.name, ', ') from work_creator c
      where c.product_id = w.product_id and c.role = 'scenario') as scenarios,
    (select group_concat(c.name, ', ') from work_creator c
      where c.product_id = w.product_id and c.role = 'illustration') as illustrations,
    (select group_concat(g.genre, ', ') from work_genre g
      where g.product_id = w.product_id) as genres
from work w
left join work_stat s on s.product_id = w.product_id

Columns

Name Type Default Nullable Children Parents Comment
product_id TEXT true
site_id TEXT true
maker_id TEXT true
work_name TEXT true
work_name_masked TEXT true
age_category INTEGER true
work_type TEXT true
book_type TEXT true
work_image TEXT true
regist_date TEXT true
announce_date TEXT true
modified_date TEXT true
series TEXT true
circle TEXT true
brand TEXT true
publisher TEXT true
label TEXT true
description TEXT true
file_size TEXT true
file_size_bytes INTEGER true
page_count INTEGER true
work_url TEXT true
first_seen_at TEXT true
summary_fetched_at TEXT true
detail_fetched_at TEXT true
price INTEGER true
dl_count INTEGER true
wishlist_count INTEGER true
rate_average REAL true
rate_count INTEGER true
review_count INTEGER true
voice_actors true
scenarios true
illustrations true
genres true

Referenced Tables

Name Columns Comment Type
work_creator 3 table
work_genre 2 table
work 25 table
work_stat 13 table

Relations

erDiagram


"work_full" {
  TEXT product_id
  TEXT site_id
  TEXT maker_id
  TEXT work_name
  TEXT work_name_masked
  INTEGER age_category
  TEXT work_type
  TEXT book_type
  TEXT work_image
  TEXT regist_date
  TEXT announce_date
  TEXT modified_date
  TEXT series
  TEXT circle
  TEXT brand
  TEXT publisher
  TEXT label
  TEXT description
  TEXT file_size
  INTEGER file_size_bytes
  INTEGER page_count
  TEXT work_url
  TEXT first_seen_at
  TEXT summary_fetched_at
  TEXT detail_fetched_at
  INTEGER price
  INTEGER dl_count
  INTEGER wishlist_count
  REAL rate_average
  INTEGER rate_count
  INTEGER review_count
   voice_actors
   scenarios
   illustrations
   genres
}

Project links

Data verified by PyPI on Aug 11, 2026
Data provided by the project maintainers, verified at the time the release was uploaded to PyPI.

Key dates

PyPI data
Data sourced directly from PyPI's database.
  • Released:
Latest release

1 maintainer

PyPI data
Data sourced directly from PyPI's database.
Avatar for eggplants from gravatar.com eggplants

Credits

Author: eggplants

GitHub Statistics

Data verified by PyPI on Aug 11, 2026
The GitHub source repository was provided by the project maintainers and verified by PyPI at the time of upload. Stars, forks, and open issues/PRs are derived from that repository and have not been independently verified.

License

MIT License (MIT)

Requires

Python >=3.11

Tags

asmr dlsite doujin sqlite

Classifiers

Report project as malware

Metadata

Project links

Data verified by PyPI on Aug 11, 2026
Data provided by the project maintainers, verified at the time the release was uploaded to PyPI.

Key dates

PyPI data
Data sourced directly from PyPI's database.
  • Released:
Latest release

1 maintainer

PyPI data
Data sourced directly from PyPI's database.
Avatar for eggplants from gravatar.com eggplants

Credits

Author: eggplants

GitHub Statistics

Data verified by PyPI on Aug 11, 2026
The GitHub source repository was provided by the project maintainers and verified by PyPI at the time of upload. Stars, forks, and open issues/PRs are derived from that repository and have not been independently verified.

License

MIT License (MIT)

Requires

Python >=3.11

Tags

asmr dlsite doujin sqlite

Classifiers

Report project as malware

Release files for dojinvoice-db 3.0.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for dojinvoice-db 3.0.0
File Size Uploaded
dojinvoice_db-3.0.0.tar.gz 25.6 kB Details

Built distribution (wheel)

Table of built distributions (wheels) for dojinvoice-db 3.0.0
File Interpreter ABI Platform
dojinvoice_db-3.0.0-py3-none-any.whl 27.0 kB Python 3 none any Details

Total release size: 52.5 kB

Release files / dojinvoice_db-3.0.0.tar.gz

Download URL dojinvoice_db-3.0.0.tar.gz
Size 25.6 kB
Tags Source
SHA-256 checksum
How to use checksums 		219ac76b3361be4ccd1bd5621d6c7eff6f79c0c903282a77504d346472b3a281
BLAKE2b-256 checksum
How to use checksums 		5eb57a3552337e884008bb91f22aecd4bd2413faeb99929f0d628b46b902cd8b
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing? 		Yes
Uploaded via uv/0.12.3 {"installer":{"name":"uv","version":"0.12.3","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}

Release files / dojinvoice_db-3.0.0-py3-none-any.whl

Download URL dojinvoice_db-3.0.0-py3-none-any.whl
Size 27.0 kB
Tags Python 3
SHA-256 checksum
How to use checksums 		15acde4702c3617c52b116e0ec1b9b81da00d6f3b30aa23668979659b55343af
BLAKE2b-256 checksum
How to use checksums 		e5be4fceb7de7dbe029a995d10bf2b9b21f7f0f8a594734817a8d2a89f7a359e
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing? 		Yes
Uploaded via uv/0.12.3 {"installer":{"name":"uv","version":"0.12.3","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}

Release history Release notifications | RSS feed

This release

3.0.0 This release

2 release files

2.1.1

2 release files

2.1.0

2 release files

2.0.1

2 release files

2.0.0

2 release files

1.1.0

2 release files

1.0.0

2 release files

0.7.0

2 release files

0.6.0

2 release files

0.5.1

2 release files

0.4

2 release files

0.3

2 release files

0.2

2 release files

0.1

2 release files

0.0.4

2 release files

0.0.3

2 release files

0.0.2

2 release files

0.0.1

2 release files

0.0.0

2 release files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page