RCS Zetta: Deletion Date Remover

ZettaRemoveDeletionDates.py

"""
Zetta Deletion Date Remover
This script will remove all deletion dates from assets in the Zetta DB, except Voice Tracks and Quick Records.

Written by Anthony Eden (https://mediarealm.com.au/)
"""

import os
import sys
import json
import pypyodbc 
import io
import time
import datetime

# Setup Zetta SQL DB Connection:
SQLConnectionString = 'DSN=ZettaDB;'
dbConn = pypyodbc.connect(SQLConnectionString, autocommit = True)
cur = dbConn.cursor()

def removeDeletionDates():
	deletionDatesQuery = '''
	UPDATE [ZettaDB].[dbo].[Asset]
        SET EraseDate = NULL
        WHERE EraseDate IS NOT NULL
        AND AssetTypeID <> 5
        AND AssetTypeID <> 4
	'''
	
	cur.execute(deletionDatesQuery)


if __name__ == "__main__":
	removeDeletionDates()