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 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 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 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 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 NewStyleIndexesTestModel(models.Model):
f1 = models.IntegerField()
f2 = models.IntegerField()
f3 = models.IntegerField()
db_index = models.IntegerField(db_index=True)
unique = models.IntegerField(unique=True)
custom_column = models.IntegerField(db_column='custom')
geo = models.IntegerField()
geo_custom_column = models.IntegerField(db_column='geo')
dict1 = DictField()
dict_custom_column = DictField(db_column='dict_custom')
embedded = EmbeddedModelField(CustomColumnEmbeddedModel)
embedded_list = ListField(EmbeddedModelField(CustomColumnEmbeddedModel))
class Meta:
unique_together = [('f2', 'custom_column'), ('f2', 'f3')]
class MongoMeta:
indexes = [
[('f1', -1)],
{'fields': 'f2', 'sparse': True},
{'fields': [('custom_column', -1), 'f3']},
[('geo', '2d')],
{'fields': [('geo_custom_column', '2d'), 'f2'], 'min': 42, 'max': 21},
{'fields': [('dict1.foo', 1)]},
{'fields': [('dict_custom_column.foo', 1)]},
{'fields' :[('embedded.a', 1)]},
{'fields' :[('embedded_list.a', 1)]},
]
class MediaScan(models.Model):
channel_id = models.CharField(max_length=100)
channel_name = models.CharField(max_length=100)
link = models.CharField(max_length=500)
headline = models.CharField(max_length=500)
summary = models.CharField(max_length=500)
content = models.CharField(max_length=10000)
content_en = models.CharField(max_length=10000)
language = models.CharField(max_length=50, default="English")
author_id = models.CharField(max_length=100, null=True)
author_name = models.CharField(max_length=100, null=True)
created_at = models.DateTimeField(null=True, blank=True)
api_sentiment_pair_keywords = ListField(DictField())
api_sentiment_pair_all = ListField(DictField())
keyword_list = ListField(models.CharField(max_length=100))
category = ListField(models.CharField(max_length=100))
news_type = ListField(models.CharField(max_length=100))
user_sentiment_pair_keyword = ListField(DictField())
user_sentiment_pair_leader = ListField(DictField())
user_sentiment_pair_party = ListField(DictField())
segmentation = ListField(models.CharField(max_length=100))
district = ListField(models.CharField(max_length=100))
author_inclination_party = ListField(DictField())
author_inclination_leader = ListField(DictField())
media_inclination_party = ListField(DictField())
media_inclination_leader = ListField(DictField())
edit_log = ListField(DictField())
added_by = models.CharField(max_length=100)
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 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 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 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 DocumentSenat(models.Model):
deposition_date = models.CharField(max_length=1337)
type = DictField()
comments = DictField()
ending_date = models.CharField(max_length=1337)
author = models.CharField(max_length=1337)
pdf = EmbeddedModelField('DocumentSenatPdf')
comments = DictField()
status = DictField()
other_pdfs = ListField(EmbeddedModelField('OtherDocumentSenatPdf'))
class AnnualReport(models.Model, Jsonify):
current = models.BooleanField(default=True)
creation_datetime = models.DateTimeField(default=datetime.now)
title = DictField()
date = models.CharField(max_length=1337)
law_and_article = DictField()
periodicity = models.CharField(max_length=1337)
pdf_url = models.URLField()
with_history = models.Manager()
objects = HistoryManager()
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"
class Venue(models.Model):
_id = models.CharField(max_length=255, unique=True)
name = models.CharField(null=True, blank=True, max_length=255)
contact = DictField()
location = DictField()
# location = EmbeddedModelField(Location)
categories = ListField()
verified = models.BooleanField()
date = models.DateTimeField(auto_now_add=True)
objects = MongoDBManager()
class BookingsBackup(models.Model):
# booking_flag = True if booking else False if lead
booking_flag = models.BooleanField()
booking_id = models.IntegerField()
booking_timestamp = models.CharField(max_length=200)
cust_id = models.CharField(max_length=200)
cust_name = models.CharField(max_length=200)
cust_make = models.CharField(max_length=200)
cust_model = models.CharField(max_length=200)
cust_vehicle_type = models.CharField(max_length=200)
cust_fuel_varient = models.CharField(max_length=200)
cust_regnumber = models.CharField(max_length=200, null=True)
cust_number = models.CharField(max_length=200)
cust_email = models.CharField(max_length=200)
cust_address = models.CharField(max_length=200)
cust_locality = models.CharField(max_length=200)
cust_city = models.CharField(max_length=200)
service_items = ListField(DictField())
price_total = models.CharField(max_length=200)
price_labour = models.CharField(max_length=200, null=True)
price_part = models.CharField(max_length=200, null=True)
price_discount = models.CharField(max_length=200, null=True)
date_booking = models.DateField()
time_booking = models.CharField(max_length=200)
date_delivery = models.DateField(null=True)
is_paid = models.BooleanField()
amount_paid = models.CharField(max_length=200, null=True)
coupon = models.CharField(max_length=200, null=True)
status = models.CharField(max_length=200)
comments = models.CharField(max_length=500, null=True)
jobssummary = ListField(DictField())
# Price Job Item
source = models.CharField(max_length=200, null=True)
agent = models.CharField(max_length=200, null=True)
estimate_history = ListField(DictField())
customer_notes = models.CharField(max_length=500, null=True)
booking_user_type = models.CharField(max_length=500,
default="User",
null=True)
booking_user_name = models.CharField(max_length=200)
booking_user_number = models.CharField(max_length=200)
clickgarage_flag = models.BooleanField(default=True)
booking_owner = models.CharField(max_length=200, default="ClickGarage")
odometer = models.CharField(max_length=200, null=True)
escalation_flag = models.BooleanField(default=False)
bill_id = models.CharField(max_length=200)
bill_generation_flag = models.BooleanField(default=False)
payment_status = models.CharField(max_length=200)
feedback_1 = models.BooleanField(default=False)
feedback_2 = models.BooleanField(default=False)
follow_up_date = models.DateField(null=True)
follow_up_time = models.TimeField(null=True)
follow_up_status = ListField(DictField())
class TestFieldModel(models.Model):
title = models.CharField(max_length=200)
mlist = ListField()
mlist_default = ListField(default=["a", "b"])
mdict = DictField()
mdict_default = DictField(default={"a": "a", 'b': 1})
class MongoMeta:
index_together = [{'fields': [('title', False), 'mlist']}]
def __unicode__(self):
return "Test special field model: %s" % (self.title)
class DocumentChambre(models.Model):
deposition_date = models.CharField(max_length=1337)
type = DictField()
taken_in_account_date = models.CharField(max_length=1337)
distribution_date = models.CharField(max_length=1337)
sending_date = models.CharField(max_length=1337)
ending_date = models.CharField(max_length=1337)
status = DictField()
authors = ListField()
comments = DictField()
pdf = EmbeddedModelField('DocumentChambrePdf')
other_pdfs = ListField(EmbeddedModelField('OtherDocumentChambrePdf'))
joint_pdfs = ListField()
class Person(models.Model):
facebook_id = models.CharField(max_length=20)
friends = DictField()
history = DictField()
lost_friends = DictField()
new_friends = DictField()
access_token = models.TextField(default='')
access_token_expires_at = models.DateTimeField(auto_now_add=True)
updated_at = models.DateTimeField(auto_now=True)
created_at = models.DateTimeField(auto_now_add=True)
class TestFieldModel(models.Model):
title = models.CharField(max_length=200)
mlist = ListField()
mlist_default = ListField(default=["a", "b"])
slist = ListField(ordering=lambda x: x)
slist_default = ListField(default=["b", "a"], ordering=lambda x: x)
mdict = DictField()
mdict_default = DictField(default={"a": "a", 'b': 1})
mset = SetField()
mset_default = SetField(default=set(["a", 'b']))
class MongoMeta:
index_together = [{'fields': [('title', -1), 'mlist']}]
class MediaChannel(models.Model):
media_name = models.CharField(max_length=200)
article_type = models.CharField(max_length=200)
rss_feed = ListField(DictField())
inclination_party = ListField(DictField())
inclination_leader = ListField(DictField())
is_active = models.BooleanField(default=True)
title_str_name = models.CharField(max_length=50, null=True)
author_str_name = models.CharField(max_length=50, null=True)
summary_str_name = models.CharField(max_length=50, null=True)
link_str_name = models.CharField(max_length=50, null=True)
pubdate_str_name = models.CharField(max_length=50, null=True)
page_content_str = models.CharField(max_length=50, null=True)
author_content_str = models.CharField(max_length=50, null=True)
language = models.CharField(max_length=50)
class PE(models.Model):
name = models.TextField()
compile_time = models.DateField()
imphash = models.TextField()
imports = ListField(EmbeddedModelField('PE_Ports'))
exports = ListField(EmbeddedModelField('PE_Ports'))
sections = ListField()
machine = models.TextField()
entrypoint = models.TextField()
is_dll = models.BooleanField(default=False)
subsystem = models.TextField()
sub = ListField(EmbeddedModelField('PE_Sub'))
version_info = DictField()
signature = DictField()
packer = ListField()
class TestProfile(TestStructure):
profile_name = models.CharField(max_length=100)
edit_log = ListField(DictField())
created_by = models.ForeignKey(CAUsers,
on_delete=models.SET_NULL,
null=True)
section = models.ForeignKey(Sections, on_delete=models.SET_NULL, null=True)
class InstagramUsers(models.Model):
instagram_handle = models.CharField(max_length=100)
instagram_id = models.CharField(max_length=100)
instagram_followers = models.CharField(max_length=100)
# instagram_following = models.CharField(max_length=100)
instagram_following_list = ListField(DictField())
followers_scraped = models.BooleanField(default=False)
class Hostels(models.Model):
name = models.TextField()
contactNo = models.IntegerField(null=True)
avgRating = models.IntegerField()
rating = DictField(null=True)
gmapsReference = models.TextField()
ownerName = models.TextField(default="Techie")
address = models.TextField()
latitude = models.FloatField()
longitude = models.FloatField()
rentMin = models.IntegerField(null=True)
rentMax = models.IntegerField(null=True)
rentDesc = models.TextField(null=True)
gender = models.TextField(null=True)
miscellaneous = DictField(null=True)
regBy = models.TextField(default="admin")
class Album(models.Model):
album_title = models.CharField(max_length=255, null=False)
album_url = models.CharField(max_length=255, null=False)
artist_object = models.CharField(max_length=255, null=False)
track_list = ListField()
lyric_stats = DictField()
album_image = models.CharField(max_length=255, null=False)
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 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 Recipe(models.Model):
_DATABASE = "records"
title = models.CharField(max_length=20)
recipe = models.TextField()
author = DictField()
reviews = ListField(EmbeddedModelField('Review'))
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()
