db.query.STORE_LINKS_SCHEMA.findMany({
limit: paginationsOpts.limit,
offset: (paginationsOpts.page - 1) * paginationsOpts.limit,
with: {
user: {
columns: {
id: true,
email: true,
name: true,
globalRole: true,
phone: true,
},
where: (user, operators) =>
operators.eq(user.globalRole, USER_ROLES.STORE_OWNER),
},
store: true,
},
columns: {
storeId: false,
userId: false,
},
})
db.query.STORE_LINKS_SCHEMA.findMany({
limit: paginationsOpts.limit,
offset: (paginationsOpts.page - 1) * paginationsOpts.limit,
with: {
user: {
columns: {
id: true,
email: true,
name: true,
globalRole: true,
phone: true,
},
where: (user, operators) =>
operators.eq(user.globalRole, USER_ROLES.STORE_OWNER),
},
store: true,
},
columns: {
storeId: false,
userId: false,
},
})