def epidoc_json(locid):
data = None
try:
doc = models.Epidat.query.filter_by(locid=locid).first_or_404()
data = {'availability': doc.availability, 'licence': doc.licence, 'title': doc.title, 'locid': doc.locid, 'urld': doc.urld, 'date': doc.date, 'insc': doc.insc, 'material': doc.material, 'condition': doc.condition, 'deconote': doc.deconote, 'decodesc': doc.decodesc, 'geoname': doc.geoname, 'geotype': doc.geotype, 'geocountry': doc.geocountry, 'georegion': doc.georegion, 'geocoord': doc.geocoord, 'graphics': doc.graphics, 'graphicsurl': doc.graphicsurl, 'idno': doc.idno, 'sex': doc.sex, 'pname': doc.pname, 'deathdate': doc.deathdate, 'edition': doc.edition, 'verso': doc.verso, 'recto': doc.recto, 'translation': doc.translation, 'linecomm': doc.linecomm, 'endcomm': doc.endcomm, 'proso': doc.proso, 'bibliography': doc.bibliography}
except sqlalchemy.exc.OperationalError as oe:
logger.error("Failed to connect to DB:%s", oe[0])
return json.dumps(data)
def randomdoc():
data = None
try:
rand = random.randrange(0, db.session.query(models.Epidat).count())
doc = db.session.query(models.Epidat)[rand]
data = {'availability': doc.availability, 'licence': doc.licence, 'title': doc.title, 'locid': doc.locid, 'urld': doc.urld, 'date': doc.date, 'insc': doc.insc, 'material': doc.material, 'condition': doc.condition, 'deconote': doc.deconote, 'decodesc': doc.decodesc, 'geoname': doc.geoname, 'geotype': doc.geotype, 'geocountry': doc.geocountry, 'georegion': doc.georegion, 'geocoord': doc.geocoord, 'graphics': doc.graphics, 'graphicsurl': doc.graphicsurl, 'idno': doc.idno, 'sex': doc.sex, 'pname': doc.pname, 'deathdate': doc.deathdate, 'edition': doc.edition, 'verso': doc.verso, 'recto': doc.recto, 'translation': doc.translation, 'linecomm': doc.linecomm, 'endcomm': doc.endcomm, 'proso': doc.proso, 'bibliography': doc.bibliography}
except sqlalchemy.exc.OperationalError as oe:
logger.error("Failed to connect to DB:%s", oe[0])
return json.dumps(data)
def permajson(locid):
data = None
try:
if locid:
doc = models.Epidat.query.filter_by(locid=locid).first()
data = {
'availability': doc.availability,
'licence': doc.licence,
'title': doc.title,
'locid': doc.locid,
'urld': doc.urld,
'date': doc.date,
'insc': doc.insc,
'material': doc.material,
'condition': doc.condition,
'deconote': doc.deconote,
'decodesc': doc.decodesc,
'geoname': doc.geoname,
'geotype': doc.geotype,
'geocountry': doc.geocountry,
'georegion': doc.georegion,
'geocoord': doc.geocoord,
'graphics': doc.graphics,
'graphicsurl': doc.graphicsurl,
'idno': doc.idno,
'sex': doc.sex,
'pname': doc.pname,
'deathdate': doc.deathdate,
'edition': doc.edition,
'verso': doc.verso,
'recto': doc.recto,
'translation': doc.translation,
'linecomm': doc.linecomm,
'endcomm': doc.endcomm,
'proso': doc.proso,
'bibliography': doc.bibliography
}
else:
data = "No valid id-loc specified."
except sqlalchemy.exc.OperationalError as oe:
logger.error("Failed to connect to DB:%s", oe[0])
return json.dumps(data)
def randomdoc():
data = None
try:
rand = random.randrange(0, db.session.query(models.Epidat).count())
doc = db.session.query(models.Epidat)[rand]
data = {
'availability': doc.availability,
'licence': doc.licence,
'title': doc.title,
'locid': doc.locid,
'urld': doc.urld,
'date': doc.date,
'insc': doc.insc,
'material': doc.material,
'condition': doc.condition,
'deconote': doc.deconote,
'decodesc': doc.decodesc,
'geoname': doc.geoname,
'geotype': doc.geotype,
'geocountry': doc.geocountry,
'georegion': doc.georegion,
'geocoord': doc.geocoord,
'graphics': doc.graphics,
'graphicsurl': doc.graphicsurl,
'idno': doc.idno,
'sex': doc.sex,
'pname': doc.pname,
'deathdate': doc.deathdate,
'edition': doc.edition,
'verso': doc.verso,
'recto': doc.recto,
'translation': doc.translation,
'linecomm': doc.linecomm,
'endcomm': doc.endcomm,
'proso': doc.proso,
'bibliography': doc.bibliography
}
except sqlalchemy.exc.OperationalError as oe:
logger.error("Failed to connect to DB:%s", oe[0])
return json.dumps(data)