davidcsejtei

const xlsx = require('xlsx');

const deleteWorksheet = (filePath, workSheetName) => {
    const workBook = xlsx.readFile(filePath);
    const workSheetNames = Object.keys(workBook.Sheets);

    if (workSheetNames.includes(workSheetName)) {
        delete workBook.Sheets[workSheetName];
        delete workBook.SheetNames[workSheetName];
        indexToDelete = workBook.SheetNames.indexOf(workSheetName);

davidcsejtei

```
git checkout feature/TICKET-123
git merge master
git reset master
git add .
git commit -m "TICKET-123 add something"
git push -f origin feature/TICKET-123
```

davidcsejtei

import { Request, Response } from "express";
import { findAllUsers } from "../services/userService";

export default function getAllUsers(request: Request, response: Response) {
    const users = findAllUsers();

    response.statusCode = 200;
    response.send().json({ users });
}

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());