class Data(Document):
meta = {'collection': 'data'}
title = StringField(required=True)
url = StringField(required=True)
content = StringField(required=True)
language = StringField(required=True)
score = FloatField(required=True)
class_result = FloatField(required=True)
operation = ListField(EmbeddedDocumentField(Operation))
class LightPollution(Document):
meta = {"collection": "lightpollution"}
ID = ObjectIdField()
sourceposition = ListField()
targetPosition = ListField()
longitude = FloatField()
latitude = FloatField()
class DeviceMeta(Document):
hid = StringField(max_length=100,
primary_key=True) # md5(node_token|device name)
name = StringField(max_length=100)
worker_type = BooleanField(
required=True) # true for input, false for output
min_throughput = FloatField(required=True)
max_throughput = FloatField(required=True)
unit = StringField(max_length=100)
class User(Document):
username = StringField(required=True, unique=True)
email = StringField(required=True, unique=True)
password = StringField(required=True)
watchList = EmbeddedDocumentListField(Stock)
balence = FloatField(default=10000.00)
# ownedStock = EmbeddedDocumentListField(OwnedStock)
totalStockValue = FloatField(default=0.00)
meta = {'ordering': ['+username']}
class Column(EmbeddedDocument):
path = StringField(required=True, help_text="column path in dot-notation")
min = FloatField(required=True,
default=float("nan"),
help_text="column minimum")
max = FloatField(required=True,
default=float("nan"),
help_text="column maximum")
unit = StringField(required=True, default="NaN", help_text="column unit")
class Buybills_payment(Document):
# The Payments of the bills of sale
id = ObjectIdField()
code = LongField(required=True)
total_paid = FloatField(required=True)
total_left = FloatField(required=True)
pay_date = LongField(required=True)
created_by = LongField(required=True)
created_date = LongField(required=True)
class SensorData(gj.Document):
meta = {"collection": "sensor_data"}
meta = {'db_alias': 'db1'}
collect_time = DateTimeField(default=datetime.utcnow)
temperature = FloatField()
humidity = FloatField()
light = IntField()
moisture = IntField()
sensor_uuid = StringField()
class Stocks(Document):
meta = {'collection': 'stocks'}
date = StringField()
symbol = StringField()
open = FloatField()
close = FloatField()
high = FloatField()
low = FloatField()
volume = FloatField()
class Strain(EmbeddedDocument):
name = StringField(required=True)
description = StringField(default="")
latitude = FloatField()
longitude = FloatField()
date = DateTimeField(default=datetime.datetime.now)
country = StringField(default="")
region = StringField(default="")
properties = ListField(DictField(required=False), default=[])
user = StringField(default="demo")
class Metric(EmbeddedDocument):
name = StringField(max_length=50, required=True)
description = StringField(required=False)
value = FloatField(required=False)
values = ListField(FloatField(), required=False)
labels = ListField(DynamicField(), required=False)
def __str__(self):
return "Metric: %s (%s) %s" % (self.name, self.description,
str(self.value))
class PrepProducts(Document):
# Products preparared on the restaurant,
# that will be add to another product.
preparation = LongField(required=True)
code = LongField(required=True)
product = LongField(required=True)
amount = FloatField(required=True)
services = FloatField(required=True)
created_date = LongField(required=True)
description = StringField()
class ProductInfo(Document):
# All the products to be sell are listed in here.
id = ObjectIdField()
code = LongField(required=True)
price = FloatField(required=True)
tax = FloatField(required=True)
category = LongField(required=True)
status = LongField(required=True)
created_by = LongField(required=True)
created_date = LongField(required=True)
class AShareExRightDividend(Document):
"""
A股除权除息
"""
# 更新时间
update_date = DateTimeField(default=datetime.utcnow())
# 证券代码
security_code = StringField(required=True, null=True)
# 除权除息日
ex_date = DateTimeField(required=True, null=True)
# 除权类型
ex_type = StringField(required=True, null=True)
# 除权说明
ex_description = StringField(required=True, null=True)
# 派息比例
cash_dividend_ratio = FloatField(required=True, null=True)
# 送股比例
bonus_share_ratio = FloatField(required=True, null=True)
# 配股比例
rightsissue_ratio = FloatField(required=True, null=True)
# 配股价格
rightsissue_price = FloatField(required=True, null=True)
# 转增比例
conversed_ratio = FloatField(required=True, null=True)
# 增发价格
seo_price = FloatField(required=True, null=True)
# 增发比例
seo_ratio = FloatField(required=True, null=True)
# 缩减比例
consolidate_split_ratio = FloatField(required=True, null=True)
# 复权因子
adj_factor = FloatField()
meta = {'indexes': ['security_code', 'ex_date']}
class cashbox_open(Document):
status = LongField(required=True)
code = LongField(required=True)
amount_open = FloatField(required=True)
user_opened = LongField(
required=True, default=1
) #Este campo es necesario, porque sin el por algun extraño motivo no funciona nada en el viejo sistema.
amount_close = FloatField(required=False, default=0.00)
open_date = LongField(required=True)
close_date = LongField(required=False)
cashbox = LongField(required=True)
class Procedure(BDocument):
name = StringField(required=True, unique=True)
code = StringField(required=True, unique=True)
price = FloatField(default=0)
is_refundable = BooleanField()
average_duration = IntField()
length_of_hospitalization = IntField()
NGAP_code = EmbeddedDocumentField(NGAPCode)
CCAM_code = EmbeddedDocumentField(CCAMCode)
modality = ReferenceField(Modality)
tnr = FloatField(default=0)
class Business(mongoengine.DynamicDocument):
"""Business Document Schema"""
name = StringField(required=True)
yelp_id = StringField(required=True, unique=True)
location = EmbeddedDocumentField(Location)
latitude = FloatField()
longitude = FloatField()
image_url = StringField()
display_phone = StringField()
open_hours = EmbeddedDocumentListField(OpenHours)
class node_config(Document):
'''
Node id
Description
Last state updated (heart beat)
'''
name = StringField()
description = StringField()
heart_beat_time = DateTimeField()
free_mem = FloatField()
free_cpu = FloatField()
free_disk = FloatField()
class MetricItem(EmbeddedDocument):
metric_type = ReferenceField(MetricType)
is_active = BooleanField(default=True)
# Optional graphite metric name
metric = StringField(required=False)
low_error = FloatField(required=False)
low_warn = FloatField(required=False)
high_warn = FloatField(required=False)
high_error = FloatField(required=False)
def __unicode__(self):
return self.metric_type.name
class Order(mongoengine.DynamicDocument):
symbol = StringField(required=True)
quantity = FloatField(required=True)
time_executed = DateTimeField(required=True)
quantity = FloatField(required=True)
order_side = StringField(required=True)
cost_basis = FloatField(
) # average price for order, which binance gives to us
order_fee = FloatField()
market_volume = FloatField()
# allow subclasses
meta = {"allow_inheritance": True}
class HostModel(DynamicDocument):
username = StringField()
levels = DictField()
blockchain = StringField()
registered_at = DateTimeField()
architect = StringField()
hoperator = StringField()
consensus_percent = FloatField()
referral_percent = FloatField()
dac_mode = IntField()
dacs = DictField()
chosts = DictField()
ahost = StringField()
non_active_chost = BooleanField()
need_switch = BooleanField()
fhosts_mode = IntField()
fhosts = DictField()
title = StringField()
purpose = StringField()
total_shares = IntField()
quote_amount = StringField()
root_token_contract = StringField()
root_token = StringField()
symbol = StringField()
precision = IntField()
to_pay = IntField()
payed = BooleanField()
cycle_start_id = IntField()
current_pool_id = IntField()
current_cycle_num = IntField()
current_pool_num = IntField()
parameters_setted = BooleanField()
activated = BooleanField()
priority_flag = BooleanField()
meta = StringField()
app = StringField()
meta = {
'collection':
'hosts',
'ordering': ['-registered_at'],
'indexes': [
'username', 'blockchain', 'ahost', 'activated', 'payed',
'parameters_setted'
'priority_flag'
'need_switch', 'non_active_chost', 'app'
],
'auto_create_index':
True,
'index_background':
True
}
class Tips(mongoengine.DynamicDocument):
"""Tips Document Schema"""
title = StringField(required=True)
content = StringField(required=True)
author = ObjectIdField(required=True)
posted_time = DateTimeField(required=True)
status = StringField(required=True)
latitude = FloatField(required=True)
longitude = FloatField(required=True)
category = StringField(required=True)
upvotes = ListField(ObjectIdField())
downvotes = ListField(ObjectIdField())
class Column(EmbeddedDocument):
path = StringField(required=True, help_text="column path in dot-notation")
min = FloatField(required=True,
default=float("nan"),
help_text="column minimum")
max = FloatField(required=True,
default=float("nan"),
help_text="column maximum")
unit = StringField(required=True, default="NaN", help_text="column unit")
def __eq__(self, other):
if isinstance(other, self.__class__):
return dict_wo_nans(self._data) == dict_wo_nans(other._data)
return False
class Vehicle2(Document):
type = StringField(validation=_vehicle_type_validation)
default_hourly_rate = FloatField()
make = StringField()
model = StringField()
year = IntField()
registration_tag = StringField()
current_mileage = FloatField()
condition = StringField()
capacity = IntField()
last_service_time = DateTimeField(default=datetime.datetime.utcnow)
is_available = BooleanField()
booking = ListField(ReferenceField(Booking2))
meta = {'db_alias': 'db1'}
class ThresholdConfig(EmbeddedDocument):
# Open condition
op = StringField(choices=["<", "<=", ">=", ">"])
value = FloatField()
# Closing condition
clear_op = StringField(choices=["<", "<=", ">=", ">"])
clear_value = FloatField()
# Umbrella alarm class
alarm_class = PlainReferenceField(AlarmClass)
# Send event to correlator
open_event_class = PlainReferenceField(EventClass)
close_event_class = PlainReferenceField(EventClass)
# Handlers to call on open and close thresholds
open_handler = PlainReferenceField(Handler)
close_handler = PlainReferenceField(Handler)
#
template = ForeignKeyField(Template)
def __str__(self):
return "%s %s" % (self.op, self.value)
def is_open_match(self, value):
"""
Check if threshold profile is matched for open condition
:param value:
:return:
"""
return (
(self.op == "<" and value < self.value)
or (self.op == "<=" and value <= self.value)
or (self.op == ">=" and value >= self.value)
or (self.op == ">" and value > self.value)
)
def is_clear_match(self, value):
"""
Check if threshold profile is matched for clear condition
:param value:
:return:
"""
return (
(self.clear_op == "<" and value < self.clear_value)
or (self.clear_op == "<=" and value <= self.clear_value)
or (self.clear_op == ">=" and value >= self.clear_value)
or (self.clear_op == ">" and value > self.clear_value)
)
@property
def name(self):
return "%s %s" % (self.op, self.value)
class AccountModel(DynamicDocument):
active_challenged = BooleanField()
balance_symbol = StringField()
balance_value = FloatField()
can_vote = BooleanField()
comment_count = IntField()
created = DateTimeField()
curation_rewards = IntField()
delegated_vesting_shares_symbol = StringField()
delegated_vesting_shares_value = FloatField()
json_metadata = DictField()
last_account_recovery = DateTimeField()
last_account_update = DateTimeField()
last_active_proved = DateTimeField()
last_owner_proved = DateTimeField()
last_post = DateTimeField()
last_vote_time = DateTimeField()
lifetime_vote_count = IntField()
memo_key = StringField()
mined = BooleanField()
name = StringField()
next_vesting_withdrawal = DateTimeField()
owner_challenged = BooleanField()
post_count = IntField()
posting_rewards = IntField()
roxied_vsf_votes = ListField(StringField())
proxy = StringField()
received_vesting_shares_symbol = StringField()
received_vesting_shares_value = FloatField()
recovery_account = StringField()
reset_account = StringField()
savings_balance_symbol = StringField()
savings_balance_value = FloatField()
savings_sbd_balance_symbol = StringField()
savings_sbd_balance_value = FloatField()
savings_sbd_last_interest_payment = DateTimeField()
savings_sbd_seconds = IntField()
savings_sbd_seconds_last_update = DateTimeField()
savings_withdraw_requests = IntField()
sbd_balance_symbol = StringField()
sbd_balance_value = FloatField()
sbd_last_interest_payment = DateTimeField()
sbd_seconds = IntField()
sbd_seconds_last_update = DateTimeField()
to_withdraw = IntField()
vesting_shares_symbol = StringField()
vesting_shares_value = FloatField()
vesting_withdraw_rate_symbol = StringField()
vesting_withdraw_rate_value = FloatField()
voting_power = IntField()
withdraw_routes = IntField()
withdrawn = IntField()
witnesses_voted_for = IntField()
meta = {
'collection': 'account_object',
'indexes': ['name', 'created', 'reset_account'],
'auto_create_index': True,
'index_background': True
}
class Chart(EmbeddedDocument):
chartType = StringField(
choices=("barChart", "pieChart", "boxPlot", "table"), required=True
)
colNameSelected = StringField(required=True)
interval = FloatField(null=True)
range = ListField(FloatField(), null=True)
groupByCol = StringField(null=True)
numBins = IntField(null=True)
visibleField = StringField(null=True)
onSameChart = BooleanField(null=True)
percentageAxis = BooleanField(null=True)
selections = ListField(StringField())
filterCols = ListField(StringField())
class StructuredQuery(Document):
userid = ObjectIdField(required=False)
query_object_type = StringField(required=True)
query_type = StringField(default='structured', required=False)
query = DictField(required=False)
creation_time = DateTimeField(default=datetime.now())
query_runtime_duration = FloatField()
class Crime(mongoengine.DynamicDocument):
"""Crime Document Schema"""
incident_id = StringField(required=True, unique=True)
incident_datetime = StringField(required=True)
incident_type_primary = StringField(required=True)
incident_description = StringField(required=True)
address_1 = StringField(required=True)
city = StringField(required=True)
state = StringField(required=True)
latitude = FloatField(required=True)
longitude = FloatField(required=True)
hour_of_day = IntField(required=True)
day_of_week = StringField(required=True)
parent_incident_type = StringField(required=True)
duration = IntField(required=False)
class VoteModel(DynamicDocument):
author = StringField()
voter = StringField()
comment = ObjectId()
last_update = DateTimeField()
num_changes = IntField()
permlink = StringField()
rshares = IntField()
vote_percent = IntField()
weight = FloatField()
meta = {
'collection': 'comment_vote_object',
'indexes': [
'author',
'voter',
'comment',
'permlink',
'parent_permlink',
'last_update'
],
'auto_create_index': True,
'index_background': True
}
class Trabajador(Document):
meta = {'collection': 'trabajador'}
negocio = ReferenceField(Negocio)
usuario = ReferenceField(Usuario)
horas_trabajadas = IntField()
sueldo_actual_mensual = FloatField()
