ActiveAndroid Update() query

Question

I'm trying to make a bulk update to a column using ActiveAndroid. Here's my code:

new Update(SomeModel.class).set("Enabled = 0").execute();

~~But I'm getting a StackOverflowError.~~ (Edit: My bad, the error was somewhere else). Does anyone know how to execute an Update() query? It doesn't say anything in ActiveAndroid's wiki.

Edit:

This syntax is correct:

new Update(SomeModel.class)
  .set("Enabled = 0")
  .where("Account = ?", account.getId())
  .execute();

You can skip the where if not needed.

@jlhonora why should you use .set("Enable = 0") .. P.S: I am new to Active Android .. — Ajay Jayendran, Jul 29 '17 at 17:20
@Ajay because it's more performant than loading + saving. Specially if you have many items to update. — jlhonora, Jul 29 '17 at 17:32

score 20 · Accepted Answer · answered Oct 23 '15 at 18:18

20

This syntax is correct:

new Update(SomeModel.class)
  .set("Enabled = 0")
  .where("Account = ?", account.getId())
  .execute();

You can skip the where if not needed.

answered Oct 23 '15 at 18:18

jlhonora

10,179
10
46
70

1

is it valid to be `.set("Enabled = ?", 0)` ? – Hamzeh Soboh Jul 10 '17 at 09:39
2

@Hamzeh yes, that's valid too – jlhonora Jul 10 '17 at 15:44

score 12 · Answer 2 · answered Jul 03 '14 at 17:16

12

Base on AndroidActive's github: "The save method works for both inserting and updating records."
So, if you want to update an item, first, you must read it from database, then modify it, and finally save it again.
For ex:

Foo for = Foo.load(Foo.class, 1);//1 is the id
foo.bar = "new value";
foo.save();

answered Jul 03 '14 at 17:16

Justin

4,400
2
32
36

1

That is highly inefficient, specially if you need to update lots of items. – jlhonora Jul 29 '15 at 11:56
@jlhonora: if you wana save lots of items, let use `ActiveAndroid transaction` [from here](https://github.com/pardom/ActiveAndroid/wiki/Saving-to-the-database#bulk-insert). By the way, could you give a better solution? – Justin Jul 30 '15 at 01:21

score 1 · Answer 3 · answered Jul 29 '15 at 12:36

You can also use something like this:

SomeModel model = selectField("fieldName", "fieldValue");
model.field = newValue;
model.save();

where selectField()method is:

public static SomeModel selectField(String fieldName, String fieldValue) {
    return new Select().from(SomeModel.class)
            .where(fieldName + " = ?", fieldValue).executeSingle();
}

ActiveAndroid Update() query

3 Answers3