class Harvest(db.Model): id = db.Column(db.Integer, primary_key=True) cropName = db.Column(db.Text, nullable=False) harvestAmount = db.Column(db.Float, nullable=False) sellingPrice = db.Column(db.Float, nullable=False) datetime = db.Column(db.Date, nullable=False) crop_id = db.Column(db.Integer, db.ForeignKey('crop.id'))
class Crop(db.Model): id = db.Column(db.Integer, primary_key=True) cropeName = db.Column(db.Text, nullable=False) cropImage = db.Column(db.String(255), nullable=True) farm_id = db.Column(db.Integer, db.ForeignKey('farm.id')) farms = db.relationship('Farm', secondary=farm_crops, backref='crop') harvest = db.relationship('Harvest', backref='crop') pestdisease = db.relationship('Pestdisease', backref='crop') created_timestamp = db.Column(db.DateTime, default=datetime.now) modified_timestamp = db.Column(db.DateTime, default=datetime.now, onupdate=datetime.now) sys_sub_crop_id = db.Column(db.Integer(), db.ForeignKey('syssubcategory.id')) production_type = db.Column(db.String(255), nullable=True) panting_unit = db.Column(db.String(255), nullable=True) crop_surface_on_farm = db.Column(db.String(255), nullable=True)
class Farmtask(db.Model): id = db.Column(db.Integer, primary_key=True) taskName = db.Column(db.Text, nullable=False) isDone = db.Column(db.Boolean) farm_id = db.Column(db.Integer, db.ForeignKey('farm.id')) created_timestamp = db.Column(db.DateTime, default=datetime.now) modified_timestamp = db.Column(db.DateTime, default=datetime.now, onupdate=datetime.now)
class Fieldvisit(db.Model): id = db.Column(db.Integer, primary_key=True) vistareaname = db.Column(db.Text, nullable=False) specialnotes = db.Column(db.Text) user_id = db.Column(db.Integer, db.ForeignKey('user.id')) created_timestamp = db.Column(db.DateTime, default=datetime.now) modified_timestamp = db.Column(db.DateTime, default=datetime.now, onupdate=datetime.now)
class Pestdisease(db.Model): id = db.Column(db.Integer, primary_key=True) diseaseName = db.Column(db.Text, nullable=False) diseaseCauses = db.Column(db.Text, nullable=False) diseaseSymptons = db.Column(db.Text, nullable=False) crops_id = db.Column(db.Integer, db.ForeignKey('crop.id')) created_timestamp = db.Column(db.DateTime, default=datetime.now) modified_timestamp = db.Column(db.DateTime, default=datetime.now, onupdate=datetime.now)
class Area(db.Model): id = db.Column(db.Integer, primary_key=True) areaName = db.Column(db.Text, nullable=False) devisionoffices = db.relationship('Devisionoffice', backref='area') district_id = db.Column(db.Integer, db.ForeignKey('district.id'), nullable=False) created_timestamp = db.Column(db.DateTime, default=datetime.now) modified_timestamp = db.Column(db.DateTime, default=datetime.now, onupdate=datetime.now)
class Farm(db.Model): id = db.Column(db.Integer, primary_key=True) farmname = db.Column(db.Text, nullable=False) latitude = db.Column(db.Float(10, 6), nullable=False) longitude = db.Column(db.Float(10, 6), nullable=False) phone = db.Column(db.Integer, nullable=False, unique=False) address = db.Column(db.Text, nullable=False) email = db.Column(db.String(255), nullable=True, unique=False) farmtask = db.relationship('Farmtask', backref='farm') farmworker = db.relationship('Farmworker', backref='farm') fieldvisit = db.relationship('Fieldvisit', secondary=farm_fieldvisits, backref='farm') farmfertilizerplan = db.relationship('FarmFertilizerPlan', backref='farm') user_id = db.Column(db.Integer, db.ForeignKey('user.id')) created_timestamp = db.Column(db.DateTime, default=datetime.now) modified_timestamp = db.Column(db.DateTime, default=datetime.now, onupdate=datetime.now) surface = db.Column(db.String(255), nullable=True, unique=False) devisionoffice_id = db.Column(db.Integer) farm_pest_details = db.relationship('Farm_pest_details', backref='farm')
def get_email_confirm_token(self, expier_time=1800): es = Serializer(app.config['SECRET_KEY'], expier_time) return es.dumps({'user_id': self.id}).decode('utf-8') @staticmethod def verify_email_token(token): se = Serializer(app.config['SECRET_KEY']) try: user_id = se.loads(token)['user_id'] except: return None return User.query.get(user_id) farm_crops = db.Table( 'farm_crops', db.Column('farm_id', db.Integer, db.ForeignKey('farm.id')), db.Column('crop_id', db.Integer, db.ForeignKey('crop.id'))) farm_fieldvisits = db.Table( 'farm_fieldvisits', db.Column('fieldvisit_id', db.Integer, db.ForeignKey('fieldvisit.id')), db.Column('farm_id', db.Integer, db.ForeignKey('farm.id'))) class Fieldvisit(db.Model): id = db.Column(db.Integer, primary_key=True) vistareaname = db.Column(db.Text, nullable=False) specialnotes = db.Column(db.Text) user_id = db.Column(db.Integer, db.ForeignKey('user.id')) created_timestamp = db.Column(db.DateTime, default=datetime.now) modified_timestamp = db.Column(db.DateTime,