class Services(models.Model):
city = models.CharField(max_length=200)
vendor = models.CharField(max_length=200)
car_bike = models.CharField(max_length=50)
service_cat = models.CharField(max_length=200)
job_name = models.CharField(max_length=200)
job_sub_cat = models.CharField(max_length=200)
type = models.CharField(max_length=200)
total_price = models.FloatField(max_length=50)
total_price_comp = models.FloatField(max_length=50)
doorstep = models.CharField(max_length=200)
year = models.CharField(max_length=50)
fuel_type = models.CharField(max_length=50)
full_veh_name = models.CharField(max_length=200)
aspect_ratio = models.CharField(max_length=20)
job_summary = ListField(models.CharField(max_length=200))
job_desc = models.CharField(max_length=500)
job_symptoms = ListField(models.CharField(max_length=200))
job_features = ListField(models.CharField(max_length=200))
time = models.CharField(max_length=200)
price_active = models.CharField(max_length=20)
priority = models.CharField(max_length=50)
make = models.CharField(max_length=50)
model = models.CharField(max_length=50)
default_components = ListField(DictField())
optional_components = ListField(DictField())
discount = models.CharField(max_length=50)
total_part = models.FloatField(max_length=50, null=True)
total_labour = models.FloatField(max_length=50, null=True)
total_discount = models.FloatField(max_length=50, null=True)
class NewsFeedAll(models.Model):
channel_name = models.CharField(max_length=100)
article_type = models.CharField(max_length=200)
channel_id = models.CharField(max_length=100, null=True)
author_id = models.CharField(max_length=100, null=True)
feedtype = models.CharField(max_length=200)
link = models.CharField(max_length=500)
headline = models.CharField(max_length=500)
summary = models.CharField(max_length=500)
content = models.CharField(max_length=10000)
author = models.CharField(max_length=100)
created_at = models.DateTimeField()
segmentation = ListField(models.CharField(max_length=100))
api_sentiment_pair_headline = ListField(DictField())
api_sentiment_pair_content = ListField(DictField())
keyword_list = ListField(models.CharField(max_length=100))
category = ListField(models.CharField(max_length=100))
keyword_searched = models.BooleanField(default=False)
keyword_found = models.BooleanField(default=False)
# keyword_synonym = ListField(models.CharField(max_length=100))
marked_important = models.BooleanField(default=False)
language = models.CharField(max_length=500)
relevance_score = models.CharField(max_length=10, default="0")
# news_state = models.CharField(max_length=200)
state_found = models.BooleanField(default=False)
state_searched = models.BooleanField(default=False)
class RentalProperty(models.Model):
# Details
name = models.TextField()
address = models.TextField() # Not always available
latitude = models.DecimalField(max_digits=10, decimal_places=8)
longitude = models.DecimalField(max_digits=11, decimal_places=8)
offered_by = models.TextField(null=True)
description = ListField()
# Dates
date_available = models.DateField()
post_date = models.DateTimeField() # Only applicable for certain websites
# Costs
rent_price = models.DecimalField(max_digits=20, decimal_places=2)
application_fee = models.DecimalField(max_digits=10,
decimal_places=2,
null=True)
security_deposit = models.DecimalField(max_digits=10,
decimal_places=2,
null=True)
# Features
size = models.DecimalField(max_digits=12, decimal_places=2, null=True)
bedrooms = models.IntegerField()
bathrooms = models.IntegerField()
amenities = ListField(
null=True) # Interrelated with description; text parsing methods?
tags = ListField()
# URL Data
listing_url = models.TextField()
class Context(models.Model):
site = models.OneToOneField(Site, related_name='site')
local_site = models.OneToOneField(Site,
related_name='local_site',
null=True,
blank=True)
top_rated = ListField()
newest = ListField()
user_refs = DictField()
failed_cdrs = ListField()
payouts_n = models.IntegerField(default=0)
def is_valid_currency(self, currency):
"""
Checks that a currency is valid for WStore
"""
valid = False
if 'allowed' in self.allowed_currencies and len(
self.allowed_currencies['allowed']) > 0:
for c in self.allowed_currencies['allowed']:
if c['currency'].lower() == currency.lower():
valid = True
break
return valid
class Customer(AbstractWatchModel):
"""
Profile information for a Buyer on whatever retail website
:attr:delivery_cities : List of delivery cities subsequently set by client. The last in the list is the current
:attr:delivery_addresses : List of delivery addresses subsequently set by client. The last in the list is the current
"""
member = models.OneToOneField(Member)
referrer = models.ForeignKey(Service,
blank=True,
null=True,
related_name='+')
delivery_addresses = ListField(
EmbeddedModelField('shopping.DeliveryAddress'))
last_payment_on = models.DateTimeField(blank=True,
null=True,
db_index=True)
orders_count_history = ListField()
items_purchased_history = ListField()
turnover_history = ListField()
earnings_history = ListField()
total_orders_count = models.IntegerField(default=0)
total_items_purchased = models.IntegerField(default=0)
total_turnover = models.IntegerField(default=0)
total_earnings = models.IntegerField(default=0)
class Course(DateStamped):
"""
This model represents a Course offered at a university of college.
"""
name = models.CharField(max_length=255) # Course Name
description = models.CharField(max_length=1023) # Course Description
institution = models.ForeignKey('Institution',
related_name="Courses_Institution"
) # the institution offering this course
url = models.URLField(verify_exists=True,
max_length=255,
blank=True,
default="") # a url for this course. (optional)
department = ListField(models.CharField(
max_length=100)) # a list of this course's departments.
teacher = ListField(models.CharField(max_length=200))
teacher_lastname = ListField(models.CharField(max_length=(200)))
# Not sure if this is the best way to store this
teacher_ids = ListField(models.IntegerField(
)) # a list of ids of teacher models teaching this course
# This part is for temporary storing averaging ratings
overall_avg = models.FloatField(default=0.0)
grading_avg = models.FloatField(default=0.0)
teaching_avg = models.FloatField(default=0.0)
def __unicode__(self):
"""
This method defines how this class is converted to a string (for example, in the admin interface)
"""
return self.name
class ServiceDealerCatNew(models.Model):
name = models.CharField(max_length=200)
brand = models.CharField(max_length=50)
carname = models.CharField(max_length=50)
type_service = models.CharField(max_length=200)
service_desc = models.CharField(max_length=500)
#year = models.CharField(max_length=50)
dealer_category = models.CharField(max_length=200)
part_dic = ListField(DictField())
part_replacement = ListField(models.CharField(max_length=200))
# while uploading part frequency
price_parts = models.CharField(max_length=50)
price_labour = models.CharField(max_length=50)
wheel_alignment = models.CharField(max_length=50)
wheel_balancing = models.CharField(max_length=50)
# WA_WB_Inc = models.CharField(max_length=50)
detail_dealers = ListField(DictField())
#paid_free = models.CharField(max_length=50)
regular_checks = ListField(models.CharField(max_length=200))
discount = models.CharField(max_length=50)
priority = models.CharField(max_length=50)
priority_service = models.CharField(max_length=50)
car_bike = models.CharField(max_length=50)
# vas_dic = ListField(DictField())
dry_cleaning = models.CharField(max_length=50)
engine_additive = models.CharField(max_length=50)
injector_cleaning = models.CharField(max_length=50)
rubbing_polishing = models.CharField(max_length=50)
anti_rust = models.CharField(max_length=50)
teflon = models.CharField(max_length=50)
engine_flush = models.CharField(max_length=50)
ac_servicing = models.CharField(max_length=50)
ac_disinfection = models.CharField(max_length=50)
class Organization(models.Model):
name = models.CharField(max_length=50, unique=True)
notification_url = models.CharField(max_length=300, null=True, blank=True)
offerings_purchased = ListField()
rated_offerings = ListField()
private = models.BooleanField(default=True)
correlation_number = models.IntegerField(default=0)
payment_info = DictField()
tax_address = DictField()
managers = ListField()
# The type of the actorId field will depend on the version of the idm API
if settings.FIWARE_IDM_API_VERSION == 1:
actor_id = models.IntegerField(null=True, blank=True)
else:
actor_id = models.CharField(null=True, blank=True, max_length=100)
expenditure_limits = DictField()
def has_rated_offering(self, user, offering):
"""
Check if the user has rated an offering on behalf the
organization
"""
found = False
for rate in self.rated_offerings:
if rate['user'] == user.pk and rate['offering'] == offering.pk:
found = True
break
return found
class Resource(models.Model):
product_id = models.CharField(max_length=100, blank=True, null=True)
version = models.CharField(max_length=20) # This field maps the Product Spec version
provider = models.ForeignKey(Organization)
content_type = models.CharField(max_length=50)
download_link = models.URLField()
resource_path = models.CharField(max_length=100)
old_versions = ListField(EmbeddedModelField(ResourceVersion))
state = models.CharField(max_length=20)
resource_type = models.CharField(max_length=100, blank=True, null=True)
is_public = models.BooleanField(default=False)
has_terms = models.BooleanField(default=False)
meta_info = DictField()
bundled_assets = ListField()
def get_url(self):
return self.download_link
def get_uri(self):
site_context = Context.objects.all()[0]
base_uri = site_context.site.domain
return urljoin(base_uri, 'charging/api/assetManagement/assets/' + self.pk)
class Meta:
app_label = 'wstore'
class QuestionStructure(BaseModel):
question_text = models.CharField(max_length=500)
question_type = models.CharField(max_length=50)
# mcq_single, mcq_multiple, word, number, essay, chooseorder, in_question_drop_down, in_question_word, in_question_number
solution = models.CharField(max_length=500, null=True)
topic = models.ForeignKey(Topics, on_delete=models.SET_NULL, null=True)
total_num_set_answers = models.IntegerField(default=1)
difficulty_user = models.CharField(max_length=1, null=True)
# to_evaluate = models.BooleanField(default=True)
is_passage = models.BooleanField()
passage = models.ForeignKey(Passages, on_delete=models.CASCADE, null=True)
num_correct_answered = models.IntegerField(default=0)
num_total_answered = models.IntegerField(default=0)
answer_options = DictField(null=True)
correct_answer = DictField(null=True)
# is_random_order = models.BooleanField(default=False)
# range 1 to 6
created_by = models.ForeignKey(CAUsers,
on_delete=models.SET_NULL,
null=True)
question_folder = models.ForeignKey(QuestionFolder,
on_delete=models.SET_NULL,
null=True)
is_flagged = models.BooleanField(default=False)
is_live = models.BooleanField(default=False)
tests = ListField()
in_test = models.BooleanField(default=False)
edoola_q_id = models.CharField(max_length=50, null=True)
feedback = ListField()
class Meta:
abstract = True
class User_data(models.Model):
name = models.CharField(max_length=64)
location = models.TextField()
contact = DictField()
education = DictField()
job_category = ListField()
age_range = ListField()
job_years = models.IntegerField(default='0')
personality_color = models.CharField(max_length=64) # blue, red, green, yellow
interest = models.CharField(max_length=256)
programs = ListField()
availability_mentor_per_week = models.IntegerField(default='0')
num_of_mentees = models.IntegerField(default='0')
num_of_mentors = models.IntegerField(default='0')
reputation = models.IntegerField(default='0')
updated_at = models.DateField(default=datetime.date.today)
calendar = models.IntegerField(default='0')
# Update job category
def update_job_category(self, category):
self.job_category = category
self.updated_at = datetime.date.today()
self.save()
# Monthly mantaince
def mantaince(self):
if (datetime.date.today() - self.updated_at).days > 365:
self.job_years += 1
self.save()
class Organization(models.Model):
name = models.CharField(max_length=50, unique=True)
notification_url = models.CharField(max_length=300, null=True, blank=True)
acquired_offerings = ListField()
private = models.BooleanField(default=True)
correlation_number = models.IntegerField(default=0)
tax_address = DictField()
managers = ListField()
actor_id = models.CharField(null=True, blank=True, max_length=100)
expenditure_limits = DictField()
def has_rated_offering(self, user, offering):
"""
Check if the user has rated an offering on behalf the
organization
"""
found = False
for rate in self.rated_offerings:
if rate['user'] == user.pk and rate['offering'] == offering.pk:
found = True
break
return found
class UserPermissionList(models.Model):
user = models.ForeignKey(User)
permission_list = ListField(models.CharField(max_length=64))
permission_fk_list = ListField(models.CharField(max_length=32))
group_fk_list = ListField(models.CharField(max_length=32))
class Report(models.Model):
"""task = models.ForeignKey(
Task,
related_name='task_reports',
primary_key=True,
on_delete=models.DO_NOTHING)
patient = models.ForeignKey(
Profile,
related_name='patient_reports',
on_delete=models.DO_NOTHING)"""
task = models.IntegerField(null=False)
patient = models.IntegerField(null=False)
date = models.DateTimeField(_(u'Fecha del Informe'), null=True)
sex = models.IntegerField(null=True)
blocks = ListField()
education = models.IntegerField(null=True)
marital = models.IntegerField(null=True)
profession = models.CharField(max_length=150)
age = models.IntegerField(null=True)
illnesses = ListField()
treatment = ListField()
variables = DictField()
aves = ListField()
dimensions = DictField()
status = DictField()
objects = MongoDBManager()
class Meta:
db_table = 'reports'
managed = False
class DisciplineTracker(StudentsPopulation):
girls_history = ListField()
boys_history = ListField()
total_history = ListField()
class Meta:
abstract = True
class Song(models.Model):
song_title = models.CharField(max_length=255, null=False)
song_url = models.CharField(max_length=255, null=False)
album_object = models.CharField(max_length=255, null=False)
artist_object = models.CharField(max_length=255, null=False)
external_links = ListField()
song_lyrics = ListField()
lyric_stats = DictField()
class PandingRecord(models.Model):
id = models.AutoField(primary_key=True)
prid = models.ForeignKey(PlayRecord)
name = models.CharField(null=True, max_length=75)
hitcount = models.IntegerField(default=0)
nhitcount = models.IntegerField(default=0)
rhitby = ListField(models.IntegerField())
rnhitby = ListField(models.IntegerField())
def contribute_to_class(self, model, name):
self.__m2m_name = name
# Call Field, not super, to skip Django's ManyToManyField extra stuff
# we don't need
ListField.contribute_to_class(self, model, name)
# Do the rest after resolving the 'to' relation
add_lazy_relation(model, self, self._mm2m_to_or_name,
self.contribute_after_resolving)
class TwitterUsers(models.Model):
twitter_handle = models.CharField(max_length=100)
twitter_followers = models.CharField(max_length=100)
num_likes_last100 = models.CharField(max_length=100)
num_retweets_last100 = models.CharField(max_length=100)
efficiency_quotient = models.CharField(max_length=100)
list_followers = ListField()
list_following = ListField()
class Answer(models.Model):
id = models.AutoField(primary_key=True)
author = models.OneToOneField(User)
publishedDate = models.CharField(max_length=128)
likes = ListField(EmbeddedModelField(User))
answerText = models.TextField()
comments = ListField(EmbeddedModelField('Comment'))
isAccepted = models.IntegerField()
def contribute_to_class(self, model, name):
self.__m2m_name = name
# Call Field, not super, to skip Django's ManyToManyField extra stuff
# we don't need
ListField.contribute_to_class(self, model, name)
# Do the rest after resolving the 'to' relation
add_lazy_relation(model, self, self._mm2m_to_or_name,
self.contribute_after_resolving)
class Movie(models.Model):
created_on = models.DateTimeField(auto_now_add=True)
actors = ListField(EmbeddedModelField('Actor'))
director = EmbeddedModelField('Director')
tags = ListField(EmbeddedModelField('Tag'))
text = models.TextField()
title = models.CharField()
year = models.CharField()
class NeuroToxin(models.Model):
sourceid = models.CharField(max_length=30)
text = models.TextField()
sourcedb = models.CharField(max_length=200)
denotations = ListField()
objtype = ListField()
objects = MongoDBManager()
class Post(models.Model):
created_on = models.DateTimeField(auto_now_add=True, null=True)
title = models.CharField(max_length=100)
text = models.TextField()
tags = ListField()
comments = ListField(EmbeddedModelField('Comment')) # <---
objects = MongoDBManager()
class Exam(models.Model):
name = models.CharField(max_length=50)
lessons = ListField(EmbeddedModelField('Lesson'))
choices = ListField(EmbeddedModelField('Choicesingle'))
readings = ListField(EmbeddedModelField('Reading'))
totalpoints = models.IntegerField(blank=True, default=0)
withtrans = models.BooleanField(default=True)
tag = models.CharField(max_length=50, blank=True, null=True)
class Dealer(models.Model):
name = models.CharField(max_length=200)
address = DictField()
pub_date = models.DateTimeField()
servicing = ListField(DictField())
tyres = ListField(DictField())
wheels = ListField(DictField())
emergency = ListField(DictField())
misc = ListField(DictField())
class Features(Document):
name = StringField(max_length=50)
product_id = ReferenceField(Products)
rating = FloatField(default=0.0)
positive_score = IntField(default=0)
negative_score = IntField(default=0)
probability = FloatField(default=0.0)
top_positive_reviews = ListField(default=["No Reviews"])
top_negative_reviews = ListField(default=["No Reviews"])
class InChargeCommissions(models.Model):
visibility = DictField()
# need to turn that into a EmbeddedModelField(commissions) in the futur
# when the commissions will be parsed
commission = DictField()
rapporters = ListField()
agenda = ListField()
incident = ListField()
rapport = DictField()
class ResumizrUserData(models.Model):
''' misc data for resumizr '''
user = models.OneToOneField(USER_MODEL, related_name='resumizr_data')
detailed_social_data = DictField()
resume_data = DictField()
subscribers = ListField()
following = ListField()
class Meta:
verbose_name_plural = "Resumizr User Data"
verbose_name = "Resumizr User Data"
def __init__(self, to, related_name=None, embed=False, *args, **kwargs):
# Call Field, not super, to skip Django's ManyToManyField extra stuff
# we don't need
self._mm2m_to_or_name = to
self._mm2m_related_name = related_name
self._mm2m_embed = embed
if embed:
item_field = EmbeddedModelField(to)
else:
item_field = None
ListField.__init__(self, item_field, *args, **kwargs)
def __init__(self, to, related_name=None, embed=False, *args, **kwargs):
# Call Field, not super, to skip Django's ManyToManyField extra stuff
# we don't need
self._mm2m_to_or_name = to
self._mm2m_related_name = related_name
self._mm2m_embed = embed
if embed:
item_field = EmbeddedModelField(to)
else:
item_field = None
ListField.__init__(self, item_field, *args, **kwargs)
class Meeting(models.Model):
meetingNumber = models.IntegerField()
startTime = models.TimeField()
endTime = models.TimeField()
room = models.CharField(max_length=25)
buildings = ListField(EmbeddedModelField("Building"))
days = ListField()
def __unicode__(self):
return self.days + u" " + unicode(self.startTime) + u" - " + unicode(
self.endTime)
