After truncate the table did you db.commit()?

On Sunday, 17 August 2014 23:17:29 UTC-5, Giacomo Dorigo wrote:
>
> I don't know,
> for some reason it does not leave me submit the ticket:
>
> Windows 8
> web2py :
> 2.9.5-stable+timestamp.2014.03.16.02.35.39
> (Running on Rocket 1.2.6, Python 2.7.7)
>
>  What steps will reproduce the problem?
> 1. run web2py from source code from a .bat file python 
> path_to_web2py/web2py.py
> 2. at same time run an other instance of web2py from terminal so: 
> path_to_web2py/web2py.py -S myapp -M
> 3. start to interact with the db api from the online shell (not from the 
> command line)
> 4. insert some records
> 5. truncate the table
> 6. insert new records
>
> =>> check the table, the old inserts had been repeated again
>
> What is the expected output?
> only the new inserts should have been inserted
>
>
> On Sun, Aug 17, 2014 at 6:18 AM, Massimo Di Pierro <
> massimo.dipie...@gmail.com> wrote:
>
>> https://code.google.com/p/web2py/issues/entry
>>
>>
>> On Saturday, 16 August 2014 23:08:36 UTC-5, Giacomo Dorigo wrote:
>>>
>>> OK, how do I open a ticket?
>>>
>>>
>>> On Wed, Aug 13, 2014 at 8:04 PM, Massimo Di Pierro <
>>> massimo.dipie...@gmail.com> wrote:
>>>
>>>> Please open a ticket about this. This is a major issue. Perhaps we 
>>>> should remove the web based shell.
>>>>
>>>>
>>>> On Wednesday, 13 August 2014 02:41:17 UTC-5, Giacomo Dorigo wrote:
>>>>>
>>>>> Today I discovered an other problem with the admin shell.
>>>>> If I execute command 1
>>>>> and then command 2, at this point it will re-execute command 1 too.
>>>>> If then I execute command 3, it will execute again also 1 and 2.
>>>>>
>>>>> This is while running web2py from source code on Windows with simple 
>>>>> python web2py.py 
>>>>>
>>>>>
>>>>>
>>>>> On Saturday, April 6, 2013 6:09:40 AM UTC+2, Massimo Di Pierro wrote:
>>>>>>
>>>>>> The admin shell has problems maintaining state. I do not consider it 
>>>>>> reliable. The terminal shell is rock solid. It is a normal pyhton shell.
>>>>>>
>>>>>> On Friday, 5 April 2013 16:48:50 UTC-5, Michael Herman wrote:
>>>>>>>
>>>>>>> yes. so when working with DAL directly from the shell it's better to 
>>>>>>> work from the web2py shell in the terminal rather than the admin app 
>>>>>>> shell? any idea why? 
>>>>>>>
>>>>>>> On Fri, Apr 5, 2013 at 2:43 PM, Anthony <abas...@gmail.com> wrote: 
>>>>>>> > 
>>>>>>> > By "built-in" shell, do you mean the one in the admin app? I think 
>>>>>>> there are sometimes problems with that (particularly with database 
>>>>>>> operations), so I tend to use the web2py shell in the terminal, which 
>>>>>>> you 
>>>>>>> can start as follows from the web2py directory: 
>>>>>>> > 
>>>>>>> > python web2py.py -S yourapp/[optional controller] -M 
>>>>>>> > 
>>>>>>> > But you may fine the admin shell works just fine for you, in which 
>>>>>>> case, use it. 
>>>>>>> > 
>>>>>>> > Anthony 
>>>>>>> > 
>>>>>>> > 
>>>>>>> > On Friday, April 5, 2013 4:57:49 PM UTC-4, Michael Herman wrote: 
>>>>>>> >> 
>>>>>>> >> i remember reading somewhere that it's better to use the built-in 
>>>>>>> shell in web2py, but i can't find the article/post. anyone know (1) if 
>>>>>>> it 
>>>>>>> is "better", and, (2)  if so, why? 
>>>>>>> > 
>>>>>>> > -- 
>>>>>>> > 
>>>>>>> > --- 
>>>>>>> > You received this message because you are subscribed to a topic in 
>>>>>>> the Google Groups "web2py-users" group. 
>>>>>>> > To unsubscribe from this topic, visit https://groups.google.com/d/
>>>>>>> topic/web2py/XWMt1Pb_2wk/unsubscribe?hl=en. 
>>>>>>> > To unsubscribe from this group and all its topics, send an email 
>>>>>>> to web2py+un...@googlegroups.com. 
>>>>>>> > For more options, visit https://groups.google.com/groups/opt_out. 
>>>>>>> > 
>>>>>>> > 
>>>>>>>
>>>>>>>  -- 
>>>> Resources:
>>>> - http://web2py.com
>>>> - http://web2py.com/book (Documentation)
>>>> - http://github.com/web2py/web2py (Source code)
>>>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>>>> --- 
>>>> You received this message because you are subscribed to a topic in the 
>>>> Google Groups "web2py-users" group.
>>>> To unsubscribe from this topic, visit https://groups.google.com/d/
>>>> topic/web2py/XWMt1Pb_2wk/unsubscribe.
>>>> To unsubscribe from this group and all its topics, send an email to 
>>>> web2py+unsubscr...@googlegroups.com.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>
>>>  -- 
>> Resources:
>> - http://web2py.com
>> - http://web2py.com/book (Documentation)
>> - http://github.com/web2py/web2py (Source code)
>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>> --- 
>> You received this message because you are subscribed to a topic in the 
>> Google Groups "web2py-users" group.
>> To unsubscribe from this topic, visit 
>> https://groups.google.com/d/topic/web2py/XWMt1Pb_2wk/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to 
>> web2py+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to