bufferings/doma3-raw-string-literals.md

## doma3-raw-string-literals.md

      
    Raw
  

              doma3-raw-string-literals.md
            
          
      項目
      現状
      案1
      案2
      案3
    
  
Select: ファイルから
@Select
Employee selectByNameAndSalary(String name, Salary salary);

デフォルトの動作は変更なし（ファイルから）:
@Select
Employee selectByNameAndSalary(String name, Salary salary);
明示的にこういう書き方もできるようになる:
@Sql(useFile = true)
@Select
Employee selectByNameAndSalary(String name, Salary salary);

デフォルトの動作は変更なし（ファイルから）:
@Select
Employee selectByNameAndSalary(String name, Salary salary);  
明示的にこういう書き方もできるようになる:
@SqlFile
@Select
Employee selectByNameAndSalary(String name, Salary salary);

変更なし:
@Select
Employee selectByNameAndSalary(String name, Salary salary);
Select: SQL直接指定

@Sql(`
    select
      *
    from
      employee
    where
      employee_name = /* name */'hoge'
      and salary > /* salary */100
`)
@Select
Employee selectByNameAndSalary(String name, Salary salary);
@Sql(`
    select
      *
    from
      employee
    where
      employee_name = /* name */'hoge'
      and salary > /* salary */100
`)
@Select
Employee selectByNameAndSalary(String name, Salary salary);
@Select(sql = `
    select
      *
    from
      employee
    where
      employee_name = /* name */'hoge'
      and salary > /* salary */100
`)
Employee selectByNameAndSalary(String name, Salary salary);
Insert: 自動生成
@Insert
int insert(Employee employee);
変更なし：@Insert
int insert(Employee employee);
変更なし：@Insert
int insert(Employee employee);
変更なし：@Insert
int insert(Employee employee);
Insert: ファイルから
@Insert(sqlFile = true)
int insert(Employee employee);
要変更：@Sql(useFile = true)
@Insert
int insert(Employee employee);
要変更：@SqlFile
@Insert
int insert(Employee employee);
変更なし：@Insert(sqlFile = true)
int insert(Employee employee);
Insert: SQL直接指定

@Sql(`
  insert into employee (
    id, name, salary, version
  ) values (
    /* employee.id */0,
    /* employee.name */'hoge',
    /* employee.salary */100,
    /* employee.version */0
  )
`)
@Insert
int insert(Employee employee);
@Sql(`
  insert into employee (
    id, name, salary, version
  ) values (
    /* employee.id */0,
    /* employee.name */'hoge',
    /* employee.salary */100,
    /* employee.version */0
  )
`)
@Insert
int insert(Employee employee);
@Insert(sql = `
  insert into employee (
    id, name, salary, version
  ) values (
    /* employee.id */0,
    /* employee.name */'hoge',
    /* employee.salary */100,
    /* employee.version */0
  )
`)
int insert(Employee employee);
項目	現状	案1	案2	案3
Select: ファイルから	@Select Employee selectByNameAndSalary(String name, Salary salary);	デフォルトの動作は変更なし（ファイルから）: @Select Employee selectByNameAndSalary(String name, Salary salary); 明示的にこういう書き方もできるようになる: @Sql(useFile = true) @Select Employee selectByNameAndSalary(String name, Salary salary);	デフォルトの動作は変更なし（ファイルから）: @Select Employee selectByNameAndSalary(String name, Salary salary); 明示的にこういう書き方もできるようになる: @SqlFile @Select Employee selectByNameAndSalary(String name, Salary salary);	変更なし: @Select Employee selectByNameAndSalary(String name, Salary salary);
Select: SQL直接指定		@Sql(` select * from employee where employee_name = /* name /'hoge' and salary > / salary */100 `) @Select Employee selectByNameAndSalary(String name, Salary salary);	@Sql(` select * from employee where employee_name = /* name /'hoge' and salary > / salary */100 `) @Select Employee selectByNameAndSalary(String name, Salary salary);	@Select(sql = ` select * from employee where employee_name = /* name /'hoge' and salary > / salary */100 `) Employee selectByNameAndSalary(String name, Salary salary);
Insert: 自動生成	@Insert int insert(Employee employee);	変更なし： @Insert int insert(Employee employee);	変更なし： @Insert int insert(Employee employee);	変更なし： @Insert int insert(Employee employee);
Insert: ファイルから	@Insert(sqlFile = true) int insert(Employee employee);	要変更： @Sql(useFile = true) @Insert int insert(Employee employee);	要変更： @SqlFile @Insert int insert(Employee employee);	変更なし： @Insert(sqlFile = true) int insert(Employee employee);
Insert: SQL直接指定		@Sql(` insert into employee ( id, name, salary, version ) values ( /* employee.id /0, / employee.name /'hoge', / employee.salary /100, / employee.version */0 ) `) @Insert int insert(Employee employee);	@Sql(` insert into employee ( id, name, salary, version ) values ( /* employee.id /0, / employee.name /'hoge', / employee.salary /100, / employee.version */0 ) `) @Insert int insert(Employee employee);	@Insert(sql = ` insert into employee ( id, name, salary, version ) values ( /* employee.id /0, / employee.name /'hoge', / employee.salary /100, / employee.version */0 ) `) int insert(Employee employee);