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 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())
