-
Notifications
You must be signed in to change notification settings - Fork 0
/
database_crud.py
89 lines (74 loc) · 2.8 KB
/
database_crud.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
from flask import Flask,render_template,request,redirect
from flask_sqlalchemy import SQLAlchemy
from datetime import datetime
app=Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI']='sqlite:///posts.db'
db=SQLAlchemy(app)
class PersonalInfo(db.Model):
id=db.Column(db.Integer,primary_key=True)
name=db.Column(db.String(100),nullable=False)
lastname=db.Column(db.String(100),nullable=True)
hobby=db.Column(db.Text,nullable=False,default='N/A')
data_posted=db.Column(db.DateTime,nullable=False,default=datetime.utcnow)
def __repr__(self):
return "Personal Info "+ str(self.id)
@app.route('/')
def index():
return render_template('index.html')
#CREATE AND ADD TO THE DATABASE
@app.route('/posts',methods=['GET','POST'])
def posts():
print(request.method)
if request.method=='POST':
post_name=request.form['name']
post_lastname=request.form['lastname']
post_hobby=request.form['hobby']
new_info = PersonalInfo(name=post_name,lastname=post_lastname,hobby=post_hobby)
print(new_info)
db.session.add(new_info)
db.session.commit()
return redirect('/posts')
else:
all_post=PersonalInfo.query.order_by(PersonalInfo.data_posted).all()
#print(all_post)
return render_template('post.html',post=all_post)
@app.route('/posts/delete/<int:id>')
def delete(id):
post_id=PersonalInfo.query.get_or_404(id)
db.session.delete(post_id)
db.session.commit()
return redirect('/posts')
@app.route('/posts/edit/<int:id>',methods=['GET','POST'])
def edit(id):
post_id=PersonalInfo.query.get_or_404(id)
if request.method=='POST':
post_id.name=request.form['name']
post_id.lastname=request.form['lastname']
post_id.hobby=request.form['hobby']
#new_info = PersonalInfo(name=post_name,lastname=post_lastname,hobby=post_hobby)
# print(new_info)
#db.session.add(new_info)
#db.session.commit()
db.session.commit()
return redirect('/posts')
else:
#all_post=PersonalInfo.query.order_by(PersonalInfo.data_posted).all()
#print(all_post)
return render_template('edit.html',post=post_id)
@app.route('/posts/new',methods=['GET','POST'])
def new_post():
if request.method=='POST':
post_name=request.form['name']
post_lastname=request.form['lastname']
post_hobby=request.form['hobby']
new_info = PersonalInfo(name=post_name,lastname=post_lastname,hobby=post_hobby)
print(new_info)
db.session.add(new_info)
db.session.commit()
return redirect('/posts')
else:
all_post=PersonalInfo.query.order_by(PersonalInfo.data_posted).all()
#print(all_post)
return render_template('new-post.html')
if __name__=="__main__":
app.run(debug=True)