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()))
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()))
