def run(self): print "Tag.run>" ## main objects db=Database(database='mtim',port=5432) ## Series 1 for d in [1,2,3,4]: objects=db.getObjects(where="Devices.deviceID=%s" % d) building=buildings.PughHall() building.tag(objects) building.check(objects) ## Setup Metadata db.writeTags(objects) building.points(objects) db.writePoints(objects) ## Series 2 for d in [5,6,7,8]: objects=db.getObjects(where="Devices.deviceID=%s" % d) building=buildings.PughHall() building.tag(objects) building.check(objects) ## Setup Metadata db.writeTags(objects) ## Join on nn db.execute("DELETE FROM PointObjectMap") db.execute( """ INSERT INTO PointObjectMap (pointID,objectID,name) SELECT Points.pointID,Objects.objectID,Points.value FROM Objects JOIN Tags ON (Objects.objectID=Tags.objectID AND tag='nn') JOIN Points ON (Tags.value=Points.value AND Points.tag='nn') """ ) db.close()
def run(self): print "Tag.run>" ## main objects db = Database(database='mtim', port=5432) ## Series 1 for d in [1, 2, 3, 4]: objects = db.getObjects(where="Devices.deviceID=%s" % d) building = buildings.PughHall() building.tag(objects) building.check(objects) ## Setup Metadata db.writeTags(objects) building.points(objects) db.writePoints(objects) ## Series 2 for d in [5, 6, 7, 8]: objects = db.getObjects(where="Devices.deviceID=%s" % d) building = buildings.PughHall() building.tag(objects) building.check(objects) ## Setup Metadata db.writeTags(objects) ## Join on nn db.execute("DELETE FROM PointObjectMap") db.execute(""" INSERT INTO PointObjectMap (pointID,objectID,name) SELECT Points.pointID,Objects.objectID,Points.value FROM Objects JOIN Tags ON (Objects.objectID=Tags.objectID AND tag='nn') JOIN Points ON (Tags.value=Points.value AND Points.tag='nn') """) db.close()