main.py 1.8 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273
  1. #!/usr/bin/env python
  2. # -*- coding: utf-8 -*-
  3. """
  4. demeter web page
  5. name:work.py
  6. author:rabin
  7. """
  8. from __load__ import *
  9. class index_path(Load):
  10. #权限控制,需要在Load类中自行做判断
  11. #@Web.auth
  12. #异步加载,增加执行效率
  13. @Web.setting
  14. def get(self):
  15. self.view("index.html")
  16. # 测试数据库 查询 /main/select
  17. class select_path(Load):
  18. @Web.setting
  19. def get(self):
  20. # 从get、post获取数据,默认值为1
  21. id = int(self.input('site', 1))
  22. site = Demeter.model('site')
  23. site.id = id
  24. self.data['site'] = site.select(type='fetchone')
  25. product = Demeter.model('product')
  26. product.site_id = id
  27. self.data['product'] = product.select(col = '*', order = 'cdate desc', group = '', limit = '0,100')
  28. self.view('index.html')
  29. # 测试数据库 更新和插入 /main/update
  30. class update_path(Load):
  31. @Web.setting
  32. def get(self):
  33. id = int(self.input('site', 1))
  34. name = self.input('name', 'tests')
  35. site = Demeter.model('site')
  36. site.id = id
  37. state = site.update(name=name)
  38. self.data['site'] = site.select(type='fetchone')
  39. self.view('index.html')
  40. # 测试json /main/json
  41. class json_path(Load):
  42. @Web.setting
  43. def get(self):
  44. id = int(self.input('site', 1))
  45. name = self.input('name', 'tests')
  46. site = Demeter.model('site')
  47. site.id = id
  48. state = site.update(name=name)
  49. data = site.select(type='fetchone')
  50. self.out('yes', data)
  51. # 测试数据库 使用sql(不建议使用) /main/sql.html
  52. class sql_html(Load):
  53. @Web.setting
  54. def get(self):
  55. id = int(self.input('site', 1))
  56. name = self.input('name', 'tests')
  57. site = Demeter.model('site')
  58. state = site.query('update demeter_site set name = %s where id = %s', (name,id))
  59. self.data['site'] = site.query('select * from demeter_site where id = %s', (id))
  60. self.view('index.html')