FilesExpand file tree

 master

/

app.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

54 lines (39 loc) · 1.73 KB

 master

/

app.py

Copy path

Top

File metadata and controls

• Code
• Blame

54 lines (39 loc) · 1.73 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

from flask import Flask, render_template, request

from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)

app.config['SQLALCHEMY_DATABASE_URI'] = 'postgres://cnvimvnrkperbi:e1b7fff4efc9c31ef1fd9e953607210171202ccc3eac78b38367943a3d0aec12@ec2-18-215-96-22.compute-1.amazonaws.com:5432/d4fq7frueo138s'

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()

return render_template('success.html')

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

if __name__ == '__main__':

app.run()