import wsgiref.handlers
from google.appengine.dist import use_library
use_library('django', '1.2')

from google.appengine.ext import db
from google.appengine.ext import webapp
from google.appengine.ext.webapp import template

class Pages(db.Model):
	id = db.IntegerProperty()
	title = db.StringProperty()
	content = db.TextProperty()
	date = db.DateTimeProperty(auto_now_add=True)

	
class Song(db.Model):
    title = db.StringProperty()
    composer = db.TextProperty()
    date = db.DateTimeProperty()

#test = Song(title = 'aaa')
#test.put()
	


class MainPage(webapp.RequestHandler):
	def get(self):


		query = Song.all()
		query.filter('title =', 'aaa1')
		obj = query.fetch(1)[0]
		page_key = obj.key()
		composer = obj.composer
		
		

		#test = Song(title = 'aaa')
		#test.put()
		
	
		values = {'content': composer,'values': page_key}
	
		self.response.out.write(
								template.render('index.html', values))
	def post(self):
	
		query = Song.all()
		query.filter('title =', 'aaa1')
		obj = query.fetch(1)[0]
		page_key = obj.key()
		
		rec = db.get(page_key)
		rec.composer = self.request.get('content')
		rec.put()
		
		self.redirect('/')
		

def main():
	app = webapp.WSGIApplication([
		(r'.*', MainPage)], debug=True)
		
	wsgiref.handlers.CGIHandler().run(app)

if __name__ == '__main__':
	main()