const sequelize = require('./db')
const {
    DataTypes
} = require('sequelize');


module.exports = async (stock, tableName) => {

    const Stock = sequelize.define("Stock", {
        id: {
            type: DataTypes.INTEGER,
            primaryKey: true,
            autoIncrement: true
        },
        date: {
            type: DataTypes.DATEONLY
        },
        code: {
            type: DataTypes.STRING
        },
        open: {
            type: DataTypes.DECIMAL(25, 10)
        },
        high: {
            type: DataTypes.DECIMAL(25, 10)
        },
        low: {
            type: DataTypes.DECIMAL(25, 10)
        },
        close: {
            type: DataTypes.DECIMAL(25, 10)
        },
        preclose: {
            type: DataTypes.DECIMAL(25, 10)
        },
        volume: {
            type: DataTypes.DECIMAL(25, 10)
        },
        amount: {
            type: DataTypes.DECIMAL(25, 10)
        },
        adjustflag: {
            type: DataTypes.INTEGER
        },
        turn: {
            type: DataTypes.DECIMAL(25, 10)
        },
        tradestatus: {
            type: DataTypes.INTEGER
        },
        pctChg: {
            type: DataTypes.DECIMAL(25, 10)
        },
        peTTM: {
            type: DataTypes.DECIMAL(25, 10)
        },
        pbMRQ: {
            type: DataTypes.DECIMAL(25, 10)
        },
        psTTM: {
            type: DataTypes.DECIMAL(25, 10)
        },
        pcfNcfTTM: {
            type: DataTypes.DECIMAL(25, 10)
        },
        isST: {
            type: DataTypes.INTEGER
        }
    }, {

        timestamps: false,
        tableName: 'n' + tableName.slice(0, 6)
    });
    await Stock.sync();
    console.time('insert')
    
    await Stock.bulkCreate(stock)
    console.timeEnd('insert')

}