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
}
