mongoose.js

require('dotenv-extended').load({
  encoding: 'utf8',
  silent: true,
  path: '.env',
  defaults: '.env.defaults',
  schema: '.env.schema',
  errorOnMissing: false,
  errorOnExtra: false,
  includeProcessEnv: false,
  assignToProcessEnv: true,
  overrideProcessEnv: false
});

const mongoose = require('mongoose');
mongoose.connect(process.env.MONGODB_URL, {
	useNewUrlParser: true,
	useUnifiedTopology: true
})
.then(() => console.log('MongoDB connected successfully'))
.catch(err => console.error('MongoDB connection error:', err));

//-------------------------------------------------------------------------------------------------------------------

const ticketsSchema = new mongoose.Schema(
  {
    ticketNumber: Number,
    name: String,
    phoneNumber: String,
    email: String,
    description: String,
    logs: String,
    status: {
      type: String,
      default: 'Open'
    },
    createdAt: String,
    updatedAt: String
  },
  {
    versionKey: false
  }
);

const Tickets = mongoose.model('Tickets', ticketsSchema);

const DUMMY_TICKET = {
  ticketNumber: '100001',
  name: 'Laxus',
  phoneNumber: '+62 349 28349',
  email: 'Laxus@email.com',
  description: 'Unable to access my account',
  logs: "I can't sign in to my account since this morning",
  createdAt: '03:03:48  16/09/2018',
  updatedAt: '03:03:48  16/09/2018'
};

Tickets.insertMany(DUMMY_TICKET).then(result => console.log(result));

//-------------------------------------------------------------------------------------------------------------------

const counterSchema = new mongoose.Schema(
  {
      name: String,
      ticketNumber: Number
  },
  {
    versionKey: false
  }
);

const Counter = mongoose.model('Counters', counterSchema);

const DUMMY_COUNTER = {
  name: 'ticketNumber',
  ticketNumber: 100001
};

Counter.insertMany(DUMMY_COUNTER).then(result => console.log(result));

//-------------------------------------------------------------------------------------------------------------------

const logsSchema = new mongoose.Schema(
  {
      ticketNumber: Number,
      logs: String,
      updatedAt: String
  },
  {
    versionKey: false
  }
);

const Logs = mongoose.model('Logs', logsSchema);

const DUMMY_LOGS = {
  ticketNumber: 100001,
  logs: "Checking the issue...",
  updatedAt: "07:03:48  16/09/2018"
};

Logs.insertMany(DUMMY_LOGS).then(result => console.log(result));