Python DBHelper.setup Examples

Example #1

import webapp2
import json
import requests
import requests_toolbelt.adapters.appengine
import os
import traceback
from sqlhelper import DBHelper
from reservation_bot import handle_updates

requests_toolbelt.adapters.appengine.monkeypatch()

db = DBHelper()
db.setup()


class MainPage(webapp2.RequestHandler):
    def get(self):
        self.response.headers['Content-Type'] = 'text/plain'
        self.response.write('Bot Initialized\n')


class DataInfoPage(webapp2.RequestHandler):
    def get(self):
        self.response.headers['Content-Type'] = 'text/plain'
        cursor = db.conn.cursor()

        #Show databases
        self.response.write('\nDATABASES\n')
        cursor.execute('SHOW DATABASES')
        for r in cursor.fetchall():
            self.response.write('{}\n'.format(r))