Updating data

Please see the reserved keyword save and Interacting with data

Main

Updating data through the use of Mandarine-powered repositories is not hard. All it requires is to know how to save a record in your entity (Please refer to the links above).

Updating Data

In order to update existent data in your tables by using Mandarine-powered repositories, you will be using the same method that is used to save new information. The save method.

save takes one argument which will be your model, but unlike when saving new data, your model's primary key cannot be null/undefined. When your model's primary key has a value, Mandarine automatically detects that the model is not meant for saving information but for updating.

Example

// usersModel.ts

import { Table, Id, GeneratedValue, Column } from "https://deno.land/x/mandarinets/mod.ts";

@Table({ schema: "public" })
class Users {

    @Id()
    @GeneratedValue({strategy: "SEQUENCE"})
    @Column()
    public id: number;

    @Column()
    public firstname: string;

    @Column()
    public lastname: string;

    @Column()
    public country: string;
}

// usersRepository.ts

import { Repository, MandarineRepository } from "https://deno.land/x/mandarinets/mod.ts";
import { Users } from "./usersModel.ts";

@Repository()
abstract class UsersRepository extends MandarineRepository<Users> {

    constructor() {
        super(Users);
    }
    
    public findByFirstname(firstname: string) {}
}

import { Component } from "https://deno.land/x/mandarinets/mod.ts";
import { Users } from "./usersModel.ts";
import { UsersRepository } from "./usersRepository.ts";

@Component()
export class MyComponent() {

    constructor(private readonly usersRepo: UsersRepository) {
    }

    public updateBillsCountry() {
        // [0] to select the first record found
        let billUser: Users = await this.usersRepo.findByFirstname("Bill")[0];
        // { id: 1, firstname: "Bill", lastname: "Clark", country: "Canada" }
        
        billUser.country = "Croatia";
        
        // Updating bill's country.
        await this.usersRepo.save(billUser);
    }
}

PreviousInteracting with data NextMandarine Query Language

Last updated 5 years ago

hashtagMain

hashtagUpdating Data

hashtagExample

Main

Updating Data

Example