Update not null columns about ormlite-jdbc HOT 4 CLOSED

Ahh, got it.

Unfortunately, the update() method is an all-in method so it will consider all columns. The only other solution is an updateBuilder(), something like this:

final UpdateBuilderUser, Long> builder = userDao.updateBuilder();
builder
  .updateColumnValue("address", "new address")
  .where().idEq(1);
builder.update();

Regarding the column names: yes, you should probably define constants for them, either alongside the main User.java class or inside it as an inner class.

Finally, you surely can consider an OAS3 specification which you can use just for the models.

from ormlite-jdbc.

Unsure what you really mean... Can you provide an example to showcase what you want?

from ormlite-jdbc.

I have code like this:

class User{
    Long id;
    String name;
    String password;
    String address;
}
....
Dao<User,Long> userDao = ....
....
User user = new User();
user.id=1;
user.name="test";
user.password="test";
user.address="test";
userDao.create(user);

and I want to update user's address where id=1, I want do this:

User user = new User();
user.id=1;
user.address="new address";
userDao.update(user);

and then, it throw exception that some column can not be null.
I know it hava UpdateBuilder, but UpdateBuilder need column name, and I don't think update method should care column name when I already have a POJO.

from ormlite-jdbc.

Another way to do this is to get the user from the database and then update it.

User user = userDao.queryForId(1);
user.address = "new address";
userDao.update(user);

That's how it is supposed to work. Or, as @noordawod said, you should use the UpdateBuilder.

from ormlite-jdbc.