We need to retrieve some documents from a database dump. We have followed the below steps on accessing the information. I was able to run successfully the below queries but, how do i actually download the file?
P.S Jive SDS 5.0.1 version
something like this?
cursor.execute("SELECT internaldocid from jivedocument where documentid like 'DOC-1284'")
internaldoc_id = str(cursor.fetchone())
print 'internaldoc id:',internaldoc_id
cursor.execute("SELECT bodyid FROM jivedocbodyversion where internaldocid= "+internaldoc_id+"")
body_id = str(cursor.fetchone())
cursor.execute("SELECT * FROM jivedocumentbody where bodyid = "+body_id+"")
result = cursor.fetchall()