Skip to content

生成插入sql语句的建议 #61

Open
@activepirate

Description

@activepirate

现在生成的sql语句,对于没有赋值的属性,插入null
这样对clickhouse数据库不太友好,clickhouse的字段类型为Nullable(typename)类型,才能插入null,Nullable(typename)
如果生成的sql语句,没有插入null值,对clickhouse友好些
1.4.0版本保存数据:

Member newMember = new Member();
newMember.setNo("100000")
        .setName("Pamela")
        .setGender(1)
        .setRegisteredAtWithJoda(DateTime.now())
        .setUpdatedAt(Timestamp.valueOf("2020-10-05 00:00:00"))
        .setMobile("15011112222");

Member member = Member.create(newMember, true);

1.4.0版本生成sql信息:

信息: [109ms] INSERT INTO `members` (`no`,`name`,`gender`,`mobile`,`extended_attributes`,`registered_at`,`updated_at`) 
VALUES (?,?,?,?,?,?,?), with: [100000,Pamela,1,15011112222,null,2020-12-02 19:54:18.157,2020-10-05 00:00:00.0]

Metadata

Metadata

Assignees

No one assigned

    Labels

    questionFurther information is requested

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions