gripson/application.py at master · snkrfrkr/gripson · GitHub

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
123
124
125
126
from flask import Flask, render_template, request
from flask_bootstrap import Bootstrap
from flask_sqlalchemy import SQLAlchemy
from flask_wtf import FlaskForm
from wtforms import StringField, FileField, BooleanField, TextAreaField, TextField, SelectField
from wtforms.validators import DataRequired, InputRequired, Length, Email
from flask_wtf.file import FileField, FileRequired
from werkzeug.utils import secure_filename
import os, time, datetime, bcrypt

#mysql = MySQL()
app = Flask(__name__)
app.config["SQLALCHEMY_DATABASE_URI"] = "mysql://service:schubert@localhost:3306/gripson_db"
app.config["SQLALCHEMY_TRACK_MODIFICATIONS"] = True
app.config["SECRET_KEY"] = "GRIPSWORLD"
db = SQLAlchemy(app)

Bootstrap(app)

class gripson_t(db.Model):
    id = db.Column('id', db.Integer, primary_key = True)
    dtime = db.Column(db.String(4096))
    go_improvement = db.Column(db.String(2048))
    go_dept_1 = db.Column(db.String(256))
    go_dept_2 = db.Column(db.String(256))
    go_dept_3 = db.Column(db.String(256))
    go_dept_4 = db.Column(db.String(256))
    go_why_1 = db.Column(db.String(2048))
    go_why_2 = db.Column(db.String(2048))
    go_why_3 = db.Column(db.String(2048))
    go_what_1 = db.Column(db.String(2048))
    go_what_2 = db.Column(db.String(2048))
    go_what_3 = db.Column(db.String(2048))
    go_high_1 = db.Column(db.String(2048))
    go_high_2 = db.Column(db.String(2048))
    go_high_3 = db.Column(db.String(2048))

    def __init__ (self, dtime, go_improvement,go_dept_1, go_dept_2, go_dept_3, go_dept_4, go_why_1, go_why_2, go_why_3, go_what_1, go_what_2, go_what_3, go_high_1, go_high_2, go_high_3):
        self.dtime = dtime
        self.go_improvement = go_improvement
        self.go_dept_1 = go_dept_1
        self.go_dept_2 = go_dept_2
        self.go_dept_3 = go_dept_3
        self.go_dept_4 = go_dept_4
        self.go_why_1 = go_why_1
        self.go_why_2 = go_why_2
        self.go_why_3 = go_why_3
        self.go_what_1 = go_what_1
        self.go_what_2 = go_what_2
        self.go_what_3 = go_what_3
        self.go_high_1 = go_high_1
        self.go_high_2 = go_high_2
        self.go_high_3 = go_high_3

class gripson_depts(db.Model):
    id = db.Column('id', db.Integer, primary_key = True)
    dep_depts = db.Column(db.String(128))

    def __init__ (self, dep_depts):
        self.dep_depts = dep_depts


class GripsInput(FlaskForm):
    go_improvement = StringField('Verbesserung*', validators=[InputRequired(message="Pflichtfeld")])
    go_dept_1 = TextField('Abteilung*', validators=[InputRequired(message="Pflichtfeld")])
    go_dept_2 = StringField('Abteilung')
    go_dept_3 = StringField('Abteilung')
    go_dept_4 = StringField('Abteilung')
    go_why_1 = StringField('Punkt 1*', validators=[InputRequired(message="Pflichtfeld")])
    go_why_2 = StringField('Punkt 2')
    go_why_3 = StringField('Punkt 3')
    go_what_1 = StringField('Punkt 1*', validators=[InputRequired(message="Pflichtfeld")])
    go_what_2 = StringField('Punkt 2')
    go_what_3 = StringField('Punkt 3')
    go_high_1 = StringField('Punkt 1*', validators=[InputRequired(message="Pflichtfeld")])
    go_high_2 = StringField('Punkt 2')
    go_high_3 = StringField('Punkt 3')

db_in = gripson_t.query.all()
db_len = len(db_in)
print(str(db_len) + " Einträge in der Datenbank")

dep = gripson_depts.query.all()
print(str(dep))

@app.route("/", methods = ['GET', 'POST'])
def index():
    if request.method == 'GET':
        try:
            return render_template("index.html", data=gripson_t.query.all(), db_len=db_len )
        except:
            print("NOK")


@app.route("/form", methods = ['GET', 'POST'])
def form():
    form = GripsInput()
    if form.validate_on_submit():
        #f = form.image.data
        #filename = secure_filename(f.filename)
        #f.save(os.path.join(
        #    app.instance_path, 'photos', filename
        #))
        g_time = datetime.datetime.now()
        g_improvement = form.go_improvement.data
        g_dept_1 = form.go_dept_1.data
        g_dept_2 = form.go_dept_2.data
        g_dept_3 = form.go_dept_3.data
        g_dept_4 = form.go_dept_4.data
        g_why_1 = form.go_why_1.data
        g_why_2 = form.go_why_2.data
        g_why_3 = form.go_why_3.data
        g_what_1 = form.go_what_1.data
        g_what_2 = form.go_what_2.data
        g_what_3 = form.go_what_3.data
        g_high_1 = form.go_high_1.data
        g_high_2 = form.go_high_2.data
        g_high_3 = form.go_high_3.data
        db_write = gripson_t(g_time, g_improvement, g_dept_1, g_dept_2, g_dept_3, g_dept_4, g_why_1, g_why_2, g_why_3, g_what_1, g_what_2, g_what_3, g_high_1, g_high_2, g_high_3)
        db.session.add(db_write)
        db.session.commit()
        return render_template("ok.html" )
    return render_template("form.html", form=form, dept=dep)

if __name__ == '__main__':
    app.run(debug=True)