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
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
| from datetime import datetime
from flask import Flask, render_template,url_for,redirect,request,abort,make_response,session,flash
from werkzeug.wrappers.response import ResponseStream
from flask_wtf import FlaskForm
from wtforms import HiddenField, StringField,IntegerField,TextAreaField,SubmitField,RadioField,SelectField
from wtforms import validators
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///contacts.db'
app.config["SECRET_KEY"] = "123456"
db = SQLAlchemy(app)
class ContactDAO(db.Model):
id = db.Column(db.Integer, primary_key = True)
name = db.Column(db.String(50))
gender = db.Column(db.String(1))
address = db.Column(db.String(100))
email = db.Column(db.String(50))
age = db.Column(db.Integer)
language = db.Column(db.String(5))
date_create = db.Column(db.DateTime,default=datetime.now())
def __init__(self,name,gender,address,email,age,language):
self.name = name
self.gender= gender
self.address = address
self.email = email
self.age = age
self.language = language
class ContactForm(FlaskForm):
id = HiddenField("id")
name = StringField("Name Of Student",[validators.InputRequired("Please enter your name.")])
Gender = RadioField('Gender', choices = [('M','Male'),('F','Female')])
Address = TextAreaField('Address')
email = StringField("Email",[validators.InputRequired("Please enter your email address."),validators.Email("Please enter your email address.")])
Age = IntegerField("age")
language = SelectField('language',choices=[('cpp','C++'),('py','Python')])
submit = SubmitField("Send")
@app.route('/')
def show_all():
return render_template("show12.html",contacts=ContactDAO.query.all())
@app.route("/add",methods = ['GET','POST'])
def do_add():
form1 = ContactForm()
if request.method == "POST":
if form1.validate() == False:
flash('All fields are required.')
return render_template('add12.html',form=form1)
else:
contact = ContactDAO(
form1.name.data,
form1.Gender.data,
form1.Address.data,
form1.email.data,
form1.Age.data,
form1.language.data,
)
try:
db.session.add(contact)
db.session.commit()
flash('Record was successfully added')
return redirect('/')
except Exception as e:
flash('there is an issue adding contact into db. {0}'.format(e))
return render_template('add12.html', form = form1)
elif request.method == 'GET':
return render_template('add12.html',form=form1)
@app.route('/delete/<int:id>')
def do_delete(id):
to_delete = ContactDAO.query.get_or_404(id)
try:
db.session.delete(to_delete)
db.session.commit()
return redirect('/')
except Exception as e:
flash('there is an issue delete contact into db. {0}'.format(e))
return redirect('/')
@app.route('/update/<int:id>',methods = ['POST','GET'])
def do_update(id):
form1 = ContactForm()
to_update = ContactDAO.query.get_or_404(id)
if request.method == 'GET':
form1.id.data = to_update.id
form1.name.data = to_update.name
form1.Gender.data = to_update.gender
form1.Address.data = to_update.address
form1.email.data = to_update.email
form1.Age.data = to_update.age
form1.language.data = to_update.language
return render_template('update12.html',form=form1)
elif request.method == 'POST':
to_update.id = id
to_update.name = form1.name.data
to_update.gender = form1.Gender.data
to_update.address = form1.Address.data
to_update.email = form1.email.data
to_update.age = form1.Age.data
to_update.language = form1.language.data
try:
db.session.commit()
return redirect('/')
except Exception as e:
flash('there is an issue delete contact into db. {0}'.format(e))
return redirect('/')
if __name__ == "__main__":
with app.app_context():
db.create_all()
app.run(debug=True,host='127.0.0.1',port=5000,threaded=True)
|
