# coding: utf-8
from sqlalchemy import Column, DateTime, Integer, Numeric, String
from flask_sqlalchemy import SQLAlchemy


#與當前項目相關的模型文件，即所有的實體類在此編寫
from manage import db


#用戶表
class User(db.Model):
    __tablename__ = 'user'

    sn = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(30), nullable=False, unique=True)
    password = db.Column(db.Text, nullable=False)

#目標點位置表
class Goal(db.Model):
    __tablename__ = 'goal'

    sn = db.Column(db.Integer, primary_key=True)
    goal_num = db.Column(db.Integer, nullable=False)
    goal_ori_x = db.Column(db.Text, nullable=False)
    goal_ori_y = db.Column(db.Text, nullable=False)
    goal_change_x = db.Column(db.Text, nullable=False)
    goal_change_y = db.Column(db.Text, nullable=False)
    datetime = db.Column(db.DateTime, nullable=False)

#目標點歷史位置表
class GoalHistory(db.Model):
    __tablename__ = 'goal_history'

    sn = db.Column(db.Integer, primary_key=True)
    goal_num = db.Column(db.Integer, nullable=False)
    goal_ori_x = db.Column(db.Text, nullable=False)
    goal_ori_y = db.Column(db.Text, nullable=False)
    goal_change_x = db.Column(db.Text, nullable=False)
    goal_change_y = db.Column(db.Text, nullable=False)
    datetime = db.Column(db.DateTime, nullable=False)

#排程時間表
class Schedule(db.Model):
    __tablename__ = 'schedule'

    sn = db.Column(db.Integer, primary_key=True)
    time1 = db.Column(db.Text, nullable=True)
    time2 = db.Column(db.Text, nullable=True)
    time3 = db.Column(db.Text, nullable=True)
    time4 = db.Column(db.Text, nullable=True)
    time5 = db.Column(db.Text, nullable=True)
    time6 = db.Column(db.Text, nullable=True)
    time7 = db.Column(db.Text, nullable=True)
    datetime = db.Column(db.DateTime, nullable=False)



#糞便高度表
class Sonic(db.Model):
    __tablename__ = 'sonic'

    sn = db.Column(db.Integer, primary_key=True)
    sonic = db.Column(db.Text, nullable=False)
    datetime = db.Column(db.DateTime, nullable=False)

#電量表
class Battery(db.Model):
    __tablename__ = 'battery'

    sn = db.Column(db.Integer, primary_key=True)
    battery = db.Column(db.Text, nullable=False)
    datetime = db.Column(db.DateTime, nullable=False)

#水位表
class WaterLevel(db.Model):
    __tablename__ = 'water_level'

    sn = db.Column(db.Integer, primary_key=True)
    water_level = db.Column(db.Text, nullable=False)
    datetime = db.Column(db.DateTime, nullable=False)

#制動器表
class Actuator(db.Model):
    __tablename__ = 'actuator'

    sn = db.Column(db.Integer, primary_key=True)
    fan = db.Column(db.Text, nullable=False, default="off")
    yellow_light = db.Column(db.Text, nullable=False, default="off")
    green_light = db.Column(db.Text, nullable=False, default="off")
    red_light = db.Column(db.Text, nullable=False, default="off")
    water_bump = db.Column(db.Text, nullable=False, default="off")
    charge = db.Column(db.Text, nullable=False, default="off")
    water_charge = db.Column(db.Text, nullable=False, default="off")
    datetime = db.Column(db.DateTime, nullable=False)

#db.create_all()