def __create_associated_infrastructure(self): html = [] result = self.resource.select.read("Associated_Infrastructure", where=[["Parent_Plant_ID", "=", self.resource.parent_plant_id]] ) #keys = result.column_names values = result.fetchall() for value in values: ai_parent_plant_id = value["Associated_Parent_Plant_ID"] ai_res = GeoResource(self.resource.connection, description_id=ai_parent_plant_id) html.append("<b><a href=\"geoid/%s\">%s</a></b><br/>" % (ai_res.get_latest_revision_id(), ai_res.get_resource_name())) html.append('<div id="searchAI" class="ai-search-module">') html.append("<div id='aiDatabase_Type' class='aiSelectable'></div>") html.append("<div id='aiType' class='aiSelectable'></div>") html.append("<div id='aiCountry' class='aiSelectable'></div>") html.append("<div id='aiState' class='aiSelectable'></div>") html.append("<div class='aiUpdateButton' id='aiUpdateButton'>") html.append("<button id='createAIResource' class='createAIResource'>Create</button>") html.append("</div>") html.append("</div>") html.append("<div id='aiResources' class='aiSelectable' style='top: 20px;'>") html.append("</div>") return "".join(html)
def view(did=None): if not did: did = flask.request.args.get("did", "") resource = GeoResource(db, description_id=did) select = Select(db) result = select.read("Associated_Infrastructure", where=[["Parent_Plant_ID", "=", resource.parent_plant_id]] ) keys = result.column_names values = result.fetchall() html = [] html.append("<ul>") for value in values: ai_parent_plant_id = value["Associated_Parent_Plant_ID"] ai_res = GeoResource(db, description_id=ai_parent_plant_id) html.append("<li>") html.append("<b><a href=\"/geoid/%s\" target=\"_blank\">%s</a></b><br/>" % (ai_res.get_latest_revision_id(), ai_res.get_resource_name())) html.append("</li>") html.append("</ul>") """ html.append('<div id="searchAI" class="ai-search-module">') html.append("<div id='aiDatabase_Type' class='aiSelectable'></div>") html.append("<div id='aiType' class='aiSelectable'></div>") html.append("<div id='aiCountry' class='aiSelectable'></div>") html.append("<div id='aiState' class='aiSelectable'></div>") html.append("<div class='aiUpdateButton' id='aiUpdateButton' style='padding-top: 10px;'>") html.append("<button id='createAIResource' class='createAIResource'>Add Associated Infrastructure</button>") html.append("</div>") html.append("</div>") html.append("<div id='aiResources' class='aiSelectable' style='top: 20px;'>") html.append("</div>") """ return "".join(html)