'use strict';
/** @type {import('sequelize-cli').Migration} */
module.exports = {
  async up(queryInterface, Sequelize) {
    await queryInterface.createTable('reader', {
      id: {
        allowNull: false,
        autoIncrement: false, // 不自動跳號
        primaryKey: true,
        type: Sequelize.CHAR(10)  // 身份證字號
      },
      password: {
        type: Sequelize.STRING(128),
        defaultValue: '000', // 加入預設值
      },
      slack_id: {
        type: Sequelize.STRING(50)
      },
      line_id: {
        type: Sequelize.STRING(50)
      },
      phone: {
        allowNull: false,
        type: Sequelize.CHAR(10)
      },
      email: {
        allowNull: false,
        type: Sequelize.STRING(50)
      },
      creator_id: {
        allowNull: false,
        type: Sequelize.INTEGER,
        // foreign key 的設定
        references: {
          model: 'user',
          key: 'id'
        },
      },
      created_at: {
        allowNull: false,
        type: Sequelize.DATE
      },
      updated_at: {
        allowNull: false,
        type: Sequelize.DATE
      }
    });
  },
  async down(queryInterface, Sequelize) {
    await queryInterface.dropTable('reader');
  }
};

'use strict';
const {
  Model
} = require('sequelize');
module.exports = (sequelize, DataTypes) => {
  class reader extends Model {
    /**
     * Helper method for defining associations.
     * This method is not a part of Sequelize lifecycle.
     * The `models/index` file will call this method automatically.
     */
    static associate(models) {
      // define association here
    }
  }
  reader.init({
    id: DataTypes.CHAR(10),
    password: DataTypes.STRING,
    slack_id: DataTypes.STRING,
    line_id: DataTypes.STRING,
    phone: DataTypes.STRING,
    email: DataTypes.STRING,
    creator_id: {
      DataTypes: DataTypes.INTEGER,
      references: {
        // This is a reference to another model
        model: user,  
        // This is the column name of the referenced model
        key: 'id',
      }
    },
  }, {
    sequelize,
    modelName: 'reader',
    underscored: true,
    freezeTableName: true, // 請手動加入這一行
  });
  return reader;
};

const { Sequelize, DataTypes } = require('sequelize');

async function main() {
  const development = {
    //...
  }
  // Option 3: Passing parameters separately (other dialects)
  const sequelize = new Sequelize(...);
                                  
  // 引用參考 (不用管順序)
  require('./models/reader')(sequelize, DataTypes);
  require('./models/user')(sequelize, DataTypes);
  
  try {
    await sequelize.authenticate();
  } catch (error) {
    console.error('Unable to connect to the database:', error);
  }
  
  try {
    const chris = await sequelize.models.user.create({ name: 'chris', password: 'chris' });
    await sequelize.models.reader.create({
      name: 'mary',
      phone: '0987654321',
      email: 'mary@gmail.com',
      creator_id: chris.id,
      created_at: Date.now(),
      updated_at: Date.now(),
    });
    
    console.log('Connection has been established successfully.');
  } catch (error) {
    console.log(error.message);
  }
}
main()

// ...
module.exports = (sequelize, DataTypes) => {
  class user extends Model {
    // ...
  }
  user.init({
    // 加上 id 的定義，要給別人 reference 成 foreign key 用的
    id: {
      type: DataTypes.INTEGER, // 型別要正確
      primaryKey: true  // 要設定 primaryKey: true
    },
    name: DataTypes.STRING(50),
    password: DataTypes.CHAR(128)
  }, {
    // ...
  });
  return user;
};

'use strict';
const {
  Model
} = require('sequelize');
const user = require('./user'); // 為了 foreign keys
module.exports = (sequelize, DataTypes) => {
  class reader extends Model {
    /**
     * Helper method for defining associations.
     * This method is not a part of Sequelize lifecycle.
     * The `models/index` file will call this method automatically.
     */
    static associate(models) {
      // define association here
    }
  }
  reader.init({
    // 加上 id 的定義，要給別人 reference 成 foreign key 用的
    id: {
      type: DataTypes.CHAR(10), // 型別要正確
      primaryKey: true // 要設定 primaryKey: true
    },
    password: DataTypes.STRING,
    slack_id: DataTypes.STRING,
    line_id: DataTypes.STRING,
    phone: DataTypes.STRING,
    email: DataTypes.STRING,
    creator_id: {
      type: DataTypes.INTEGER,
      // foreign keys 的設定
      references: {
        // This is a reference to another model
        model: user,  
        // This is the column name of the referenced model
        key: 'id',
      }
    },
  }, {
    sequelize,
    modelName: 'reader',
    underscored: true,
    freezeTableName: true, // 請手動加入這一行
  });
  return reader;
};

await sequelize.models.user.create({ name: 'chris', password: 'chris' });

// 要將 user 的資料從資料庫再撈一次，才會是包含所有在資料庫裡的內容。而不是只有在 JS 出現的而已。
const chris = await sequelize.models.user.findOne({
  where: { name: 'chris' }
})

const mary = await sequelize.models.reader.create({
  id: 'E123456789',
  name: 'mary',
  phone: '0987654321',
  email: 'mary@gmail.com',
  creator_id: chris.id,
  created_at: Date.now(),
  updated_at: Date.now(),
});

console.log('mary.password', mary.password)

{
  id: 'E123456789',
  phone: '0987654321',
  email: 'mary@gmail.com',
  creator_id: 19,
  updatedAt: 2023-09-12T15:48:58.828Z,
  createdAt: 2023-09-12T15:48:58.828Z
}