def GET(self): global myCurrentQueries DBLinks = DB.doOpen(C.SQLCONFIG) myInput = web.input(STARTRECNUM=0, QUERYNUM=1) if myInput[C.QUERYNUM] != myCurrentQueries[C.QUERYNUM]: myCurrentQueries = C.QUERIESINGLOBALDEFAULTS myCurrentQueries[C.STARTRECNUM] = myInput[C.STARTRECNUM] myCurrentQueries[C.QUERYNUM] = myInput[C.QUERYNUM] myCurrentQueries[C.ROWNUM] = 0 SQLStr = f""" select * from {C.QUERIESINTABLENAME} where {C.RID} = {myCurrentQueries[C.QUERYNUM]};""" SQLRowsDict = DB.getSqlOne(DBLinks, SQLStr) myCurrentQueries = DB.upgradeDBToGQI(SQLRowsDict, C.QUERIESINGLOBALDEFAULTS) outStr = sendMyHeader( f"{myCurrentQueries[C.QUERIESINTITLE]} {__file__}") SQLStr = f""" {myCurrentQueries[C.SQLSELECT]} {myCurrentQueries[C.SQLWHERE]} {myCurrentQueries[C.SQLGROUPBY]} {myCurrentQueries[C.SQLORDERBY]} """ SQLStr += DB.saneMakeSqlLimitStr(myCurrentQueries[C.STARTRECNUM]) + ";" SQLRowsDict, SQLNumRows = DB.getSqlAll(DBLinks, SQLStr) myCurrentQueries[C.NUMROWS] = SQLNumRows myCurrentQueries[C.PGNUM] = int( int(myCurrentQueries[C.STARTRECNUM]) / C.NUMROWSPERPG) + 1 myCurrentQueries[C.OFPGS] = int( int(myCurrentQueries[C.NUMROWS]) / C.NUMROWSPERPG) + 1 # theseRows = DB.upgradeDBToGQIMany(SQLRowsDict, C.QUERIESINGLOBALDEFAULTS) outStr += "<table>\n" for thisRow in SQLRowsDict: thisRow = DB.DTfixThisLineToDisplay(thisRow) lastRow = thisRow outStr += DB.makeTableRow(thisRow, myCurrentQueries, 0) myCurrentQueries[C.ROWNUM] += 1 outStr += DB.makeTableRow(lastRow, myCurrentQueries, 1) outStr += """ </table> <span class="fp">bottom of the page</span> </body> </html> """ return outStr
def GET(self): global myCurrentQueries DBLinks = DB.doOpen(C.SQLCONFIG) myInput = web.input(STARTRECNUM=0, QUERYNUM=C.DEFQUERYNUM) # C.QUERYLOADED (-1) if from select the parts # C.QUERYFROMPRESET (1) if from presets # C.QUERYEMPTY (0) if anything else if myInput[C.QUERYNUM] != myCurrentQueries[C.QUERYNUM]: myCurrentQueries = C.QUERIESINDEFAULTS() myCurrentQueries[C.QUERYNUM] = myInput[C.QUERYNUM] # C.QUERYLOADED if set by any of the query building parts, # C.QUERYFROMPRESET if loaded from a preset # C.QUERYEMPTY if "empty" myCurrentQueries[C.ISLOADED] = C.QUERYEMPTY myCurrentQueries[C.STARTRECNUM] = myInput[C.STARTRECNUM] myCurrentQueries[C.QUERYNUM] = myInput[C.QUERYNUM] myCurrentQueries[C.ROWNUM] = 0 if myCurrentQueries[C.ISLOADED] != C.QUERYLOADED: SQLStr = f""" select * from {C.QUERIESINTABLENAME} where {C.RID} = {myCurrentQueries[C.QUERYNUM]};""" SQLRowsDict = DB.getSqlOne(DBLinks, SQLStr) myCurrentQueries = DB.upgradeDBToGQI(SQLRowsDict, myCurrentQueries) myCurrentQueries[C.ISLOADED] = 1 C.REGIONNAMESDICT[C.REGION0NAME] = myCurrentQueries[C.REGION0NAME] C.REGIONNAMESDICT[C.REGION1NAME] = myCurrentQueries[C.REGION1NAME] C.REGIONNAMESDICT[C.REGION2NAME] = myCurrentQueries[C.REGION2NAME] C.REGIONNAMESDICT[C.REGION3NAME] = myCurrentQueries[C.REGION3NAME] C.REGIONDESCRIPTIONSDICT[C.REGION0DESCRIPTION] = myCurrentQueries[ C.REGION0DESCRIPTION] C.REGIONDESCRIPTIONSDICT[C.REGION1DESCRIPTION] = myCurrentQueries[ C.REGION1DESCRIPTION] C.REGIONDESCRIPTIONSDICT[C.REGION2DESCRIPTION] = myCurrentQueries[ C.REGION2DESCRIPTION] C.REGIONDESCRIPTIONSDICT[C.REGION3DESCRIPTION] = myCurrentQueries[ C.REGION3DESCRIPTION] outStr = sendMyHeader(f"""{myCurrentQueries[C.QUERIESINTITLE]}""", f"""styleChunk.css""") SQLStr = f""" {myCurrentQueries[C.SQLSELECT]} {myCurrentQueries[C.SQLWHERE]} {myCurrentQueries[C.SQLGROUPBY]} {myCurrentQueries[C.SQLHAVING]} {myCurrentQueries[C.SQLORDERBY]} """ SQLStr += DB.saneMakeSqlLimitStr(myCurrentQueries[C.STARTRECNUM]) + ";" SQLRowsDict, SQLNumRows = DB.getSqlAll(DBLinks, SQLStr) myCurrentQueries[C.NUMROWS] = SQLNumRows myCurrentQueries[C.PGNUM] = int( int(myCurrentQueries[C.STARTRECNUM]) / C.NUMROWSPERPG) + 1 myCurrentQueries[C.OFPGS] = int( int(myCurrentQueries[C.NUMROWS]) / C.NUMROWSPERPG) + 1 # theseRows = DB.upgradeDBToGQIMany(SQLRowsDict, C.QUERIESINGLOBALDEFAULTS) outStr += f""" <span class="labels"><br />current SQLStr<br />{SQLStr}<br /></span><br /> """ outStr += "<table>\n" if myCurrentQueries[C.NUMROWS] < 1: outStr += f""" <tr> <td class="close0r0">no entries found</td> <td class="close3r0"><a href="menu">click for the menu</a></td> </tr> <tr> <td class="close3r1"><a href="presets">presets</a></td> <td class="close2r0"><a href="quakes/?QUERYNUM={C.DEFQUERYNUM}&STARTRECNUM=0"> for the default preset</a></td> </tr> <tr> <td class="close2r1"><a href="stop">stop the server</a></td> <td class="close1r0">{TDS.nowStrSql()}</td> </tr> </table> </body> </html> """ return outStr for thisRow in SQLRowsDict: thisRow = DB.DTfixThisLineToDisplay(thisRow) lastRow = thisRow outStr += DB.makeTableRow(thisRow, myCurrentQueries, 0) myCurrentQueries[C.ROWNUM] += 1 outStr += DB.makeTableRow(lastRow, myCurrentQueries, 1) outStr += f""" </table> {DB.makeDistance()} <span class="fp">bottom of the page</span> </body> </html> """ return outStr