FilesExpand file tree

 master

/

app.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

61 lines (47 loc) · 1.79 KB

 master

/

app.py

Copy path

Top

File metadata and controls

• Code
• Blame

61 lines (47 loc) · 1.79 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

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

from flask import Flask, render_template, request

from flask_sqlalchemy import SQLAlchemy

from send_mail import send_mail

app = Flask(__name__)

ENV = 'dev'

if ENV == 'dev':

app.debug = True

app.config['SQLALCHEMY_DATABASE_URI'] = ''

else:

app.debug = False

app.config['SQLALCHEMY_DATABASE_URI'] = ''

app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False

db = SQLAlchemy(app)

class Feedback(db.Model):

__tablename__ = 'feedback'

id = db.Column(db.Integer, primary_key=True)

customer = db.Column(db.String(200), unique=True)

dealer = db.Column(db.String(200))

rating = db.Column(db.Integer)

comments = db.Column(db.Text())

def __init__(self, customer, dealer, rating, comments):

self.customer = customer

self.dealer = dealer

self.rating = rating

self.comments = comments

@app.route('/')

def index():

return render_template('index.html')

@app.route('/submit', methods=['POST'])

def submit():

if request.method == 'POST':

customer = request.form['customer']

dealer = request.form['dealer']

rating = request.form['rating']

comments = request.form['comments']

# print(customer, dealer, rating, comments)

if customer == '' or dealer == '':

return render_template('index.html', message='Please enter required fields')

if db.session.query(Feedback).filter(Feedback.customer == customer).count() == 0:

data = Feedback(customer, dealer, rating, comments)

db.session.add(data)

db.session.commit()

send_mail(customer, dealer, rating, comments)

return render_template('success.html')

return render_template('index.html', message='You have already submitted feedback')

if __name__ == '__main__':

app.run()