Appwrite Database Query

export const fetchMetadata = async (userId: string) => {
  try {
    // query database for files owned by the user
    const ownedFilesMetadata = await database.listDocuments(import.meta.env.VITE_DATABASE_ID, import.meta.env.VITE_FILE_METADATA_COLLECTION_ID, [Query.equal("ownerId", userId)]);

    // query database for files shared with the user
    const sharedFilesMetadata = await database.listDocuments(import.meta.env.VITE_DATABASE_ID, import.meta.env.VITE_FILE_METADATA_COLLECTION_ID, [Query.search("shared_with", userId)]);

    return {
      ownedFilesMetadata: ownedFilesMetadata.documents,
      sharedFilesMetadata: sharedFilesMetadata.documents
    }
  } catch (error) {
    console.log(error);
    return {
      ownFilesMetadata: [],
      sharedFilesMetadata: [],
    }
  }
}