class Application(models.Model):
id = models.AutoField(primary_key=True)
appName = models.CharField(max_length=23)
totalDevices = models.BigIntegerField(10)
totalScenarios = models.BigIntegerField(10)
activeStatus = models.BooleanField(default=True)
preConditionStatus = models.BigIntegerField(10)
objectRunStatus = models.BigIntegerField(10)
class Api_data(models.Model):
crypto_id = models.CharField(max_length=50)
rank = models.IntegerField()
symbol = models.CharField(max_length=50)
name = models.CharField(max_length=50)
supply = models.BigIntegerField()
maxSupply = models.BigIntegerField()
marketCapUsd = models.BigIntegerField()
volumeUsd24Hr = models.BigIntegerField()
priceUsd = models.DecimalField(decimal_places=4,max_digits=20)
changePercent24Hr = models.DecimalField(decimal_places=2,max_digits=20)
vwap24Hr = models.DecimalField(decimal_places=2,max_digits=20)
class Offer(models.Model):
email = models.EmailField(max_length=255)
phone = models.BigIntegerField()
offer = models.BigIntegerField()
comment = models.TextField(blank=True)
user = models.ForeignKey(
settings.AUTH_USER_MODEL,
on_delete=models.CASCADE) # Delete when user is deleted
listing_id = models.CharField(max_length=255)
def __str__(self):
return self.email
class GenericModel(models.Model):
big_int = models.BigIntegerField()
bool = models.BooleanField()
char = models.CharField(max_length=20)
comma_int = models.CommaSeparatedIntegerField()
date = models.DateField()
date_time = models.DateTimeField()
decimal = models.DecimalField(max_digits=10, decimal_places=5)
email = models.EmailField()
float = models.FloatField()
integer = models.IntegerField()
null_bool = models.NullBooleanField()
pos_int = models.PositiveIntegerField()
pos_small_int = models.PositiveSmallIntegerField()
slug = models.SlugField()
small_int = models.SmallIntegerField()
text = models.TextField()
time = models.TimeField()
url = models.URLField()
ip = models.GenericIPAddressField()
uuid = models.UUIDField()
# TODO: add these
# basic_file = models.FileField()
# image = models.ImageField()
objects = models.DjongoManager()
class Device(models.Model):
_class = models.CharField(max_length=100)
_id = models.CharField(max_length=23)
communicationPort = models.CharField(max_length=23)
connectionType: models.BigIntegerField(10)
deviceState = models.CharField(max_length=23)
deviceStatus = models.BooleanField(default=False)
emailId = models.CharField(max_length=60)
imagePort = models.CharField(max_length=23)
imei = models.CharField(max_length=23)
ipAddress = models.CharField(max_length=23)
location = models.EmbeddedField(model_container=Location, default=None)
macAddress = models.CharField(max_length=23)
mdn = models.CharField(max_length=23)
modelColor = models.NullBooleanField
modelName = models.CharField(max_length=23)
modelNumber = models.CharField(max_length=23)
oem = models.CharField(max_length=23)
oemColor = models.CharField(max_length=23)
os = models.CharField(max_length=23)
osVersion = models.CharField(max_length=23)
serialNumber = models.CharField(max_length=23)
team = models.CharField(max_length=23)
user = models.ForeignKey(DeviceUser,
on_delete=models.SET_NULL,
null=True,
blank=True)
videoStreamingPort = models.CharField(max_length=23)
class Status(models.Model):
"""
Model for Tweet status
"""
id = models.BigIntegerField(primary_key=True)
created_at = models.DateTimeField()
text = models.TextField()
entities = models.ListField()
user = models.OneToOneField(User, on_delete=models.CASCADE)
retweet_count = models.IntegerField()
favorite_count = models.IntegerField()
geo = models.ListField()
country = models.TextField()
predicted_country = models.BooleanField(default=False)
sentiment = models.TextField(default='')
promotion = models.TextField(default='')
feedback = models.TextField(default='')
def as_dict(self):
return {
'id': self.id,
'created_at': self.created_at.strftime('%Y-%m-%d'),
'text': self.text,
'user': self.user.as_dict(),
'country': self.country,
'sentiment': self.sentiment,
'promotion': self.promotion,
'feedback': self.feedback
}
class Crypto_data(models.Model):
_id = models.ObjectIdField()
Name = models.CharField(max_length=50)
Date = models.DateTimeField()
Close = models.DecimalField(decimal_places=4,max_digits=20)
High = models.DecimalField(decimal_places=4,max_digits=20)
Low = models.DecimalField(decimal_places=4,max_digits=20)
Open = models.DecimalField(decimal_places=4,max_digits=20)
Volume = models.BigIntegerField()
class VuserInfo(models.Model):
scenario = models.ForeignKey(Scenario, on_delete=models.CASCADE)
Name = models.CharField(max_length=100, default="default")
Timestamp = models.BigIntegerField(default=0)
Num_users = models.IntegerField(default=0)
Type = models.CharField(max_length=100, default="default")
def __str__(self):
return self.Count
class User(models.Model):
_id = models.ObjectIdField()
name = models.CharField(max_length=20, blank=False)
email = models.EmailField(max_length=256, blank=False, unique=True)
contact = models.BigIntegerField(blank=False, unique=True)
password = models.CharField(max_length=300)
class Meta:
db_table = 'users'
class citizen(models.Model):
name = models.CharField(max_length=30, null=False)
adhar = models.BigIntegerField(max_length=16, primary_key=True)
gender = models.CharField(max_length=10, null=False)
place = models.ForeignKey(region, on_delete=models.CASCADE, null=False)
migrated = models.CharField(max_length=20, null=False)
def __str__(self):
return self.name
class Veiculo(models.Model):
placa = models.CharField(max_length=7, null=False, unique=True)
proprietario = models.CharField(max_length=50, null=False, unique=True)
matricula = models.BigIntegerField(unique=True)
curso = models.CharField(max_length=50, null=False)
area_especial = models.BooleanField()
def __str__(self):
return self.proprietario
class Incident(models.Model):
id = models.CharField(primary_key=True, max_length=100)
creation_date = models.DateField()
creation_ts = models.BigIntegerField(null=True, default=None)
status = models.CharField(max_length=100)
completion_date = models.DateField()
completion_ts = models.BigIntegerField(null=True, default=None)
service_request_number = models.CharField(max_length=100)
type_of_service_request = models.CharField(max_length=200)
street_address = models.CharField(max_length=200)
zip_code = models.IntegerField()
x_coordinate = models.FloatField()
y_coordinate = models.FloatField()
ward = models.IntegerField()
police_district = models.IntegerField()
community_area = models.IntegerField()
longitude = models.FloatField()
latitude = models.FloatField()
location = models.CharField(max_length=500)
class donate(models.Model):
id = models.AutoField(primary_key=True)
date = models.DateField()
name = models.CharField(max_length=30)
email = models.EmailField()
organization = models.CharField(max_length=50, null=False)
amount = models.BigIntegerField(null=False)
def __str__(self):
return self.organization
class user(models.Model):
username = models.CharField(max_length=50, primary_key=True)
password = models.TextField()
fname = models.CharField(max_length=50)
mname = models.CharField(max_length=50)
lname = models.CharField(max_length=50)
email = models.EmailField()
mobile_no = models.BigIntegerField()
address = models.TextField(default='')
profile_pic = models.ImageField(upload_to='home/profile_img/', default='')
class RegisterModel(models.Model):
'''DB Model for Registering User'''
full_name = models.CharField(default='',max_length=100)
dob = models.DateField(default='2020-07-22')
phone_no = models.BigIntegerField(default=0)
email_id = models.EmailField(default='')
passport_num = models.CharField(default='0',max_length=12)
# Resize the image after uploading using Pillow library
profile_image = ResizedImageField(size=[200, 200],crop=['middle', 'center'],upload_to='profile_photo',blank=True , default='profile_photo/profile_image.jpg' ,max_length=100)
def __str__(self):
return self.full_name
class UserDetail(models.Model):
fullname = models.CharField(max_length=30)
email = models.EmailField(primary_key="True")
username = models.TextField(max_length=20, unique="True")
userimage = models.ImageField(upload_to='Image/UserImage/')
usercreated = models.DateTimeField(auto_now_add=True)
lastlogin = models.DateTimeField(auto_now_add=True)
userphone = models.BigIntegerField(default="9292929292")
useraddress = models.TextField(default="Adress ...")
aboutuser = models.TextField(default="About Me ...")
activeuser = models.BooleanField(default=True)
def __str__(self):
return self.email
class Admin(models.Model):
firstName = models.TextField()
lastName = models.TextField()
email = models.EmailField()
password = models.TextField()
phoneNo = models.TextField()
address = models.TextField()
role = models.TextField(default="subAdmin", )
date = models.DateTimeField(auto_now_add=True)
resetPasswordToken = models.TextField(default="token")
tokenExpiration = models.BigIntegerField(default="10101")
def __str__(self):
return self.email
class Post(models.Model):
id = models.ObjectIdField(db_column='_id', default=None)
title = models.CharField(max_length=100, null=True)
content = models.CharField(max_length=20000)
# 使用 URI-liked 的形式，暂时仅允许第一级目录
# TODO: 给 Post 的 category 字段添加 validator
category = models.CharField(max_length=255)
date_submitted = models.DateTimeField(default=timezone.now)
date_confirmed = models.DateTimeField(null=True, default=None)
transaction_id = models.CharField(max_length=128, unique=True)
is_confirmed = models.BooleanField(default=False)
block_height = models.IntegerField(default=0)
# 对应另一个 Post 的 transaction_id
# TODO: 暂时限制仅能回复 reply_to 字段为空的 post
reply_to = models.CharField(max_length=128, null=True, db_index=True)
replies = models.IntegerField(default=0)
last_reply = models.CharField(max_length=128, null=True)
# TODO: 用于编辑，对应原始 post 的 transaction_id
base_to = models.CharField(max_length=128, null=True)
# 发送者的 public address
public_address = models.CharField(max_length=128)
# TODO: 可能需要限制为 UV 而不是 PV
views = models.BigIntegerField(default=0)
# TODO: 需要新的接口，对登录用户可用
likes = models.BigIntegerField(default=0)
objects = PostManager()
class Meta:
db_table = 'infnote_posts'
class Coin(models.Model):
txid = models.CharField(max_length=64, db_index=True)
vout = models.IntegerField(default=0)
value = models.BigIntegerField(default=0)
spendable = models.BooleanField(default=False)
frozen = models.BooleanField(default=False)
# User.public_address
owner = models.CharField(max_length=34)
height = models.IntegerField(default=0)
class Meta:
db_table = 'bc_coin'
unique_together = ('txid', 'vout')
class Producto(models.Model):
clasificacion = models.CharField(
max_length=50,
default='',
blank=False,
help_text="Cerveza, Licor, Cigarrillo, etc.",
verbose_name="Clasificación")
distribuidor = models.CharField(max_length=100,
default='',
blank=False,
help_text="Cerverpar, etc.",
verbose_name="Distribuidor")
marca = models.CharField(max_length=50,
default='',
blank=False,
help_text="Pilsen, Beldent, Lucky Strike, etc.",
verbose_name="Marca")
descripcion = models.CharField(max_length=50,
blank=False,
help_text="Pilsen'i, Infinity, etc.",
verbose_name="Descripción")
presentacion = models.CharField(max_length=50,
blank=False,
help_text="350ml, 1Ltr., etc.",
verbose_name="Presentación")
barcode = models.BigIntegerField(blank=False,
verbose_name='Código de barras')
etiqueta_opcional = models.CharField(
max_length=100,
blank=True,
default='',
help_text="Cualquier otra carateristica",
verbose_name="Etiqueta opcional")
precio_costo = models.PositiveIntegerField(blank=False,
verbose_name="Precio de costo")
precio_venta = models.PositiveIntegerField(blank=False,
verbose_name="Precio de venta")
impuesto = models.CharField(blank=False, max_length=2, default='10')
stock = models.EmbeddedField(model_container=Stock)
class Transaction(models.Model):
scenario = models.ForeignKey(Scenario, on_delete=models.CASCADE)
Name = models.CharField(max_length=100)
Timestamp = models.BigIntegerField(default=0)
Avg_time = models.FloatField(default=0)
Txs_count = models.IntegerField(default=0)
Type = models.CharField(max_length=100)
# VuserGroup = models.CharField(max_length=100)
# Type = models.IntegerField(default=0)
# StartTime = models.FloatField(default=0.0)
# EndTime = models.FloatField(default=0.0)
# AverageTime = models.FloatField(default=0.0)
# ThinkTime = models.FloatField(default=0.0)
# WastedTime = models.FloatField(default=0.0)
# Status = models.IntegerField(default=0)
# InstanceHandle = models.BigIntegerField(default=0)
# ParentHandle = models.BigIntegerField(default=0)
# VuserID = models.IntegerField(default=0)
def __str__(self):
return self.Name
class User(models.Model):
username = models.CharField(max_length=50, unique=True)
email = models.EmailField(unique=True)
password = models.CharField(max_length=80)
phone_number = models.BigIntegerField(primary_key=True)
objects = models.DjongoManager()
def __hash__(self):
return hash(self.phone_number)
def __repr__(self):
return f'User({self.username}, {self.pk}, {self.email})'
def to_json(self):
user_data = {"email": self.email, "username": self.username}
notifications = Notification.objects.filter(user_id=self)
user_data['notifications_count'] = len(notifications)
return user_data
@classmethod
def get_users_with_notifications(cls):
return cls.objects.filter(notifications__isnull=False)
class Candidate(models.Model):
#Choices
source_choices = (('RF','Referral'),('JP','Job Portal'))
status_choices = (('pending','Pending'),('hired','Hired'),('reject','Reject'))
skill_choices = (('python','Python'),('java','Java'))
rating_choices = ((1,1),(2,2),(3,3),(4,4),(5,5))
sex_choices=(('m', 'Male'), ('f', 'Female'))
#fields
#user = models.ForeignKey(User, related_name='User', null=True,on_delete=models.CASCADE)
First_name = models.CharField(max_length=20,null = False,blank = False)
Last_name = models.CharField(max_length=20,null = False,blank = False)
Sex = models.CharField(max_length = 1,choices = sex_choices)
Phone = models.BigIntegerField(null = False,blank = False)
Experience = models.IntegerField(default = 2,blank = False,null =False)
Notice_period = models.IntegerField(default = 0,blank = False,null =False)
Skill = models.SlugField(default = 'Python',choices = skill_choices)
Source = models.CharField(max_length = 10,choices = source_choices)
#admin
Status = models.CharField(default = 'Pending',max_length = 10,choices = status_choices)
Rating = models.IntegerField(null = True,blank = True,choices = rating_choices)
feedback = models.TextField(null = True,blank = True)
Created_at = models.DateTimeField(auto_now=False, auto_now_add=True)
Updated_at = models.DateTimeField(auto_now=True, auto_now_add=False)
class Meta:
ordering = ['-Created_at','-Updated_at']
# def get_absolute_url(self):
# return f"/blog/{self.slug}"
# def __str__(self):
# Name = First_name + ' ' + Last_name
# return self.Name
class ExecutionData(models.Model):
userEmail = models.EmailField()
devices = models.TextField(blank=False)
applicationId = models.BigIntegerField(10)
executionStatus = models.IntegerField(10)
executionDate = models.CharField(max_length=50)
class Restaurant(models.Model):
""" Model for Restaurants """
_id = models.ObjectIdField()
name = models.CharField(max_length=30)
address = models.CharField(max_length=60)
phone = models.BigIntegerField(null=True)
email = models.EmailField(unique=True)
city = models.CharField(max_length=40)
cuisine = models.CharField(max_length=30)
pricepoint = models.CharField(max_length=10, choices=Prices.choices())
twitter = models.CharField(max_length=200, blank=True)
instagram = models.CharField(max_length=200, blank=True)
bio = models.TextField(null=True)
GEO_location = models.CharField(max_length=200)
external_delivery_link = models.CharField(max_length=200, blank=True)
cover_photo_url = models.CharField(
max_length=200,
default='https://storage.googleapis.com/default-assets/cover.jpg')
logo_url = models.CharField(
max_length=200,
default='https://storage.googleapis.com/default-assets/logo.jpg')
rating = models.DecimalField(max_digits=3, decimal_places=2, default=0.00)
owner_name = models.CharField(max_length=50, blank=True)
owner_story = models.CharField(max_length=3000, blank=True)
owner_picture_url = models.CharField(max_length=200, blank=True)
categories = models.ListField(default=[], blank=True)
def category_exists(self, category):
"""
Check whether category is new
@param category: referenced category
@return: boolean
"""
return category in self.categories
@classmethod
def get(cls, _id):
"""
retrieve restaurant based on id
:param _id: id of restaurant
:return: restaurant json or None
"""
try:
restaurant = Restaurant.objects.get(_id=_id)
return restaurant
except ObjectDoesNotExist:
return None
@classmethod
def insert(cls, restaurant_data):
"""
Insert restaurant into database given restaurant data
:param restaurant_data: json data of restaurant
:return: restaurant object representing sent data
"""
try:
cls.objects.get(email=restaurant_data['email'])
raise ValueError('Cannot insert')
except ObjectDoesNotExist:
restaurant = cls(**restaurant_data)
update_model_geo(restaurant, restaurant_data['address'])
restaurant = save_and_clean(restaurant)
return restaurant
@classmethod
def field_validate(self, fields):
"""
Validates fields
:param fields: Dictionary of fields to validate
:return: A list of fields that were invalid. Returns None if all fields are valid
"""
restaurant_urls = [
'twitter', 'instagram', 'cover_photo_url', 'logo_url',
'owner_picture_url', 'external_delivery_link'
]
invalid = {'Invalid': []}
for field in restaurant_urls:
if field in fields and fields[field] != '':
try:
requests.get(fields[field])
except (requests.ConnectionError,
requests.exceptions.MissingSchema):
invalid['Invalid'].append(field)
if 'phone' in fields and fields['phone'] is not None:
if len(str(fields['phone'])) != 10:
invalid['Invalid'].append('phone')
if 'address' in fields:
try:
geocode(fields['address'])
except ValueError:
invalid['Invalid'].append('address')
if len(invalid['Invalid']) == 0:
return None
else:
return invalid
class Caja(models.Model):
caja_apertura = models.BigIntegerField(verbose_name='Monto inicial',
blank=False)
caja_cierre = models.BigIntegerField(verbose_name='Monto al cierre',
blank=False)
