background_ORM

참고사이트

• https://www.youtube.com/watch?v=CdvCfOBzewM

ORM

Object Relational Mapping ( SQL / RDBMS )

3 요소

1. Schema Object

# sql
create table User(
	id integer not null
    name varchar(100)
    );

// js > json type
models.User ={
	id : DATATYPES.INTEGER.NOT_NULL,
  	name : DataTypes.VARCHAR(100)
};

2. Query Builder

# sql
SELECT id,name FROM User WHERE id = 123;

//js
User.findAll({
  attributes:["id","name"],
  where:{id:123}
});

3. Migration
   • version control
     • git
     • Jenkins (ci/cd)