def getTimelineOptions(self, appdef):
layers = appdef["Layers"]
times = set()
for layer in layers:
if layer.timeInfo is not None:
if isinstance(layer.timeInfo[0], basestring):
features = layer.layer.getFeatures()
for feature in features:
for field in layer.timeInfo:
try:
value = feature[field]
if isinstance(value, QDate):
t = QDateTime()
t.setDate(value)
else:
t = QDateTime.fromString(
unicode(value), Qt.ISODate)
if t.isValid():
times.add(t.toMSecsSinceEpoch())
except:
pass
else:
times.add(layer.timeInfo[0])
times.add(layer.timeInfo[1])
if times:
return [min(times), max(times)]
else:
return [0, 1]
def getTimelineOptions(self, appdef):
layers = appdef["Layers"]
times = set()
for layer in layers:
if layer.timeInfo is not None:
if isinstance(layer.timeInfo[0], basestring):
features = layer.layer.getFeatures()
for feature in features:
for field in layer.timeInfo:
try:
value = feature[field]
if isinstance(value, QDate):
t = QDateTime()
t.setDate(value)
else:
t = QDateTime.fromString(unicode(value), Qt.ISODate)
if t.isValid():
times.add(t.toMSecsSinceEpoch())
except:
pass
else:
times.add(layer.timeInfo[0])
times.add(layer.timeInfo[1])
if times:
return [min(times), max(times)]
else:
return [0,1]
class LogResultRow():
def __init__(self, logFeature, featureLayer, pkeyName, geomColumn):
self.featureLayer = featureLayer
self.fields = featureLayer.dataProvider().fields()
self.logFeature = QgsFeature(logFeature)
self.geomColumn = geomColumn
self.date = QDateTime().fromString(logFeature["action_tstamp_clk"],
Qt.ISODate)
print logFeature[
"action_tstamp_clk"], self.date, self.date.toMSecsSinceEpoch()
self.dateMs = self.date.toMSecsSinceEpoch()
self.logData = self.logFeature["row_data"]
self.layerFeatureId = int(self.getFieldValue(self.logData, pkeyName))
def getFieldValue(self, data, fieldName):
if data is None:
return None
p = fieldRe(fieldName).search(data)
if p:
value = ""
data = data[p.end():]
p = dataReWithQuote.match(data)
if p:
value = data[p.start() + 1:p.end() - 1]
else:
p = dataReWithoutQuote.match(data)
if p:
value = data[p.start():p.end() - 1]
else:
p = dataReWithoutQuoteEndOfString.match(data)
if p:
value = data[p.start():p.end()]
return value
return None
def dateStr(self):
return self.date.toString("ddd dd MMM yyyy hh:mm")
def user(self):
return self.logFeature["session_user_name"]
def action(self):
action = self.logFeature["action"]
if action == "I":
#return u"\u002B" # plus sign
return "insert"
if action == "U":
#return u"\u2713" # check sign
return "update"
if action == "D":
#return u"\u2A2F" # cross sign
return "delete"
raise NameError("Invalid action %s" % action)
def application(self):
return self.logFeature["application_name"]
def clientIP(self):
return self.logFeature["client_addr"]
def clientPort(self):
return self.logFeature["client_port"]
def changedFields(self):
data = self.logFeature["changed_fields"]
columns = ""
for field in self.fields:
if self.getFieldValue(data, field.name()) is not None:
columns += field.name() + ", "
return columns[:-2]
def changedGeometry(self):
data = self.logFeature["changed_fields"]
geometry = self.getFieldValue(data, self.geomColumn)
return geometry is not None
def changedGeometryStr(self):
if self.changedGeometry():
return u"\u2713" # i.e. check sign
else:
return ""
def geometry(self):
if self.geomColumn is None:
return QgsGeometry()
ewkb = "%s" % self.getFieldValue(self.logData, self.geomColumn)
return geometryTools.ewkb2gqgis(ewkb)
def data(self):
out = dict()
for field in self.fields:
out[field.name()] = self.getFieldValue(self.logData, field.name())
return out
def getLayerFeature(self):
layerFeature = QgsFeature()
featReq = QgsFeatureRequest().setFilterFid(self.layerFeatureId)
if not self.featureLayer.hasGeometryType():
featReq.setFlags(QgsFeatureRequest.NoGeometry)
if self.featureLayer.getFeatures(featReq).nextFeature(layerFeature):
return layerFeature
else:
return None
def restoreFeature(self):
if not self.featureLayer.isEditable():
return False
currentFeature = self.getLayerFeature()
editBuffer = self.featureLayer.editBuffer()
if currentFeature is not None:
fid = currentFeature.id()
for idx, field in enumerate(self.fields):
value = self.getFieldValue(self.logData, field.name())
editBuffer.changeAttributeValue(fid, idx, value)
if self.featureLayer.hasGeometryType():
editBuffer.changeGeometry(fid, self.geometry())
else:
newFeature = QgsFeature()
newFeature.setFields(self.fields)
newFeature.initAttributes(self.fields.size())
for field in self.fields:
value = self.getFieldValue(self.logData, field.name())
newFeature[field.name()] = QVariant(value)
if self.featureLayer.hasGeometryType():
newFeature.setGeometry(self.geometry())
editBuffer.addFeature(newFeature)
class LogResultRow():
def __init__(self, logFeature, featureLayer, pkeyName, geomColumn):
self.featureLayer = featureLayer
self.fields = featureLayer.dataProvider().fields()
self.logFeature = QgsFeature(logFeature)
self.geomColumn = geomColumn
self.date = QDateTime().fromString(logFeature["action_tstamp_clk"], Qt.ISODate)
print logFeature["action_tstamp_clk"], self.date, self.date.toMSecsSinceEpoch()
self.dateMs = self.date.toMSecsSinceEpoch()
self.logData = self.logFeature["row_data"]
self.layerFeatureId = int(self.getFieldValue(self.logData, pkeyName))
def getFieldValue(self, data, fieldName):
if data is None:
return None
p = fieldRe(fieldName).search(data)
if p:
value = ""
data = data[p.end():]
p = dataReWithQuote.match(data)
if p:
value = data[p.start()+1:p.end()-1]
else:
p = dataReWithoutQuote.match(data)
if p:
value = data[p.start():p.end()-1]
else:
p = dataReWithoutQuoteEndOfString.match(data)
if p:
value = data[p.start():p.end()]
return value
return None
def dateStr(self):
return self.date.toString("ddd dd MMM yyyy hh:mm")
def user(self):
return self.logFeature["user_name"]
def action(self):
action = self.logFeature["action"]
if action == "I":
#return u"\u002B" # plus sign
return "insert"
if action == "U":
#return u"\u2713" # check sign
return "update"
if action == "D":
#return u"\u2A2F" # cross sign
return "delete"
raise NameError("Invalid action %s" % action)
def clientIP(self):
return self.logFeature["addr"]
def changedFields(self):
data = self.logFeature["changed_fields"]
columns = ""
for field in self.fields:
if self.getFieldValue(data, field.name()) is not None:
columns += field.name() + ", "
return columns[:-2]
def changedGeometry(self):
data = self.logFeature["changed_fields"]
geometry = self.getFieldValue(data, self.geomColumn)
return geometry is not None
def changedGeometryStr(self):
if self.changedGeometry():
return u"\u2713" # i.e. check sign
else:
return ""
def geometry(self):
if self.geomColumn is None:
return QgsGeometry()
ewkb = "%s" % self.getFieldValue(self.logData, self.geomColumn)
return geometryTools.ewkb2gqgis(ewkb)
def data(self):
out = dict()
for field in self.fields:
out[field.name()] = self.getFieldValue(self.logData, field.name())
return out
def getLayerFeature(self):
layerFeature = QgsFeature()
featReq = QgsFeatureRequest().setFilterFid(self.layerFeatureId)
if not self.featureLayer.hasGeometryType():
featReq.setFlags(QgsFeatureRequest.NoGeometry)
if self.featureLayer.getFeatures(featReq).nextFeature(layerFeature):
return layerFeature
else:
return None
def restoreFeature(self):
if not self.featureLayer.isEditable():
return False
currentFeature = self.getLayerFeature()
editBuffer = self.featureLayer.editBuffer()
if currentFeature is not None:
fid = currentFeature.id()
for idx, field in enumerate(self.fields):
value = self.getFieldValue(self.logData, field.name())
editBuffer.changeAttributeValue(fid, idx, value)
if self.featureLayer.hasGeometryType():
editBuffer.changeGeometry(fid, self.geometry())
else:
newFeature = QgsFeature()
newFeature.setFields(self.fields)
newFeature.initAttributes(self.fields.size())
for field in self.fields:
value = self.getFieldValue(self.logData, field.name())
newFeature[field.name()] = value
if self.featureLayer.hasGeometryType():
newFeature.setGeometry(self.geometry())
editBuffer.addFeature(newFeature)
