JAVASCRIPT

typeorm caching queries

const users = await dataSource.getRepository(User).find({
    where: { isAdmin: true },
    cache: true,
})

typeorm caching queries

const users = await dataSource
    .createQueryBuilder(User, "user")
    .where("user.isAdmin = :isAdmin", { isAdmin: true })
    .cache(true)
    .getMany()

typeorm caching queries limit

const users = await dataSource.getRepository(User).find({
    where: { isAdmin: true },
    cache: 60000,
})

typeorm caching queries time limit

const users = await dataSource
    .createQueryBuilder(User, "user")
    .where("user.isAdmin = :isAdmin", { isAdmin: true })
    .cache(60000) // 1 minute
    .getMany()

typeorm caching queries time limit globally

{
    type: "mysql",
    host: "localhost",
    username: "test",
    ...
    cache: {
        duration: 30000 // 30 seconds
    }
}

typeorm caching queries time limit by id

const users = await dataSource
    .createQueryBuilder(User, "user")
    .where("user.isAdmin = :isAdmin", { isAdmin: true })
    .cache("users_admins", 25000)
    .getMany()

typeorm caching queries time limit by id

const users = await dataSource.getRepository(User).find({
    where: { isAdmin: true },
    cache: {
        id: "users_admins",
        milliseconds: 25000,
    },
})