Updating nullable columns in typeorm entities: a step-by-step guide

Within my typeorm entity, there is a column defined as:

@Column({
        type: 'bigint',
        nullable: true,
    })
    lockedTimestamp?: number;

In my nest.js code, I am trying to handle it like this:

if (...) {entity.lockedTimestamp = null;}

Issue: TypeScript strict mode is flagging that lockedTimestamp cannot be null. It must either be undefined or a number.

What could be the problem here? Have I correctly specified the column as nullable?

Would the database throw an error if I try to update it with undefined?

typescriptnestjstypeorm

Answer №1

If you wish to set a property to null explicitly, make sure to enable null on that specific property in your typing:

@Column({
    type: 'bigint',
    nullable: true,
})
lockedTimestamp?: number | null;

This is important because according to the documentation, properties with undefined values are skipped when using the save function:

save - Saves a given entity or array of entities. If the entity already exists in the database, it will be updated. If not, it will be inserted. All entities are saved in one transaction, and partial updates are supported as undefined properties are ignored. To set a value to null, you have to manually assign null to the property.

Therefore, while using the save function, any undefined values will not cause a database error but will simply be disregarded.

Similar questions

If you have not found the answer to your question or you are interested in this topic, then look at other similar questions below or use the search

Jest: A guide on mocking esModule methods

In my code, I have a function that utilizes the library jszip to zip folders and files: // app.ts const runJszip = async (): Promise<void> => { const zip = new Jszip(); zip.folder('folder')?.file('file.txt', 'just som ...

javascripttypescriptunit-testingjestjsmocking

Deleting a key from a type in TypeScript using subtraction type

I am looking to create a type in TypeScript called ExcludeCart<T>, which essentially removes a specified key (in this case, cart) from the given type T. For example, if we have ExcludeCart<{foo: number, bar: string, cart: number}>, it should re ...

reactjsgenericstypescriptdecoratorhigher-order-components

Typescript - The type is lacking certain properties from another type, despite having all options defined

I have defined the following TypeScript declarations: type TDisplayKey = "a" | "b" | "c"; const DISPLAY_KEYS: Record<string, TDisplayKey> = { A: "a", B: "b", C: "c" }; const DISPLAY_KEY_TITLES: Record<TDisplayKey, string> = { [DISPLA ...

typescript

Discovering the JavaScript source file for a package using WebStorm and TypeScript

In my TypeScript project, there is a usage of Express with the following method: response.send('Hello'); I am interested in exploring the implementation of the send() method. However, when I try to navigate to the source code by ctrl+clicking o ...

typescriptwebstorm

gulp-tsc cannot locate the src directory

I am currently working on developing a .NET Core application using Angular2, but I keep encountering the following error: /wwwroot/NodeLib/gulp-tsc/src/compiler.ts' not found. I'm having trouble pinpointing what I might be missing. tsconfig.js ...

angulartypescriptgulp

Using TypeScript: Implementing array mapping with an ES6 Map

If I have an array of key-value objects like this: const data = [ {key: "object1", value: "data1"}, {key: "object2", value: "data2"}, {key: "object3", value: "data3"}, ] const mappedData = data.map(x => [x.key, x.value]); const ES6Map = n ...

javascripttypescriptdictionaryecmascript-6

Removing fields when extending an interface in TypeScript

Attempting to extend the ISampleB interface and exclude certain values, like in the code snippet below. Not sure if there is an error in this implementation export interface ISampleA extends Omit<ISampleB, 'fieldA' | 'fieldB' | &apos ...

node.jstypescriptswagger

typescript's JSON.stringify function includes internal fields but omits public interface values

I'm currently grappling with some confusion surrounding serialization in TypeScript using JSON.stringify and interfaces. My goal is to create an export format for serializing certain objects back to their server-side representation, focusing solely on ...

jsontypescriptgetter

How to resolve the issue of not being able to access functions from inside the timer target function in TypeScript's

I've been attempting to invoke a function from within a timed function called by setInterval(). Here's the snippet of my code: export class SmileyDirective { FillGraphValues() { console.log("The FillGraphValues function works as expect ...

javascripttypescriptsetinterval

Creating a modal with a checkbox option for "remember my preference" in Angular

Currently, I am working on an Angular project (version 16) and my goal is to create a dialog modal that includes a checkbox for "do not show again". Here is the process I envision: When a user visits the web application for the first time, a dialog moda ...

javascriptangulartypescriptmodal-dialoglocal-storage

Types of navigation items based on conditions

I want to create an interface where a navigationItem can have optional childs for a dropdown menu. If the childs property is provided, I want to require the icon property in the navigationItem object. If no childs are given, the icon property should not be ...

reactjstypescriptnext.js

Utilizing typed arrays within generic functions

Within a library, there exists a helper function designed to work with arrays of any type. The next step is to expand its functionality to also accommodate typed arrays. However, the challenge lies in the absence of a common base class for typed arrays or ...

typescript

Angular Compilation Blocked Due to Circular Dependency Error

Currently, I am utilizing WebStorm as my IDE to work on a personal project that I envision turning into a game in the future. The primary goal of this project is to create an Alpha version that I can showcase to potential employers, as I am actively seekin ...

javascriptangulartypescriptnestjs

Encountering Typescript problem following the upgrade to create-react-app 4.0.0

After updating create-react-app to version 4.0.0, I faced several issues. The first one being: TypeError: Cannot add property noFallthroughCasesInSwitch, object is not extensible To resolve this, I added "noFallthroughCasesInSwitch": true, to m ...

reactjstypescriptcreate-react-app

Please ensure that the property name is a valid type, such as 'string', 'number', 'symbol', or 'any'

Can anyone help me convert this JavaScript file to Typescript? import React, { useState } from 'react'; import { Button } from './Button'; import { Link } from 'react-router-dom'; import './Navbar.css'; import Settin ...

reactjstypescript

How to retrieve an object of type T from a collection of classes that extend a common base type in Typescript

In my current project, I have a class named Foo that is responsible for holding a list of items. These items all inherit from a base type called IBar. The list can potentially have any number of items. One challenge I am facing is creating a get method in ...

javascripttypescript

In order to determine if components linked from anchor elements are visible on the screen in Next.js, a thorough examination of the components

Currently, I am in the process of developing my own single-page website using Next.js and Typescript. The site consists of two sections: one (component 1) displaying my name and three anchor elements with a 'sticky' setting for easy navigation, a ...

javascripttypescriptnext.js

What causes Angular2 to detect both reference changes and primitive changes even when the OnPush flag is enabled?

Take a look at this code snippet import {Component, OnInit, Input, OnChanges, DoCheck, ChangeDetectionStrategy} from 'angular2/core' @Component({ selector: 'child1', template: ` <div>reference change for entire object: { ...

javascripttypescriptangularangular2-changedetection

A versatile method to organize a multi-dimensional array of items

I need help sorting a nested array using a generic function. The sorting should be based on the values of the items within the nested array. Here is an example of my array: type Person = { id: number, name: string, childs: Child[] } type Chil ...

typescript

Upon subscribing to an observable, the initial value is invariably null

Here is an example of the ProfileService I am currently using: export class ProfileService { private user: BehaviorSubject<User> = new BehaviorSubject<User>(null); constructor(private userService: UserService) { this.userService.getUs ...

angulartypescriptrxjsangular10