title: Connect to SQLite database in web app
body: <p>I am trying to connect to a database object I created for use in a web app.</p>
  
  <p>The python code for the app is the following:</p>
  
  <pre><code>import os
  import jinja2
  import webapp2
  import sqlite3
  #from google.appengine.ext import db
  
  template_dir = os.path.join(os.path.dirname(__file__), 'templates')
  jinja_env = jinja2.Environment(loader = jinja2.FileSystemLoader(template_dir), autoescape = True)
  
  class Handler(webapp2.RequestHandler):
      def write(self, *a, **kw):
          self.response.out.write(*a,**kw)
  
      def render_str(self, template, **params):
          t = jinja_env.get_template(template)
          return t.render(params)
  
      def render(self, template, **kw):
          self.write(self.render_str(template, **kw))
  
  #class bars_data():
  #    def createdb(self):
          #barsdb = sqlite3.connect('bardatabase.db')
          #barsdb.execute("DROP TABLE if exists bars")
          #barsdb.execute("create table bars(name text, address text, state int)")
          #barsdb.execute('Insert into bars (name, address, state) VALUES(?,?,?)',("Hoolies", '24 Glebe Rd', 10))
          #barsdb.execute('Insert into bars (name, address, state) VALUES(?,?,?)',("Bar1", '25 Main St', 10))
          #barsdb.execute('Insert into bars (name, address, state) VALUES(?,?,?)',('Cafe Doug', '35 Summer St.', 5))
          #barsdb.execute('Insert into bars (name, address, state) VALUES(?,?,?)',("McMurphy", '25 F Street', 20))
          #barsdb.commit()       
  
  class MainPage(Handler):
      def get(self):
          barsdb = sqlite3.connect('bardatabase.db')
          query = barsdb.cursor()
          bars_list = barsdb.execute("SELECT name FROM barsdb")
  
          self.render("index.html")
  
  app = webapp2.WSGIApplication([
      ('/', MainPage)
  ], debug=True)
  </code></pre>
  
  <p>I used the code in "class bars_data()" to originally create the data base file which is in the same directory as the rest of the source code files but since I do not run it with the app I commented it out.  I am not sure if I need to recreate the database/table when I run the app so included it if this is the case.  I want to access the bar names from the database and write it to the page using jinja.</p>
  
  <p>I am using the Google App Engine to run it.  I know I could use the data store but this seemed an easier way to create a static database.</p>
  
  <p>When I try to run the app nothing will render.  But when I remove the code tyring to make the database connection my "index.html" template will again render in the browser.  What am I doing wrong?</p>