Add flask code base

GeekMasher · web-flow · commit 59dc46d09739 · 2021-10-06T15:39:02.000Z
diff --git a/Pipfile b/Pipfile
@@ -0,0 +1,13 @@
+[[source]]
+url = "https://pypi.org/simple"
+verify_ssl = true
+name = "pypi"
+
+[packages]
+flask = "*"
+flask-sqlalchemy = "*"
+
+[dev-packages]
+
+[requires]
+python_version = "3.8"
diff --git a/Pipfile.lock b/Pipfile.lock
diff --git a/server/__init__.py b/server/__init__.py
diff --git a/server/__main__.py b/server/__main__.py
@@ -0,0 +1,25 @@
+import sys
+sys.path.append('.')
+
+from server.webapp import flaskapp, db, TEMPLATES
+from server.models import *
+from server.routes import *
+
+default_books = [
+    ("The Hobbit", "JRR Tolkien", True),
+    ("The Fellowship of the Ring", "JRR Tolkien", True),
+    ("The Eye of the World", "Robert Jordan", False),
+    ("A Game of Thrones", "George R. R. Martin", True),
+    ("The Way of Kings", "Brandon Sanderson", False)
+]
+
+
+if __name__ == "__main__":
+    for bookname, bookauthor, hasread in default_books:
+        if not Book.query.filter_by(name=bookname).first():
+            book = Book(name=bookname, author=bookauthor, read=hasread)
+            db.session.add(book)
+            db.session.commit()
+
+    db.create_all()
+    flaskapp.run('0.0.0.0', debug=True)
diff --git a/server/models/__init__.py b/server/models/__init__.py
@@ -0,0 +1,2 @@
+
+from server.models.books import Book
diff --git a/server/models/books.py b/server/models/books.py
@@ -0,0 +1,10 @@
+
+from server.webapp import db
+
+
+class Book(db.Model):
+    id = db.Column(db.Integer, primary_key=True)
+    name = db.Column(db.String(128), unique=False, nullable=False)
+    author = db.Column(db.String(128), unique=False, nullable=False)
+
+    read = db.Column(db.Boolean(), unique=False, nullable=False)
diff --git a/server/routes.py b/server/routes.py
@@ -0,0 +1,31 @@
+
+from flask import request, render_template, make_response
+
+from server.webapp import flaskapp, db
+from server.models import Book
+
+
+@flaskapp.route('/')
+def index():
+    name = request.args.get('name')
+    author = request.args.get('author')
+    read = bool(request.args.get('read'))
+
+    if name:
+        result = db.engine.execute(
+            "SELECT * FROM Book WHERE name LIKE '%" + name + "%'"
+        )
+        books = [row for row in result]
+        if len(books) == 0:
+            return make_response(f"Search Result not found: {name}", 404)
+    elif author:
+        result = db.engine.execute(
+            "SELECT * FROM Book WHERE author LIKE '%" + author + "%'"
+        )
+        books = [row for row in result]
+        if len(books) == 0:
+            return make_response(f"Search Result not found: {author}", 404)
+    else:
+        books = Book.query.all()
+    
+    return render_template('books.html', books=books)
diff --git a/server/webapp.py b/server/webapp.py
@@ -0,0 +1,13 @@
+import os
+
+from flask import Flask
+from flask_sqlalchemy import SQLAlchemy
+
+ROOT = os.path.dirname(os.path.abspath(os.path.dirname(__file__)))
+TEMPLATES = os.path.join(ROOT, 'templates')
+
+flaskapp = Flask("BookStore", template_folder=TEMPLATES)
+flaskapp.config['SQLALCHEMY_DATABASE_URI'] = os.environ.get('SQLITE_URI', 'sqlite:////tmp/test.db')
+flaskapp.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
+
+db = SQLAlchemy(flaskapp)
diff --git a/templates/books.html b/templates/books.html
@@ -0,0 +1,14 @@
+<!DOCTYPE html>
+<html lang="en">
+<head>
+    <title>Book Store</title>
+</head>
+<body>
+    <h1>Book Store</h1>
+    <ul id="books">
+    {% for book in books %}
+        <li>{{ book.name }} by {{ book.author }}</li>
+    {% endfor %}
+    </ul>
+</body>
+</html>

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+`
	`2`	`+from server.models.books import Book`