Please check agin. there is no more try-except in there.
On Monday, 27 August 2012 09:01:26 UTC-5, Yarin wrote:
>
> Massimo- Just tried testing with latest trunk DAL- it still fails silently
> and returns None results when trying to execute multiple statements with a
> single call
>
> On Saturday, August 25, 2012 4:39:23 PM UTC-4, Massimo Di Pierro wrote:
>>
>> Exately. On top of this until yesterday executesql had a "try fetchall()
>> except return None." which is now gone. If you get the latest web2py from
>> trunk it should give you an error.
>>
>> On Saturday, 25 August 2012 13:52:42 UTC-5, Niphlod wrote:
>>>
>>> I think the DBAPI doesn't support several results set in a single
>>> statement.
>>>
>>> If you cared to do those one line at a time you'd noticed that:
>>> create temporary table tmp like people does not return results.
>>> insert into tmp select * from people returns the just inserted values
>>> select * from tmp returns your lines.
>>>
>>> I think that as long as you have only one statement (and it's the last )
>>> in your executesql() wrapped string you'll be fine. If some of your lines
>>> returns results, then the driver doesn't know what set to actually return.
>>> Anyway splitting those lines in multiple db.executesql()s is working
>>> great.
>>>
>>> On Saturday, August 25, 2012 5:58:40 PM UTC+2, Yarin wrote:
>>>>
>>>> I'm trying to execute some SQL from the DAL that relies on a temp table:
>>>>
>>>> CREATE TEMPORARY TABLE tmp LIKE people;
>>>>
>>>> INSERT INTO tmp SELECT * FROM people;
>>>> INSERT INTO tmp SELECT * FROM people;
>>>> SELECT * FROM tmp;
>>>>
>>>>
>>>> This code works fine in a SQL panel, but fails when used in the DAL:
>>>>
>>>> def test():
>>>>
>>>>
>>>> db_test = DAL('mysql://root:root@localhost/test')
>>>>
>>>> sql = """CREATE TEMPORARY TABLE tmp LIKE people;
>>>> INSERT INTO tmp SELECT * FROM people;
>>>> INSERT INTO tmp SELECT * FROM people;
>>>> SELECT * FROM tmp;"""
>>>>
>>>> results = db_test.executesql(sql)
>>>>
>>>>
>>>> Results always returns None. No idea why or how to proceed.
>>>>
>>>
--
