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,
