### What?
With Postgres, before join to self like:
```ts
import type { CollectionConfig } from 'payload'
export const SelfJoins: CollectionConfig = {
slug: 'self-joins',
fields: [
{
name: 'rel',
type: 'relationship',
relationTo: 'self-joins',
},
{
name: 'joins',
type: 'join',
on: 'rel',
collection: 'self-joins',
},
],
}
```
wasn't possible, even though it's a valid usage.
### How?
Now, to differentiate parent `self_joins` and children `self_joins` we
do additional alias for the nested select -
`"4d3cf2b6_1adf_46a8_b6d2_3e1c3809d737"`:
```sql
select
"id",
"rel_id",
"updated_at",
"created_at",
(
select
coalesce(
json_agg(
json_build_object('id', "joins_alias".id)
),
'[]' :: json
)
from
(
select
"created_at",
"rel_id",
"id"
from
"self_joins" "4d3cf2b6_1adf_46a8_b6d2_3e1c3809d737"
where
"4d3cf2b6_1adf_46a8_b6d2_3e1c3809d737"."rel_id" = "self_joins"."id"
order by
"4d3cf2b6_1adf_46a8_b6d2_3e1c3809d737"."created_at" desc
limit
$1
) "joins_alias"
) as "joins_alias"
from
"self_joins"
where
"self_joins"."id" = $2
order by
"self_joins"."created_at" desc
limit
$3
```
Fixes https://github.com/payloadcms/payload/issues/10144
-->
185 lines
4.1 KiB
TypeScript
185 lines
4.1 KiB
TypeScript
import { fileURLToPath } from 'node:url'
|
|
import path from 'path'
|
|
|
|
import { buildConfigWithDefaults } from '../buildConfigWithDefaults.js'
|
|
import { Categories } from './collections/Categories.js'
|
|
import { CategoriesVersions } from './collections/CategoriesVersions.js'
|
|
import { HiddenPosts } from './collections/HiddenPosts.js'
|
|
import { Posts } from './collections/Posts.js'
|
|
import { SelfJoins } from './collections/SelfJoins.js'
|
|
import { Singular } from './collections/Singular.js'
|
|
import { Uploads } from './collections/Uploads.js'
|
|
import { Versions } from './collections/Versions.js'
|
|
import { seed } from './seed.js'
|
|
import {
|
|
categoriesJoinRestrictedSlug,
|
|
collectionRestrictedSlug,
|
|
localizedCategoriesSlug,
|
|
localizedPostsSlug,
|
|
postsSlug,
|
|
restrictedCategoriesSlug,
|
|
restrictedPostsSlug,
|
|
} from './shared.js'
|
|
|
|
const filename = fileURLToPath(import.meta.url)
|
|
const dirname = path.dirname(filename)
|
|
|
|
export default buildConfigWithDefaults({
|
|
admin: {
|
|
importMap: {
|
|
baseDir: path.resolve(dirname),
|
|
},
|
|
},
|
|
collections: [
|
|
Posts,
|
|
Categories,
|
|
HiddenPosts,
|
|
Uploads,
|
|
Versions,
|
|
CategoriesVersions,
|
|
Singular,
|
|
SelfJoins,
|
|
{
|
|
slug: localizedPostsSlug,
|
|
admin: {
|
|
useAsTitle: 'title',
|
|
},
|
|
fields: [
|
|
{
|
|
name: 'title',
|
|
type: 'text',
|
|
localized: true,
|
|
},
|
|
{
|
|
name: 'category',
|
|
type: 'relationship',
|
|
localized: true,
|
|
relationTo: localizedCategoriesSlug,
|
|
},
|
|
],
|
|
},
|
|
{
|
|
slug: localizedCategoriesSlug,
|
|
admin: {
|
|
useAsTitle: 'name',
|
|
},
|
|
fields: [
|
|
{
|
|
name: 'name',
|
|
type: 'text',
|
|
},
|
|
{
|
|
name: 'relatedPosts',
|
|
type: 'join',
|
|
collection: localizedPostsSlug,
|
|
on: 'category',
|
|
localized: true,
|
|
},
|
|
],
|
|
},
|
|
{
|
|
slug: restrictedCategoriesSlug,
|
|
admin: {
|
|
useAsTitle: 'name',
|
|
},
|
|
fields: [
|
|
{
|
|
name: 'name',
|
|
type: 'text',
|
|
},
|
|
{
|
|
// this field is misconfigured to have `where` constraint using a restricted field
|
|
name: 'restrictedPosts',
|
|
type: 'join',
|
|
collection: postsSlug,
|
|
on: 'category',
|
|
where: {
|
|
restrictedField: { equals: 'restricted' },
|
|
},
|
|
},
|
|
],
|
|
},
|
|
{
|
|
slug: categoriesJoinRestrictedSlug,
|
|
admin: {
|
|
useAsTitle: 'name',
|
|
},
|
|
fields: [
|
|
{
|
|
name: 'name',
|
|
type: 'text',
|
|
},
|
|
{
|
|
// join collection with access.read: () => false which should not populate
|
|
name: 'collectionRestrictedJoin',
|
|
type: 'join',
|
|
collection: collectionRestrictedSlug,
|
|
on: 'category',
|
|
},
|
|
],
|
|
},
|
|
{
|
|
slug: restrictedPostsSlug,
|
|
admin: {
|
|
useAsTitle: 'title',
|
|
},
|
|
fields: [
|
|
{
|
|
name: 'title',
|
|
type: 'text',
|
|
},
|
|
{
|
|
name: 'restrictedField',
|
|
type: 'text',
|
|
access: {
|
|
read: () => false,
|
|
update: () => false,
|
|
},
|
|
},
|
|
{
|
|
name: 'category',
|
|
type: 'relationship',
|
|
relationTo: restrictedCategoriesSlug,
|
|
},
|
|
],
|
|
},
|
|
{
|
|
slug: collectionRestrictedSlug,
|
|
admin: {
|
|
useAsTitle: 'title',
|
|
},
|
|
access: {
|
|
read: () => ({ canRead: { equals: true } }),
|
|
},
|
|
fields: [
|
|
{
|
|
name: 'title',
|
|
type: 'text',
|
|
},
|
|
{
|
|
name: 'canRead',
|
|
type: 'checkbox',
|
|
defaultValue: false,
|
|
},
|
|
{
|
|
name: 'category',
|
|
type: 'relationship',
|
|
relationTo: categoriesJoinRestrictedSlug,
|
|
},
|
|
],
|
|
},
|
|
],
|
|
localization: {
|
|
locales: ['en', 'es'],
|
|
defaultLocale: 'en',
|
|
},
|
|
onInit: async (payload) => {
|
|
if (process.env.SEED_IN_CONFIG_ONINIT !== 'false') {
|
|
await seed(payload)
|
|
}
|
|
},
|
|
typescript: {
|
|
outputFile: path.resolve(dirname, 'payload-types.ts'),
|
|
},
|
|
})
|