Guest User

Untitled

a guest
Nov 19th, 2017
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.15 KB | None | 0 0
  1. SyntaxError: invalid table/column name "start" is a "ALL" reserved SQL/NOSQL keyword
  2.  
  3. @request.restful()
  4. def v1():
  5. response.view = 'generic.'+request.extension
  6. def GET(*args,**vars):
  7. patterns = 'auto'
  8. parser = db.parse_as_rest(patterns,args,vars)
  9. if parser.status == 200:
  10. return dict(data=parser.response)
  11. else:
  12. raise HTTP(parser.status,parser.error)
  13. def POST(table_name,**vars):
  14. return db[table_name].validate_and_insert(**vars)
  15. def PUT(table_name,record_id,**vars):
  16. return db(db[table_name]._id==record_id).update(**vars)
  17. def DELETE(table_name,record_id):
  18. return db(db[table_name]._id==record_id).delete()
  19. return dict(GET=GET, POST=POST, PUT=PUT, DELETE=DELETE)
  20.  
  21. db.define_table('events',
  22. Field('title', requires=IS_NOT_EMPTY()),
  23. Field('event_comment', requires=IS_NOT_EMPTY()),
  24. Field('event_start', type='datetime'),
  25. Field('event_end', type='datetime'),
  26. Field('creator_id', db.auth_user),
  27. Field('client_id', db.auth_user),
  28. Field('worker_id', db.auth_user)
  29. )
Add Comment
Please, Sign In to add comment