davidcsejtei

import { Request, Response } from 'express';
import GetAllUsers from './getAllUsers';

describe('Get all users request', () => {
    let mockRequest: Partial<Request>;
    let mockResponse: Partial<Response>;
    let responseObject = {};

    beforeEach(() => {
        mockRequest = {

davidcsejtei

const express = require('express');
const router = express.Router();

router.get('/excel/example', (request, response) => {
    response.download('./excelFiles/foods.xlsx', 'example.xlsx');
});

module.exports = router;

davidcsejtei

export type User = {
    name: string,
    age: number,
    roles: Role[];
}

export function isValidUser(user: unknown): user is User {
    return  !!(user as User).name && 
            !!(user as User).age && 
            !!(user as User).roles && 

davidcsejtei

type User = {
    name: string,
    age: number,
    roles: Role[];
}

type Role = {
    label: string
}

davidcsejtei

const xlsx = require('xlsx');
const path = require('path');

const exportExcel = (data, workSheetColumnNames, workSheetName, filePath) => {
    const workBook = xlsx.utils.book_new();
    const workSheetData = [
        workSheetColumnNames,
        ... data
    ];
    const workSheet = xlsx.utils.aoa_to_sheet(workSheetData);

davidcsejtei

const validateUser = (user) ⇒ {
	return user.name === undefined;
}

// OR

const validateUser = (user) ⇒ user.name === undefined;

// OR

davidcsejtei

import "reflect-metadata";
import {createConnection, ConnectionOptions} from "typeorm";
import http from "http";
import express from 'express';
import config from "../ormconfig.json";
import GetAllUsers from "./controllers/GetAllUsers";

createConnection(config as ConnectionOptions).then(async connection => {
    const app = express();
    app.use(express.json());

davidcsejtei

import {Request, Response} from 'express';
import {getCustomRepository} from "typeorm";
import {UserRepository} from "../db/repositories/UserRepository";

const GetAllUsers = async (request: Request, response: Response) => {
    const userRepository = getCustomRepository(UserRepository);
    const users = await userRepository.find();

    response.json({ users });
}

davidcsejtei

import {EntitySubscriberInterface, EventSubscriber, InsertEvent} from "typeorm";
import {User} from "../entities/User";

@EventSubscriber()
export class UserSubscriber implements EntitySubscriberInterface<User> {
    listenTo() {
        return User;
    }

    beforeInsert(event: InsertEvent<User>) {

davidcsejtei

import {EntityRepository, Repository} from "typeorm";
import {User} from "../entities/User";

@EntityRepository(User)
export class UserRepository extends Repository<User> {
    findByName(name: string) {
        return this.findOne({ name });
    }
}