PageRenderTime 27ms CodeModel.GetById 25ms RepoModel.GetById 1ms app.codeStats 0ms

/webserver.py

https://bitbucket.org/diverdano/mls
Python | 619 lines | 534 code | 13 blank | 72 comment | 32 complexity | 20d3019b2b19cc082b86fa46ee583089 MD5 | raw file
    

  1. #!/usr/bin/env python
    2. 

  2. 

  3. ## ==================================
    4. 

  4. ## === packages, modules, pragmas ===
    5. 

  5. ## ==================================
    6. 

  6. 

  7. ## === built-ins ===
    8. 

  8. import cgi
    9. 

  9. import sys
    10. 

  10. import os                                                   # used to obtain environment host name & process web file paths
    11. 

  11. import argparse                                             # used when running as script; should be moved to DAO
    12. 

  12. import logging
    13. 

  13. import logging.config                                       # pythons logging feature
    14. 

  14. from mimetypes import types_map                             # for processing additional files
    15. 

  15. from http.server import BaseHTTPRequestHandler, HTTPServer
    16. 

  16. 

  17. # ## === 3rd party ===
    18. 

  18. from sqlalchemy import create_engine
    19. 

  19. from sqlalchemy.orm import sessionmaker
    20. 

  20. from database_setup import Restaurant, MenuItem, Employee, Address
    21. 

  21. # from database_setup import Base, Restaurant, MenuItem, Employee, Address
    22. 

  22. # import pymongo
    23. 

  23. # import json
    24. 

  24. # from tornado.ioloop import IOLoop
    25. 

  25. # #from tornado.log import enable_pretty_logging
    26. 

  26. # #import tornado.options 
    27. 

  27. # from tornado.web import RequestHandler, Application, url, RedirectHandler, StaticFileHandler
    28. 

  28. # from tornado.httpclient import AsyncHTTPClient
    29. 

  29. # from tornado.escape import json_decode
    30. 

  30. # from tornado import gen
    31. 

  31. # #import tornado.logging
    32. 

  32. # #import tornado.web.authenticated (decorator for ensuring user is logged in)
    33. 

  33. # 
    34. 

  34. # ## === custom ===
    35. 

  35. # import restaurant as r
    36. 

  36. # import util
    37. 

  37. # import rplace
    38. 

  38. # 
    39. 

  39. ## ===============================
    40. 

  40. ## === command-line processing ===
    41. 

  41. ## ===============================
    42. 

  42. 

  43. parser = argparse.ArgumentParser()
    44. 

  44. parser.add_argument('--port',           default=8080,                           help="sets port number for web service")
    45. 

  45. parser.add_argument('--log_file',       default='log/web.log',                  help="path/file for logging")
    46. 

  46. parser.add_argument('--start',          dest='start',   action='store_true',    help="start the server")
    47. 

  47. parser.add_argument('--app',            default='restaurant_app',               help="name of application")
    48. 

  48. parser.add_argument('--debug',          dest='debug',   action='store_true',    help="sets server debug, and level of logging")
    49. 

  49. #parser.add_argument('--debug_off',      dest='debug',   action='store_false',   help="sets server debug")
    50. 

  50. #parser.add_argument('--mongo_server',   default=2,                              help="server where mongodb resides")
    51. 

  51. #parser.add_argument('--i_mode',         dest='start',   action='store_false',   help="skip starting the server")
    52. 

  52. 

  53. args        = parser.parse_args()
    54. 

  54. 

  55. def pargs():
    56. 

  56.     '''prints items in args object for ease of reading'''
    57. 

  57.     print('\n')
    58. 

  58.     for item in args._get_kwargs():
    59. 

  59.         k,v = item
    60. 

  60.         print('\t' + k + ': ' + str(v))
    61. 

  61. 

  62. ## ===================================
    63. 

  63. ## === logging to file and console ===
    64. 

  64. ## ===================================
    65. 

  65. 

  66. ERROR_FORMAT        = "%(asctime)s %(name)s %(levelname)-8s %(message)s"
    67. 

  67. INFO_FORMAT         = "%(asctime)s %(name)s %(levelname)-8s %(message)s"
    68. 

  68. CONSOLE_FORMAT      = "\n\t%(message)s"
    69. 

  69. if args.debug == True:
    70. 

  70.     DEBUG_FORMAT    = "%(asctime)s %(name)s %(levelname)-8s %(filename)s->%(funcName)s line %(lineno)d: %(message)s"
    71. 

  71.     LOG_LEVEL       = "DEBUG"
    72. 

  72. else:
    73. 

  73.     DEBUG_FORMAT    = INFO_FORMAT
    74. 

  74.     LOG_LEVEL       = "INFO"
    75. 

  75. LOG_CONFIG = {'version':1,
    76. 

  76.               'formatters':{'error':{'format':ERROR_FORMAT},
    77. 

  77.                             'info':{'format':INFO_FORMAT},
    78. 

  78.                             'console':{'format':CONSOLE_FORMAT},
    79. 

  79.                             'debug':{'format':DEBUG_FORMAT}},
    80. 

  80.               'handlers':{'console':{'class':'logging.StreamHandler',
    81. 

  81.                                      'formatter':'console',
    82. 

  82.                                      'level':logging.DEBUG},
    83. 

  83.                           'file':{'class':'logging.FileHandler',
    84. 

  84.                                   'filename':args.log_file,
    85. 

  85.                                   'formatter':'debug',
    86. 

  86.                                   'level':logging.INFO}},
    87. 

  87.               'root':{'handlers':['console', 'file'], 'level':LOG_LEVEL}}
    88. 

  88. logging.config.dictConfig(LOG_CONFIG)
    89. 

  89. logger      = logging.getLogger(args.app)
    90. 

  90. 

  91. # ## =============
    92. 

  92. # ## == classes ==
    93. 

  93. # ## =============
    94. 

  94. 

  95. class DB(object):
    96. 

  96.     '''custom class for loading menu items from json'''
    97. 

  97.     def __init__(self, db = 'sqlite:///restaurant.db'):
    98. 

  98.         self.engine = create_engine(db)
    99. 

  99.         Base.metadata.bind = self.engine     # is this really used?
    100. 

  100.         self.DBSession = sessionmaker(bind=self.engine)
    101. 

  101.         self.session = self.DBSession()
    102. 

  102. #        self.session = sessionmaker(bind=self.engine)
    103. 

  103.     def loadJSON(self, file='menu_items.json'):
    104. 

  104.         '''bulk upload menu items using JSON file'''
    105. 

  105.         self.items = util.readFile(file)
    106. 

  106.         for item in self.items:
    107. 

  107.             self.loadItem(item)
    108. 

  108.     def loadItem(self, menu):
    109. 

  109.         '''create/add and commit items to db
    110. 

  110.         TODO: make this a generic loader for any underlying db table'''
    111. 

  111.         restaurant = Restaurant(name = menu['restaurant'])      # TODO: read attributes from JSON entry to determine type
    112. 

  112.         self.session.add(restaurant)
    113. 

  113.         self.session.commit()
    114. 

  114.         for item in menu['menu_items']:
    115. 

  115.             menu_item = MenuItem(name = item['name'], desc = item['desc'], price = item['price'], course = item['course'], restaurant = restaurant)
    116. 

  116.             self.session.add(menu_item)
    117. 

  117.             self.session.commit()
    118. 

  118.     def getMenuItems(self, name = None, id = None):
    119. 

  119.         '''method for fetching items from db'''
    120. 

  120.         if name != None:
    121. 

  121.             items = self.session.query(MenuItem).filter_by(name = name)
    122. 

  122.             for item in items:
    123. 

  123.                 print(item.id, item.price, item.restaurant.name, item.name)
    124. 

  124.             print('thats all folks...')
    125. 

  125.         if id != None:
    126. 

  126.             item = self.session.query(MenuItem).filter_by(id = id).one()
    127. 

  127.             self.result = item
    128. 

  128. 

  129. 

  130. class webserverHandler(BaseHTTPRequestHandler):
    131. 

  131.     def do_GET(self):
    132. 

  132.         self.cwd = os.environ['PWD']
    133. 

  133.         try:
    134. 

  134.             if self.path == "/":
    135. 

  135.                  self.path = "/index.html"
    136. 

  136.             fname,ext = os.path.splitext(self.path)
    137. 

  137.             if ext in (".ico", ".jpg",".png"):                  # binary files (images)
    138. 

  138.                  with open('.'+self.path, 'rb') as f:
    139. 

  139.                     self.send_response(200)
    140. 

  140.                     self.send_header('Content-type', types_map[ext])
    141. 

  141.                     self.end_headers()
    142. 

  142.                     self.wfile.write(f.read())
    143. 

  143.             if ext in (".html", ".css",".js"):                  # text files only, not binary (images)
    144. 

  144.                  with open('.'+self.path) as f:
    145. 

  145.                     self.send_response(200)
    146. 

  146.                     self.send_header('Content-type', types_map[ext])
    147. 

  147.                     self.end_headers()
    148. 

  148.                     self.wfile.write(bytes(f.read(), 'utf-8'))
    149. 

  149.             if self.path.endswith("/hello"):
    150. 

  150.                 self.send_response(200)
    151. 

  151.                 self.send_header('Content-type', 'text/html')
    152. 

  152.                 self.end_headers()
    153. 

  153.                 ho = htmlizer()
    154. 

  154.                 ho.title    = 'Hello form'
    155. 

  155.                 ho.head     = 'Hello'
    156. 

  156.                 ho.body     = 'some text here'
    157. 

  157.                 ho.foot     = 'little test footnote'
    158. 

  158.                 ho.prompt   = 'what should I say?'
    159. 

  159.                 ho.action   = '/hello'
    160. 

  160.                 ho.renderForm()
    161. 

  161.                 output = bytes(ho.__repr__(), 'utf-8')
    162. 

  162.                 self.wfile.write(output)
    163. 

  163. #                logger.debug(output)
    164. 

  164.                 return
    165. 

  165.             if self.path.endswith("/hola"):
    166. 

  166.                 self.send_response(200)
    167. 

  167.                 self.send_header('Content-type', 'text/html')
    168. 

  168.                 self.end_headers()
    169. 

  169.                 ho = htmlizer()
    170. 

  170.                 ho.title    = 'Hola form'
    171. 

  171.                 ho.head     = '&#161Hola <a href = "/hello" ">Back to Hello</a>'
    172. 

  172.                 ho.body     = 'some text here'
    173. 

  173.                 ho.foot     = 'little test footnote'
    174. 

  174.                 ho.prompt   = 'what should I say?'
    175. 

  175.                 ho.action   = '/hola'
    176. 

  176.                 ho.renderForm()
    177. 

  177.                 output = bytes(ho.__repr__(), 'utf-8')
    178. 

  178.                 self.wfile.write(output)
    179. 

  179. #                logger.debug(output)
    180. 

  180.                 return
    181. 

  181.             if self.path.endswith("/restaurants"):
    182. 

  182.                 self.send_response(200)
    183. 

  183.                 self.send_header('Content-type', 'text/html')
    184. 

  184.                 self.end_headers()
    185. 

  185.                 ho = htmlizer()
    186. 

  186.                 ho.renderRest(rest)
    187. 

  187.                 output = bytes(ho.__repr__(), 'utf-8')
    188. 

  188.                 self.wfile.write(output)
    189. 

  189. #                logger.debug(output)
    190. 

  190.                 return
    191. 

  191.             if self.path.endswith("/restaurants/new"):
    192. 

  192.                 self.send_response(200)
    193. 

  193.                 self.send_header('Content-type', 'text/html')
    194. 

  194.                 self.end_headers()
    195. 

  195.                 ho = htmlizer()
    196. 

  196.                 ho.title        = 'New Restaurant'
    197. 

  197.                 ho.head         = 'Make a New Restaurant'
    198. 

  198.                 ho.body         = 'please enter restaurant name'
    199. 

  199.                 ho.foot         = 'new restaurant form'
    200. 

  200.                 ho.prompt       = "enter name"
    201. 

  201.                 ho.action       = '/restaurants/new'
    202. 

  202.                 ho.placeholder  = 'new restaurant name'
    203. 

  203.                 ho.name         = 'NewRestaurantName'
    204. 

  204.                 ho.value        = 'Create'
    205. 

  205.                 ho.renderForm()
    206. 

  206. #                logger.debug('do_GET' + ho.__repr__())
    207. 

  207.                 output = bytes(ho.__repr__(), 'utf-8')
    208. 

  208.                 self.wfile.write(output)
    209. 

  209.                 return
    210. 

  210. #            if self.path.endswith(r"/restaurants/([0-9]+)/edit"):
    211. 

  211.             if self.path.endswith("/edit"):
    212. 

  212.                 rest_ID         = self.path.split('/')[-2]
    213. 

  213.                 curRest         = rest.filter_by(id=rest_ID).one()
    214. 

  214.                 self.send_response(200)
    215. 

  215.                 self.send_header('Content-type', 'text/html')
    216. 

  216.                 self.end_headers()
    217. 

  217.                 ho = htmlizer()
    218. 

  218.                 ho.title        = curRest.name
    219. 

  219.                 ho.head         = 'Restaurant: {0}'.format(curRest.name)
    220. 

  220.                 ho.body         = 'update restaurant name'
    221. 

  221.                 ho.foot         = 'update restaurant form'
    222. 

  222.                 ho.prompt       = "enter name"
    223. 

  223.                 ho.action       = '/restaurants/{0}/edit'.format(rest_ID)
    224. 

  224.                 ho.placeholder  = 'updated restaurant name'
    225. 

  225.                 ho.name         = 'NewRestaurantName'
    226. 

  226.                 ho.value        = 'Update'
    227. 

  227.                 ho.renderForm()
    228. 

  228.                 output = bytes(ho.__repr__(), 'utf-8')
    229. 

  229.                 self.wfile.write(output)
    230. 

  230.                 logger.debug(output)
    231. 

  231.                 return
    232. 

  232.             if self.path.endswith("/delete"):
    233. 

  233.                 rest_ID         = self.path.split('/')[-2]
    234. 

  234.                 curRest         = rest.filter_by(id=rest_ID).one()
    235. 

  235.                 self.send_response(200)
    236. 

  236.                 self.send_header('Content-type', 'text/html')
    237. 

  237.                 self.end_headers()
    238. 

  238.                 ho = htmlizer()
    239. 

  239.                 ho.title        = curRest.name
    240. 

  240.                 ho.head         = 'Delete Restaurant: {0}'.format(curRest.name)
    241. 

  241.                 ho.body         = 'Delete Restaurant'
    242. 

  242.                 ho.foot         = 'delete restaurant form'
    243. 

  243.                 ho.prompt       = "delete restaurant?"
    244. 

  244.                 ho.action       = '/restaurants/{0}/delete'.format(rest_ID)
    245. 

  245. #                 ho.placeholder  = 'updated restaurant name'
    246. 

  246. #                 ho.name         = 'NewRestaurantName'
    247. 

  247.                 ho.value        = 'Delete'
    248. 

  248.                 ho.renderForm()
    249. 

  249.                 output = bytes(ho.__repr__(), 'utf-8')
    250. 

  250.                 self.wfile.write(output)
    251. 

  251.                 logger.debug(output)
    252. 

  252.                 return
    253. 

  253.             if self.path.endswith("/restaurant_list"):
    254. 

  254.                 self.send_response(200)
    255. 

  255.                 self.send_header('Content-type', 'text/html')
    256. 

  256.                 self.end_headers()
    257. 

  257.                 rest_list = sorted([item.name for item in rest])
    258. 

  258.                 output = bytes(htmlizer(list = rest_list, title='Restaurant List', head='List of Restaurants', body='additional body text...', foot='end of list').__repr__(), 'utf-8')
    259. 

  259.                 self.wfile.write(output)
    260. 

  260. #                logger.debug(output)
    261. 

  261.                 return
    262. 

  262.         except IOError:
    263. 

  263.             self.send_error(404, "File Not Found %s" % self.path)
    264. 

  264.     def do_POST(self):
    265. 

  265.         try:
    266. 

  266.             if self.path.endswith("/restaurants/new"):
    267. 

  267.                 ctype, pdict = cgi.parse_header(self.headers.get('content-type'))
    268. 

  268.                 logger.debug('do_POST (ctype): ' + str(ctype))
    269. 

  269.                 pdict['boundary'] = pdict['boundary'].encode('utf-8')
    270. 

  270.                 if ctype == 'multipart/form-data':
    271. 

  271.                     fields=cgi.parse_multipart(self.rfile, pdict)
    272. 

  272.                     messagecontent = fields.get('NewRestaurantName')
    273. 

  273.                 restName = messagecontent[0].decode('ascii')
    274. 

  274.                 logger.debug('do_POST (restName): ' + restName)
    275. 

  275.                 newRestaurant = Restaurant(name=restName)
    276. 

  276.                 session.add(newRestaurant)
    277. 

  277.                 session.commit()
    278. 

  278.                 self.send_response(200)
    279. 

  279. #                 self.send_response(301)
    280. 

  280. #                 self.send_header('Content-type', 'text/html')
    281. 

  281. #                 self.send_header('Location', '/restaurants')
    282. 

  282.                 self.end_headers()
    283. 

  283.                 ho = htmlizer()
    284. 

  284.                 ho.title        = 'New Restaurant'
    285. 

  285.                 ho.head         = 'Restaurant Added'
    286. 

  286.                 ho.body         = restName
    287. 

  287.                 ho.foot         = '<a href = "/restaurants">Back to Restaurants</a>'
    288. 

  288.                 ho.renderHTML()
    289. 

  289.                 output = bytes(ho.__repr__(), 'utf-8')
    290. 

  290.                 self.wfile.write(output)
    291. 

  291.                 return
    292. 

  292.             if self.path.endswith("/edit"):
    293. 

  293.                 rest_ID         = self.path.split('/')[-2]
    294. 

  294.                 curRest         = rest.filter_by(id=rest_ID).one()
    295. 

  295.                 ctype, pdict = cgi.parse_header(self.headers.get('content-type'))
    296. 

  296.                 logger.debug('do_POST (ctype): ' + str(ctype))
    297. 

  297.                 pdict['boundary'] = pdict['boundary'].encode('utf-8')
    298. 

  298.                 if ctype == 'multipart/form-data':
    299. 

  299.                     fields=cgi.parse_multipart(self.rfile, pdict)
    300. 

  300.                     messagecontent = fields.get('NewRestaurantName')
    301. 

  301.                 newRestName = messagecontent[0].decode('ascii')
    302. 

  302.                 logger.debug('do_POST (restName): ' + newRestName)
    303. 

  303.                 curRest.name = newRestName
    304. 

  304.                 session.add(curRest)
    305. 

  305.                 session.commit()
    306. 

  306.                 self.send_response(200)
    307. 

  307. #                 self.send_response(301)
    308. 

  308. #                 self.send_header('Content-type', 'text/html')
    309. 

  309. #                 self.send_header('Location', '/restaurants')
    310. 

  310.                 self.end_headers()
    311. 

  311.                 ho = htmlizer()
    312. 

  312.                 ho.title        = 'Edit Restaurant'
    313. 

  313.                 ho.head         = 'Restaurant Name Updated'
    314. 

  314.                 ho.body         = newRestName
    315. 

  315.                 ho.foot         = '<a href = "/restaurants">Back to Restaurants</a>'
    316. 

  316.                 ho.renderHTML()
    317. 

  317.                 output = bytes(ho.__repr__(), 'utf-8')
    318. 

  318.                 self.wfile.write(output)
    319. 

  319.                 return
    320. 

  320.             if self.path.endswith("/delete"):
    321. 

  321.                 rest_ID         = self.path.split('/')[-2]
    322. 

  322.                 curRest         = rest.filter_by(id=rest_ID).one()
    323. 

  323. #                 ctype, pdict = cgi.parse_header(self.headers.get('content-type'))
    324. 

  324. #                 logger.debug('do_POST (ctype): ' + str(ctype))
    325. 

  325. #                 pdict['boundary'] = pdict['boundary'].encode('utf-8')
    326. 

  326. #                 if ctype == 'multipart/form-data':
    327. 

  327. #                     fields=cgi.parse_multipart(self.rfile, pdict)
    328. 

  328. #                     messagecontent = fields.get('NewRestaurantName')
    329. 

  329. #                 newRestName = messagecontent[0].decode('ascii')
    330. 

  330. #                 logger.debug('do_POST (restName): ' + newRestName)
    331. 

  331. #                curRest.name = newRestName
    332. 

  332. #                session.add(curRest)
    333. 

  333.                 session.delete(curRest)
    334. 

  334.                 session.commit()
    335. 

  335.                 self.send_response(200)
    336. 

  336. #                 self.send_response(301)
    337. 

  337. #                 self.send_header('Content-type', 'text/html')
    338. 

  338. #                 self.send_header('Location', '/restaurants')
    339. 

  339.                 self.end_headers()
    340. 

  340.                 ho = htmlizer()
    341. 

  341.                 ho.title        = 'Restaurant Deleted'
    342. 

  342.                 ho.head         = 'Restaurant Deleted'
    343. 

  343.                 ho.body         = curRest.name
    344. 

  344.                 ho.foot         = '<a href = "/restaurants">Back to Restaurants</a>'
    345. 

  345.                 ho.renderHTML()
    346. 

  346.                 output = bytes(ho.__repr__(), 'utf-8')
    347. 

  347.                 self.wfile.write(output)
    348. 

  348.                 return
    349. 

  349.             if self.path.endswith("/hello"):
    350. 

  350. #            if self.path.endswith("/hello") or self.path.endswith("/hola"):
    351. 

  351.                 self.send_response(301)
    352. 

  352.                 self.end_headers()
    353. 

  353.                 ctype, pdict = cgi.parse_header(self.headers.get('content-type'))
    354. 

  354.                 logger.debug(type(ctype), ctype)
    355. 

  355.                 logger.debug(type(pdict), pdict)
    356. 

  356.                 pdict['boundary'] = pdict['boundary'].encode('utf-8')
    357. 

  357.                 if ctype == 'multipart/form-data':
    358. 

  358.                     fields=cgi.parse_multipart(self.rfile, pdict)
    359. 

  359.                     messagecontent = fields.get('message')
    360. 

  360.                 ho = htmlizer()
    361. 

  361.                 ho.title        = 'Echo'
    362. 

  362.                 ho.head         = 'How about this...?'
    363. 

  363.                 ho.body         = messagecontent[0].decode('ascii')
    364. 

  364.                 ho.foot         = 'echo messages'
    365. 

  365.                 ho.prompt       = 'what else should I say?'
    366. 

  366.                 ho.action       = '/hello'
    367. 

  367.                 ho.placeholder  = 'message'
    368. 

  368.                 ho.name         = 'message'
    369. 

  369.                 ho.value        = 'Submit'
    370. 

  370.                 ho.renderForm()
    371. 

  371.                 output = bytes(ho.__repr__(), 'utf-8')
    372. 

  372.                 self.wfile.write(output)
    373. 

  373.                 return
    374. 

  374.         except IOError:
    375. 

  375.             logger.exception("IOError", exc_info=1)
    376. 

  376.             pass
    377. 

  377. 

  378. class htmlizer(object):
    379. 

  379.     '''to structure html page'''
    380. 

  380.     title       = 'test_title'
    381. 

  381.     head        = 'header_text'
    382. 

  382.     body        = 'body_text'
    383. 

  383.     foot        = 'footer_stuff'
    384. 

  384.     list        = None
    385. 

  385.     prompt      = None
    386. 

  386.     action      = None
    387. 

  387.     placeholder = 'message'
    388. 

  388.     name        = None
    389. 

  389.     value       = 'Submit'
    390. 

  390.     form        = ''
    391. 

  391.     doc         = ''
    392. 

  392.     def __init__(self):
    393. 

  393.         pass
    394. 

  394.     def __repr__(self):
    395. 

  395.         '''method for generating page'''
    396. 

  396.         return self.doc
    397. 

  397.     def renderList(self, list):
    398. 

  398.         '''simple list replaced body'''
    399. 

  399.         self.body = str('<br>'.join(list))
    400. 

  400.         self.renderHTML()
    401. 

  401.     def renderRest(self, rest):
    402. 

  402.         '''use restaurant_id as key for edit and delete replaces body'''
    403. 

  403.         self.title='Restaurants'
    404. 

  404.         self.head='List of Restaurants'
    405. 

  405.         self.foot='<a href = "/restaurants/new">Add new restaurant</a>'
    406. 

  406.         self.rest_list = []
    407. 

  407.         for item in rest:
    408. 

  408.             self.rest_list.append('{0}&nbsp<a href="/restaurants/{1}/edit">edit</a>&nbsp<a href="/restaurants/{1}/delete">delete</a>'.format(item.name, str(item.id)))
    409. 

  409.         self.body = '<br>'.join(sorted(self.rest_list))
    410. 

  410. #         self.body = ""
    411. 

  411. #         for item in rest:
    412. 

  412. #             self.body += '<br>{0}&nbsp<a href="/restaurants/{1}/edit">edit</a>&nbsp<a href="/restaurants/{1}/delete">delete</a>'.format(item.name, str(item.id))
    413. 

  413.         self.renderHTML()
    414. 

  414.     def renderForm(self):
    415. 

  415.         '''form appended to body'''
    416. 

  416.         self.body += '<form method="POST" enctype="multipart/form-data" action="{0}">'.format(self.action)
    417. 

  417.         if self.name != None:
    418. 

  418.             self.body += '<br><input name="{0}" type="text" placeholder="{1}">'.format(self.name, self.placeholder) 
    419. 

  419.         self.body += '<input type="submit" value="{0}"></form>'.format(self.value)
    420. 

  420. #         self.body += str(
    421. 

  421. #             '<form method="POST" enctype="multipart/form-data" ' +
    422. 

  422. #             'action="%s"><br><input name="%s" type="text" placeholder="%s">' % (self.action, self.name, self.placeholder) +
    423. 

  423. #             '<input type="submit" value="%s"></form>' % self.value)
    424. 

  424.         self.renderHTML()
    425. 

  425.     def renderHTML(self):
    426. 

  426.         self.doc    = str(
    427. 

  427.             '<!DOCTYPE html>' +
    428. 

  428.             '<meta charset="utf-8">' +
    429. 

  429.             '<html>' +
    430. 

  430.             '<head>' +
    431. 

  431.             '    <title>' + self.title + '</title>' +
    432. 

  432.             '    <link rel="icon" href="/image/favicon.ico">' +
    433. 

  433.             '    <link rel="stylesheet" type="text/css" href="/css/bootstrap.min.css" />' +
    434. 

  434.             '    <link rel="stylesheet" type="text/css" href="/css/restaurant.css" />' +
    435. 

  435.             '</head>' + 
    436. 

  436.             '<body>' +
    437. 

  437.             '    <div class="container-fluid">' +
    438. 

  438.                      self.head +
    439. 

  439.             '        <p>' +
    440. 

  440.                      self.body +
    441. 

  441.             '        </p>' +
    442. 

  442.             '        <script src="/js/jquery.min.js"></script>' +
    443. 

  443.             '        <script src="/js/bootstrap.min.js"></script>' +
    444. 

  444.             '    </div>' +
    445. 

  445.             '</body>' +
    446. 

  446.             '    <div class="container-fluid">' +
    447. 

  447.                  self.foot +
    448. 

  448.             '    </div>' +
    449. 

  449.             '</html>')
    450. 

  450.     def renderTable(self, dict):
    451. 

  451.         pass
    452. 

  452. #                 <table class="table table-condensed">
    453. 

  453. #                     <thead>
    454. 

  454. #                         <tr>
    455. 

  455. #                             <th>'Restaurant'</th>
    456. 

  456. #                             <th>QF Name</th>
    457. 

  457. #                             <th>Versions</th>
    458. 

  458. #                         </tr>
    459. 

  459. #                     </thead>
    460. 

  460. #                     {%for model in models%}
    461. 

  461. #                     <tbody>
    462. 

  462. #                         <tr>
    463. 

  463. #                             <td>{{model['class']}}</td>
    464. 

  464. #                             <td>{{model['qf_name']}}</td>
    465. 

  465. #                             <td>{{model['versions']}}</td>
    466. 

  466. #                         </tr>
    467. 

  467. #                     </tbody>
    468. 

  468. #                     {%end%}
    469. 

  469. #                 </table>
    470. 

  470. 

  471. # class Server(object):
    472. 

  472. #     '''server object for assembling model objects'''
    473. 

  473. #     freshness   = 3600
    474. 

  474. #     def __init__(self, db=args.mongo_server):
    475. 

  475. #         args.mongo_server = db or args.mongo_server
    476. 

  476. # #        self.db = args.mongo_server
    477. 

  477. #         self.r = rplace.RPLACE(args.mongo_server)
    478. 

  478. #         self.h = html_obj()
    479. 

  479. #         self.refreshed = 0
    480. 

  480. #         self.refresh()
    481. 

  481. #         self.r.setChildNodes()
    482. 

  482. #         self.r.setMiniNodes()
    483. 

  483. #         self.setRouteTable()
    484. 

  484. #         if args.start == False: pargs()
    485. 

  485. #     def load(self):
    486. 

  486. #         self.r.setObjViv()
    487. 

  487. #     def refresh(self, force=False):
    488. 

  488. #         '''refresh models from DAO, store in sorted order based on sort keys'''
    489. 

  489. #         print(util.logger('IO read') + 'refreshing server objects...')
    490. 

  490. #         force = bool(force)
    491. 

  491. #         if force == True or self.refreshed < int(util.strftime('%s',util.localtime())) - self.freshness:
    492. 

  492. #             self.load()
    493. 

  493. #             self.refreshed  = int(util.strftime('%s',util.localtime()))
    494. 

  494. #             print(util.logger('Status') + 'server objects last refreshed: ' + str(util.strftime('%Y-%m-%d %H:%M:%S',util.localtime(self.refreshed))))
    495. 

  495. #             logger.error('server objects last refreshed: ' + str(util.strftime('%Y-%m-%d %H:%M:%S',util.localtime(self.refreshed))))
    496. 

  496. #         return
    497. 

  497. #     def getRefreshedTime(self): return util.displayTime(option=1, value=self.refreshed)
    498. 

  498. #     def setRouteTable(self):
    499. 

  499. #         self.route_table = Application([
    500. 

  500. #             # -- pages --#
    501. 

  501. #             url(r"/", MainHandler),
    502. 

  502. #             url(r"/(robots.txt|sitemap.xml)", StaticFileHandler, {"path": "admin/"}),
    503. 

  503. #             url(r"/objectives", ObjectiveHandler),
    504. 

  504. #             # -- data --#
    505. 

  505. #             url(r"/data/(.*)", StaticFileHandler, {"path": "data/"}),
    506. 

  506. #             url(r"/objective_json", ObjectiveJSONHandler),
    507. 

  507. #             url(r"/mini_nodes", MiniNodeHandler),
    508. 

  508. #             url(r"/obj_nodes", ObjectiveNodeHandler),
    509. 

  509. #             # -- files --#
    510. 

  510. #             url(r"/html/(.*)", StaticFileHandler, {"path": "html/"}),
    511. 

  511. #             url(r"/fonts/(.*)", StaticFileHandler, {"path": "fonts/"}),
    512. 

  512. #             url(r"/image/(.*)", StaticFileHandler, {"path": "image/"}),
    513. 

  513. #             url(r"/css/(.*)", StaticFileHandler, {"path": "css/"}),
    514. 

  514. #             url(r"/js/(.*)", StaticFileHandler, {"path": "js/"}),
    515. 

  515. #             # -- test --#
    516. 

  516. #             url(r"/app", RedirectHandler, dict(url="http://itunes.apple.com/my-app-id")),
    517. 

  517. #             url(r"/co", CoHandler),
    518. 

  518. #             url(r"/api/", ApiHandler),
    519. 

  519. #             url(r"/hello", HelloHandler),
    520. 

  520. #             url(r"/hello_body", HelloBodyHandler),
    521. 

  521. #             url(r"/myform", FormHandler),
    522. 

  522. #             url(r"/static/(.*)", StaticFileHandler, {"path": "html/"}),
    523. 

  523. #             url(r"/example/([0-9]+)", ExampleHandler, dict(db=None), name="example"),
    524. 

  524. #             url(r"/story/([0-9]+)", StoryHandler, dict(db=None), name="story"),
    525. 

  525. #             url(r"/template", TemplateHandler), 
    526. 

  526. #             url(r"/template_html", TemplateHandler, {"path": "html/"}), 
    527. 

  527. #         #    url(r"/photos/(.*)", MyPhotoHandler),
    528. 

  528. #         #    url(r"/pictures/(.*)", tornado.web.RedirectHandler, dict(url=r"/photos/\1")),
    529. 

  529. #         ],debug=args.debug)
    530. 

  530. # 
    531. 

  531. # ## =====================
    532. 

  532. # ## == handler classes ==
    533. 

  533. # ## =====================
    534. 

  534. # 
    535. 

  535. # class MainHandler(RequestHandler):
    536. 

  536. #     '''main route'''
    537. 

  537. #     def get(self):
    538. 

  538. #         self.render('html/index.html')
    539. 

  539. # #        self.write('<a href="%s">link to story 1</a>' % self.reverse_url("story", "1"))
    540. 

  540. # 
    541. 

  541. # class ObjectiveHandler(RequestHandler):
    542. 

  542. #     '''starburst route'''
    543. 

  543. #     def get(self):
    544. 

  544. #         self.render('html/sunburst.html')
    545. 

  545. # 
    546. 

  546. # class ObjectiveJSONHandler(RequestHandler):
    547. 

  547. #     '''autoviv derived json built from objectives'''
    548. 

  548. #     def get(self):
    549. 

  549. #         self.write(s.r.objective_viv)
    550. 

  550. # 
    551. 

  551. # class MiniNodeHandler(RequestHandler):
    552. 

  552. #     '''children node derived json built from objectives'''
    553. 

  553. #     def get(self):
    554. 

  554. #         self.write(s.r.obj_mini)
    555. 

  555. # 
    556. 

  556. # class ObjectiveNodeHandler(RequestHandler):
    557. 

  557. #     '''children node derived json built from objectives'''
    558. 

  558. #     def get(self):
    559. 

  559. #         self.write(s.r.obj_children)
    560. 

  560. 

  561. ## ====================
    562. 

  562. ## == db connection ==
    563. 

  563. ## ===================
    564. 

  564. 

  565. try:
    566. 

  566.     session = sessionmaker()(bind=create_engine('sqlite:///restaurant.db'))
    567. 

  567. 

  568. #    engine              = create_engine('sqlite:///restaurant.db')     # multi-line approach
    569. 

  569. #    Base.metadata.bind  = engine
    570. 

  570. #    DBSession           = sessionmaker(bind=engine)                    # can bind when creating sessionmaker instance
    571. 

  571. #    session             = DBSession()
    572. 

  572. #    DBSession           = sessionmaker()                               # or after
    573. 

  573. #    session             = DBSession(bind=engine)
    574. 

  574. 

  575.     emp     = session.query(Employee)                                   # load global objects for convenience
    576. 

  576.     rest    = session.query(Restaurant)
    577. 

  577.     addr    = session.query(Address)
    578. 

  578.     mi      = session.query(MenuItem)
    579. 

  579. 

  580. #     db      = DB()                                                    # prefer to put in a class
    581. 

  581. #     emp     = db.session.query(Employee)
    582. 

  582. #     rest    = db.session.query(Restaurant)
    583. 

  583. #     addr    = db.session.query(Address)
    584. 

  584. #     mi      = db.session.query(MenuItem)
    585. 

  585. except:
    586. 

  586.     logger.exception("issue loading restaurant database items", exc_info=1)
    587. 

  587. 

  588. ## ====================================================
    589. 

  589. ## == create server object and run bottle -> tornado ==
    590. 

  590. ## ====================================================
    591. 

  591. 

  592. def main():
    593. 

  593.     try:
    594. 

  594.         server = HTTPServer(('', args.port), webserverHandler)
    595. 

  595.         log_info = "HTTPServer started " + os.environ['HOSTNAME'] + ':' + str(args.port) + ' debug=' + str(args.debug) + ' log_file=' + str(args.log_file)
    596. 

  596.         logger.info(log_info)
    597. 

  597.         server.serve_forever()
    598. 

  598.     except KeyboardInterrupt:
    599. 

  599.         logger.info("HTTPServer stopped via control-C")
    600. 

  600.         server.socket.close()                                # server not in scope...
    601. 

  601.     except OSError:
    602. 

  602.         logger.exception("HTTPServer server already running?", exc_info=1)
    603. 

  603.     except:
    604. 

  604.         logger.exception("hmmm, we have a problem", exc_info=1)
    605. 

  605. #        server.socket.close()                                # server not in scope...
    606. 

  606. 

  607. if args.start   == True:
    608. 

  608. #if __name__== '__main__':
    609. 

  609.     main()
    610. 

  610.     
    611. 

  611. 

  612. # def main
    613. 

  613. # if args.start   == True:
    614. 

  614. #     global s
    615. 

  615. #     s                       = Server(db=args.mongo_server)
    616. 

  616. #     logger.info('Tornado server running on: ' + os.environ['HOSTNAME'] + ':' + str(args.port) + ' debug = ' + str(args.debug))
    617. 

  617. #     s.route_table.listen(args.port)
    618. 

  618. #     IOLoop.current().start()
    619. 

  619. #     enable_pretty_logging()
    620.