How to use the Not function from typeorm

contracts.ts

GitHub: ShipChain/engine

212
213
214
215
216
217
218
219
220
const loadedContracts = LoadedContracts.Instance;

const previousContracts: Contract[] = await Contract.find({
    projectId: currentContract.projectId,
    networkId: currentContract.networkId,
    versionId: typeorm.Not(currentContract.versionId),
});

logger.debug(`Found ${previousContracts.length} previous Load contracts in DB`);

1

14

9

+ 9 other calls in file

teams.js

GitHub: milaneyia/obwc

43
44
45
46
47
48
49
50
51
52
    }))
        .getMany();
}
else {
    users = await User_1.User.findByIds(input.invitations, {
        id: typeorm_1.Not(user.id),
        countryId: user.country.id,
        teamId: typeorm_1.IsNull(),
    });
}

1

0

0

User.repository.js

GitHub: ydanielsb97/api-chat-realtime

20
21
22
23
24
25
26
27
28
29
let UserRepository = class UserRepository extends typeorm_1.Repository {
    findAllWithRooms() {
        return __awaiter(this, void 0, void 0, function* () {
            return yield this.find({
                where: {
                    roomId: typeorm_1.Not(typeorm_1.IsNull())
                },
                relations: ['room']
            });
        });

0

2

0

RetiradoController.js

GitHub: YuriRDev/fiip-bar-server

358
359
360
361
362
363
364
365
366
367
return __generator(this, function (_a) {
    switch (_a.label) {
        case 0:
            eventId = req.body.eventId;
            itemsCompradosRepo = typeorm_1.getRepository(Items_Comprados_1.default);
            return [4 /*yield*/, itemsCompradosRepo.find({ where: { event: { id: eventId }, retirado: typeorm_1.Not(typeorm_1.IsNull()), refund: typeorm_1.IsNull() } })];
        case 1:
            itemsComprados = _a.sent();
            itemsCompradosRetirados = [];
            itemsComprados.map(function (item) {

0

0

0

ItemController.js

GitHub: YuriRDev/fiip-bar-server

575
576
577
578
579
580
581
582
583
584
    "quantity": null
}
    */
    }
    itemRepo = typeorm_1.getRepository(Item_1.default);
    return [4 /*yield*/, itemRepo.find({ where: { id: typeorm_1.Not(typeorm_1.IsNull()) } })];
case 1:
    getAllItems = _a.sent();
    arrayTotal = [];
    getAllItems.map(function (item) {

0

0

0

EventController.js

GitHub: YuriRDev/fiip-bar-server

473
474
475
476
477
478
479
480
481
482
event_5 = _a.sent();
if (!event_5) return [3 /*break*/, 7];
if (!((event_5 === null || event_5 === void 0 ? void 0 : event_5.host.id) == id)) return [3 /*break*/, 5];
itemRepo = typeorm_1.getRepository(Item_1.default);
itemsCompradosRepo = typeorm_1.getRepository(Items_Comprados_1.default);
return [4 /*yield*/, itemsCompradosRepo.find({ where: { event: eventId, retirado: typeorm_1.Not(typeorm_1.IsNull()) } })
    // Item mais comprado
    // Logica:
    // Listar todos items retirados
    // ver quais deles apareceram mais vezes

0

0

0

+ 2 other calls in file