def get(self):
debug(self.request.accept)
assert isinstance(self.request.accept, MIMEAccept)
try:
odenki_user = getCurrentUser()
self.resource["odenkiId"] = odenki_user.odenkiId
except OdenkiUserNotFound:
self.resource["odenkiId"] = "unknown"
#assert isinstance(odenki_user, OdenkiUser)
query = Command.all()
query.order("-queuedDateTime")
result = query.run()
for x in result:
v = {}
v["commandId"] = x.commandId
v["gatewayId"] = x.gatewayId
v["equipmentId"] = x.equipmentId
v["userId"] = x.userId
v["command"] = x.command
v["result"] = x.result
v["queuedDateTime"] = str(x.queuedDateTime)
v["attemptedDateTimes"] = str(
x.attemptDateTimes[-1]
) if x.attemptDateTimes is not None and len(
x.attemptDateTimes) > 0 else None
v["executedDateTime"] = str(x.executedDateTime)
self.resource["commands"].append(v)
if self.request.accept.accept_html():
self.resource["commands"] = self.resource["commands"][:10]
self.writeWithTemplate(self.resource, "Command")
else:
self.writeJson(self.resource)
def get(self):
debug(self.request.accept)
assert isinstance(self.request.accept, MIMEAccept)
try:
odenki_user = getCurrentUser()
self.resource["odenkiId"] = odenki_user.odenkiId
except OdenkiUserNotFound:
self.resource["odenkiId"] = "unknown"
#assert isinstance(odenki_user, OdenkiUser)
query = Command.all()
query.order("-queuedDateTime")
result = query.run()
for x in result:
v = {}
v["commandId"] = x.commandId
v["gatewayId"] = x.gatewayId
v["equipmentId"] = x.equipmentId
v["userId"] = x.userId
v["command"] = x.command
v["result"] = x.result
v["queuedDateTime"] = str(x.queuedDateTime)
v["attemptedDateTimes"] = str(x.attemptDateTimes[-1]) if x.attemptDateTimes is not None and len(x.attemptDateTimes) > 0 else None
v["executedDateTime"] = str(x.executedDateTime)
self.resource["commands"].append(v)
if self.request.accept.accept_html():
self.resource["commands"] = self.resource["commands"][:10];
self.writeWithTemplate(self.resource, "Command")
else:
self.writeJson(self.resource)
def getCommandWorksheet():
odenki_user = getCurrentUser()
assert isinstance(odenki_user, OdenkiUser)
if odenki_user.docsCommandWorksheetId is not None:
try :
worksheet = getWorksheet(odenki_user.docsCommandWorksheetId)
assert isinstance(worksheet, WorksheetEntry)
return worksheet
except RequestError, e:
debug("failed to get worksheet " + odenki_user.docsCommandWorksheetId)
odenki_user.docsCommandWorksheetId = None
odenki_user.put()
def getCommandWorksheet():
odenki_user = getCurrentUser()
assert isinstance(odenki_user, OdenkiUser)
if odenki_user.docsCommandWorksheetId is not None:
try:
worksheet = getWorksheet(odenki_user.docsCommandWorksheetId)
assert isinstance(worksheet, WorksheetEntry)
return worksheet
except RequestError, e:
debug("failed to get worksheet " +
odenki_user.docsCommandWorksheetId)
odenki_user.docsCommandWorksheetId = None
odenki_user.put()
def get(self):
try:
getCurrentUser()
except:
self.response.set_status(401)
self.redirect("/OdenkiUser")
return
folder = getOdenkiFolder()
assert isinstance(folder, Resource)
spreadsheet = getOdenkiSpreadsheet()
assert isinstance(spreadsheet, Resource)
command_worksheet = getCommandWorksheet()
assert isinstance(command_worksheet, WorksheetEntry)
v = {}
v["folder_title"] = folder.title
v["folder_id"] = folder.resource_id
v["folder_link"] = folder.find_html_link()
v["spreadsheet_title"] = spreadsheet.title
v["spreadsheet_id"] = spreadsheet.resource_id
v["spreadsheet_link"] = spreadsheet.find_html_link()
v["command_worksheet_link"] = spreadsheet.find_html_link() + "#gid=" + str(getWorksheetGid(command_worksheet.GetWorksheetId()))
self.writeWithTemplate(v, "Spreadsheet")
def post(self):
try:
odenki_user = getCurrentUser()
except OdenkiUserNotFound:
self.response.set_status(401)
return
#assert isinstance(odenki_user, OdenkiUser)
parsed_json = loads(self.request.body)
parsed_json["userId"] = odenki_user.odenkiId
try:
renewCommand(parsed_json)
except (CommandNotFound, KeyError):
registerCommand(parsed_json)
self.get()
def get(self):
try:
getCurrentUser()
except:
self.response.set_status(401)
self.redirect("/OdenkiUser")
return
folder = getOdenkiFolder()
assert isinstance(folder, Resource)
spreadsheet = getOdenkiSpreadsheet()
assert isinstance(spreadsheet, Resource)
command_worksheet = getCommandWorksheet()
assert isinstance(command_worksheet, WorksheetEntry)
v = {}
v["folder_title"] = folder.title
v["folder_id"] = folder.resource_id
v["folder_link"] = folder.find_html_link()
v["spreadsheet_title"] = spreadsheet.title
v["spreadsheet_id"] = spreadsheet.resource_id
v["spreadsheet_link"] = spreadsheet.find_html_link()
v["command_worksheet_link"] = spreadsheet.find_html_link(
) + "#gid=" + str(getWorksheetGid(command_worksheet.GetWorksheetId()))
self.writeWithTemplate(v, "Spreadsheet")
def post(self):
try:
odenki_user = getCurrentUser()
except OdenkiUserNotFound:
self.response.set_status(401)
return
#assert isinstance(odenki_user, OdenkiUser)
parsed_json = loads(self.request.body)
parsed_json["userId"] = odenki_user.odenkiId
try:
renewCommand(parsed_json)
except (CommandNotFound, KeyError):
registerCommand(parsed_json)
self.get()
def getOdenkiSpreadsheet():
odenki_user = getCurrentUser()
assert isinstance(odenki_user, OdenkiUser)
if odenki_user.docsSpreadsheetId is not None:
google_docs = GoogleDocs()
client = google_docs.getDocsClient()
try:
existing_spreadsheet = client.GetResourceById(odenki_user.docsSpreadsheetId)
assert isinstance(existing_spreadsheet, Resource)
return existing_spreadsheet
except RequestError, e:
odenki_user.docsSpreadsheetId = None
odenki_user.put()
except DownloadError, e:
odenki_user.docsSpreadsheetId = None
odenki_user.put()
def getOdenkiSpreadsheet():
odenki_user = getCurrentUser()
assert isinstance(odenki_user, OdenkiUser)
if odenki_user.docsSpreadsheetId is not None:
google_docs = GoogleDocs()
client = google_docs.getDocsClient()
try:
existing_spreadsheet = client.GetResourceById(
odenki_user.docsSpreadsheetId)
assert isinstance(existing_spreadsheet, Resource)
return existing_spreadsheet
except RequestError, e:
odenki_user.docsSpreadsheetId = None
odenki_user.put()
except DownloadError, e:
odenki_user.docsSpreadsheetId = None
odenki_user.put()
