如何使用Postgresql，Knex.js，Objection.js和HasOneRelation将默认值插入到有关系的外来对象中？

npm install knex objection

module.exports = {
  development: {
    client: 'postgresql',
    connection: {
      host: 'localhost',
      port: 5432,
      database: 'your_database',
      user: 'your_username',
      password: 'your_password'
    },
    migrations: {
      directory: './migrations'
    }
  }
};

npx knex migrate:make create_related_objects_table

exports.up = function(knex) {
  return knex.schema
    .createTable('users', function(table) {
      table.increments('id').primary();
      table.string('name');
    })
    .createTable('posts', function(table) {
      table.increments('id').primary();
      table.string('title');
      table.integer('user_id').unsigned().references('users.id').onDelete('CASCADE');
    });
};

exports.down = function(knex) {
  return knex.schema
    .dropTableIfExists('posts')
    .dropTableIfExists('users');
};

npx knex migrate:latest

const { Model } = require('objection');

class User extends Model {
  static get tableName() {
    return 'users';
  }

  static get relationMappings() {
    return {
      posts: {
        relation: Model.HasOneRelation,
        modelClass: Post,
        join: {
          from: 'users.id',
          to: 'posts.user_id'
        }
      }
    };
  }
}

class Post extends Model {
  static get tableName() {
    return 'posts';
  }
}

// 插入默认值
User.query().insertGraph({
  name: 'John Doe',
  posts: {
    title: 'Default Post Title'
  }
}).then(user => {
  console.log(user);
}).catch(error => {
  console.error(error);
});