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()