Note Component's Storage Usage

[Mani Varma]

Hi,

I cooked up a script to delete File Component from Note's belonging to a specific Project and has worked out fine, but it doesn't seem to reflect on Ftrack Storage Usage. Query for NoteComponent doesn't return anything anymore and I don't understand where NoteComponent get it's storage space from if it's not in Ftrack Storage.

def get_filter_string(entity_ids):
    return ', '.join(
        '"{0}"'.format(entity_id) for entity_id in entity_ids
    )
note_entities = []
project_component = session.query('select name, descendants from Project where id is "{0}"'.format(
	entity_id
)).one()
note_entities.append(project_component['id'])
for hierarchy_item in project_component['descendants']:
	note_entities.append(hierarchy_item['id'])
note_components = session.query('select component, component.file_type, component.name '
	'from NoteComponent where note.parent_id in ({0})'.format(
	get_filter_string(note_entities)
)).all()
# Download happens from note_components information then delete.
for note_component in note_components:
	session.delete(note_component['component'])

session.commit()

 

Edited March 12, 2020 by Mani Varma
Better clarity on script.