def getDocumentLabels(self, idDocument, lang): """Get document labels.""" dv = DataValidator() dv.checkLang(lang) dv.checkNumber(idDocument) q = "SELECT dl.id_label_{} as id_label, l.label FROM www.document_label_{} dl "\ " INNER JOIN www.label_{} l ON dl.id_label_{}=l.id_label_{} "\ " WHERE id_document=%s".format(lang,lang,lang,lang,lang) return self.query(q, [idDocument]).result()
def getDocumentLabels(self, idDocument, lang): """Get document labels.""" dv = DataValidator() dv.checkLang(lang) dv.checkNumber(idDocument) q = "SELECT dl.id_label_{} as id_label, l.label FROM www.document_label_{} dl "\ " INNER JOIN www.label_{} l ON dl.id_label_{}=l.id_label_{} "\ " WHERE id_document=%s".format(lang,lang,lang,lang,lang) return self.query(q,[idDocument]).result()
def getDocumentPdf(self, idDocument, lang=None): """Gets the list of PDF of a document, optionally for a given language.""" dv = DataValidator() if lang: dv.checkLang(lang) dv.checkNumber(idDocument) q = "select id_pdf as id, id_document, lang, pdf_name as name, hash from www.pdf where id_document=%s" bindings = [idDocument] if lang: q += " and lang=%s;" bindings.append(lang) else: q += ";" return self.query(q, bindings).result()
def getDocumentDetails(self, lang, idDocument): """Gets details of documents for the frontend document catalog by ID.""" dv = DataValidator() dv.checkLang(lang) dv.checkNumber(idDocument) sql = """ select id_document, title_{} as title, theme_{} as theme, description_{} as description, link_{} as link, last_edit_id_user, last_edit_time, published, publishing_date from www.document where id_document=%s;""".format(lang, lang, lang, lang) return (self.query(sql, bindings=[idDocument]).row())
def getDocumentDetails(self, lang, idDocument): """Gets details of documents for the frontend document catalog by ID.""" dv = DataValidator() dv.checkLang(lang) dv.checkNumber(idDocument) sql = """ select id_document, title_{} as title, theme_{} as theme, description_{} as description, link_{} as link, last_edit_id_user, last_edit_time, published, publishing_date from www.document where id_document=%s;""".format(lang,lang,lang,lang) return(self.query(sql, bindings=[idDocument]).row())