const path = require('path');

const sqlDb = (env, client) => ({
  host: env('DATABASE_HOST', '127.0.0.1'),
  port: env.int('DATABASE_PORT', client === 'postgres' ? 5432 : 3306),
  database: env('DATABASE_NAME', 'strapi'),
  user: env('DATABASE_USERNAME', 'strapi'),
  password: env('DATABASE_PASSWORD', 'strapi'),
  schema: client === 'postgres' ? env('DATABASE_SCHEMA', 'public') : undefined,
  ssl: false
})

const sqlLite = (env) => ({
  filename: path.join(__dirname, '..', env('DATABASE_FILENAME', '.tmp/data.db')),
})

module.exports = ({ env }) => {
  const client = env('DATABASE_CLIENT', 'sqlite')
  return ({
    connection: {
      client,
      connection: client === 'sqlite' ? sqlLite(env) : sqlDb(env, client),
      useNullAsDefault: true
    },
  });
};