summaryrefslogtreecommitdiff
path: root/ebus/sql
diff options
context:
space:
mode:
Diffstat (limited to 'ebus/sql')
-rw-r--r--ebus/sql/__init__.py0
-rw-r--r--ebus/sql/model.py79
2 files changed, 0 insertions, 79 deletions
diff --git a/ebus/sql/__init__.py b/ebus/sql/__init__.py
deleted file mode 100644
index e69de29..0000000
--- a/ebus/sql/__init__.py
+++ /dev/null
diff --git a/ebus/sql/model.py b/ebus/sql/model.py
deleted file mode 100644
index 7e21e82..0000000
--- a/ebus/sql/model.py
+++ /dev/null
@@ -1,79 +0,0 @@
-from datetime import datetime
-from sqlalchemy import Column, Integer, Float, DateTime, String, ForeignKey
-from sqlalchemy.orm import relationship, backref
-from sqlalchemy.ext.declarative import declarative_base
-
-ModelBase = declarative_base()
-
-class Sensor(ModelBase):
- __tablename__ = 'sensor'
-
- id = Column(Integer, primary_key=True)
- name = Column(String)
- description = Column(String, default="")
-
- def __init__(self, name, description=""):
- self.name = name
- self.description = description
-
- def __repr__(self):
- return "<Sensor('%s','%s','%s')>" % (self.id, self.name, self.description)
-
-# http://www.sqlalchemy.org/docs/05/reference/ext/declarative.html#inheritance-configuration
-class Value(ModelBase):
- __tablename__ = 'value'
-
- id = Column(Integer, primary_key=True)
- timestamp = Column(DateTime)
- sensor_id = Column(Integer, ForeignKey("sensor.id"))
- sensor = relationship(Sensor, backref=backref('values', order_by=timestamp))
-
- discriminator = Column('type', String(50))
- __mapper_args__ = {'polymorphic_on': discriminator}
-
- def __init__(self, sensor, timestamp=datetime.now()):
- self.timestamp = timestamp
- self.sensor = sensor
-
- def __repr__(self):
- return "<Value('%s','%s','%s','%s'>" % (self.id, self.sensor, self.value, self.timestamp)
-
- def value(self):
- raise NotImplementedException()
-
-class ValueFloat(Value):
- __mapper_args__ = {'polymorphic_identity': 'float'}
- value_float = Column(Float(precision=4))
-
- def __init__(self, sensor, value, timestamp=datetime.now()):
- Value.__init__(self, sensor, timestamp)
- self.value_float = value
-
- def value(self):
- return self.value_float
-
-class ValueInt(Value):
- __mapper_args__ = {'polymorphic_identity': 'int'}
- value_int = Column(Integer)
-
- def __init__(self, sensor, value, timestamp=datetime.now()):
- Value.__init__(self, sensor, timestamp)
- self.value_int = value
-
- def value(self):
- return self.value_int
-
-class ValueString(Value):
- __mapper_args__ = {'polymorphic_identity': 'string'}
- value_string = Column(String)
-
- def __init__(self, sensor, value, timestamp=datetime.now()):
- Value.__init__(self, sensor, timestamp)
- self.value_string = value
-
- def value(self):
- return self.value_string
-
-
-
-