Subversion Repositories yaws

Rev

Rev 14 | Rev 16 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 14 Rev 15
Line 28... Line 28...
28 
session = Session()
 28 
session = Session()
29 
import datetime
 29 
import datetime
30 
from sqlalchemy import Table, Column, DateTime, Boolean, Float
 30 
from sqlalchemy import Table, Column, DateTime, Boolean, Float
31 
from sqlalchemy.ext.declarative import declarative_base
 31 
from sqlalchemy.ext.declarative import declarative_base
Line -... Line 32...
- 
 
 32 
 
- 
 
 33 
def create_connection():
- 
 
 34 
    return engine.connect()
32 
 
 35 
 
Line 33... Line 36...
33 
Base = declarative_base()
 36 
Base = declarative_base()
34 
 
 37 
 
35 
class Samples(Base):
 38 
class Samples(Base):
Line 43... Line 46...
43 
    rain = Column(Boolean)
 46 
    rain = Column(Boolean)
44 
    rainfall = Column(Float)
 47 
    rainfall = Column(Float)
45 
    sunlight = Column(Float)
 48 
    sunlight = Column(Float)
46 
    cputemp = Column(Float)
 49 
    cputemp = Column(Float)
Line 47... Line -...
47 
 
 - 
 
48 
    def create_connection():
 - 
 
49 
        return engine.connect()
 - 
 
50
- 
 
51 
 
 50 
 
52 
    def __repr__(self):
 51 
    def __repr__(self):
53 
        return {'sampled':self.sampled, 'airtemp':self.airtemp,
 52 
        return {'sampled':self.sampled, 'airtemp':self.airtemp,
54 
            'gndtemp':self.gndtemp, 'pressure':self.pressure,
 53 
            'gndtemp':self.gndtemp, 'pressure':self.pressure,
55 
            'humidity':self.humidity, 'windspeed':self.windspeed,
 54 
            'humidity':self.humidity, 'windspeed':self.windspeed,