I want to set primary key auto increment for my table.
Here is my Class. I have set primary key but I want it to be auto increment primary key.
public class users extends RealmObject {
@PrimaryKey
private int id;
private long icn;
private String name;
private String email;
private String password;
private int phone;
public String getName() {
return name;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public long getIcn() {
return icn;
}
public void setIcn(long icn) {
this.icn = icn;
}
public void setName(String name) {
this.name = name;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public int getPhone() {
return phone;
}
public void setPhone(int phone) {
this.phone = phone;
}
}
Thanks in Advance.
In a transaction, you can always reliably access the current maximum ID, based on which you can increment that and use it as the basis for the next ID.
realm.executeTransaction(new Realm.Transaction() { // must be in transaction for this to work
@Override
public void execute(Realm realm) {
// increment index
Number currentIdNum = realm.where(users.class).max(usersFields.ID);
int nextId;
if(currentIdNum == null) {
nextId = 1;
} else {
nextId = currentIdNum.intValue() + 1;
}
users user = new users(); // unmanaged
user.setId(nextId);
//...
realm.insertOrUpdate(user); // using insert API
}
}
This is an old and already answered question, but I want to post another solution that I used. You can do like this:
Realm realm = Realm.getDefaultInstance();
// Realm transaction
realm.executeTransactionAsync(new Realm.Transaction() {
@Override
public void execute(Realm bgRealm) {
// Get the current max id in the users table
Number maxId = bgRealm.where(users.class).max("id");
// If there are no rows, currentId is null, so the next id must be 1
// If currentId is not null, increment it by 1
int nextId = (maxId == null) ? 1 : maxId.intValue() + 1;
// User object created with the new Primary key
users user = bgRealm.createObject(users.class, nextId);
// Now you can update your object with your data. The object will be
// automatically saved in the database when the execute method ends
// ...
// ...
}
}
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With