sqlobject-discuss

[SQLObject] manually created query

[Petr J. <pet...@tp...>]

Hi, I have feeling it has been discussed already in the past, but I
can not find the answer in the list archive.

I would like to query the database something like this:

select sum(quantity) as qty, product_name, sum(quantity) * price *
(1+tax_rate/100)
        FROM `prestashop`.`ps_view_new_order_detail`
        where id_order = 1
        group by product_name

I think it is not possible to create similar kind of queries through
the SQLObject.
(http://www.sqlobject.org/FAQ.html#what-about-group-by-union-etc)

Is there a way to drop this "handcrafted" query to the SQLObject and
get the result?

Regards

Petr

Re: [SQLObject] manually created query

[Sean D. <hal...@gm...>]

> Is there a way to drop this "handcrafted" query to the SQLObject and
> get the result?
>


I think you can use Prestashop._connection.queryAll("SELECT ...")

~Sean

Re: [SQLObject] manually created query

[Oleg B. <ph...@ph...>]

On Sun, Feb 07, 2010 at 09:06:42PM +0100, Petr Jake?? wrote:
> I would like to query the database something like this:
> 
> select sum(quantity) as qty, product_name, sum(quantity) * price *
> (1+tax_rate/100)
>         FROM `prestashop`.`ps_view_new_order_detail`
>         where id_order = 1
>         group by product_name
> 
> Is there a way to drop this "handcrafted" query to the SQLObject and
> get the result?

   You can execute the query but you cannot get the results as a list of
SQLObject instances because there are no declarations of columns with sum()
and other expressions. The result will be a list of tuples.

Oleg.
-- 
     Oleg Broytman            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.

Re: [SQLObject] manually created query

[Petr J. <pet...@tp...>]

>   You can execute the query but you cannot get the results as a list of
> SQLObject instances because there are no declarations of columns with sum()
> and other expressions. The result will be a list of tuples.
>

Yes, I know, but sometimes it is OK to get not-object  data (some
nasty complicated SQL queries for example)

Thanks Oleg, thanks Sean