Query builder

umutau · December 13, 2010, 5:06am

for debugging, I had to go CDbCommand and echo _text to find what sql i am calling. I think great idea

felyx · December 13, 2010, 4:17pm

When can we expect it to be released? It looks very very good.

jacmoe · December 13, 2010, 4:21pm

You can take it for a spin already if you grab the nightly build, or pull from the SVN repository.

As Qiang said: the more people test this and the more feedback you give, the better it’s going to get.

dheeraj_kumar · December 14, 2010, 12:37pm

I love the idea! I come from a .NET background, and this reminds me of LINQ, which I loved

syy870714 · December 14, 2010, 1:45pm

it is not necessary! To write SQL as ‘SELECT NAME,PASSWOR FROM TBL_USER FROM ID = ??’ is more clear than what you written.

why not refer to IBATIS ?

syy870714 · December 14, 2010, 1:50pm

many frameworks do like you do, for example,CI

jacmoe · December 15, 2010, 5:35pm

If you don’t like it, don’t use it.

It’s really that simple.

If writing raw SQL is your thing, then by all means…

To me, the new Query Builder is going to be a much appreciated tool.

Who doesn’t want to be able to do more with less work?

On the other side of that fence: if you like Doctrine and RoR inspired stuff, then why not use a heavier framework which makes use of it?

There’s always a trade-off between features and performance, and I find that Yii has stricken the perfect balance.

jacmoe · December 15, 2010, 5:37pm

You are looking at that tool, actually.

Migration functionality is going to be part of query builder.

tonydspaniard · December 16, 2010, 7:47am

Having said what I said at the beginning of this thread, I would like to apologize for those who pointing me how good this new feature could be.

You were all right, I just had a look into the code and I am truly impress with it. This will easy the tasks for those who are planning to create installation features into their web software, creating tables ‘on-the-fly’ as required ( no more create this tables or that tables for my extension -yes, we could do it before but no one did it because it was easier to say it that create it on the fly ), jquery-like CDbCommand mechanism… woah

I know is not stable but I think I wont be able to wait

dreamynsx · December 17, 2010, 7:22am

Its okay idea, personally I use CActiveRecord since you get all the nice features of model, validation, callbacks etc. I disagree with the person saying that using activerecord is for noobs…its should be the opposite. I can sql very well, but I also like OOP and code reuse and code enscapulation.

I also like CDbCriteria used in activerecord, and its basically a query builder.

So…i guess for the people who doesn’t use activerecord, this would make sense then.

Diff topic but, anyone benchmark how much faster it is by not using CActiveRecord? Wouldn’t using some opcode cache make cactiverecord just as fast as using the CommandBuilder or PDO?

StErMi · December 17, 2010, 9:02am

I like it very much

It will be perfect to match my case

waylex · December 28, 2010, 4:21pm

What about implementing a simple Active Record pattern on top of Query Builder? Any plans? Thoughts?

junxiong · December 30, 2010, 3:14am

There is some question regarding like() method. From the guide I see that like() automatically append % in the beginning and the ending of the word


// WHERE `name` LIKE '%Qiang%'

where(array('like', 'name', 'Qiang'))

What must I do if for example I just want to query like this

WHERE name LIKE ‘Qiang%’

or

WHERE name LIKE %Qiang

tronga · December 30, 2010, 11:45am

Hmm … I think that automatic appending should be turned off.

This should be the choise of the User/Developer.

Even in Doctrine you have to do this manually.

1114 · January 1, 2011, 6:50am

It’s cool, I like it very much.

But,how can I use "REPLACE INTO…"?

qiang · January 2, 2011, 1:12am

Thank you for your suggestion. I have made the change.

perochak · January 4, 2011, 6:03am

Waiting for release …

tronga · January 4, 2011, 10:37pm

imho the orm is quite stable, but I don´t think that an release should be

too fast. If you look at the tickts with the milestone 1.1.6, there are a lot of tickets

to make, before a release could get out.

More important may be the question, if the code generator (crud) can be made with the

orm, too? Are there any plans?

Chris83 · January 7, 2011, 11:43pm

ricardograna:

Particullary, I would want to see something more like CDbCriteria (maybe a "CDbQuery")
$query = new CDbQuery("tbl_user");

$query->alias = 'user';

$query->with('tbl_profile', 'tbl_profile.user_id=tbl_user.id');

$query->select = 'user.name, user.password, tbl_profile.content';

$query->order = 'name';


$result = $query->queryRow(); 
I think that using an object (just like CDbCriteria) is easier to customizate.

I would also have preferred the CDbCriteria syntax for creating queries. I’m not a fan of chaning.

mikl · January 8, 2011, 10:20am

Even though i don’t understand why (i’m a fan of jQuery’s “write less, do more” slogan), i think the current implementation does also allow you to write:




$cmd=$db->createCommand();

$cmd->select('name, password');

$cmd->from('tbl_user');

$cmd->where('id=:id', array(':id'=>$id));

$result=$cmd->queryRow();