from google.oauth2 import service_account
from googleapiclient.discovery import build
import google

# ID of folder to test this with; make sure it contains a trashed item
TEST_FOLDER_ID = 'folder_id'

# Path to your service account key file
SERVICE_ACCOUNT_FILE = 'path_to_sa_json'

def default_credentials():
    credentials, project = google.auth.default()
    return credentials

def service_account_credentials():
    credentials = service_account.Credentials.from_service_account_file(SERVICE_ACCOUNT_FILE)
    return credentials


auth_type_credentials = {
    "default": default_credentials(),
    "service_account": service_account_credentials(),
}

queries = [
    f"'{TEST_FOLDER_ID}' in parents",
    f"('{TEST_FOLDER_ID}' in parents)",
    f"('{TEST_FOLDER_ID}' in parents or '{TEST_FOLDER_ID}' in parents)",
]

for auth_type, credentials in auth_type_credentials.items():
    drive_service = build('drive', 'v3', credentials=credentials)
    print(f"{auth_type=}")
    for query in queries:
        fields = "incompleteSearch, nextPageToken, files(id, name, driveId, mimeType, parents, trashed)"
        results = drive_service.files().list(
            q=query,
            fields=fields,
            supportsAllDrives=True,
            includeItemsFromAllDrives=True,
        ).execute()

        print(f"\t{query=}")
        print(f"\t\t- Cnt results: {len(results['files'])}")
        print(f"\t\t- Of which trashed: {len([f for f in results['files'] if f.get('trashed', False)])}")
    print("\n")