flask.py

flask_test.py

from datetime import datetime
from flask import Flask, render_template, url_for, flash, redirect
from flask_sqlalchemy import SQLAlchemy
# from sqlalchemy import Column
from sqlalchemy import Integer
# from sqlalchemy import String
#from forms import RegistrationForm, LoginForm

app = Flask(__name__)
#app.config['SECRET_KEY'] = '5791628bb0b13ce0c676dfde280ba245'
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///site.db'
db = SQLAlchemy(app)


class WMS(db.Model):
    __tablename__ = 'wms'
    # print ("UJHASSABHJ  ---->>>>>"
    id = db.Column(Integer, primary_key=True)
    date = db.Column(Integer)
    time = db.Column(Integer)
    Global_Irradiance_W_m2 = db.Column(Integer)
    Panel_Irradiance_W_m2 = db.Column(Integer)
    Wind_Speed_m_s = db.Column(Integer)
    Panel_Temperature_deg_C = db.Column(Integer)
    Ambient_Temperature_deg_C = db.Column(Integer)
    Wind_Direction_degrees = db.Column(Integer)

    def __init__(self, date, time, Global_Irradiance_W_m2, Panel_Irradiance_W_m2, Wind_Speed_m_s, Panel_Temperature_deg_C, Ambient_Temperature_deg_C, Wind_Direction_degrees):
        self.date = date
        self.time = time
        self.Global_Irradiance_W_m2 = Global_Irradiance_W_m2
        self.Panel_Irradiance_W_m2 = Panel_Irradiance_W_m2
        self.Wind_Speed_m_s = Wind_Speed_m_s
        self.Panel_Temperature_deg_C = Panel_Temperature_deg_C
        self.Ambient_Temperature_deg_C = Ambient_Temperature_deg_C
        self.Wind_Direction_degrees = Wind_Direction_degrees