Untitled

    def get(self):
        # [START urllib-get]
        url = 'http://www.google.com/humans.txt'
        config = dict(host="postgresql-1-vm", database="hcl", user="postgres", password="omYSaG8t")
        sql = '''
        SELECT * FROM greetings ;
        '''
        self.response.write('<html>')
        self.response.write('<body>')
        self.response.write('<table>')
        with psycopg2.connect(**config) as conn:
            with conn.cursor() as curs:
                curs.execute(sql)
                for row in curs.fetchall():
                    self.response.write('<tr>')
                    self.response.write('<td>%s</td>' % row[0])
                    self.response.write('<td>%s</td>' % row[1])
                    self.response.write('<td>%s</td>' % row[2])
                    self.response.write('<td>%s</td>' % row[3])
                    self.response.write('</tr>')
        self.response.write('</table>')
        self.response.write('</body>')
        self.response.write('</html>')
        try:
            result = urllib2.urlopen(url)
            self.response.write(result.read())
        except urllib2.URLError:
            logging.exception('Caught exception fetching url')
        # [END urllib-get]