Skip to content

Latest commit

 

History

History
38 lines (36 loc) · 1004 Bytes

README.md

File metadata and controls

38 lines (36 loc) · 1004 Bytes

books_data_collection

Collecting Authors + Books data as for Burmese literature records.

Create SQLite db for data backup

  • sql script to create table
create table books_data(book_id text,book_name text, book_price int, book_url text, book_header_name text, author_id text, author_name text, item_type text)

PSL Data

  • create old table
sql_create_books_data = """
    CREATE TABLE IF NOT EXISTS books_data(
        id integer PRIMARY KEY,
        name text NOT NULL,
        description text,
        book_url text,
        price real,
        currency_code text,
        avg_rating real,
        image_url text,
        categories text,
        author_id integer,
        author_name text,
        author_slug text,
        pages text,
        size text,
        records text,
        is_purchasable numeric,
        is_in_stock numeric,
        remaining text
    )
"""

List to do

  • create requirements.txt for the required libraries
  • another book site to scrape