recover-nextcloud-vcards

recover_nextcloud_vcards.py

db = pymysql.connect(host="localhost",user="root",password="****",database="nextcloud",cursorclass=pymysql.cursors.DictCursor)
with db:
  with db.cursor() as cursor:
    sql = "SELECT carddata,uri FROM oc_cards WHERE addressbookid='5';"
    cursor.execute(sql)
    result = cursor.fetchall()
    for item in result:
      vcard = open("/tmp/restored_vcards/"+item["uri"],"w")
      vcard.write(item["carddata"].decode("utf-8"))
      vcard.close()