Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit307e485

Browse files
authored
Merge pull requestx4nth055#103 from EzzEddin/frontend-crud-flask-sqlalchemy-app
Add the frontend of the Flask SQLAlchemy CRUD app tutorial
2 parentsa86f6c4 +2c93f3b commit307e485

File tree

13 files changed

+402
-0
lines changed

13 files changed

+402
-0
lines changed
Lines changed: 20 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,20 @@
1+
The MIT License (MIT)
2+
3+
Copyright (c) 2022 Ezzeddin Abdullah
4+
5+
Permission is hereby granted, free of charge, to any person obtaining a copy of
6+
this software and associated documentation files (the "Software"), to deal in
7+
the Software without restriction, including without limitation the rights to
8+
use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of
9+
the Software, and to permit persons to whom the Software is furnished to do so,
10+
subject to the following conditions:
11+
12+
The above copyright notice and this permission notice shall be included in all
13+
copies or substantial portions of the Software.
14+
15+
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
16+
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS
17+
FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR
18+
COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER
19+
IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN
20+
CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Lines changed: 12 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,12 @@
1+
#Fullstack Bookshop CRUD app using MySQL with Flask and SQLAlchemy
2+
3+
##Quick start
4+
```bash
5+
$ python3 -m venv venv
6+
$. venv/bin/activate
7+
$ pip install --upgrade pip
8+
$ pip install -r requirements.txt
9+
$cd fullstack_crud_flask_sqlalchemy
10+
$export FLASK_APP=bookshop.py
11+
$ flask run
12+
```
Lines changed: 17 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,17 @@
1+
fromflaskimportFlask
2+
fromflask_sqlalchemyimportSQLAlchemy
3+
fromflask_bootstrapimportBootstrap
4+
fromconfigimportconfig
5+
6+
db=SQLAlchemy()
7+
bootstrap=Bootstrap()
8+
9+
10+
defcreate_app(config_name):
11+
app=Flask(__name__)
12+
app.config.from_object(config[config_name])
13+
config[config_name].init_app(app)
14+
15+
bootstrap.init_app(app)
16+
db.init_app(app)
17+
returnapp
Lines changed: 17 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,17 @@
1+
from .importdb
2+
3+
4+
classBook(db.Model):
5+
__tablename__='books'
6+
isbn=db.Column(db.Integer,primary_key=True)
7+
author=db.Column(db.String(100),nullable=False)
8+
title=db.Column(db.String(100),nullable=False)
9+
price=db.Column(db.Float)
10+
11+
defto_json(self):
12+
return {
13+
'isbn':self.isbn,
14+
'author':self.author,
15+
'title':self.title,
16+
'price':self.price
17+
}
Lines changed: 65 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,65 @@
1+
importos
2+
from .importcreate_app
3+
from .modelsimportBook
4+
from .importdb
5+
fromflaskimportjsonify,redirect,request,abort,render_template,url_for
6+
7+
app=create_app(os.getenv('FLASK_CONFIG')or'default')
8+
9+
10+
@app.route("/")
11+
defindex():
12+
books=Book.query.all()
13+
returnrender_template("index.html",books=books)
14+
15+
16+
@app.route("/book/list",methods=["GET"])
17+
defget_books():
18+
books=Book.query.all()
19+
returnjsonify([book.to_json()forbookinbooks])
20+
21+
22+
@app.route("/book/<int:isbn>",methods=["GET"])
23+
defget_book(isbn):
24+
book=Book.query.get(isbn)
25+
ifbookisNone:
26+
abort(404)
27+
returnrender_template("book.html",isbn=isbn)
28+
29+
30+
@app.route("/delete/<int:isbn>",methods=["POST"])
31+
defdelete(isbn):
32+
book=Book.query.get(isbn)
33+
ifbookisNone:
34+
abort(404)
35+
db.session.delete(book)
36+
db.session.commit()
37+
returnredirect(url_for("index"))
38+
39+
40+
@app.route('/add_book/',methods=['POST'])
41+
defadd_book():
42+
ifnotrequest.form:
43+
abort(400)
44+
book=Book(
45+
title=request.form.get('title'),
46+
author=request.form.get('author'),
47+
price=request.form.get('price')
48+
)
49+
db.session.add(book)
50+
db.session.commit()
51+
returnredirect(url_for("index"))
52+
53+
54+
@app.route('/update_book/<int:isbn>',methods=['POST'])
55+
defupdate_book(isbn):
56+
ifnotrequest.form:
57+
abort(400)
58+
book=Book.query.get(isbn)
59+
ifbookisNone:
60+
abort(404)
61+
book.title=request.form.get('title',book.title)
62+
book.author=request.form.get('author',book.author)
63+
book.price=request.form.get('price',book.price)
64+
db.session.commit()
65+
returnredirect(url_for("index"))
Lines changed: 12 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,12 @@
1+
body {
2+
padding-top:50px;
3+
}
4+
5+
.starter-template {
6+
padding:40px15px;
7+
text-align: center;
8+
}
9+
10+
td,th {
11+
text-align: center
12+
}
Lines changed: 36 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,36 @@
1+
{% extends "bootstrap/base.html" %}
2+
3+
{% block title %}Bookshop{% endblock %}
4+
5+
{% block head %}
6+
{{ super() }}
7+
<linkrel="stylesheet"href="{{ url_for('static', filename='main.css') }}">
8+
{% endblock %}
9+
{% block navbar %}
10+
11+
<navclass="navbar navbar-inverse navbar-fixed-top">
12+
<divclass="container">
13+
<divclass="navbar-header">
14+
<buttontype="button"class="navbar-toggle collapsed"data-toggle="collapse"data-target="#navbar"
15+
aria-expanded="false"aria-controls="navbar">
16+
<spanclass="sr-only">Toggle navigation</span>
17+
<spanclass="icon-bar"></span>
18+
<spanclass="icon-bar"></span>
19+
<spanclass="icon-bar"></span>
20+
</button>
21+
<aclass="navbar-brand"href="/">Bookshop</a>
22+
</div>
23+
<divid="navbar"class="collapse navbar-collapse">
24+
<ulclass="nav navbar-nav">
25+
<liclass="active"><ahref="/">Home</a></li>
26+
</ul>
27+
</div>
28+
</div>
29+
</nav>
30+
{% endblock %}
31+
32+
{% block content %}
33+
<divclass="container">
34+
{% block page_content %} {% endblock %}
35+
</div>
36+
{% endblock %}
Lines changed: 7 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,7 @@
1+
{% extends "base.html" %}
2+
3+
{% block page_content %}
4+
<divclass="starter-template">
5+
<h1>Book's ISBN: {{ isbn }}</h1>
6+
</div>
7+
{% endblock %}
Lines changed: 7 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,7 @@
1+
{% extends "base.html" %}
2+
3+
{% block page_content %}
4+
<divclass="starter-template">
5+
<buttontype="button"class="btn btn-lg btn-primary">Add a book</button>
6+
</div>
7+
{% endblock %}
Lines changed: 154 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,154 @@
1+
{% extends "base.html" %}
2+
3+
{% block page_content %}
4+
<divclass="starter-template">
5+
<h1>Welcome to our bookshop!</h1>
6+
</div>
7+
<buttontype="button"data-toggle="modal"class="btn btn-lg btn-primary"data-target="#insert_book">Add a book</button>
8+
9+
<!-- Modal 1 for adding a book -->
10+
<divclass="modal fade"id="insert_book"tabindex="-1"role="dialog"aria-labelledby="basicModal"aria-hidden="true">
11+
<divclass="modal-dialog">
12+
<divclass="modal-content">
13+
<divclass="modal-header">
14+
<buttontype="button"class="close"data-dismiss="modal"aria-hidden="true">&times;</button>
15+
<h4class="modal-title"id="myModalLabel">Add a book</h4>
16+
</div>
17+
<formaction="{{url_for('add_book')}}"method="post">
18+
<divclass="modal-body">
19+
<divclass="form-group row">
20+
<labelfor="author"class="col-xs-2 control-label">Author</label>
21+
<divclass="col-xs-10">
22+
<inputtype="text"id="author"class="form-control"name="author"placeholder="Author"/>
23+
</div>
24+
</div>
25+
<divclass="form-group row">
26+
<labelfor="author"class="col-xs-2 control-label">Title</label>
27+
<divclass="col-xs-10">
28+
<inputtype="text"class="form-control"name="title"placeholder="Title"/>
29+
</div>
30+
</div>
31+
<divclass="form-group row">
32+
<labelfor="author"class="col-xs-2 control-label">Price</label>
33+
<divclass="col-xs-10">
34+
<inputtype="number"class="form-control"name="price"placeholder="Price"/>
35+
</div>
36+
</div>
37+
</div>
38+
<divclass="modal-footer">
39+
<buttontype="button"class="btn btn-default"data-dismiss="modal">Close</button>
40+
<buttontype="submit"class="btn btn-success">Submit</button>
41+
</div>
42+
</form>
43+
</div>
44+
</div>
45+
</div>
46+
<!-- End Modal 1 -->
47+
48+
<divclass="row">
49+
<divclass="col-md-6">
50+
<tableclass="table"border="1">
51+
<thead>
52+
<tr>
53+
<th>ISBN</th>
54+
<th>Author</th>
55+
<th>Title</th>
56+
<th>Price</th>
57+
<thcolspan="2">Action</th>
58+
</tr>
59+
</thead>
60+
<tbody>
61+
{% for book in books %}
62+
<tr>
63+
<td>{{ book.isbn }}</td>
64+
<td>{{ book.author }}</td>
65+
<td>{{ book.title }}</td>
66+
<td>{{ book.price }}</td>
67+
<td><buttontype="button"class="btn btn-success"data-toggle="modal"
68+
data-target="#update_book_{{book['isbn']}}">Update</button></td>
69+
70+
71+
<!-- Modal 2 for updating a book -->
72+
<divclass="modal fade"id="update_book_{{book['isbn']}}"tabindex="-1"role="dialog"
73+
aria-labelledby="basicModal"aria-hidden="true">
74+
<divclass="modal-dialog">
75+
<divclass="modal-content">
76+
<divclass="modal-header">
77+
<buttontype="button"class="close"data-dismiss="modal"
78+
aria-hidden="true">&times;</button>
79+
<h4class="modal-title"id="myModalLabel">Update a book</h4>
80+
</div>
81+
<formaction="{{url_for('update_book', isbn=book['isbn'])}}"method="post">
82+
<divclass="modal-body">
83+
<divclass="form-group row">
84+
<labelfor="author"class="col-xs-2 control-label">Author</label>
85+
<divclass="col-xs-10">
86+
<inputtype="text"id="author"class="form-control"name="author"
87+
value="{{book['author']}}"/>
88+
</div>
89+
</div>
90+
<divclass="form-group row">
91+
<labelfor="author"class="col-xs-2 control-label">Title</label>
92+
<divclass="col-xs-10">
93+
<inputtype="text"class="form-control"name="title"
94+
value="{{book['title']}}"/>
95+
</div>
96+
</div>
97+
<divclass="form-group row">
98+
<labelfor="author"class="col-xs-2 control-label">Price</label>
99+
<divclass="col-xs-10">
100+
<inputtype="number"class="form-control"name="price"
101+
value="{{book['price']}}"/>
102+
</div>
103+
</div>
104+
</div>
105+
<divclass="modal-footer">
106+
<buttontype="button"class="btn btn-default"
107+
data-dismiss="modal">Close</button>
108+
<buttontype="submit"class="btn btn-success">Submit</button>
109+
</div>
110+
</form>
111+
</div>
112+
</div>
113+
</div>
114+
<!-- End Modal 2 -->
115+
<td><buttontype="button"class="btn btn-danger"data-toggle="modal"
116+
data-target="#delete_book_{{book['isbn']}}">Delete</button></td>
117+
118+
119+
<!-- Modal 3 for deleting a book -->
120+
<divclass="modal fade"id="delete_book_{{book['isbn']}}"tabindex="-1"role="dialog"
121+
aria-labelledby="basicModal"aria-hidden="true">
122+
<divclass="modal-dialog">
123+
<divclass="modal-content">
124+
<divclass="modal-header">
125+
<buttontype="button"class="close"data-dismiss="modal"
126+
aria-hidden="true">&times;</button>
127+
<h4class="modal-title"id="myModalLabel">Delete a book</h4>
128+
</div>
129+
<formaction="{{url_for('delete', isbn=book['isbn'])}}"method="post">
130+
<divclass="modal-body">
131+
<divclass="form-group row">
132+
<labelclass="col-sm-12 col-form-label">Do you want to delete the book<span
133+
style='font-weight:bold;color:red'>{{book['title']}}</span>
134+
?</label>
135+
136+
</div>
137+
</div>
138+
<divclass="modal-footer">
139+
<buttontype="button"class="btn btn-default"
140+
data-dismiss="modal">Close</button>
141+
<buttontype="submit"class="btn btn-danger">Delete</button>
142+
</div>
143+
</form>
144+
</div>
145+
</div>
146+
</div>
147+
<!-- End Modal 3-->
148+
</tr>
149+
{% endfor %}
150+
</tbody>
151+
</table>
152+
</div>
153+
</div>
154+
{% endblock %}
Lines changed: 8 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,8 @@
1+
fromappimportdb
2+
fromapp.routesimportapp
3+
fromapp.modelsimportBook
4+
5+
6+
@app.shell_context_processor
7+
defmake_shell_context():
8+
returndict(db=db,Book=Book)

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp