mirror of
https://github.com/strapi/strapi.git
synced 2026-06-02 16:27:47 +00:00
Ben Irvin
97f5cde810
* fix(core): preserve createdBy/updatedBy on drafts created by discard-drafts migration Stage 1 of the v4→v5 discard-drafts migration now copies join-column foreign keys when cloning published rows to drafts, so creator metadata is no longer NULL on the new draft rows. Adds a focused migration test and extends the complex example migration validator to catch this regression. Fixes #26460 * fix(core): skip virtual join columns in discard-drafts stage 1 i18n localizations reuses document_id as a virtual join column; copying it alongside the scalar duplicated the column in INSERT…SELECT and broke v4→v5 migration. Dedupe clone columns and apply the same filter in later stages.
65 lines
2.2 KiB
TypeScript
65 lines
2.2 KiB
TypeScript
export default ({ env }) => {
|
|
const client = env('DATABASE_CLIENT', 'postgres');
|
|
|
|
const connections = {
|
|
mysql: {
|
|
connection: {
|
|
host: env('DATABASE_HOST', 'localhost'),
|
|
port: env.int('DATABASE_PORT', 3306),
|
|
database: env('DATABASE_NAME', 'strapi'),
|
|
user: env('DATABASE_USERNAME', 'strapi'),
|
|
password: env('DATABASE_PASSWORD', 'strapi'),
|
|
ssl: env.bool('DATABASE_SSL', false) && {
|
|
key: env('DATABASE_SSL_KEY', undefined),
|
|
cert: env('DATABASE_SSL_CERT', undefined),
|
|
ca: env('DATABASE_SSL_CA', undefined),
|
|
capath: env('DATABASE_SSL_CAPATH', undefined),
|
|
cipher: env('DATABASE_SSL_CIPHER', undefined),
|
|
rejectUnauthorized: env.bool('DATABASE_SSL_REJECT_UNAUTHORIZED', true),
|
|
},
|
|
},
|
|
pool: { min: env.int('DATABASE_POOL_MIN', 2), max: env.int('DATABASE_POOL_MAX', 10) },
|
|
},
|
|
postgres: {
|
|
connection: {
|
|
connectionString: env('DATABASE_URL'),
|
|
host: env('DATABASE_HOST', 'localhost'),
|
|
port: env.int('DATABASE_PORT', 5432),
|
|
database: env('DATABASE_NAME', 'strapi'),
|
|
user: env('DATABASE_USERNAME', 'strapi'),
|
|
password: env('DATABASE_PASSWORD', 'strapi'),
|
|
ssl: env.bool('DATABASE_SSL', false) && {
|
|
key: env('DATABASE_SSL_KEY', undefined),
|
|
cert: env('DATABASE_SSL_CERT', undefined),
|
|
ca: env('DATABASE_SSL_CA', undefined),
|
|
capath: env('DATABASE_SSL_CAPATH', undefined),
|
|
cipher: env('DATABASE_SSL_CIPHER', undefined),
|
|
rejectUnauthorized: env.bool('DATABASE_SSL_REJECT_UNAUTHORIZED', true),
|
|
},
|
|
schema: env('DATABASE_SCHEMA', 'public'),
|
|
},
|
|
pool: { min: env.int('DATABASE_POOL_MIN', 2), max: env.int('DATABASE_POOL_MAX', 10) },
|
|
},
|
|
sqlite: {
|
|
connection: {
|
|
filename: env('DATABASE_FILENAME', '.tmp/data.db'),
|
|
},
|
|
useNullAsDefault: true,
|
|
},
|
|
};
|
|
|
|
if (!connections[client]) {
|
|
throw new Error(
|
|
`Unsupported DATABASE_CLIENT: ${client}. Use "postgres", "mysql", or "sqlite".`
|
|
);
|
|
}
|
|
|
|
return {
|
|
connection: {
|
|
client,
|
|
...connections[client],
|
|
acquireConnectionTimeout: env.int('DATABASE_CONNECTION_TIMEOUT', 60000),
|
|
},
|
|
};
|
|
};
|