""" MoinMoin - Processor for MySQL data @copyright: 2004 by Alexander Fischer @license: GNU GPL, see http://www.gnu.org/licenses/gpl for details Take care that a MySQL based database for source is assumed. For additional information performing these processor without any data given. """ from MoinMoin import wikiutil, config import MySQLdb import re def process(request, formatter, lines): result=[request.formatter.paragraph(0)] cr=request.formatter.linebreak(0) #### initialize flags ################################################################### dbflag=0 qflag=0 hdflag=0 wlflag=0 hlflag=0 mflag=0 hflag=0 ##### section1 ########################################################################### if lines[1:]: parameterlist=[] for index in range(len(lines[1:])): parameterlist.append(lines[1:][index]) i=0 for parameterstring in parameterlist : regexdb=re.compile("DBDATA") matchdb=regexdb.search(parameterstring) if matchdb: dbflag=1 parameterdb='''''' for char in range(matchdb.span(0)[1],len(parameterlist[i])): if parameterlist[i][char]!=' ': parameterdb=parameterdb+parameterlist[i][char] parameterdb=parameterdb.split(',') regexq=re.compile("QUERY") matchq=regexq.search(parameterstring) if matchq: qflag=1 parameterq='''''' for char in range(matchq.span(0)[1],len(parameterlist[i])): parameterq=parameterq+parameterlist[i][char] regexhd=re.compile("HEADLINE") matchhd=regexhd.search(parameterstring) if matchhd: hdflag=1 parameterhd='''''' for char in range(matchhd.span(0)[1],len(parameterlist[i])): if parameterlist[i][char]!=' ': parameterhd=parameterhd+parameterlist[i][char] parameterhd=parameterhd.split(',') regexwl=re.compile("WIKICOLUMN") matchwl=regexwl.search(parameterstring) if matchwl: wlflag=1 parameterwl='''''' for char in range(matchwl.span(0)[1],len(parameterlist[i])): if parameterlist[i][char]!=' ': parameterwl=parameterwl+parameterlist[i][char] parameterwl=parameterwl.split(',') regexhl=re.compile("HTMLCOLUMN") matchhl=regexhl.search(parameterstring) if matchhl: hlflag=1 parameterhl='''''' for char in range(matchhl.span(0)[1],len(parameterlist[i])): if parameterlist[i][char]!=' ': parameterhl=parameterhl+parameterlist[i][char] parameterhl=parameterhl.split(',') regexm=re.compile("MAILCOLUMN") matchm=regexm.search(parameterstring) if matchm: mflag=1 parameterm='''''' for char in range(matchm.span(0)[1],len(parameterlist[i])): if parameterlist[i][char]!=' ': parameterm=parameterm+parameterlist[i][char] parameterm=parameterm.split(',') regexh=re.compile("HIDDENCOLUMN") matchh=regexh.search(parameterstring) if matchh: hflag=1 parameterh='''''' for char in range(matchh.span(0)[1],len(parameterlist[i])): if parameterlist[i][char]!=' ': parameterh=parameterh+parameterlist[i][char] parameterh=parameterh.split(',') i=i+1 ##### sectiont 2 ####################################################################### output=[] output.append(formatter.table(1)) if dbflag==1 and qflag==1: if hdflag==1: output.append(formatter.table_row(1)) for element in parameterhd: output.append(formatter.table_cell(1)) output.append(formatter.strong(1)) output.append(formatter.text(element)) output.append(formatter.strong(0)) output.append(formatter.table_cell(0)) output.append(formatter.table_row(0)) h=parameterdb[0] d=parameterdb[1] u=parameterdb[2] p=parameterdb[3] query=parameterq con=MySQLdb.connect(host=h,user=u,db=d,passwd=p) c=con.cursor() c.execute(parameterq) list=c.fetchall() for row in list: output.append(formatter.table_row(1)) i=0 html=0 hidden=0 for cell in row: i=i+1 element=str(cell) if hlflag==1: for value in parameterhl: if i==int(value): html=1 element='\"[www]\"'+str(cell)+'' if wlflag==1: for value in parameterwl: if i==int(value): html=1 element=''+str(cell)+'' if mflag==1: for value in parameterm: if i==int(value): html=1 element='%s'%(str(cell),str(cell)) if hflag==1: for value in parameterh: if i==int(value): hidden=1 if html==1: output.append(formatter.table_cell(1)) output.append(formatter.rawHTML(element)) output.append(formatter.table_cell(0)) html=0 elif hidden==1: pass hidden=0 else: output.append(formatter.table_cell(1)) output.append(formatter.text(element)) output.append(formatter.table_cell(0)) output.append(formatter.table_row(0)) output.append(formatter.table(0)) result.extend(output) con.close() if dbflag==0 or not lines[1:] or qflag==0: comment1='''''' comment1="Transfer connectiondata and query for correct output!" comment2='''''' comment2="{{{#!MySQL" comment3='''''' comment3="DBDATA host,database,[user],[password]" comment4='''''' comment4="QUERY dbquery" comment5='''''' comment5="[HEADLINE columnname1,columnname2,...,...]" comment6='''''' comment6="[HTMLCOLUMN columnnumber1,columnnumber2,...,...]" comment7='''''' comment7="[WIKICOLUMN columnnumber1,columnnumber2,...,...]" comment8='''''' comment8="[MAILCOLUMN columnnumber1,columnnumber2,...,...]" comment9='''''' comment9="[HIDDENCOLUMN columnnumber1,columnnumber2,...,...]" comment10='''''' comment10="}}}" comment11='''''' comment11="Replace host, database, user, password, dbquery, columname, columnnumber with practical data!" comment12='''''' comment12="Take care for lower and upper case. Squared bracket = Optional data, Large letters = Syntax" comment=[] comment=[cr,comment1,cr,cr,comment2,cr,comment3,cr,comment4,cr,comment5,cr,comment6,cr,comment7,cr,comment8,cr,comment9,cr,comment10,cr,cr,comment11,cr,cr,comment12] result.extend(comment) request.write(''.join(result))