Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import mysql from 'mysql';
- var db;
- const connectDatabase = () => {
- if (!db) {
- db = mysql.createConnection({
- host: 'localhost',
- user: 'root',
- password: 'root',
- port: '8889',
- database : 'testDb'
- });
- db.connect(function(err){
- if(!err) {
- console.log('Database is connected!');
- } else {
- console.log('Error connecting database!', err);
- }
- });
- }
- return db;
- }
- export { connectDatabase, db};
- import express from "express";
- import bodyParser from "body-parser";
- import cors from "cors";
- import logger from './core/logger/app-logger'
- import morgan from 'morgan'
- import config from './core/config/config.dev'
- import user from './routes/user.route'
- import {connectDatabase} from './db/connect'
- const port = config.serverPort;
- logger.stream = {
- write: function(message, encoding){
- logger.info(message);
- }
- };
- connectDatabase();
- const app = express();
- app.use(cors());
- app.use(bodyParser.json());
- app.use(bodyParser.urlencoded({ extended: true }));
- app.use(morgan("dev", { "stream": logger.stream }));
- app.use('/user', user);
- //Index route
- app.get('/', (req, res) => {
- res.send('Invalid endpoint!');
- });
- app.listen(port, () => {
- logger.info('server started - ', port);
- });
- import express from "express";
- import userController from "../controllers/user.controller"
- const router = express.Router()
- router.get('/allUsers', (req, res) => {
- userController.getAll(req, res);
- });
- export default router;
- import userModel from '../models/user.model';
- import logger from '../core/logger/app-logger';
- let userController = {};
- userController.getAll = (req, res) => {
- try {
- const users = userModel.getAll();
- logger.info('sending all users...');
- console.log('sending all users...');
- res.send(users);
- }
- catch(err) {
- logger.error('Error in getting users- ' + err);
- console.log('Error in getting users- ' + err);
- res.send('Got error in getAll');
- }
- }
- export default userController;
- import { db } from '../db/connect'
- import mysql from 'mysql';
- const userModel = {};
- userModel.getAll = () => {
- db.query("select * from user",query, function(err, results, query) {
- if (err) throw err;
- return results;
- });
- }
- export default userModel;
- Error in getting users- ReferenceError: query is not defined
Add Comment
Please, Sign In to add comment