def POST(self): if web.ctx.session.login==True: f = form.uploadfile_form() datafile = web.input(datafile={}).datafile msg = '' if not f.validates(): msg = ERR_TABLE_NAME return web.template.render('templates/',base='base',globals={'session':web.ctx.session}).Import(form.uploadfile_form(),msg)#这儿必须返回新的form,不然会出错 else: msg = importdata(models.any2str(f.d.tablename),models.any2str(f.d.filetype),datafile,models.any2str(f.d.sep)) return web.template.render('templates/',base='base',globals={'session':web.ctx.session}).Import(form.uploadfile_form(),msg)#这儿也一样 else: raise web.seeother("/../")
def GET(self,text): text = any2str(text) flist,msg = models.get_fields_name(text) f = DynamicForm() custom_master(f,flist) if msg == '' : msg = models.if_table_exists(text,config.MDM) return web.template.render('templates/',base='base',globals={'session':web.ctx.session}).master_data(f,msg)
def POST(self): if web.ctx.session.login==True: f = form.search_form() alldata=web.input() if not f.validates(): return web.template.render('templates/',base='base',globals={'session':web.ctx.session}).search(f) else: if alldata.has_key('ismaster'): rtdata=models.search_master(models.any2str(f.d.content)) else: rtdata = models.search_all_tables(models.any2str(f.d.content)) if rtdata==None: return web.template.render('templates/',base='base',globals={'session':web.ctx.session}).search(f,ERR_DB) elif rtdata=={}: return web.template.render('templates/',base='base',globals={'session':web.ctx.session}).search(f,NO_RESULT) else: return web.template.render('templates/',base='base',globals={'session':web.ctx.session}).search(f,THIS_RESULT,rtdata) else: raise web.seeother('/session/login')
def POST(self,text): if web.ctx.session.login==True: num = int(text.split('--')[1]) tablename = text.split('--')[0] f = DynamicForm() custom_form(f,num) if not f.validates(): msg = ERR_COL_EDIT return web.template.render('templates/',base='base',globals={'session':web.ctx.session}).columns(f,msg) else: fnames = [models.any2str(f["name" + str(i)].value) for i in range(num)] fattrs = [models.any2str(f["attr" + str(i)].value) for i in range(num)] attrs = {models.any2str('PK'):models.any2str(f["primarykey"].value)} msg = models.create_table(models.any2str(tablename),fnames,fattrs,attrs) if msg!='': return web.template.render('templates/',base='base',globals={'session':web.ctx.session}).columns(f,msg) else: raise web.seeother('/../') else: raise web.seeother("/../")
def POST(self,text): text = any2str(text) flist,msg = models.get_fields_name(text) f = DynamicForm() custom_master(f,flist) if not f.validates() or msg != '': msg = ERR_NOTNULL return web.template.render('templates/',base='base',globals={'session':web.ctx.session}).master_data(f,msg) else : tbinfo = [text] fw = web.input() mflist = [any2str(flist[idx]) for idx in range(len(flist)) if fw.has_key(str(idx))] tbinfo.append(','.join(mflist)) print tbinfo[1] msg = models.insert_column(config.MDM,tbinfo,('text','text')) models.db.commit() if msg != '': return web.template.render('templates/',base='base',globals={'session':web.ctx.session}).master_data(f,msg) else : raise web.seeother('/../')