APP

import webapp2
import cgi
import datetime
import urllib
import wsgiref.handlers
import jinja2
import os

from google.appengine.ext import db
from google.appengine.api import users
from google.appengine.ext import webapp
from google.appengine.ext.webapp.util import run_wsgi_app

jinja_environment = jinja2.Environment(
    loader=jinja2.FileSystemLoader(os.path.dirname(__file__)))

# Data bases
class db_Person(db.Model):
    kennitala = int()
    nafn = db.StringProperty()
    heimili = db.StringProperty()
    postnumer = db.StringProperty()
    stadur = db.StringProperty()
    land = db.StringProperty()
    simi = int()
    gsm = int()

class db_Eigandi(db.Model):
    kennitala = int()
    nafn = db.StringProperty()
    heimili = db.StringProperty()
    postnumer = db.StringProperty()
    stadur = db.StringProperty()
    land = db.StringProperty()
    simi = int()

class db_Vel(db.Model):
    skraningarnr = db.StringProperty()
    tegund = db.StringProperty()
    typa = db.StringProperty()
    serial = db.StringProperty()
    argerd = db.StringProperty()
    flokkur = db.StringProperty()
    eigandi = db.StringProperty()

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

        notandi = users.get_current_user()
        email = 'def'
        url = ''

        email = notandi.nickname()
        url = users.create_logout_url(self.request.uri)

        template_values = {
            'email': email,
            'url': url
        }

        template = jinja_environment.get_template('index.html')
        self.response.out.write(template.render(template_values))

class add(webapp2.RequestHandler):
    def get(self):

        message = ""

        template_values = {
            'message': message
        }

        template = jinja_environment.get_template('breyta.html')
        self.response.out.write(template.render(template_values))

    def post(self):
        q = db.Query(db_Person)

        message = "Innsetning tokst"

        in_kennitala = int(self.request.get('p_kennitala'))
        in_nafn = self.request.get('p_nafn')
        in_heimili = self.request.get('p_heimili')
        in_postnumer = self.request.get('p_postnumer')
        in_stadur = self.request.get('p_stadur')
        in_land = self.request.get('p_land')
        in_simi = int(self.request.get('p_simi'))
        in_gsm = int(self.request.get('p_gsm')

        B = db_Person(nafn='Alex')
        B.put()

        template_values = {
            'message': message
        }

        template = jinja_environment.get_template('breyta.html')
        self.response.out.write(template.render(template_values))


class skoda(webapp2.RequestHandler):
    def get(self):

        tafla_p = ''
        tafla_e = ''
        tafla_v = ''
        q = db.Query(db_Person)
        qe = db.Query(db_Eigandi)
        qv = db.Query(db_Vel)

        #Persona tafla
        tafla_p = """<table border="1" cellpadding="3" id="persona">"""

        #persona.kennitala
        tafla_p += """<tr><th>Kennitala</th>"""
        for db_person in q.run():
            tafla_p += """<td>"""
            if db_person.kennitala != 0:
                tafla_p += str(db_person.kennitala)
            tafla_p +="""</td>"""
        tafla_p += """</tr>"""

        #persona.nafn
        tafla_p += """<tr><th>Nafn</th>"""
        for db_person in q.run():
            tafla_p += """<td>"""
            if db_person.nafn:
                tafla_p += db_person.nafn
            tafla_p +="""</td>"""
        tafla_p += """</tr>"""

        #persona.heimili
        tafla_p += """<tr><th>Heimili</th>"""
        for db_person in q.run():
            tafla_p += """<td>"""
            if db_person.heimili:
                tafla_p += db_person.heimili
            tafla_p +="""</td>"""
        tafla_p += """</tr>"""

        #persona.postnumer
        tafla_p += """<tr><th>Postnumer</th>"""
        for db_person in q.run():
            tafla_p += """<td>"""
            if db_person.postnumer:
                tafla_p += db_person.postnumer
            tafla_p +="""</td>"""
        tafla_p += """</tr>"""

        #persona.stadur
        tafla_p += """<tr><th>Stadur</th>"""
        for db_person in q.run():
            tafla_p += """<td>"""
            if db_person.stadur:
                tafla_p += db_person.stadur
            tafla_p +="""</td>"""
        tafla_p += """</tr>"""

        #persona.land
        tafla_p += """<tr><th>Land</th>"""
        for db_person in q.run():
            tafla_p += """<td>"""
            if db_person.land:
                tafla_p += db_person.land
            tafla_p +="""</td>"""
        tafla_p += """</tr>"""

        #persona.simi
        tafla_p += """<tr><th>Simi</th>"""
        for db_person in q.run():
            tafla_p += """<td>"""
            if db_person.simi != 0:
                tafla_p += str(db_person.simi)
            tafla_p +="""</td>"""
        tafla_p += """</tr>"""

        #persona.gsm
        tafla_p += """<tr><th>Gsm</th>"""
        for db_person in q.run():
            tafla_p += """<td>"""
            if db_person.gsm != 0:
                tafla_p += str(db_person.gsm)
            tafla_p +="""</td>"""
        tafla_p += """</tr>"""

        #
        #
        #Eigandi tafla
        tafla_e = """<table border="1" cellpadding="3" id="eigandi">"""

        #.kennitala
        tafla_e += """<tr><th>Kennitala</th>"""
        for db_eigandi in qe.run():
            tafla_e += """<td>"""
            if db_eigandi.kennitala != 0:
                tafla_e += str(db_eigandi.kennitala)
            tafla_e +="""</td>"""
        tafla_e += """</tr>"""

        #eigandia.nafn
        tafla_e += """<tr><th>Nafn</th>"""
        for db_eigandi in qe.run():
            tafla_e += """<td>"""
            if db_eigandi.nafn:
                tafla_e += db_eigandi.nafn
            tafla_e +="""</td>"""
        tafla_e += """</tr>"""

        #eigandia.heimili
        tafla_e += """<tr><th>Heimili</th>"""
        for db_eigandi in qe.run():
            tafla_e += """<td>"""
            if db_eigandi.heimili:
                tafla_e += db_eigandi.heimili
            tafla_e +="""</td>"""
        tafla_e += """</tr>"""

        #eigandia.postnumer
        tafla_e += """<tr><th>Postnumer</th>"""
        for db_eigandi in qe.run():
            tafla_e += """<td>"""
            if db_eigandi.postnumer:
                tafla_e += db_eigandi.postnumer
            tafla_e +="""</td>"""
        tafla_e += """</tr>"""

        #eigandia.stadur
        tafla_e += """<tr><th>Stadur</th>"""
        for db_eigandi in qe.run():
            tafla_e += """<td>"""
            if db_eigandi.stadur:
                tafla_e += db_eigandi.stadur
            tafla_e +="""</td>"""
        tafla_e += """</tr>"""

        #eigandia.land
        tafla_e += """<tr><th>Land</th>"""
        for db_eigandi in qe.run():
            tafla_e += """<td>"""
            if db_eigandi.land:
                tafla_e += db_eigandi.land
            tafla_e +="""</td>"""
        tafla_e += """</tr>"""

        #eigandia.simi
        tafla_e += """<tr><th>Simi</th>"""
        for db_eigandi in qe.run():
            tafla_e += """<td>"""
            if db_eigandi.simi != 0:
                tafla_e += str(db_eigandi.simi)
            tafla_e +="""</td>"""
        tafla_e += """</tr>"""


        #
        #
        #Vel tafla
        tafla_v = """<table border="1" cellpadding="3" id="vel">"""

        #vel.skraningarnr
        tafla_v += """<tr><th>Skraningar numer</th>"""
        for db_vel in qv.run():
            tafla_v += """<td>"""
            if db_vel.skraningarnr:
                tafla_v += db_vel.skraningarnr
            tafla_v +="""</td>"""
        tafla_v += """</tr>"""

        #vel.tegund
        tafla_v += """<tr><th>Tegund</th>"""
        for db_vel in qv.run():
            tafla_v += """<td>"""
            if db_vel.tegund:
                tafla_v += db_vel.tegund
            tafla_v +="""</td>"""
        tafla_v += """</tr>"""

        #vel.typa
        tafla_v += """<tr><th>Typa</th>"""
        for db_vel in qv.run():
            tafla_v += """<td>"""
            if db_vel.typa:
                tafla_v += db_vel.typa
            tafla_v +="""</td>"""
        tafla_v += """</tr>"""

        #vel.serial
        tafla_v += """<tr><th>Serial numer</th>"""
        for db_vel in qv.run():
            tafla_v += """<td>"""
            if db_vel.serial:
                tafla_v += db_vel.serial
            tafla_v +="""</td>"""
        tafla_v += """</tr>"""

        #vel.argerd
        tafla_v += """<tr><th>Argerd</th>"""
        for db_vel in qv.run():
            tafla_v += """<td>"""
            if db_Vel.argerd:
                tafla_v += db_Vel.argerd
            tafla_v +="""</td>"""
        tafla_v += """</tr>"""

        #vel.flokkur
        tafla_v += """<tr><th>Flokkur</th>"""
        for db_vel in qv.run():
            tafla_v += """<td>"""
            if db_Vel.flokkur:
                tafla_v += db_Vel.flokkur
            tafla_v +="""</td>"""
        tafla_v += """</tr>"""

        #vel.eigandi
        tafla_v += """<tr><th>Eigandi</th>"""
        for db_vel in qv.run():
            tafla_v += """<td>"""
            if db_Vel.eigandi:
                tafla_v += db_Vel.eigandi
            tafla_v +="""</td>"""
        tafla_v += """</tr>"""


        template_values = {
            'tafla': tafla_p,
            'tafla_e': tafla_e,
            'tafla_v': tafla_v
        }

        template = jinja_environment.get_template('skoda.html')
        self.response.out.write(template.render(template_values))



app = webapp2.WSGIApplication([
    ('/', MainPage),
    ('/heim', MainPage),
    ('/breyta', add),
    ('/skoda', skoda),
], debug=True)