def _serveDBContent( self, filename, contentType = None ):
conn = DBConnection()
try:
result = conn.execute( "SELECT content FROM glashart_pages WHERE page=?", [filename] )
if result:
row = result[0]
if contentType:
cherrypy.response.headers["Content-Type"] = contentType
return row["content"]
else:
raise cherrypy.HTTPError( 404 )
except:
raise cherrypy.HTTPError( 500 )
def _serveDBContent(self, filename, contentType=None):
conn = DBConnection()
try:
result = conn.execute(
"SELECT content FROM glashart_pages WHERE page=?", [filename])
if result:
row = result[0]
if contentType:
cherrypy.response.headers["Content-Type"] = contentType
return row["content"]
else:
raise cherrypy.HTTPError(404)
except:
raise cherrypy.HTTPError(500)
def _translateContent(self):
indexContent, title, codeJsPath, styleCssPath = self._parseIndexPage()
if title and indexContent:
codeJsContent, symbolNames = self._parseCodeJs(codeJsPath)
if codeJsContent:
indexContent = self._modifyIndexPage(indexContent)
codeJsContent = self._modifyCodeJs(codeJsContent, symbolNames)
styleCssContent = self._getStyleCss(styleCssPath)
apiJsContent = self._modifyApiJs(symbolNames)
if indexContent and codeJsContent and styleCssContent and apiJsContent:
self._logger.warning(
"_translateContent: content translated: title=%s" %
(title))
conn = DBConnection()
if conn:
row = conn.execute(
"SELECT * FROM glashart_pages WHERE page=?",
("index.xhtml", ))
if row:
conn.execute(
"UPDATE glashart_pages SET content=? WHERE page=?",
(indexContent, "index.xhtml"))
else:
conn.insert(
"INSERT INTO glashart_pages (page, content) VALUES (?, ?)",
("index.xhtml", indexContent))
row = conn.execute(
"SELECT * FROM glashart_pages WHERE page=?",
("code.js", ))
if row:
conn.execute(
"UPDATE glashart_pages SET content=? WHERE page=?",
(codeJsContent, "code.js"))
else:
conn.insert(
"INSERT INTO glashart_pages (page, content) VALUES (?, ?)",
("code.js", codeJsContent))
row = conn.execute(
"SELECT * FROM glashart_pages WHERE page=?",
("style.css", ))
if row:
conn.execute(
"UPDATE glashart_pages SET content=? WHERE page=?",
(styleCssContent, "style.css"))
else:
conn.insert(
"INSERT INTO glashart_pages (page, content) VALUES (?, ?)",
("style.css", styleCssContent))
row = conn.execute(
"SELECT * FROM glashart_pages WHERE page=?",
("api.js", ))
if row:
conn.execute(
"UPDATE glashart_pages SET content=? WHERE page=?",
(apiJsContent, "api.js"))
else:
conn.insert(
"INSERT INTO glashart_pages (page, content) VALUES (?, ?)",
("api.js", apiJsContent))
if symbolNames:
conn = DBConnection()
if conn:
PageSymbol.addAllDictToDb(conn, symbolNames)
def _translateContent( self ):
indexContent, title, codeJsPath, styleCssPath = self._parseIndexPage()
if title and indexContent:
codeJsContent, symbolNames = self._parseCodeJs( codeJsPath )
if codeJsContent:
indexContent = self._modifyIndexPage( indexContent )
codeJsContent = self._modifyCodeJs( codeJsContent, symbolNames )
styleCssContent = self._getStyleCss( styleCssPath )
apiJsContent = self._modifyApiJs( symbolNames )
if indexContent and codeJsContent and styleCssContent and apiJsContent:
self._logger.warning( "_translateContent: content translated: title=%s" % ( title ) )
conn = DBConnection()
if conn:
row = conn.execute( "SELECT * FROM glashart_pages WHERE page=?", ( "index.xhtml", ) )
if row:
conn.execute( "UPDATE glashart_pages SET content=? WHERE page=?", ( indexContent, "index.xhtml" ) )
else:
conn.insert( "INSERT INTO glashart_pages (page, content) VALUES (?, ?)", ( "index.xhtml", indexContent ) )
row = conn.execute( "SELECT * FROM glashart_pages WHERE page=?", ( "code.js", ) )
if row:
conn.execute( "UPDATE glashart_pages SET content=? WHERE page=?", ( codeJsContent, "code.js" ) )
else:
conn.insert( "INSERT INTO glashart_pages (page, content) VALUES (?, ?)", ( "code.js", codeJsContent ) )
row = conn.execute( "SELECT * FROM glashart_pages WHERE page=?", ( "style.css", ) )
if row:
conn.execute( "UPDATE glashart_pages SET content=? WHERE page=?", ( styleCssContent, "style.css" ) )
else:
conn.insert( "INSERT INTO glashart_pages (page, content) VALUES (?, ?)", ( "style.css", styleCssContent ) )
row = conn.execute( "SELECT * FROM glashart_pages WHERE page=?", ( "api.js", ) )
if row:
conn.execute( "UPDATE glashart_pages SET content=? WHERE page=?", ( apiJsContent, "api.js" ) )
else:
conn.insert( "INSERT INTO glashart_pages (page, content) VALUES (?, ?)", ( "api.js", apiJsContent ) )
if symbolNames:
conn = DBConnection()
if conn:
PageSymbol.addAllDictToDb( conn, symbolNames )
