Query Building about sugar HOT 9 CLOSED

Right now, it is a wrapper over query method in SQLiteDatabase http://bit.ly/p4uv2V
You could follow the same syntax.

Yes, I'm in the process of writing a Query Builder for Sugar ORM. Should be in fairly soon. Something in the following lines:

Select.fromTable(Note.class).where("title").eq("Satya").list();

Select.fromTable(Note.class)
.where("tag").eq(tag.getId())
.orderBy("title ASC")
.list();

Please suggest if you have any preferences.. thanks.

from sugar.

Hey @homer123 I've included Select in this checkin in a very alpha condition.. Do try it out and let me know what you think.

There is a test file SelectTest.java. Would show you different operations possible with Select query.
Typical usage would be as follows:

Select.from(TestRecord.class)
.where(Condition.prop("test").eq("satya"),
            Condition.prop("prop").eq(2))
.list();

Property names are not converted currently, it'd be the table column names (conversion eg: testUnderscore => test_underscore)

Its still work in progress..

from sugar.

The syntax looks good. It would be good to have AND/OR/NOT operations for the where clause.

Would you have any beta code that I can try out ? I will be happy to provide feedback

Also did you graduate from CEG, Anna Univ ?

from sugar.

Its in progress. Will let you know once its ready to try out.
I'm from St. Joseph's college of Engg, Chennai. How about yourself?

from sugar.

Thank you. I graduated from annamalai univ, chidambaram

from sugar.

To me, that query builder looks much worse than using a raw SQL query - so I don't see the point. Why not use ActiveRecord-style query building for simple queries? For example:

Book.findBy("title or author", title, author);

from sugar.

Hmm.. I guess that can be already done with existing finders. Instead of Array input, we can make it a varargs argument.

Thanks for the input. We'll see if we can make QueryBuilder add more value than what it does currently.

from sugar.

I think all the functionality being requested here has been implemented. QueryBuilder is mostly complete and findWithQuery has a varargs version.

from sugar.

does sugar ORM support query like this

elect PRODUCT from PRODUCT_TAGS where TAGS = 1 intersect Select PRODUCT from PRODUCT_TAGS where TAGS = 5; how do i pass this using sugar orm . @satyan @whoshuu @homer123 @tobykurien @allieus please can some one help me .

from sugar.