class FareModel(models.Model):
baseFare = models.FloatField()
vehicleTypeId = models.TextField()
fromTime = models.TimeField(auto_now_add=True)
toTime = models.TimeField(auto_now_add=True)
status = models.BooleanField(default=True)
isDeleted = models.BooleanField(default=False)
class Classes(models.Model):
class_id = models.UUIDField(primary_key=True,
blank=False,
default=uuid.uuid4,
editable=False)
credit = models.IntegerField(blank=False, verbose_name='credit')
section_id = models.PositiveSmallIntegerField(
verbose_name="class section ID", blank=False)
start_time = models.TimeField(auto_now=False,
blank=False,
verbose_name="class start time")
end_time = models.TimeField(auto_now=False,
blank=False,
verbose_name="class end time")
course_part = models.ForeignKey(to='Courses',
on_delete=models.CASCADE,
verbose_name='Course part')
grade_scale = models.ForeignKey(to='GpaScale',
on_delete=models.CASCADE,
verbose_name='Grade Scale',
blank=False)
weights = models.ForeignKey(to='Weights',
on_delete=models.CASCADE,
verbose_name='Grade weights',
blank=False)
students = models.ArrayReferenceField(to=Student, on_delete=models.CASCADE)
teachers = models.ArrayReferenceField(to=Teacher, on_delete=models.CASCADE)
def __str__(self):
return str(self.course_part) + '_' + str(self.section_id)
class TimeLine(models.Model):
description = models.CharField(max_length=255, null=True)
action = models.CharField(max_length=7, choices=ACTIONS)
team = models.CharField(
max_length=5,
choices=(('Black', 'Black'), ('White', 'White')),
null=True,
)
foul = models.ForeignKey(Foul, models.CASCADE, null=True)
time = models.TimeField()
timestamp = models.TimeField()
class Meta:
abstract = True
# TODO: Refactor
def __str__(self):
if self.description:
return self.action + ' | ' + self.description
if self.action == 'Start' or self.action == 'End' or 'Half Time' in self.action or 'Warning' in self.action:
return str(
self.timestamp.replace(tzinfo=None)) + ' | ' + self.action
line = str(self.timestamp.replace(tzinfo=None)) + ' | ' + str(
self.time) + ' | ' + self.action
if self.action == 'Foul':
return line + ' | ' + self.team + ' | ' + str(self.foul)
return line if not self.team else line + ' | ' + self.team
class AttendanceLab(models.Model):
date = models.DateField()
from_time = models.TimeField()
to_time = models.TimeField()
lab = models.CharField(max_length=10)
batch = models.CharField(max_length=5)
year = models.CharField(max_length=3)
attendance = models.ArrayModelField(model_container=Attendance)
class SlotF(models.Model):
date = models.DateField()
time_s = models.TimeField()
time_e = models.TimeField()
class Meta:
abstract = True
class AttendanceSubject(models.Model):
date = models.DateField()
from_time = models.TimeField()
to_time = models.TimeField()
subject = models.CharField(max_length=10)
division = models.CharField(max_length=5)
year = models.CharField(max_length=3)
slots = models.IntegerField()
attendance = models.ArrayModelField(model_container=Attendance)
class Voccupy(models.Model):
eid = models.CharField(max_length=10)
edate = models.DateField(default=date.today)
etime_s = models.TimeField()
etime_e = models.TimeField()
class Meta:
abstract = True
class Event(models.Model):
organiser = models.ForeignKey(User, on_delete=models.PROTECT, related_name="Organiser")
title = models.CharField(max_length=50)
description = models.CharField(max_length=2500)
venue = models.CharField(max_length=100)
date = models.DateField()
startTime = models.TimeField()
endTime = models.TimeField()
video = EmbedVideoField(default='')
calendar_link = models.CharField(max_length=500, default='')
class Fare(models.Model):
_id = models.ObjectIdField(default="")
baseFare = models.FloatField()
vehicleTypeId = models.TextField()
fromTime = models.TimeField(auto_now_add=True)
toTime = models.TimeField(auto_now_add=True)
status = models.BooleanField(default=True)
isDeleted = models.BooleanField(default=False)
def __str__(self):
return self.vehicleTypeId
class Hashtag(commonInfo):
_id = models.ObjectIdField()
hashtag_name = models.CharField(max_length=150)
strategy = models.ForeignKey(Strategy, on_delete=models.CASCADE)
number_of_likes_per_day = models.PositiveIntegerField(default=0)
initial_time_to_like_posts = models.TimeField()
final_time_to_like_posts = models.TimeField()
initial_time_to_comment_posts = models.TimeField()
final_time_to_comment_posts = models.TimeField()
def __str__(self):
return self.hashtag_name
class FondosEmbebido(models.Model):
descripcion = models.CharField(max_length=255, blank=False, default='')
orientacion = models.CharField(max_length=20, blank=False, default='')
url_verde = models.CharField(max_length=255, blank=False, default='')
url_ambar = models.CharField(max_length=255, blank=False, default='')
url_rojo = models.CharField(max_length=255, blank=False, default='')
url_cerrado = models.CharField(max_length=255, blank=False, default='')
hora_apertura = models.TimeField(blank=False)
hora_cierre = models.TimeField(blank=False)
class Meta:
abstract = True
class Attendance(models.Model): # Collection name
user = models.ForeignKey(User, on_delete=models.CASCADE)
date = models.DateField(default=timezone.now)
office_hours = models.TimeField()
off_hours = models.TimeField()
clockin_time = models.TimeField(blank=True, null=True)
clockout_time = models.TimeField(blank=True, null=True)
clockin_status = models.CharField(max_length=20)
clockout_status = models.CharField(max_length=20)
total_working_hours = models.FloatField()
abnormal_hours = models.FloatField()
def __str__(self):
return f"{self.user.username}'s Attendance"
class Garage(models.Model):
# name of the parking garage/structure/lot. Cannot be None/NULL/Empty String
name = models.CharField(max_length=50, null=False, blank=False)
# start of the enforcement period. Cannot be None/NULL
start_enforce_time = models.TimeField(null=False, blank=False)
# end of the enforcement period. Cannot be None/NULL
end_enforce_time = models.TimeField(null=False, blank=False)
# whether the enforcement period applies to weekends. Default is False
enforced_on_weekends = models.BooleanField(default=False)
# array/list of DayProbability. [0] = Sunday, ..., [6] = Saturday
probability = models.ArrayField(model_container=DayProbability)
latitude = models.FloatField()
longitude = models.FloatField()
def __str__(self):
return self.name
class Probability(models.Model):
# start time for the probability (15 minute duration). ie) 00:00 == 00:00 <= time < 00:15
time = models.TimeField()
# probability value. 0 <= value <= 1
probability = models.FloatField(
validators=[MinValueValidator(0.0),
MaxValueValidator(1.0)])
class Note(models.Model):
title = models.CharField(
'Название',
max_length=100,
)
description = models.TextField(blank=True, null=True, default=None)
theme = models.ArrayReferenceField(to=Theme,
verbose_name='Тема заметки',
on_delete=models.SET_NULL,
blank=True,
null=True,
default=None)
user = models.ArrayReferenceField(to=User,
verbose_name='Автор заметки',
validators=[
validate_user_field,
])
date = models.DateField(
'Дата напоминания',
blank=True,
default=None,
null=True,
)
time = models.TimeField(
'Время напоминания',
blank=True,
default=None,
null=True,
)
def __str__(self):
return f'{self.title}'
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 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 myCamaras(models.Model):
_id = models.ObjectIdField()
instalacion = models.EmbeddedField(
model_container=InstalacionEmbebido,
null=True,
blank=True,
)
nombre_camara = models.CharField(max_length=250, blank=False, default='')
serial_camara = models.CharField(max_length=250, blank=False, default='')
ts = models.TimeField(blank=False)
fecha = models.DateField(auto_now_add=True, blank=True, null=True)
zonas_camara = models.ArrayField(
model_container=ZonaCamara,
null=True,
blank=True,
)
def __unicode__(self):
return self.nombre_camara
def __str__(self, ):
return str(self.nombre_camara)
class Meta:
db_table = "camaras_historico"
class Message(models.Model):
identifier = models.IntegerField()
source = models.CharField(max_length=50) # User
time_stamp = models.TimeField(auto_now=False, auto_now_add=False)
message = models.TextField()
def __str__(self):
return self.identifier
class Influencer(commonInfo):
_id = models.ObjectIdField()
strategy = models.ForeignKey(Strategy, on_delete=models.CASCADE)
influencer_instagram_id = models.CharField(
max_length=255
) # I don't really know in this moment if needed and the type de Instagram ID from API Oficial Instagram
name = models.CharField(
max_length=150) # Influencer name, it will be the @ on Instagram
number_of_users_to_follow = models.PositiveIntegerField(
default=0) # It represents how many users follow in the schedule
days_has_to_pass_to_unfollow = models.PositiveIntegerField(
default=0) # It sets how many days has to unfollow
initial_time_to_follow = models.TimeField(
) # Initial hour to follow people
final_time_to_follow = models.TimeField() # Final hour to follow people
def __str__(self):
return self.name
class Build(models.Model):
time_stamp = models.TimeField(auto_now=False, auto_now_add=False)
image = models.ImageField(upload_to=None,
height_field=None,
width_field=None,
max_length=None)
name = models.CharField(max_length=50)
description = models.TextField()
source = models.CharField(max_length=50) # User
class reviews(models.Model):
class Meta:
unique_together = (('review_user_id', 'movie_id'),)
review_user_id = models.CharField(max_length=30, blank=False, unique=False)
#movie = models.ForeignKey(movies,to_field='movie_id', related_name='movie', on_delete=models.CASCADE, default=None)
movie_id = models.IntegerField(unique=False,default=0)
review = models.CharField(max_length=300, blank=True, unique=False)
rating=models.FloatField(default=0.0)
wishlist=models.BooleanField(default=False)
liked=models.BooleanField(default=False)
watched=models.BooleanField(default=False)
review_time=models.TimeField(auto_now=False, default=datetime.datetime.now().time())
review_date=models.DateField(auto_now=False, default=datetime.date.today())
Time=models.TimeField(auto_now=True)
Date=models.DateField(auto_now=True)
upvote_count=models.IntegerField(default=0)
like_reviewers = MultiSelectField(default= None)
follow=models.BooleanField(default=False)
class DayTime(models.Model):
day_of_week = models.CharField(max_length=20)
time = models.TimeField()
objects = models.DjongoManager()
def __init__(self, *args, **kwargs):
super().__init__(*args, **kwargs)
def __iter__(self):
yield 'day_of_week', self.day_of_week
yield 'time', self.time
class Episode(models.Model):
series = models.ForeignKey(Series, on_delete=models.CASCADE)
episode_id = models.IntegerField()
episode_name = models.CharField(max_length=255)
episode_length = models.TimeField()
episode_date = models.DateField()
episode_link = models.URLField() #! Should use file field
episode_rating = models.IntegerField()
review = models.ForeignKey(Review, on_delete=models.CASCADE)
def __str__(self):
return self.episode_name
class Abstract_Reading_Collection(models.Model):
_id = models.AutoField(primary_key=True, null=False)
rack = models.IntegerField()
sensor = models.IntegerField()
sensor_type = models.CharField(max_length=15)
sensor_value = models.IntegerField()
datetime = models.IntegerField()
date = models.DateField()
time = models.TimeField()
class Meta:
abstract = True
class UserDetails(models.Model):
usrId = models.TextField()
usrName = models.TextField()
usrFirstName = models.TextField()
usrLastName = models.TextField()
usrMail = models.EmailField()
usrImage = models.ImageField()
usrPassword = models.TextField()
usrCreated = models.TimeField() #models.DateTimeField()
def __str__(self):
return self.usrName
class Product(models.Model):
name = models.CharField(unique=True, max_length=255, null=False)
category = models.CharField(max_length=255, null=False)
price = models.FloatField(max_length=17, null=False)
sku = models.CharField(max_length=13,
help_text="Enter Product Stock Keeping Unit")
subcategory = models.ForeignKey(SubCategory, on_delete=models.CASCADE)
quantity = models.FloatField(help_text="Enter Product Quantity")
discription = models.CharField(max_length=255, null=False)
created_date = models.TimeField(default=timezone.now)
last_updated = models.TimeField(default=timezone.now, editable=True)
image = models.ImageField(upload_to='app/', blank=True, null=True)
buffer_stock = models.FloatField(help_text="Enter Product Quantity")
class Meta:
db_table = "product"
def __str__(self):
return " {} - {} - {} - {} - {} - {} - {} - {} - {} - {} - {}".format(
self.name, self.category, self.price, self.sku, self.quantity,
self.discription, self.subcategory, self.created_date,
self.last_updated, self.image, self.buffer_stock)
class Events(models.Model):
org_id = models.CharField(max_length=20)
event_name = models.CharField(max_length=50, blank=False)
e_date = models.DateField(blank=False)
Venue = models.CharField(max_length=20)
E_ptime_s = models.TimeField(auto_now=False)
E_ptime_e = models.TimeField(auto_now=False)
optional = models.BooleanField()
slot1 = models.ArrayModelField(model_container=SlotF)
slot2 = models.ArrayModelField(model_container=SlotF)
Venue_s = models.CharField(max_length=20)
rp = models.CharField(max_length=50, blank=False)
organi_names = models.ArrayModelField(model_container=OrganiList,
null=True)
enotes = models.TextField()
active_stat = models.BooleanField()
objects = models.DjongoManager()
def __str__(self):
return self.event_name
class neutron_log(models.Model):
id = models.IntegerField(primary_key=True)
date = models.DateField()
time = models.TimeField()
host_name = models.TextField()
agent_name = models.TextField()
priority = models.TextField()
agent_details = models.TextField()
request_details = models.TextField()
remaining_log = models.TextField()
def __str__(self):
return '%s %s %s %s %s %s %s %s %s' % (
self.id, self.date, self.time, self.host_name, self.agent_name,
self.priority, self.agent_details, self.request_details,
self.remaining_log)
class horizon_log(models.Model):
id = models.IntegerField(primary_key=True)
remote_host = models.TextField()
date = models.DateField()
time = models.TimeField()
zone = models.IntegerField()
method = models.CharField(max_length=100)
browser_path = models.TextField()
apache_status = models.IntegerField()
data_transfer = models.IntegerField()
message = models.TextField()
def __str__(self):
return '%s %s %s %s %s %s %s %s %s %s' % (
self.id, self.remote_host, self.date, self.time, self.zone,
self.method, self.browser_path, self.apache_status,
self.data_transfer, self.message)
