mirror of
https://github.com/docker-training/node-bulletin-board.git
synced 2025-05-17 19:39:31 +08:00
41 lines
845 B
JavaScript
41 lines
845 B
JavaScript
var Sequelize = require('sequelize');
|
|
var username = 'postgres';
|
|
var password = 'DockerCon!!!';
|
|
var host = 'bb-db';
|
|
var dbName = 'postgres';
|
|
|
|
var sequelize = new Sequelize(dbName, username, password, {
|
|
dialect: 'postgres',
|
|
host: host,
|
|
port: 5432,
|
|
omitNull: true,
|
|
define: {
|
|
timestamps: false
|
|
},
|
|
dialectOptions: {
|
|
requestTimeout: 30000,
|
|
encrypt: false
|
|
},
|
|
operatorsAliases: false
|
|
});
|
|
|
|
sequelize
|
|
.authenticate()
|
|
.then(() => {
|
|
console.log('Successful connection to SQL Server.');
|
|
})
|
|
.catch(err => {
|
|
console.error('** SQL Server connection failed: ', err);
|
|
process.exit(1);
|
|
});
|
|
|
|
var Event = sequelize.define('event', {
|
|
title: Sequelize.STRING,
|
|
detail: Sequelize.STRING,
|
|
date: Sequelize.DATE
|
|
});
|
|
|
|
Event.sync();
|
|
|
|
exports.Events = Event;
|