Is it possible to 'protect' a property and exclude it from select statements

typeorm
Highmastdon picture Highmastdon · May 1, 2017 · Viewed 9.4k times · Source

I'd like to protect certain properties on the data-layer level. For example I'd like to protect the password hash I store in the database for a user, so that it doesn't show up in arbitrary select-statements.

This way only when it's explicitly requested in a select property, property2 statement.

Answer

nomadoda picture nomadoda · Mar 14, 2019

I think a more accurate answer would be to set select: false on column options:

@Column({ select: false })
password: string;

And explicitly select the column like this:

const user = await getRepository(User)
    .createQueryBuilder()
    .addSelect('password')
    .getOne()

Related questions

TypeError: Class extends value undefined is not a function or null

I am getting the following error when trying to create these entities. TypeError: Class extends value undefined is not a function or null I am assuming this has something to do with circular dependencies, but how is that supposed to …

Read More
TypeORM subqueries

Based on typeORM docs on using subqueries, there are explained how to create subqueries. Example: const qb = await getRepository(Post).createQueryBuilder("post"); const posts = qb .where("post.title IN " + qb.subQuery().select("user.name").from(User, "user").where("user.registered = :…

Read More
TypeORM upsert - create if not exist

Does TypeORM include some functionnality to avoid this : let contraption = await thingRepository.findOne({ name : "Contraption" }); if(!contraption) // Create if not exist { let newThing = new Thing(); newThing.name = "Contraption" await thingRepository.save(newThing); contraption = newThing; } Something like : let contraption = await thingRepository.…

Read More