skopa/dbInit.js

28 lines
909 B
JavaScript

const Sequelize = require('sequelize');
const sequelize = new Sequelize('database', 'username', 'password', {
host: 'localhost',
dialect: 'sqlite',
logging: false,
storage: 'database.sqlite',
});
const ItemShop = require('./models/ItemShop.js')(sequelize, Sequelize.DataTypes);
require('./models/Users.js')(sequelize, Sequelize.DataTypes);
require('./models/UserItems.js')(sequelize, Sequelize.DataTypes);
const force = process.argv.includes('--force') || process.argv.includes('-f');
sequelize.sync({ force }).then(async () => {
const shop = [
ItemShop.upsert({ name: 'Canary', desc: 'A little guy! :>', cost: 100 }),
ItemShop.upsert({ name: 'Brick', desc: 'For throwing at friends :3', cost: 3 }),
ItemShop.upsert({ name: 'Book', desc: 'Reading is good for the mind.', cost: 10 }),
];
await Promise.all(shop);
console.log('Database synced');
sequelize.close();
}).catch(console.error);