import os
from google.appengine.ext import db
from google.appengine.ext import webapp
from google.appengine.ext.webapp.util import run_wsgi_app
from google.appengine.ext.webapp import template

class MainPage(webapp.RequestHandler):
    def get(self):
	
	pg = '1'
	if self.request.get('pg') != '':
		pg = self.request.get('pg');
	
	class Pages(db.Model):
		id = db.IntegerProperty()
		title = db.StringProperty()
		content = db.TextProperty()
	
	# add new pages
	page = Pages(
					id = 1,
					title = 'Page-1',
					content = '<img src="images/App1.png" align="left" vspace="10" hspace="10" atpage2t="" />page1 page1 page1 page1 page1 page1 page1 page1 page1 page1 page1 page1 page1 page1 page1 page1 page1 page1 page1' +
								'page1 page1 page1 page1 page1 <b>page1 page1 page1 page1 page1 page1 page1</b> page1 page1 page1 page1 page1 page1 page1' +
								'page1 page1 page1 page1 page1 page1 page1 page1 page1 page1 page1 page1 page1 page1 page1 page1 page1 page1 page1'
				)
	#page.put()
	page = Pages(
					id = 2,
					title = 'Page-2',
					content = 'page2 page2 page2 page2 page2 page2 page2 page2 page2 page2 page2 page2 page2 page2 page2 page2 page2 page2' +
								'page2 page2 page2 page2 page2 page2 page2 page2 page2 page2 page2 page2 page2 page2 page2 page2 page2 page2 page2' +
								'page2 page2 page2 page2 page2 page2 page2 page2 page2 page2 page2 page2 page2 page2 page2 page2 page2 page2 page2'
				)
	#page.put()
	
	# get pages
	if pg=='1':
		results = db.GqlQuery("SELECT * FROM Pages WHERE id = 1")
	if pg=='2':
		results = db.GqlQuery("SELECT * FROM Pages WHERE id = 2")
		
	r = results.fetch(1)
	for row in r:
		#print row.title + row.content
		tmp = 1
		
        path = os.path.join(os.path.dirname(__file__), 'index.html')
        self.response.out.write(template.render(path, {'title': row.title, 'content': row.content}))

		
application = webapp.WSGIApplication(
                                     [('/', MainPage)],
                                     debug=True)

def main():
    run_wsgi_app(application)

if __name__ == "__main__":
    main()