class airlineontime(Model): # __keyspace__ = 'thirdeye_test' __table_name__ = 'airlineontime' id = columns.UUID(primary_key=True) crsdeptime = columns.Integer() crsarrtime = columns.Integer() flight_date = columns.Date() reporting_airline = columns.Text() tail_number = columns.Text() originairportid = columns.Integer() destairportid = columns.Integer() carriername = columns.Text() manufacturer = columns.Text() aircraft_issue_date = columns.Date() aircraft_model = columns.Text() aircraft_type = columns.Text() aircraft_engine = columns.Text() origincityname = columns.Text() depdel15 = columns.Integer() arrdel15 = columns.Integer() carrierdelay = columns.Integer() weatherdelay = columns.Integer() nasdelay = columns.Integer() securitydelay = columns.Integer() lateaircraftdelay = columns.Integer() close = columns.Decimal()
class MahalCalendar(DjangoCassandraModel): id = columns.UUID(primary_key=True) cid = columns.UUID(primary_key=True) from_date= columns.Date(primary_key=True) to_date= columns.Date(primary_key=True) booker_name=columns.Text() amount=columns.Integer() rent_hr = columns.Integer() status=columns.Text(default='pending') class Meta: get_pk_field='id'
class doorsecurity(Model): id = columns.Integer(primary_key=True) createtime = columns.DateTime() modifytime = columns.DateTime() enable = columns.Boolean() group = columns.Text(index=True) domain = columns.Text(index=True) start_date = columns.Date() end_date = columns.Date() work_day = columns.Text() begin_time = columns.Text() end_time = columns.Text()
class SectionCours(Model): __table_name__ = 'section_cours' code_session = columns.Text(primary_key=True, partition_key=True) nrc = columns.Text(primary_key=True, partition_key=True) titre = columns.Text(required=True) sigle_matiere = columns.Text(required=True) numero_cours = columns.Text(required=True) date_debut = columns.Date() date_fin = columns.Date() inscriptions = columns.Set(value_type=columns.BigInt()) enseignants = columns.Set(value_type=columns.BigInt())
class URLModels(DjangoCassandraModel): url_id = columns.UUID(primary_key=True, default=uuid.uuid4) original_url = columns.Text() creation_date = columns.Date() expiration_date = columns.Date() user_id = columns.Text() hits = columns.Integer(default=0) def get_short_url(self): url_ = self.original_url result = base64.b64encode(hashlib.sha1(url_)) return result def decode_url(self, str1): return base64.b64decode(str1)
class ControlAction(Model): date = columns.Date(required = True, partition_key = True) time = columns.Time(required = True, primary_key = True) mac_address = columns.Bytes(required = True, primary_key = True) user_id = columns.Bytes(required = True, primary_key = True) command = columns.Text(required = True) params = columns.Text() result = columns.Text() def validate(self): super(ControlAction, self).validate() validate_mac_address(self.mac_address) validate_user_id(self.user_id) @staticmethod def validate_mac_address(id): if len(id) != 6: raise ValidationError('not a valid mac address') return id @staticmethod def validate_user_id(id): if len(id) != 12 or not mongo_adapter.is_valid_foreign_id(PEOPLE_COLLECTION_NAME, id.hex()): raise ValidationError('not a valid user id') return id
class main(Model): product_type = columns.Ascii(primary_key=True) date = columns.Date(primary_key=True) product_id = columns.Ascii(primary_key=True) parameters = columns.Map(columns.Ascii(), columns.Map(columns.Ascii(), columns.Ascii()))
class CrimeRecord(DjangoCassandraModel): __table_name = "crime_record" __keyspace__ = "dis_test1" crime_id = columns.Text(primary_key=True, required=False) court = columns.Text(required=False) potema = columns.Text(required=False) penalty = columns.Text(required=False) criminal_name = columns.Text(required=False) criminal_nrc = columns.Text(required=False) time = columns.Date(required=False) tayalo_name = columns.Text(required=False) tayalo_nrc = columns.Text(required=False) street = columns.Text(required=False) city = columns.Text(required=False) number = columns.Text(required=False) ward = columns.Text(required=False) township = columns.Text(required=False) def __str__(self): return '%s %s %s' % (self.criminal_nrc, self.criminal_name, self.potema) class Meta: db_table = "crime_record" def address_approval(self): return '%s %s %s' % (self.nrc, self.name, self.father_name)
class TestModel(DjangoCassandraModel): __table_name = "test_model" __keyspace__ = "dis_test" nrc = columns.Text(primary_key=True, required=False) name = columns.Text(required=False) occupation = columns.Text(required=False) labour_id = columns.Text(index=True) race = columns.Text(required=False) religion = columns.Text(required=False) father_name = columns.Text(required=False) father_nrc = columns.Text(required=False) marital_status = columns.Boolean(required=False) dob = columns.Date(required=False) spouse_name = columns.Text(required=False) spouse_nrc = columns.Text(required=False) street = columns.Text(required=False) city = columns.Text(required=False) home_no = columns.Text(required=False) ward = columns.Text(required=False) township = columns.Text(required=False) gender = columns.Text(required=False) def __str__(self): return '%s %s %s' % (self.nrc, self.name, self.race) class Meta: db_table = "test_model" def address_approval(self): return '%s %s %s' % (self.nrc, self.name, self.father_name, self.street, self.ward, self.home_no, self.township)
class MessageData(Model): node_id = columns.Text(partition_key=True) date = columns.Date(partition_key=True) topic = columns.Text(primary_key=True) created_at = columns.DateTime(primary_key=True) received_at = columns.DateTime(required=True) body = columns.Blob(required=True)
class Planets(m.Model): __keyspace__ = "swapi" __connection__ = "swapi" id = col.BigInt(primary_key=True) name = col.Text(max_length=96) diameter = col.Text(max_length=16) rotation_period = col.Text(max_length=16) orbital_period = col.Text(max_length=16) gravity = col.Text(max_length=96) population = col.Text(max_length=32) climate = col.Text(max_length=96) terrain = col.Text(max_length=96) surface_water = col.Text(max_length=16) residents = col.Set(col.BigInt) films = col.Set(col.BigInt) created = col.Date() edited = col.Date()
class Films(m.Model): __keyspace__ = "swapi" __connection__ = "swapi" id = col.BigInt(primary_key=True) episode_id = col.Integer(index=True) title = col.Text(index=True) director = col.Text(max_length=96) producer = col.Text(max_length=96) release_date = col.Date() opening_crawl = col.Text() species = col.Set(col.BigInt) starships = col.Set(col.BigInt) vehicles = col.Set(col.BigInt) characters = col.Set(col.BigInt) planets = col.Set(col.BigInt) created = col.Date() edited = col.Date()
class ThreeOneOneDataset(Model): __keyspace__ = 'spardata' __connection__ = 'cluster1' date = columns.Date(primary_key=True, required=True) unique_key = columns.Integer(primary_key=True, required=True) year = columns.Integer(required=False) month = columns.Integer(required=False) complaint_type = columns.Text(required=True) descriptor = columns.Text(required=False)
class SensorData(Model): node_id = columns.Text(partition_key=True) date = columns.Date(partition_key=True) created_at = columns.DateTime(primary_key=True) received_at = columns.DateTime() plugin_id = columns.Text(primary_key=True) topic = columns.Text() data = columns.Blob()
class airlineontime_delaytype(Model): __keyspace__ = 'thirdeye_test' __table_name__ = 'airlineontime_delaytype' id = columns.UUID(primary_key=True) year = columns.Integer() quarter = columns.Integer() month = columns.Integer() dayofmonth = columns.Integer() dayofweek = columns.Integer() flight_date = columns.Date() crsdeptime = columns.Integer() actualdeptime = columns.Integer() depdelay = columns.Integer() depdelayminutes = columns.Integer() crsarrtime = columns.Integer() actualarrtime = columns.Integer() arrdelay = columns.Integer() arrdelayminutes = columns.Integer() reporting_airline = columns.Text() tail_number = columns.Text() originairportid = columns.Integer() destairportid = columns.Integer() carriername = columns.Text() manufacturer = columns.Text() aircraft_issue_date = columns.Date() aircraft_model = columns.Text() aircraft_type = columns.Text() aircraft_engine = columns.Text() origincityname = columns.Text() originstatename = columns.Text() originstatecode = columns.Text() destinationcityname = columns.Text() destinationstatename = columns.Text() destinationstatecode = columns.Text() depdel15 = columns.Integer() arrdel15 = columns.Integer() cancelled = columns.Integer() carrierdelay = columns.Integer() weatherdelay = columns.Integer() nasdelay = columns.Integer() securitydelay = columns.Integer() lateaircraftdelay = columns.Integer() close = columns.Decimal() ownership = columns.Text()
class People(m.Model): __keyspace__ = "swapi" __connection__ = "swapi" id = col.BigInt(primary_key=True) name = col.Text(max_length=96) height = col.Text(max_length=16) mass = col.Text(max_length=16) skin_color = col.Text(max_length=16) eye_color = col.Text(max_length=16) birth_year = col.Text(max_length=16) gender = col.Text(max_length=16) homeworld = col.BigInt() films = col.Set(col.BigInt) species = col.Set(col.BigInt) starships = col.Set(col.BigInt) vehicles = col.Set(col.BigInt) created = col.Date() edited = col.Date()
class Species(m.Model): __keyspace__ = "swapi" __connection__ = "swapi" id = col.BigInt(primary_key=True) name = col.Text(max_length=96) classification = col.Text(max_length=96) designation = col.Text(max_length=96) average_height = col.Text(max_length=16) average_lifespan = col.Text(max_length=16) eye_colors = col.Text(max_length=96) hair_colors = col.Text(max_length=96) skin_colors = col.Text(max_length=96) language = col.Text(max_length=96) homeworld = col.BigInt() people = col.Set(col.BigInt) films = col.Set(col.BigInt) created = col.Date() edited = col.Date()
class CateringBoyOrder(DjangoCassandraModel): id = columns.UUID(primary_key=True, default=uuid.uuid4) cid = columns.UUID() venue = columns.Map(columns.Text(), columns.Text()) amount = columns.Integer(default=300) catboy_max = columns.Integer(default=0) timing = columns.Time(default=Time('19:00:00')) date = columns.Date( default=Date(datetime.date.today().strftime("%Y-%m-%d"))) count = columns.Integer(default=0)
class StockDataset(Model): __keyspace__ = 'spardata' __connection__ = 'cluster1' exchange = columns.Text(primary_key=True, required=True) symbol = columns.Text(primary_key=True, required=True) avg = columns.Double(required=True) date = columns.Date(primary_key=True, required=True) open = columns.Double(required=True) close = columns.Double(required=True) high = columns.Double(required=True)
class fsa_user(DjangoCassandraModel): # idsite = columns.Text(primary_key=True) # login = columns.Text(required=False) # name = columns.Text(required=False) # password = columns.Text(required=True) # url = columns.Text(required=False) login = columns.Text(primary_key=True) alias = columns.Text(required=False) date_registered = columns.Date() email = columns.Text(required=False) password = columns.Text(required=False)
class WeatherDataset(Model): __keyspace__ = 'spardata' __connection__ = 'cluster1' year = columns.Integer(primary_key=True, required=True) month = columns.Integer(primary_key=True, required=True) date = columns.Date(primary_key=True, required=True) station_location = columns.Text(primary_key=True, required=True) tmin = columns.Double(required=False, default=None) tmax = columns.Double(required=False, default=None) tavg = columns.Double(required=False, default=None) prcp = columns.Boolean(required=False, default=False)
class StockWeather311(Model): __keyspace__ = 'spardata' __connection__ = 'cluster1' date = columns.Date(primary_key=True, required=True) stock_deviation = columns.Double(required=True) prcp = columns.Boolean(required=True, default=False) all_complaints = columns.Integer(required=False) noise_complaints = columns.Integer(required=False) homeless_complaints = columns.Integer(required=False) tavg = columns.Double(required=False, default=None) tmax = columns.Double(required=False, default=None) tmin = columns.Double(required=False, default=None)
class Starships(m.Model): __keyspace__ = "swapi" __connection__ = "swapi" id = col.BigInt(primary_key=True) cargo_capacity = col.Text(max_length=32) consumables = col.Text(max_length=96) cost_in_credits = col.Text(max_length=32) crew = col.Text(max_length=32) hyperdrive_rating = col.Text(max_length=32) length = col.Text(max_length=32) manufacturer = col.Text(max_length=96) max_atmosphering_speed = col.Text(max_length=32) mglt = col.Text(max_length=96) model = col.Text(max_length=96) name = col.Text(max_length=96) passengers = col.Text(max_length=16) starship_class = col.Text(max_length=96) films = col.Set(col.BigInt) pilots = col.Set(col.BigInt) created = col.Date() edited = col.Date()
class CateringServiceOrder(DjangoCassandraModel): receiver_id = columns.UUID(primary_key=True) booker_id = columns.UUID(primary_key=True) reg_type = columns.Text(primary_key=True) date = columns.Date(primary_key=True, default=Date( datetime.date.today().strftime("%Y-%m-%d"))) amount = columns.Integer() plates = columns.Integer() foodlist = columns.Map(columns.Text, columns.List(columns.Text)) address = columns.Text() status = columns.Text() class Meta: get_pk_field = 'receiver_id'
class AllDatatypes(UserType): a = columns.Ascii() b = columns.BigInt() c = columns.Blob() d = columns.Boolean() e = columns.Date() f = columns.DateTime() g = columns.Decimal() h = columns.Float(double_precision=True) i = columns.Inet() j = columns.Integer() k = columns.Text() l = columns.TimeUUID() m = columns.UUID() n = columns.VarInt()
class Semester(Model): __keyspace__ = 'infs3208' year = columns.Integer(primary_key=True) semester = columns.Integer(primary_key=True) active = columns.Boolean(custom_index=True) weeks = columns.Map(columns.Integer(), columns.Date()) def serialise(self) -> {}: return { 'year': self.year, 'semester': self.semester, 'active': self.active, 'weeks': {week: str(date) for (week, date) in self.weeks.items()} }
class AllDatatypesModel(Model): id = columns.Integer(primary_key=True) a = columns.Ascii() b = columns.BigInt() c = columns.Blob() d = columns.Boolean() e = columns.Date() f = columns.DateTime() g = columns.Decimal() h = columns.Double() i = columns.Float(double_precision=False) j = columns.Inet() k = columns.Integer() l = columns.Text() m = columns.TimeUUID() n = columns.UUID() o = columns.VarInt()
class Clean_Daily_Measurement(Model): station_id = columns.Text(primary_key=True, required=True) #indicativo measure_date = columns.Date(primary_key=True, required=True) #fecha max_temp_hour = columns.Text(required=False) #horatmax min_temp_hour = columns.Text(required=False) #horatmin max_temp = columns.Decimal(required=False, index=True) #tmax med_temp = columns.Decimal(required=False) #tmed min_temp = columns.Decimal(required=False, index=True) #tmin max_press_hour = columns.Text(required=False) #horaPresMax min_press_hour = columns.Text(required=False) #horaPresMin max_pressure = columns.Decimal(required=False, index=True) #presMax min_pressure = columns.Decimal(required=False, index=True) #presMin precip = columns.Decimal(required=False, index=True) #prec wind_med_vel = columns.Decimal(required=False, index=True) #velmedia wind_dir = columns.Text(required=False) #dir wind_streak = columns.Decimal(required=False, index=True) #racha wind_streak_hour = columns.Text(required=False) #horaracha insolation = columns.Decimal(required=False, index=True) #sol
class ShiftState(Model): date = columns.Date(required=True, partition_key=True) time = columns.Time(required=True, primary_key=True) shift_id = columns.Bytes(required=True) warning_level = columns.Text(required=True) remaining_cartridges = columns.TinyInt(required=True) remaining_air = columns.TinyInt(required=True) remaining_electricity = columns.TinyInt(required=True) comment = columns.Text() def validate(self): super(ShiftState, self).validate() ShiftState.validate_shift_id(self.shift_id) ShiftState.validate_warning_level(self.warning_level) ShiftState.validate_remaining_quantity(self.remaining_cartridges, 'remaining cartridges') ShiftState.validate_remaining_quantity(self.remaining_air, 'remaining air') ShiftState.validate_remaining_quantity(self.remaining_electricity, 'remaining electricity') @staticmethod def validate_shift_id(shift_id): if len(shift_id) != 16 or not neo4j_adapter.is_valid_foreign_id( 'Shift', shift_id.hex()): raise ValidationError('not a valid shift id') return shift_id @staticmethod def validate_warning_level(warning_level): if warning_level not in WARNING_LEVELS: raise ValidationError('not a warning level') return warning_level @staticmethod def validate_remaining_quantity(remaining_quantity, message): if remaining_quantity < 0 or remaining_quantity > 100: raise ValidationError('not a valid {0} value'.format(message)) return remaining_quantity
class Turnos(Base): id = columns.UUID(primary_key=True, default=uuid.uuid4) nro_turno = columns.Text(default='A1') fecha = columns.Date() hora = columns.Time() medico_cin = columns.Text() persona_cin = columns.Text() estado = columns.Boolean(default=True) def get_data(self): return { 'id': str(self.id), 'nro_turno': self.nro_turno, 'fecha': self.fecha, 'hora': self.hora, 'medico': self.medico_cin, 'persona': self.persona_cin, 'estado': self.estado }