def get(self, database, table, rowid=None): """Dumps a single record or all records from a table""" try: if rowid: self.write(dumps(db.get_record(database, table, rowid))) else: self.write(dumps([row for row in db.all_records(database, table)])) except db.NoSuchDatabase: raise HTTPError(404)
def get(self, database, table, rowid=None): """Dumps a single record or all records from a table""" try: if rowid: self.write(dumps(db.get_record(database, table, rowid))) else: self.write( dumps([row for row in db.all_records(database, table)])) except db.NoSuchDatabase: raise HTTPError(404)
def post(self, database, table, rowid=None): """INSERT or UPDATE records""" # Prepare request (POST) vars. We only have to do this because # we get a dict of lists and our funcs want a dict of single # values kwargs = {} for k, v in self.request.arguments.iteritems(): kwargs[k] = v[0] try: if rowid: # Perform UPDATE json = dumps(db.update_record(database, table, rowid, **kwargs)) self.write(json) else: # Perform INSERT id = db.insert_record(database, table, **kwargs) self.set_status = 201 # HTTP 201 Created loc = "/%s/%s/%d" % (database, table, id) self.set_header("Location", loc) self.write(loc) except db.NoSuchDatabase: raise HTTPError(404)
def post(self, database, table, rowid=None): """INSERT or UPDATE records""" # Prepare request (POST) vars. We only have to do this because # we get a dict of lists and our funcs want a dict of single # values kwargs = {} for k, v in self.request.arguments.iteritems(): kwargs[k] = v[0] try: if rowid: # Perform UPDATE json = dumps(db.update_record(database, table, rowid, **kwargs)) self.write(json) else: # Perform INSERT id = db.insert_record(database, table, **kwargs) self.set_status = 201 # HTTP 201 Created loc = '/%s/%s/%d' % (database, table, id) self.set_header('Location', loc) self.write(loc) except db.NoSuchDatabase: raise HTTPError(404)
def get(self, database): try: self.write(dumps(db.list_tables(database))) except db.NoSuchDatabase: raise HTTPError(404)
def get(self): self.write(dumps(db.list_databases()))