User:Alexander Roidl/flask: Difference between revisions

From XPUB & Lens-Based wiki
No edit summary
 
(4 intermediate revisions by the same user not shown)
Line 2: Line 2:


==TO DO==
==TO DO==
* Make distributed character visible (how much is this book part of xpub / varia .... )
* <s>Make distributed character visible (how much is this book part of xpub / varia .... )</s>
** How much XPUB is this book |-x----------------------|
** <s>How much XPUB is this book     |-x----------------------|</s>
** How much is this book VARIA |------------------x-----|
** <s>How much is this book VARIA   |------------------x-----|</s>
* EX / IMPORT CSV
* <s>EX / IMPORT CSV</s>
* PDF to Text
* <s>PDF to Text</s>
* Chat more interactive with search? with Tash?
*<s> Chat more interactive with search? with Tash?</s>




Line 14: Line 14:
http://flask.pocoo.org
http://flask.pocoo.org
====RQLite====
====RQLite====
https://github.com/rqlite/rqlite
====SQLAlchemy====
====SQLAlchemy====
 
https://www.sqlalchemy.org/


= Further Development =
= Further Development =
Line 21: Line 22:
[[File:Screen Shot 2018-06-01 at 10.19.48.png|thumbnail]]
[[File:Screen Shot 2018-06-01 at 10.19.48.png|thumbnail]]


* Added chat with integration of socket io
* added »Newsticker« to top of page
* make main table sortable


= First Prototype =
= First Prototype =
Line 53: Line 57:
== Long To Do List (obviously) ==
== Long To Do List (obviously) ==


* much more properties for books
*<s> much more properties for books</s>
** multiple authors?
**<s> multiple authors?</s>
** description
**<s> description</s>
** date uploaded?
**<s> date uploaded?</s>
** ISBN
**<s> ISBN</s>
** MD5 to link books (more stable than db ID)
** MD5 to link books (more stable than db ID)
** Filetype (PDf, mobi, epub)
**<s> Filetype (PDf, mobi, epub)</s>
** Publisher
** Publisher
** Tags
**<s> Tags</s>
** Categories? (also important for infrastructure)
**<s> Categories? (also important for infrastructure)</s>
* Keep SQLite or python shelve?
*<s> Keep SQLite or python shelve? -> RQLITE</s>
* function to make stacks
*<s> function to make stacks</s>
* delete books from DB?
*<s> delete books from DB?</s>
* Coverimage from PDF / ebooks
*<s> Coverimage from PDF / ebooks</s>
** extract_cover.py <PDF file path> already done, but need to connect
**<s> extract_cover.py <PDF file path> already done, but need to connect</s>
* access to python scripts  
* access to python scripts  
** like: python add_book.py <path to file> <name> <properties …>
** like: python add_book.py <path to file> <name> <properties …>
* do we need users? (→ also conceptional question)
*<s> do we need users? (→ also conceptional question) -> NO USERS</s>
* Interface, Interface, Interface
*<s> Interface, Interface, Interface</s>
** search, links, categories, shelfs/stacks
**<s> search, links, categories, shelfs/stacks</s>
* API
*<s> API</s>
** make all that above accessible via RESTful API
**<s>make all that above accessible via RESTful API</s>
** add POST / PUT / DELETE (not sure how it works yet)
**<s> add POST / PUT / DELETE (not sure how it works yet)</s>
* Make Files only accessible via local network, but catalog online
* Make Files only accessible via local network, but catalog online

Latest revision as of 18:49, 9 June 2018

Development

TO DO

  • Make distributed character visible (how much is this book part of xpub / varia .... )
    • How much XPUB is this book |-x----------------------|
    • How much is this book VARIA |------------------x-----|
  • EX / IMPORT CSV
  • PDF to Text
  • Chat more interactive with search? with Tash?


Software

Flask

http://flask.pocoo.org

RQLite

https://github.com/rqlite/rqlite

SQLAlchemy

https://www.sqlalchemy.org/

Further Development

Screen Shot 2018-06-01 at 10.19.48.png
  • Added chat with integration of socket io
  • added »Newsticker« to top of page
  • make main table sortable

First Prototype

Screen Shot 2018-05-25 at 00.18.56.png

first version of lib (super super prototype)

http://37.139.6.124:8080/


with first API setup:

http://37.139.6.124:8080/api/books

{
  "books": [
    {
      "author": "Jan Tschichold", 
      "file": "The_Form_of_the_Book___Essays_on_the_Moral_-_Jan_Tschichold.pdf", 
      "id": 1, 
      "title": "The Form of the Book"
    }
  ]
}

Code on the git:

https://git.xpub.nl/xpub-lib/log.html

Long To Do List (obviously)

  • much more properties for books
    • multiple authors?
    • description
    • date uploaded?
    • ISBN
    • MD5 to link books (more stable than db ID)
    • Filetype (PDf, mobi, epub)
    • Publisher
    • Tags
    • Categories? (also important for infrastructure)
  • Keep SQLite or python shelve? -> RQLITE
  • function to make stacks
  • delete books from DB?
  • Coverimage from PDF / ebooks
    • extract_cover.py <PDF file path> already done, but need to connect
  • access to python scripts
    • like: python add_book.py <path to file> <name> <properties …>
  • do we need users? (→ also conceptional question) -> NO USERS
  • Interface, Interface, Interface
    • search, links, categories, shelfs/stacks
  • API
    • make all that above accessible via RESTful API
    • add POST / PUT / DELETE (not sure how it works yet)

  • Make Files only accessible via local network, but catalog online