Subversion Repositories SmartDukaan

# -*- coding: utf-8 -*-
"""Main Controller"""

from tg import expose, flash, require, url, request, redirect
from pylons.i18n import ugettext as _, lazy_ugettext as l_

from wiki20.lib.base import BaseController
from wiki20.model import DBSession, metadata
from wiki20.controllers.error import ErrorController
from wiki20.processors.RequestProcessors import process_gaurav
from datastore.DataAccessor import DataHelper
from datastore.DataCodeAccessor import *
from xml.etree.ElementTree import *
import urllib
from tg import tmpl_context
from wiki20.widgets.infibeam_form import *
from wiki20.widgets.univercell_form import *
from wiki20.widgets.indiaplaza_form import *
from wiki20.widgets.mobilestore_form import *
from wiki20.widgets.naaptol_form import *
from wiki20.widgets.babuchak_form import *

__all__ = ['RootController']


class RootController(BaseController):
    """
    The root controller for the Wiki-20 application.
    
    All the other controllers and WSGI applications should be mounted on this
    controller. For example::
    
        panel = ControlPanelController()
        another_app = AnotherWSGIApplication()
    
    Keep in mind that WSGI applications shouldn't be mounted directly: They
    must be wrapped around with :class:`tg.controllers.WSGIAppController`.
    
    """
    
    error = ErrorController()

    @expose('wiki20.templates.index')
    def index(self):
        """Handle the front-page."""
        forms = {'indiaplaza':'form_indiaplaza','infibeam':'form_infibeam',
                 'univercell':'form_univercell','naaptol':'form_naaptol',
                 'babuchak':'form_babuchak','mobilestore':'form_mobilestore'}
        print froms
        return forms

    @expose('wiki20.templates.about')
    def about(self):
        """Handle the 'about' page."""
        return dict(page='about')
    
    @expose('wiki20.templates.gaurav')
    def gaurav(self, **data):
        """ Handle gaurav url"""
        print data
        ret_val = process_gaurav(data)
        return ret_val
    
    
    @expose('wiki20.templates.compare')
    def compare(self):
        """ Handle compare url"""
        str1 = ""
        da = DataHelper()
        models = da.get_all_models()
        ret_val = {}
        for m in models:
            name = m.model
            str1 = str1 + "<option value="
            #str1 = str1 + "/'"
            str1 = str1 + unicode(name, "iso-8859-1")
            #str1 = str1 + "/'"
            str1 = str1 + ">"
            str1 = str1 + unicode(name, "iso-8859-1")
            str1 = str1 + "</option>"
            
        #print data
        #ret_val = process_compare(data)
        ret_val['val1'] = str1
        return ret_val
    
    @expose('wiki20.templates.compare_model')
    def compare_model(self,**data):
        model = data['model']
        da = DataHelper()
        mid = da.get_modbyModel(model).id
        models_list = da.get_prbyMid(mid)
        sorted(models_list, key=lambda prices: prices.supplier_id)
        leng = len(models_list)
        print "length is :"
        print leng
        price_list = []
        vendor_list = []
        while leng>0:
            price_list.append(0)
             #['infibeam','indiaplaza','mobilestore','univercell']
            leng = leng -1
        max = 0
        index = 0
        for m in models_list:
            price_list[index] = m.final_price
            index = index + 1
            s_info = ""
            s_info = s_info + str(da.get_supp_byId(m.supplier_id).name) 
            if str(m.extra_info) != "":
                s_info = s_info + " with " 
                s_info = s_info + str(m.extra_info)
            
            vendor_list.append(s_info)
            if(m.final_price > max):
                max = m.final_price
        range = 0
        if max<3000:
            range = 3000 
        elif max>=3000 and max<5000:
            range = 5000   
        elif max>=5000 and max<7000:
            range = 7000   
        elif max>=7000 and max<10000:
            range = 10000   
        elif max>=10000 and max<15000:
            range = 15000   
        elif max>=15000 and max<20000:
            range = 20000   
        elif max>=20000 and max<25000:
            range = 25000   
        elif max>=25000 and max<30000:
            range = 30000   
        elif max>=30000 and max<50000:
            range = 50000   
        str3 = ""
        for p in price_list:
            str3 = str3 + str(p) 
            str3 = str3 + ","
        str3 = str3[0:len(str3)-1]
        str4 = ""
        for v in vendor_list:
            str4 = str4 + v 
            str4 = str4 + "|"
        str4 = str4[0:len(str4)-1]
                         
        ret_val = {}
        ret_val['val1'] = str3
        ret_val['val2'] = str4
        #ret_val['val1'] = price_list
        #ret_val['val2'] = vendor_list
        str1 = ""
        models = da.get_all_models()
        for m in models:
            name = m.model
            str1 = str1 + "<option value="
            #str1 = str1 + "/'"
            str1 = str1 + unicode(name, "iso-8859-1")
            #str1 = str1 + "/'"
            if str(name) == str(model):
                str1 = str1 + " selected=yes"
            str1 = str1 + ">"
            str1 = str1 + unicode(name, "iso-8859-1")
            str1 = str1 + "</option>"
        ret_val['val3'] = str1
        ret_val['val4'] = range
        str2 = ""
        str2 = str2 + '<table align = "right"><tr><th>' 
        str2 = str2 + "vendor"
        str2 = str2 + "</th><th>"
        str2 = str2 + "price"
        str2 = str2 + "</th></tr>"
        leng = len(vendor_list)
        j = 0
        while(j<leng):
            str2 = str2 + "<tr><td>"
            str2 = str2 + str(vendor_list[j]) 
            str2 = str2 + "</td><td>"
            str2 = str2 + str(price_list[j])
            str2 = str2 + "</td></tr>"
            j = j+1
        str2 = str2 + "</table>"
        ret_val['val5'] = str2    
        return ret_val
    
            
    @expose(template="wiki20.templates.model" , content_type='text/xml')
    def model(self, **data):   
        #print " I m in "
        id = int(data['id'])
        str1 = brandname = modelname =  extra_i = sup_name = sup_site = sup_lastcrawled = ""
        quoted_p = final_p = 0
        da = DataHelper()
        mo = da.get_modbyId(id)
        brandname = mo.brand
        modelname = mo.model
        prlist = da.get_prbyMid(id)
        #print len(prlist)
        
        str1 = str1 + "<Mobile><mid>" 
        str1 = str1 + str(id)
        str1 = str1 + "</mid><barandname>" 
        str1 = str1 + unicode(brandname, "iso-8859-1")           
        str1 = str1 + "</barandname><modelname>" 
        str1 = str1 + unicode(modelname, "iso-8859-1")
        str1 = str1 + "</modelname>"
        sorted(prlist, key=lambda prices: prices.supplier_id)
        prev_sid = -1    
        ct = 0
        for pr in prlist:
            quoted_p = pr.quoted_price
            final_p = pr.final_price
            extra_i = pr.extra_info
            pid = pr.id
            sid = pr.supplier_id
            su = da.get_supp_byId(sid)
            sup_name = su.name
            sup_site = su.site
            sup_lastcrawled = su.last_crawled
            '''
            print brandname
            print modelname 
            print quoted_p
            print final_p 
            print extra_i 
            print sup_name 
            print sup_site
            print sup_lastcrawled
            '''
            
            if sid != prev_sid:
                if ct != 0:
                     str1 = str1 + "</Supplier>";
                str1 = str1 + "<Supplier>";
                str1 = str1 + "<name>" 
                str1 = str1 + unicode(sup_name, "iso-8859-1") 
                str1 = str1 + "</name><sid>" 
                str1 = str1 + str(sid)
                str1 = str1 + "</sid><site>" 
                str1 = str1 +  unicode(sup_site, "iso-8859-1")
                str1 = str1 + "</site><last_updated>"
                str1 = str1 + str(sup_lastcrawled) 
                str1 = str1 + "</last_updated>"
                prev_sid = sid
            ct = ct+1    
            str1 = str1 + "<Price><pid>"
            str1 = str1 + str(pid) 
            str1 = str1 + "</pid><quotedprice>"
            str1 = str1 + str(quoted_p) 
            str1 = str1 + "</quotedprice><finalprice>"
            str1 = str1 + str(final_p) 
            str1 = str1 + "</finalprice><extrainfo>"
            str1 = str1 + unicode(extra_i, "iso-8859-1") 
            str1 = str1 + "</extrainfo></Price>" 
            #str1 = str1 + "</Supplier>"
            #root = Element(str1)
            #xml_elem = xml.etree.ElementTree.fromstring(str1)
        str1 = str1 + "</Supplier>";
        str1 = str1 + "</Mobile>"
        ret_val = {}
        ret_val['val1'] = urllib.unquote(str1)#root
        #tree = ElementTree(root)
        #tree.write("/home/gaurav/code/TG2Test/src/wiki20/templates/model.html")
        print str1 
        return ret_val
    
    @expose(template="wiki20.templates.modelIds" , content_type='text/xml')
    def mobileIds(self):   
        da = DataHelper()
        mobiles = da.get_all_models()
        str1 = ""
        for m in mobiles:
            id = m.id
            model = m.model
            brand = m.brand
            str1 = str1 + "<Mobile><id>"
            str1 = str1 + str(id)
            str1 = str1 + "</id><model>"
            str1 = str1 + unicode(model, "iso-8859-1")
            str1 = str1 + "</model><vendor>"
            str1 = str1 + unicode(brand, "iso-8859-1")
            str1 = str1 + "</vendor></Mobile>"
        ret_val = {}
        print str1
        ret_val['val1'] = urllib.unquote(str1)#root
        return ret_val
    
    @expose('wiki20.templates.input_form')
    def form_infibeam(self, **kw):
        """Show form to add data record for infibeam."""
        initialize_table()
        create_infibeam_form = InfibeamForm("create_infibeam_form",action='save_infibeam')
        tmpl_context.form = create_infibeam_form
        de = get_code_word("INFIBEAM_DOMAINNAME")
        kw['INFIBEAM_DOMAINNAME'] = de
        #de = get_code_word("INFIBEAM_NO")
        #kw['INFIBEAM_NO'] = de
        #de = get_code_word("INFIBEAM_CT")
        #kw['INFIBEAM_CT'] = de
        de = get_code_word("INFIBEAM_URL")
        kw['INFIBEAM_URL'] = de
        de = get_code_word("INFIBEAM_HOMEPAGE")
        kw['INFIBEAM_HOMEPAGE'] = de
        de = get_code_word("INFIBEAM_REFERER")
        kw['INFIBEAM_REFERER'] = de
        de = get_code_word("INFIBEAM_VATPLUSTAX")
        kw['INFIBEAM_VATPLUSTAX'] = de
        de = get_code_word("INFIBEAM_REMOVELIST")
        kw['INFIBEAM_REMOVELIST'] = de
        de = get_code_word("INFIBEAM_XPATH1")
        kw['INFIBEAM_XPATH1'] = de
        de = get_code_word("INFIBEAM_XPATH2")
        kw['INFIBEAM_XPATH2'] = de
        de = get_code_word("INFIBEAM_XPATH3")
        kw['INFIBEAM_XPATH3'] = de   
        return dict(modelname='infibeam_form',
        value=kw)

    @expose('wiki20.templates.input_form')
    def save_infibeam(self, **kw):
        """Create a infibeam object and save it to the database."""
        set_code_word("INFIBEAM_DOMAINNAME",kw['INFIBEAM_DOMAINNAME'],"")  
        #set_code_word("INFIBEAM_NO",kw['INFIBEAM_NO'],"")
        #set_code_word("INFIBEAM_CT",kw['INFIBEAM_CT'],"")
        set_code_word("INFIBEAM_URL",kw['INFIBEAM_URL'],"")
        set_code_word("INFIBEAM_HOMEPAGE",kw['INFIBEAM_HOMEPAGE'],"")
        set_code_word("INFIBEAM_REFERER",kw['INFIBEAM_REFERER'],"")
        set_code_word("INFIBEAM_VATPLUSTAX",kw['INFIBEAM_VATPLUSTAX'],"")
        set_code_word("INFIBEAM_REMOVELIST",kw['INFIBEAM_REMOVELIST'],"")
        set_code_word("INFIBEAM_XPATH1",kw['INFIBEAM_XPATH1'],"")
        set_code_word("INFIBEAM_XPATH2",kw['INFIBEAM_XPATH2'],"")
        set_code_word("INFIBEAM_XPATH3",kw['INFIBEAM_XPATH3'],"")
        flash("Data successfully saved.")
        redirect("form_infibeam")
        
    @expose('wiki20.templates.input_form')
    def form_univercell(self, **kw):
    #"""Show form to add data record for univercell."""
        initialize_table()
        create_univercell_form = UnivercellForm("create_univercell_form",action='save_univercell')
        tmpl_context.form = create_univercell_form
        de = get_code_word("UNIVERCELL_DOMAINNAME")
        kw['UNIVERCELL_DOMAINNAME']=de
        de = get_code_word("UNIVERCELL_DOMAINNAME1")
        kw['UNIVERCELL_DOMAINNAME1']=de
        de = get_code_word("UNIVERCELL_URL")
        kw['UNIVERCELL_URL']=de
        de = get_code_word("UNIVERCELL_HOMEPAGE")
        kw['UNIVERCELL_HOMEPAGE']=de
        de = get_code_word("UNIVERCELL_REFERER")
        kw['UNIVERCELL_REFERER']=de
        de = get_code_word("UNIVERCELL_URL1")
        kw['UNIVERCELL_URL1']=de
        de = get_code_word("UNIVERCELL_XPATH1")
        kw['UNIVERCELL_XPATH1']=de
        de = get_code_word("UNIVERCELL_XPATH2")
        kw['UNIVERCELL_XPATH2']=de
        de = get_code_word("UNIVERCELL_XPATH3")
        kw['UNIVERCELL_XPATH3']=de
        de = get_code_word("UNIVERCELL_XPATH4")
        kw['UNIVERCELL_XPATH4']=de
        de = get_code_word("UNIVERCELL_XPATH5")
        kw['UNIVERCELL_XPATH5']=de
        de = get_code_word("UNIVERCELL_XPATH6")
        kw['UNIVERCELL_XPATH6']=de
        de = get_code_word("UNIVERCELL_VAR1")
        kw['UNIVERCELL_VAR1']=de
        de = get_code_word("UNIVERCELL_VAR2")
        kw['UNIVERCELL_VAR2']=de
        de = get_code_word("UNIVERCELL_VAR3")
        kw['UNIVERCELL_VAR3']=de
        de = get_code_word("UNIVERCELL_VAR4")
        kw['UNIVERCELL_VAR4']=de
        de = get_code_word("UNIVERCELL_VATPLUSTAX")
        kw['UNIVERCELL_VATPLUSTAX']=de
        de = get_code_word("UNIVERCELL_REMOVELIST")
        kw['UNIVERCELL_REMOVELIST']=de
        return dict(modelname='univercell_form',
        value=kw)

    @expose('wiki20.templates.input_form')
    def save_univercell(self, **kw):
        """Create a univercell object and save it to the database."""
        set_code_word("UNIVERCELL_DOMAINNAME",kw['UNIVERCELL_DOMAINNAME'],"")  
        set_code_word("UNIVERCELL_URL",kw['UNIVERCELL_URL'],"")
        set_code_word("UNIVERCELL_HOMEPAGE",kw['UNIVERCELL_HOMEPAGE'],"")
        set_code_word("UNIVERCELL_REFERER",kw['UNIVERCELL_REFERER'],"")
        set_code_word("UNIVERCELL_URL1",kw['UNIVERCELL_URL1'],"")
        set_code_word("UNIVERCELL_XPATH1",kw['UNIVERCELL_XPATH1'],"")
        set_code_word("UNIVERCELL_XPATH2",kw['UNIVERCELL_XPATH2'],"")
        set_code_word("UNIVERCELL_XPATH3",kw['UNIVERCELL_XPATH3'],"")
        set_code_word("UNIVERCELL_XPATH4",kw['UNIVERCELL_XPATH4'],"")
        set_code_word("UNIVERCELL_XPATH5",kw['UNIVERCELL_XPATH5'],"")
        set_code_word("UNIVERCELL_XPATH6",kw['UNIVERCELL_XPATH6'],"")
        set_code_word("UNIVERCELL_VATPLUSTAX",kw['UNIVERCELL_VATPLUSTAX'],"")
        set_code_word("UNIVERCELL_REMOVELIST",kw['UNIVERCELL_REMOVELIST'],"")
        set_code_word("UNIVERCELL_VAR1",kw['UNIVERCELL_VAR1'],"")
        set_code_word("UNIVERCELL_VAR2",kw['UNIVERCELL_VAR2'],"")
        set_code_word("UNIVERCELL_VAR3",kw['UNIVERCELL_VAR3'],"")
        set_code_word("UNIVERCELL_VAR4",kw['UNIVERCELL_VAR4'],"")
        set_code_word("UNIVERCELL_DOMAINNAME1",kw['UNIVERCELL_DOMAINNAME1'],"")
        flash("Data successfully saved.")
        redirect("form_univercell")
        
        
    @expose('wiki20.templates.input_form')
    def form_indiaplaza(self, **kw):
        """Show form to add data record for indiaplaza."""
        de = get_code_word("INDIAPLAZA_DOMAINNAME")
        kw['INDIAPLAZA_DOMAINNAME']=de
        de = get_code_word("INDIAPLAZA_DOMAINNAME1")
        kw['INDIAPLAZA_DOMAINNAME1']=de
        de = get_code_word("INDIAPLAZA_URL")
        kw['INDIAPLAZA_URL']=de
        de = get_code_word("INDIAPLAZA_HOMEPAGE")
        kw['INDIAPLAZA_HOMEPAGE']=de
        de = get_code_word("INDIAPLAZA_REFERER")
        kw['INDIAPLAZA_REFERER']=de
        de = get_code_word("INDIAPLAZA_URL1")
        kw['INDIAPLAZA_URL1']=de
        de = get_code_word("INDIAPLAZA_XPATH1")
        kw['INDIAPLAZA_XPATH1']=de
        de = get_code_word("INDIAPLAZA_XPATH2")
        kw['INDIAPLAZA_XPATH2']=de
        de = get_code_word("INDIAPLAZA_XPATH3")
        kw['INDIAPLAZA_XPATH3']=de
        de = get_code_word("INDIAPLAZA_XPATH4")
        kw['INDIAPLAZA_XPATH4']=de
        de = get_code_word("INDIAPLAZA_XPATH5")
        kw['INDIAPLAZA_XPATH5']=de
        de = get_code_word("INDIAPLAZA_XPATH6")
        kw['INDIAPLAZA_XPATH6']=de
        de = get_code_word("INDIAPLAZA_XPATH7")
        kw['INDIAPLAZA_XPATH7']=de
        de = get_code_word("INDIAPLAZA_XPATH8")
        kw['INDIAPLAZA_XPATH8']=de
        de = get_code_word("INDIAPLAZA_XPATH9")
        kw['INDIAPLAZA_XPATH9']=de
        de = get_code_word("INDIAPLAZA_XPATH10")
        kw['INDIAPLAZA_XPATH10']=de
        de = get_code_word("INDIAPLAZA_VAR1")
        kw['INDIAPLAZA_VAR1']=de
        de = get_code_word("INDIAPLAZA_REMOVELIST")
        kw['INDIAPLAZA_REMOVELIST']=de
        #de = get_code_word("INDIAPLAZA_NO")
        #kw['INDIAPLAZA_NO']=de
        #de = get_code_word("INDIAPLAZA_CT")
        #kw['INDIAPLAZA_CT']=de
        create_indiaplaza_form = IndiaplazaForm("create_indiaplaza_form",action='save_indiaplaza')
        tmpl_context.form = create_indiaplaza_form 
        
        return dict(modelname='indiaplaza_form',
        value=kw)

    @expose('wiki20.templates.input_form')
    def save_indiaplaza(self, **kw):
        """Create a indiaplaza object and save it to the database."""
        #initialize_table()
        set_code_word("INDIAPLAZA_DOMAINNAME",kw['INDIAPLAZA_DOMAINNAME'],"")  
        set_code_word("INDIAPLAZA_URL",kw['INDIAPLAZA_URL'],"")
        set_code_word("INDIAPLAZA_HOMEPAGE",kw['INDIAPLAZA_HOMEPAGE'],"")
        set_code_word("INDIAPLAZA_REFERER",kw['INDIAPLAZA_REFERER'],"")
        set_code_word("INDIAPLAZA_URL1",kw['INDIAPLAZA_URL1'],"")
        set_code_word("INDIAPLAZA_XPATH1",kw['INDIAPLAZA_XPATH1'],"")
        set_code_word("INDIAPLAZA_XPATH2",kw['INDIAPLAZA_XPATH2'],"")
        set_code_word("INDIAPLAZA_XPATH3",kw['INDIAPLAZA_XPATH3'],"")
        set_code_word("INDIAPLAZA_XPATH4",kw['INDIAPLAZA_XPATH4'],"")
        set_code_word("INDIAPLAZA_XPATH5",kw['INDIAPLAZA_XPATH5'],"")
        set_code_word("INDIAPLAZA_XPATH6",kw['INDIAPLAZA_XPATH6'],"")
        set_code_word("INDIAPLAZA_XPATH7",kw['INDIAPLAZA_XPATH7'],"")
        set_code_word("INDIAPLAZA_XPATH8",kw['INDIAPLAZA_XPATH8'],"")
        set_code_word("INDIAPLAZA_XPATH9",kw['INDIAPLAZA_XPATH9'],"")
        set_code_word("INDIAPLAZA_XPATH10",kw['INDIAPLAZA_XPATH10'],"")
        set_code_word("INDIAPLAZA_REMOVELIST",kw['INDIAPLAZA_REMOVELIST'],"")
        set_code_word("INDIAPLAZA_VAR1",kw['INDIAPLAZA_VAR1'],"")
        set_code_word("INDIAPLAZA_DOMAINNAME1",kw['INDIAPLAZA_DOMAINNAME1'],"")
        #set_code_word("INDIAPLAZA_NO",kw['INDIAPLAZA_NO'],"")
        #set_code_word("INDIAPLAZA_CT",kw['INDIAPLAZA_CT'],"")
        flash("Data successfully saved.")
        redirect("form_indiaplaza")
    
    @expose('wiki20.templates.input_form')
    def form_mobilestore(self, **kw):
    #"""Show form to add data record for mobilestore."""
        initialize_table()
        create_mobilestore_form = MobilestoreForm("create_mobilestore_form",action='save_mobilestore')
        tmpl_context.form = create_mobilestore_form
        de = get_code_word("MOBILESTORE_DOMAINNAME")
        kw['MOBILESTORE_DOMAINNAME']=de
        de = get_code_word("MOBILESTORE_DOMAINNAME1")
        kw['MOBILESTORE_DOMAINNAME1']=de
        de = get_code_word("MOBILESTORE_URL")
        kw['MOBILESTORE_URL']=de
        de = get_code_word("MOBILESTORE_HOMEPAGE")
        kw['MOBILESTORE_HOMEPAGE']=de
        de = get_code_word("MOBILESTORE_REFERER")
        kw['MOBILESTORE_REFERER']=de
        de = get_code_word("MOBILESTORE_CHKLIST1")
        kw['MOBILESTORE_CHKLIST1']=de
        de = get_code_word("MOBILESTORE_VATPLUSTAX")
        kw['MOBILESTORE_VATPLUSTAX']=de
        de = get_code_word("MOBILESTORE_REMOVELIST")
        kw['MOBILESTORE_REMOVELIST']=de
        de = get_code_word("MOBILESTORE_XPATH1")
        kw['MOBILESTORE_XPATH1']=de
        de = get_code_word("MOBILESTORE_XPATH2")
        kw['MOBILESTORE_XPATH2']=de
        de = get_code_word("MOBILESTORE_XPATH3")
        kw['MOBILESTORE_XPATH3']=de
        de = get_code_word("MOBILESTORE_XPATH4")
        kw['MOBILESTORE_XPATH4']=de
        de = get_code_word("MOBILESTORE_XPATH5")
        kw['MOBILESTORE_XPATH5']=de
        de = get_code_word("MOBILESTORE_XPATH6")
        kw['MOBILESTORE_XPATH6']=de
        de = get_code_word("MOBILESTORE_XPATH7")
        kw['MOBILESTORE_XPATH7']=de
        de = get_code_word("MOBILESTORE_XPATH8")
        kw['MOBILESTORE_XPATH8']=de
        de = get_code_word("MOBILESTORE_DOMAINNAME0")
        kw['MOBILESTORE_DOMAINNAME0']=de
        de = get_code_word("MOBILESTORE_URL1")
        kw['MOBILESTORE_URL1']=de
        de = get_code_word("MOBILESTORE_URL2")
        kw['MOBILESTORE_URL2']=de
        return dict(modelname='mobilestore_form',
        value=kw)
    
    @expose('wiki20.templates.input_form')
    def save_mobilestore(self, **kw):
        """Create a mobilestore object and save it to the database."""
        set_code_word("MOBILESTORE_DOMAINNAME",kw['MOBILESTORE_DOMAINNAME'],"")
        set_code_word("MOBILESTORE_DOMAINNAME1",kw['MOBILESTORE_DOMAINNAME1'],"")  
        set_code_word("MOBILESTORE_URL",kw['MOBILESTORE_URL'],"")
        set_code_word("MOBILESTORE_HOMEPAGE",kw['MOBILESTORE_HOMEPAGE'],"")
        set_code_word("MOBILESTORE_REFERER",kw['MOBILESTORE_REFERER'],"")
        set_code_word("MOBILESTORE_VATPLUSTAX",kw['MOBILESTORE_VATPLUSTAX'],"")
        set_code_word("MOBILESTORE_REMOVELIST",kw['MOBILESTORE_REMOVELIST'],"")
        set_code_word("MOBILESTORE_CHKLIST1",kw['MOBILESTORE_CHKLIST1'],"")
        set_code_word("MOBILESTORE_XPATH1",kw['MOBILESTORE_XPATH1'],"")
        set_code_word("MOBILESTORE_XPATH2",kw['MOBILESTORE_XPATH2'],"")
        set_code_word("MOBILESTORE_XPATH3",kw['MOBILESTORE_XPATH3'],"")
        set_code_word("MOBILESTORE_XPATH4",kw['MOBILESTORE_XPATH4'],"")
        set_code_word("MOBILESTORE_XPATH5",kw['MOBILESTORE_XPATH5'],"")
        set_code_word("MOBILESTORE_XPATH6",kw['MOBILESTORE_XPATH6'],"")
        set_code_word("MOBILESTORE_XPATH7",kw['MOBILESTORE_XPATH7'],"")
        set_code_word("MOBILESTORE_XPATH8",kw['MOBILESTORE_XPATH8'],"")
        set_code_word("MOBILESTORE_DOMAINNAME0",kw['MOBILESTORE_DOMAINNAME0'],"")
        set_code_word("MOBILESTORE_URL1",kw['MOBILESTORE_URL1'],"")
        set_code_word("MOBILESTORE_URL2",kw['MOBILESTORE_URL2'],"")
        flash("Data successfully saved.")
        redirect("form_mobilestore")
        
    @expose('wiki20.templates.input_form')
    def form_naaptol(self, **kw):
    #"""Show form to add data record for naaptol."""
        initialize_table()
        create_naaptol_form = NaaptolForm("create_naaptol_form",action='save_naaptol')
        tmpl_context.form = create_naaptol_form
        de = get_code_word("NAAPTOL_DOMAINNAME")
        kw['NAAPTOL_DOMAINNAME']=de
        de = get_code_word("NAAPTOL_DOMAINNAME1")
        kw['NAAPTOL_DOMAINNAME1']=de
        de = get_code_word("NAAPTOL_DOMAINNAME2")
        kw['NAAPTOL_DOMAINNAME2']=de
        de = get_code_word("NAAPTOL_URL")
        kw['NAAPTOL_URL']=de
        de = get_code_word("NAAPTOL_HOMEPAGE")
        kw['NAAPTOL_HOMEPAGE']=de
        de = get_code_word("NAAPTOL_REFERER")
        kw['NAAPTOL_REFERER']=de
        de = get_code_word("NAAPTOL_CHKLIST1")
        kw['NAAPTOL_CHKLIST1']=de
        de = get_code_word("NAAPTOL_CHKLIST2")
        kw['NAAPTOL_CHKLIST2']=de
        de = get_code_word("NAAPTOL_PART")
        kw['NAAPTOL_PART']=de
        de = get_code_word("NAAPTOL_XPATH1")
        kw['NAAPTOL_XPATH1']=de
        de = get_code_word("NAAPTOL_XPATH2")
        kw['NAAPTOL_XPATH2']=de
        de = get_code_word("NAAPTOL_XPATH3")
        kw['NAAPTOL_XPATH3']=de
        de = get_code_word("NAAPTOL_XPATH4")
        kw['NAAPTOL_XPATH4']=de
        de = get_code_word("NAAPTOL_XPATH5")
        kw['NAAPTOL_XPATH5']=de
        de = get_code_word("NAAPTOL_XPATH6")
        kw['NAAPTOL_XPATH6']=de
        de = get_code_word("NAAPTOL_XPATH7")
        kw['NAAPTOL_XPATH7']=de
        de = get_code_word("NAAPTOL_XPATH8")
        kw['NAAPTOL_XPATH8']=de
        de = get_code_word("NAAPTOL_XPATH9")
        kw['NAAPTOL_XPATH9']=de
        de = get_code_word("NAAPTOL_XPATH10")
        kw['NAAPTOL_XPATH10']=de
        de = get_code_word("NAAPTOL_REMOVELIST")
        kw['NAAPTOL_REMOVELIST']=de
        return dict(modelname='naaptol_form',
        value=kw)
    
    @expose('wiki20.templates.input_form')
    def save_naaptol(self, **kw):
        """Create a naaptol object and save it to the database."""
        set_code_word("NAAPTOL_DOMAINNAME",kw['NAAPTOL_DOMAINNAME'],"")  
        set_code_word("NAAPTOL_URL",kw['NAAPTOL_URL'],"")
        set_code_word("NAAPTOL_HOMEPAGE",kw['NAAPTOL_HOMEPAGE'],"")
        set_code_word("NAAPTOL_REFERER",kw['NAAPTOL_REFERER'],"")
        set_code_word("NAAPTOL_CHKLIST1",kw['NAAPTOL_CHKLIST1'],"")
        set_code_word("NAAPTOL_CHKLIST2",kw['NAAPTOL_CHKLIST2'],"")
        set_code_word("NAAPTOL_XPATH1",kw['NAAPTOL_XPATH1'],"")
        set_code_word("NAAPTOL_XPATH2",kw['NAAPTOL_XPATH2'],"")
        set_code_word("NAAPTOL_XPATH3",kw['NAAPTOL_XPATH3'],"")
        set_code_word("NAAPTOL_XPATH4",kw['NAAPTOL_XPATH4'],"")
        set_code_word("NAAPTOL_XPATH5",kw['NAAPTOL_XPATH5'],"")
        set_code_word("NAAPTOL_XPATH6",kw['NAAPTOL_XPATH6'],"")
        set_code_word("NAAPTOL_XPATH7",kw['NAAPTOL_XPATH7'],"")
        set_code_word("NAAPTOL_XPATH8",kw['NAAPTOL_XPATH8'],"")
        set_code_word("NAAPTOL_XPATH9",kw['NAAPTOL_XPATH9'],"")
        set_code_word("NAAPTOL_XPATH10",kw['NAAPTOL_XPATH10'],"")
        set_code_word("NAAPTOL_REMOVELIST",kw['NAAPTOL_REMOVELIST'],"")
        set_code_word("NAAPTOL_DOMAINNAME1",kw['NAAPTOL_DOMAINNAME1'],"")
        set_code_word("NAAPTOL_DOMAINNAME2",kw['NAAPTOL_DOMAINNAME2'],"")
        set_code_word("NAAPTOL_PART",kw['NAAPTOL_PART'],"")
        flash("Data successfully saved.")
        redirect("form_naaptol")
        
        
    @expose('wiki20.templates.input_form')
    def form_babuchak(self, **kw):
    #"""Show form to add data record for babuchak."""
        initialize_table()
        create_babuchak_form = BabuchakForm("create_babuchak_form",action='save_babuchak')
        tmpl_context.form = create_babuchak_form
        de = get_code_word("BABUCHAK_DOMAINNAME")
        kw['BABUCHAK_DOMAINNAME']=de
        de = get_code_word("BABUCHAK_DOMAINNAME1")
        kw['BABUCHAK_DOMAINNAME1']=de
        de = get_code_word("BABUCHAK_DOMAINNAME2")
        kw['BABUCHAK_DOMAINNAME2']=de
        de = get_code_word("BABUCHAK_URL")
        kw['BABUCHAK_URL']=de
        de = get_code_word("BABUCHAK_URL1")
        kw['BABUCHAK_URL1']=de
        de = get_code_word("BABUCHAK_VAR1")
        kw['BABUCHAK_VAR1']=de
        de = get_code_word("BABUCHAK_URL2")
        kw['BABUCHAK_URL2']=de
        de = get_code_word("BABUCHAK_HOMEPAGE")
        kw['BABUCHAK_HOMEPAGE']=de
        de = get_code_word("BABUCHAK_REFERER")
        kw['BABUCHAK_REFERER']=de
        de = get_code_word("BABUCHAK_XPATH1")
        kw['BABUCHAK_XPATH1']=de
        de = get_code_word("BABUCHAK_XPATH2")
        kw['BABUCHAK_XPATH2']=de
        de = get_code_word("BABUCHAK_XPATH3")
        kw['BABUCHAK_XPATH3']=de
        de = get_code_word("BABUCHAK_XPATH4")
        kw['BABUCHAK_XPATH4']=de
        de = get_code_word("BABUCHAK_XPATH5")
        kw['BABUCHAK_XPATH5']=de
        de = get_code_word("BABUCHAK_XPATH6")
        kw['BABUCHAK_XPATH6']=de
        de = get_code_word("BABUCHAK_XPATH7")
        kw['BABUCHAK_XPATH7']=de
        de = get_code_word("BABUCHAK_REMOVELIST")
        kw['BABUCHAK_REMOVELIST']=de
        return dict(modelname='babuchak_form',
        value=kw)
    
    @expose('wiki20.templates.input_form')
    def save_babuchak(self, **kw):
        """Create a babuchak object and save it to the database."""
        set_code_word("BABUCHAK_DOMAINNAME",kw['BABUCHAK_DOMAINNAME'],"")  
        set_code_word("BABUCHAK_URL",kw['BABUCHAK_URL'],"")
        set_code_word("BABUCHAK_URL1",kw['BABUCHAK_URL1'],"")
        set_code_word("BABUCHAK_VAR1",kw['BABUCHAK_VAR1'],"")
        set_code_word("BABUCHAK_URL2",kw['BABUCHAK_URL2'],"")
        set_code_word("BABUCHAK_HOMEPAGE",kw['BABUCHAK_HOMEPAGE'],"")
        set_code_word("BABUCHAK_REFERER",kw['BABUCHAK_REFERER'],"")
        set_code_word("BABUCHAK_XPATH1",kw['BABUCHAK_XPATH1'],"")
        set_code_word("BABUCHAK_XPATH2",kw['BABUCHAK_XPATH2'],"")
        set_code_word("BABUCHAK_XPATH3",kw['BABUCHAK_XPATH3'],"")
        set_code_word("BABUCHAK_XPATH4",kw['BABUCHAK_XPATH4'],"")
        set_code_word("BABUCHAK_XPATH5",kw['BABUCHAK_XPATH5'],"")
        set_code_word("BABUCHAK_XPATH6",kw['BABUCHAK_XPATH6'],"")
        set_code_word("BABUCHAK_XPATH7",kw['BABUCHAK_XPATH7'],"")
        set_code_word("BABUCHAK_REMOVELIST",kw['BABUCHAK_REMOVELIST'],"")
        set_code_word("BABUCHAK_DOMAINNAME1",kw['BABUCHAK_DOMAINNAME1'],"")
        set_code_word("BABUCHAK_DOMAINNAME2",kw['BABUCHAK_DOMAINNAME2'],"")
        flash("Data successfully saved.")
        redirect("form_babuchak")    
        
    @expose('wiki20.templates.codedata_forms')
    def form_codedata(self):
        """Handle the front-page."""
        return dict(page='codedata_forms')