Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SyntaxError: invalid table/column name "start" is a "ALL" reserved SQL/NOSQL keyword
- @request.restful()
- def v1():
- response.view = 'generic.'+request.extension
- def GET(*args,**vars):
- patterns = 'auto'
- parser = db.parse_as_rest(patterns,args,vars)
- if parser.status == 200:
- return dict(data=parser.response)
- else:
- raise HTTP(parser.status,parser.error)
- def POST(table_name,**vars):
- return db[table_name].validate_and_insert(**vars)
- def PUT(table_name,record_id,**vars):
- return db(db[table_name]._id==record_id).update(**vars)
- def DELETE(table_name,record_id):
- return db(db[table_name]._id==record_id).delete()
- return dict(GET=GET, POST=POST, PUT=PUT, DELETE=DELETE)
- db.define_table('events',
- Field('title', requires=IS_NOT_EMPTY()),
- Field('event_comment', requires=IS_NOT_EMPTY()),
- Field('event_start', type='datetime'),
- Field('event_end', type='datetime'),
- Field('creator_id', db.auth_user),
- Field('client_id', db.auth_user),
- Field('worker_id', db.auth_user)
- )
Add Comment
Please, Sign In to add comment