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 Post(models.Model):
dominio = models.CharField(max_length=255)
porcentaje_movil = models.CharField(max_length=255)
orportunidades_movil = models.ListField()
diagnosticos_movil = models.ListField()
porcentaje_ordenador = models.CharField(max_length=255)
oportunidades_ordenador = models.ListField()
diagnosticos_ordenador = models.ListField()
class TimelinePost(models.Model):
_id = models.ObjectIdField()
restaurant_id = models.CharField(max_length=24)
user_email = models.EmailField()
likes = models.ListField(default=[], blank=True)
content = models.TextField(max_length=4096)
Timestamp = models.DateTimeField(auto_now=True)
comments = models.ListField(default=[], blank=True)
class Criteria(models.Model):
cri_Name = models.CharField(max_length=100)
cri_Given = models.ListField()
cri_When = models.ListField()
cri_Then = models.ListField()
class Meta:
abstract = True
class Transaction(models.Model):
id = models.CharField(max_length=64, primary_key=True, unique=True)
vin = models.ListField()
vout = models.ListField()
class Meta:
db_table = 'bc_tx'
class Project(models.Model):
place = models.IntegerField()
title = models.CharField(max_length=45)
blurb = models.ListField()
image = models.ListField()
links = models.ListField()
# created_at = models.DateTimeField(auto_now_add=True)
# updated_at = models.DateTimeField(auto_now=True)
objects = models.DjongoManager()
class TestCase(models.Model):
case_Name = models.CharField(max_length=100)
objec = models.CharField(max_length=100)
precon = models.CharField(max_length=100)
step = models.ListField()
check = models.ListField()
prio = models.CharField(max_length=100)
class Meta:
abstract = True
class CustomUser(AbstractUser):
role = models.CharField(blank=True, max_length=50, default='user')
dashboards = models.ListField(default=[])
# default_dashboard = models.CharField(blank=True, null=True, max_length=200)
default_dashboard = models.DictField(default={})
grants = models.ListField(default=[])
def __str__(self):
return self.username
class SEOResult(models.Model):
query = models.TextField()
text = models.TextField()
score = models.FloatField()
query_keywords = models.ListField(default=[])
document_keywords = models.ListField(default=[])
general = models.ListField(default=[])
specific = models.ListField(default=[])
objects = DjongoManager()
class Meta:
abstract = True
class Intent(models.Model):
_id = models.ObjectIdField()
nlu_model = models.ForeignKey(
NLUModel,
on_delete=models.CASCADE,
related_name = 'intents',
)
name = models.CharField(max_length=128, blank=False)
phrases = models.ListField(models.CharField(max_length=256))
answers = models.ListField(models.CharField(max_length=256))
def __str__(self):
return self.name
class Wishlist(models.Model):
mapping_id = models.IntegerField(default=0)
brand = models.CharField(max_length=50)
description = models.ListField(models.CharField(max_length=500))
user = models.ForeignKey(User, on_delete=models.CASCADE)
display_size = models.CharField(max_length=10)
graphics_memory = models.CharField(max_length=30)
img_link = models.URLField(max_length=10000)
product_title = models.CharField(max_length=1000)
ram = models.CharField(max_length=10)
ram_type = models.CharField(max_length=100)
storage = models.DictField()
websites = models.ListField(
models.EmbeddedModelField(model_container=Website))
class Student(models.Model):
username = models.CharField(max_length=30, default='inbar')
objects = models.DjongoManager()
# more fields unique to students
relevantCourses = models.ListField(models.CharField(max_length=50))
school = models.CharField(max_length=30, default="Computer Science")
examsGradesList = models.ArrayField(model_container=ExamGradesObj)
questionsAnsweredPerCourse = models.ArrayField(
model_container=QuestionsAnsweredPerCourse, default=[])
def as_json(self):
json_dict = dict()
json_dict["username"] = self.username
json_dict["school"] = self.school
json_dict['relevantCourses'] = self.relevantCourses
json_dict['examsGradesList'] = list()
myExamsGrades = list(self.examsGradesList)
myExamsGrades = sorted(myExamsGrades,
key=operator.attrgetter('dateSolved',
'timeSolved'),
reverse=True)
for examGrade in myExamsGrades:
json_dict['examsGradesList'].append(examGrade.as_json())
json_dict['questionsAnsweredPerCourse'] = list()
for questionsAnswered in self.questionsAnsweredPerCourse:
json_dict["questionsAnsweredPerCourse"].append(
questionsAnswered.as_json())
return json_dict
class Bid(models.Model):
"""
Bid object. The criteria a buyer specifies for a swipe such that he/she is willing to purchase the swipe.
"""
BID_STATES = [
(
'0', 'Pending'
), # Doesn't meet minimum, sits in the queue until an eligible listing pops up
(
'1', 'Accepted'
), # Pairing between buyer and seller has been made (either at the time of bid or after a swipe was created)
(
'2', 'Confirmed'
), # Transaction has occured between buyer and seller, whether successful or refund-based
]
bid_id = models.AutoField(primary_key=True)
status = models.CharField(max_length=1, choices=BID_STATES, default=0)
swipe = models.ForeignKey(Swipe, on_delete=models.CASCADE, null=True)
buyer = models.ForeignKey(User, on_delete=models.DO_NOTHING)
hall_id = models.ForeignKey(DiningHall, on_delete=models.DO_NOTHING)
bid_price = models.DecimalField(max_digits=5, decimal_places=2)
desired_time = models.TimeField(null=True)
visibility = models.ListField(
blank=True, null=True, default=[]
) # An array of JSON objects that contains intervals when this buyer wants the swipe
class Utter(models.Model):
name = models.TextField()
alternatives = models.ListField(default=[])
multiple_alternatives = models.BooleanField(blank=False, default=False)
project = models.EmbeddedModelField(model_container=Project)
objects = models.DjongoManager()
class Licitacao(models.Model):
# atomic Fields
numero_aviso_licitacao
identificador_licitacao
tipo_pregao
situacao_aviso
objeto
numero_processo
tipo_recurso
endereco_entrega
numero_itens_licitacao
nome_responsavel
funcao_responsavel
data_entrega_edital
endereco_entrega_edital
data_abertura_proposta
data_entrega_proposta
data_publicacao
# embeedded Fields one-to-one
uasg = models.EmbeddedModelField(model_container=Uasg)
pregao = models.EmbeddedModelField(model_container=Pregao)
# list Fields one-to-many
itens = models.ListField()
# choices Fields
modalidade_licitacao = models.CharField(blank=True,
null=True,
choices=MODALIDADE_LICITACAO_LIST)
class Meta:
abstract = True
class Exam(models.Model):
name = models.CharField(max_length=50)
date = models.DateField()
examID = models.CharField(max_length=50)
# who wrote the exam
writers = models.ListField(models.CharField(max_length=30))
course = models.EmbeddedField(model_container=Course)
questions = models.ArrayField(model_container=Question)
subjects = models.ArrayField(model_container=Subject)
objects = models.DjongoManager()
def as_json(self):
json_dict = dict(
examID=self.examID,
name=self.name,
date=self.date,
writers=self.writers,
course=self.course.as_json(), # pylint: disable=maybe-no-member
questions=list(),
subjects=list())
for question in list(self.questions):
json_dict['questions'].append(question.as_json())
for subject in list(self.subjects):
json_dict['subjects'].append(subject.as_json())
return json_dict
class Lecturer(models.Model):
username = models.CharField(max_length=30, default='inbar')
schools = models.ListField(models.CharField(max_length=50),
default=["מדעי המחשב", "משפטים"])
objects = models.DjongoManager()
# more fields unique to lecturers
coursesTeaching = models.ListField(models.CharField(max_length=50))
def as_json(self):
json_dict = dict()
json_dict["username"] = self.username
json_dict["schools"] = self.schools
json_dict['coursesTeaching'] = self.coursesTeaching
return json_dict
class ListEntry(models.Model):
_id = models.ObjectIdField()
headline = models.CharField(max_length=255)
authors = models.ListField()
def __str__(self):
return self.headline
class Group(models.Model):
groupname = models.CharField(max_length=24, unique=True)
users_in_list = models.ListField()
def __str__(self):
return self.groupname
@classmethod
def getUsers(cls, group):
# get users which group have
results = []
users_list = User.objects.all()
for user in users_list:
if group in user.groups:
results.append(user.username)
return results
@classmethod
def addGroup(cls, name):
# add group to db
maxId = 1
if Group.objects.all().order_by("-id"):
maxId = Group.objects.all().order_by("-id")[0].id + 1
Group.objects.create(id=maxId, groupname=name, users_in_list=[])
@classmethod
def delGroup(cls, groupname):
users = User.objects.all()
for user in users:
if groupname in user.groups:
user.groups.remove(groupname)
user.save()
from ..models import Group
Group.objects.filter(groupname=groupname).delete()
class VideoTag(models.Model):
_id = models.ObjectIdField(primary_key=True)
tid = models.IntegerField()
pubdate = models.IntegerField()
# tag_id = ObjectIdField()
tag_id = models.BinaryField(max_length=12)
aids = models.ListField(models.IntegerField())
avg_stat_view = models.IntegerField()
avg_stat_danmaku = models.IntegerField()
avg_stat_reply = models.IntegerField()
avg_stat_favorite = models.IntegerField()
avg_stat_coin = models.IntegerField()
avg_stat_share = models.IntegerField()
avg_stat_like = models.IntegerField()
avg_stat_dislike = models.IntegerField()
objects = models.DjongoManager()
class Meta:
db_table = 'video_tag'
indexes = [
models.Index(fields=[
'_id',
]),
]
constraints = [
models.UniqueConstraint(fields=[
'tid',
'pubdate',
'tag_id',
],
name='unique_tid_pubdate_tagid')
]
class SearchRecord(models.Model):
_id = models.ObjectIdField()
user = models.ForeignKey(SDUser)
query = models.CharField(max_length=50)
querytype = models.CharField(max_length=30)
filters = models.ListField()
Timestamp = models.DateTimeField()
class Blog(models.Model):
blogId = models.TextField()
blogHeading = models.TextField()
blogContent = models.TextField()
blogImage = models.ImageField(upload_to='BlogImage/')
blogCreatorName = models.TextField()
blogCreatorMail = models.EmailField()
blogCreatorImage = models.ImageField(upload_to='BlogerImage/')
blogLikedBy = models.ListField(default=[])
blogDisLikeBy = models.ListField(default=[])
blogComment = models.ListField(default={})
blogLikeCount = models.IntegerField()
blogDisLikeCount = models.IntegerField()
blogPostTime = models.DateTimeField()
def __str__(self):
return self.blogId
class ProcessModelFields(models.Model):
template = models.CharField(max_length=32)
parameters = models.ListField()
support = models.CharField(max_length=10)
confidence = models.CharField(max_length=10)
interestFactor = models.CharField(max_length=10)
class Meta:
abstract = True
class Mapping(models.Model):
brand = models.CharField(max_length=50)
description = models.ListField(models.CharField(max_length=500))
display_size = models.CharField(max_length=10)
graphics_memory = models.CharField(max_length=30)
img_link = models.URLField(max_length=10000)
product_title = models.CharField(max_length=1000)
ram = models.CharField(max_length=10)
ram_type = models.CharField(max_length=100)
storage = models.DictField()
_id = models.CharField(max_length=100)
websites = models.ListField(
models.EmbeddedModelField(
model_container=Website
)
)
id = models.IntegerField(primary_key=True)
class Dataset(models.Model):
_id = models.ObjectIdField()
dataset_id = models.IntegerField()
submitter_name = models.CharField(max_length=64)
relevant_questions = models.ListField()
actual_data = models.FileField()
is_approved = models.BooleanField(default=False)
objects = models.DjongoManager()
class User(models.Model):
TYPE_OF_CLIENT = (
('GOLD', 'GOLD'),
('SILVER', 'SILVER'),
('BRONZE', 'BRONZE'),
('NONE', 'NONE'),
)
fullName = models.TextField(default="")
countryCode = models.TextField(default="+91")
phoneNo = models.TextField(default="")
email = models.EmailField(default="")
createDate = models.DateTimeField(auto_now_add=True)
removeDate = models.DateTimeField(default=timezone.now)
deviceIMEI = models.TextField(default=[])
deviceHash = models.TextField(default="")
status = models.BooleanField(default=False)
isDeleted = models.BooleanField(default=False)
dateOfBirth = models.DateTimeField(auto_now_add=True)
gender = models.TextField(default='Others')
address = models.TextField(default="My Address")
about = models.TextField(default="About User")
educationalQualification = models.TextField(default="Education")
paymentMethod = models.ListField(default=[])
userOTP = models.TextField()
userLocation = models.TextField(default="88.4807644, 22.5808643")
language = models.TextField(default='English')
favoriteTaxis = models.ListField(default=[])
taxisBlocked = models.ListField(default=[])
adminNotices = models.TextField(default="Notice")
clintScore = models.FloatField(default=0.0)
ProfileImage = models.ImageField(default=DEFAUT_IMAGE,
upload_to='User/ProfileImage/')
typeOfClient = models.CharField(max_length=10,
choices=TYPE_OF_CLIENT,
default="")
package = models.BooleanField(default=False)
solidarityTaxi = models.BooleanField(default=False)
handicapedTaxi = models.BooleanField(default=False)
bankCardDetails = models.TextField(default="")
bankAccountDetails = models.TextField(default="")
def __str__(self):
return self.phoneNo
class BaseDataset(TimestampedModel):
user = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.CASCADE, null=False)
name = models.CharField(max_length=100)
description = models.TextField(blank=True, default='')
total_samples = models.PositiveIntegerField(default=0)
total_classes = models.PositiveIntegerField(default=1)
status = models.SmallIntegerField(choices=CHOICES_DS_STATUS, default=DEFAULT_DS_STATUS)
labels = models.ListField(default=[])
class Meta:
abstract = True
class DiningHall(Location):
"""
DiningHall object. Used as filtering criteria for buyers and sellers to specify where they want to use / sell
their Swipes at. Inherits from Location.
"""
hall_id = models.AutoField(primary_key=True)
hours = models.ListField()
name = models.CharField(max_length=50)
description = models.CharField(max_length=255)
picture = models.URLField()
class School(models.Model):
name = models.CharField(max_length=30)
courses = models.ListField(models.CharField(max_length=50))
objects = models.DjongoManager()
def as_json(self):
json_dict = dict(name=self.name, courses=list())
for course in list(self.courses):
json_dict['courses'].append(course)
return json_dict
class User(models.Model):
uid = models.IntegerField(auto_created=True, primary_key=True)
name = models.CharField(max_length=50)
email = models.EmailField(null=True)
agency = models.ForeignKey(Agency, on_delete=models.CASCADE, null=True)
start_date = models.DateField(auto_now_add=True, null=True)
end_date = models.DateField(null=True)
licenses = models.ListField(models.CharField(max_length=30), null=True)
def __str__(self):
return self.name
