Vacuum about sugar HOT 8 CLOSED

Yes. What we could do is open a method to execute raw queries. This would enable us to execute 'vacuum' query. We could also wrap this with a method vacuum on an Entity.

Thanks for the suggestion. We'll add that quickly.

from sugar.

Sounds good =)
Thanks!

from sugar.

There are two new static methods to execute raw queries on SugarRecord classes.

// for specific vacuum call. Could execute other raw queries too here with arguments.
Note.executeQuery("VACUUM");

// for finders using raw query. Initial stages now, need to do more testing here.
List<Note> notes = Note.findWithQuery(Note.class, "Select * from Note where name = ?", "satya");

Please try these and let me know if it works for you.

Thanks.

from sugar.

The raw query using findWithQuery works well for my application where I can build a query string from spinner data and then call this method. Would you know why

DataRecord.findWithQuery(DataRecord.class, "SELECT * FROM DATA_RECORD WHERE NAME = ?", "NOT NULL");

provides no results but

DataRecord.findWithQuery(DataRecord.class, "SELECT * FROM DATA_RECORD WHERE NAME <> ?", "NULL");

listed the completed database. I expected both cases to provide the same result

from sugar.

@Tyris Did it resolve your issue?

from sugar.

Hi @satyan - sorry I've taken so long to reply... had compiled in the change but hadn't had a chance to get around to testing it. It seems to execute fine; though my database is too small I think to currently actually benefit from a VACUUM (well, Android reports my used data is 48kb). Since the all doesn't throw any errors though I guess thats all good =)
Thx.

from sugar.

cool.. Thanks.

from sugar.

Addressed in 81b1984.

from sugar.