'''
Created on 2011-10-27

@author: yuzx
'''
from tornado import database
import os
import tornado.ioloop
import tornado.web

class MainHandler(tornado.web.RequestHandler):
    def get(self):
        term_price_lst = []
        term_start_lst = []
        term_end_lst = []
        sq_lst = []
        payoff_lst = []

        db = database.Connection("10.28.9.205", "TRSBO_MAIN",'MAIN','123456')
        for term in db.query("SELECT * FROM BO_TERM_CONFIG WHERE TRADING_DATE='20111027' ORDER BY TERM_ID+0 ASC"):
            term_price_lst.append(term.TERM_STRIKE_PRICE_TIME)
            term_start_lst.append(term.TERM_TRADE_BEGIN_TIME)
            term_end_lst.append(term.TERM_TRADE_END_TIME)
            sq_lst.append(term.TERM_SQ_BEGIN_TIME)
            payoff_lst.append(term.TERM_PAYOFF_TIME)

        db.close()
        self.render("templates/bo.html",
                    term_price_lst=term_price_lst,
                    term_start_lst=term_start_lst,
                    term_end_lst=term_end_lst,
                    sq_lst=sq_lst,
                    payoff_lst=payoff_lst,
                    )

#application = tornado.web.Application([
#    (r"/", MainHandler),
#])


settings = {
    "static_path": os.path.join(os.path.dirname(__file__), "static"),
    "cookie_secret": "61oETzKXQAGaYdkL5gEmGeJJFuYh7EQnp2XdTP1o/Vo=",
    "login_url": "/login",
    "xsrf_cookies": True,
#    'debug':True,
}
application = tornado.web.Application([
    (r"/", MainHandler),
    (r"/static/.*", tornado.web.StaticFileHandler,
     dict(path=settings['static_path'])),
], **settings)

if __name__ == "__main__":
    application.listen(8080)
    tornado.ioloop.IOLoop.instance().start()