No wonder this kept happening as I had this code in db_wizard_populate.py:
from gluon.contrib.populate import populate
if db(db.auth_user).isempty():
populate(db.auth_user,10)
populate(db.t_kiinnostuneet,10)
Can I just delete the entire file? I wrote this particular app a few years
ago and just needed to deploy it so my memory on specifics is a bit hazy...
On Saturday, January 16, 2016 at 9:49:23 PM UTC+2, Marko Poutiainen wrote:
>
> Ah, yes, I have that when I grepped the code. I must have copied it from
> somewhere when I wrote the code (probably some example that I used).
>
> The strange thing was that when I cleared auth_user this was run again,
> but not when I did it to another table.
>
> I did manage to clean the database by first adding a new user to
> auth_user, then using sqlite3 to delete everything else from that and clean
> the other affected table. If I didn't add it, for some reason the tables
> were populated again.
>
> On Saturday, January 16, 2016 at 9:10:38 PM UTC+2, Jim S wrote:
>>
>> What does your code look like?
>>
>> Web2py isn't going to do this on its own. Do you have have code similar
>> to this someone in your db.py or controller?
>>
>> from gluon.contrib.populate import populatepopulate(db.mytable_name_here,100)
>>
>> -Jim
>>
>>
>>
>> On Saturday, January 16, 2016 at 12:49:37 PM UTC-6, Marko Poutiainen
>> wrote:
>>>
>>> What the bleeping bleep bleep? Even with sqlite3 web2py keeps creating
>>> this crap again and again. I delete and open the admin page again and the
>>> table again has this crap?
>>>
>>> On Saturday, January 16, 2016 at 8:41:36 PM UTC+2, Marko Poutiainen
>>> wrote:
>>>>
>>>> Sorry for the rude topic but I have just spent an hour on something so
>>>> mindbogglingly stupid it makes my blood boil.
>>>>
>>>> Why does web2py create those stupid useless rows in my database that I
>>>> have to clean by hand?
>>>>
>>>> Why does telling the delete confirmation not to bother me make the
>>>> whole delete checkbox to stop working? (Yes, I clicked it and now if I try
>>>> to select it it unsets automatically.) So I can't remove them by hand.
>>>>
>>>> How am I supposed to clean the database (and why the heck do I need to
>>>> do it in the first place??)? I have tried db.table.truncate() in table's
>>>> administration panel -> nothing happens. Where am I supposed to do that?
>>>>
>>>> Yes, this is definitely something I want to do on a Saturday evening...
>>>>
>>>> This is the stuff I see in my db and I'm pretty sure I didn't add this:
>>>>
>>>>
>>>> Semnopithecus...Daughter-cell...Violet will b...Nerve-fibres ...Respective
>>>> bo...Family spawn ...Nowhere do so...Tartan; but
>>>> t...Reconstructio...Timber
>>>> for it...263 professor...True2016-01-16 19:37:08None
>>>> <https://37.16.104.194/kiinnostuneet/appadmin/update/db/auth_user/None>2016-01-16
>>>>
>>>> 19:37:08None
>>>> <https://37.16.104.194/kiinnostuneet/appadmin/update/db/auth_user/None>
>>>> 4
>>>> <https://37.16.104.194/kiinnostuneet/appadmin/update/db/t_kiinnostuneet/4>Standing
>>>>
>>>> out ...Healthfulness...Rigel 466 sir...Outdated equi...Cambrian
>>>> peri...Heavy
>>>> as if e...Vedda of monk...O as the broa...Regulated the...Trillion
>>>> mile...Oval. Evoluti...True2016-01-16 19:37:08None
>>>> <https://37.16.104.194/kiinnostuneet/appadmin/update/db/auth_user/None>2016-01-16
>>>>
>>>> 19:37:08None
>>>> <https://37.16.104.194/kiinnostuneet/appadmin/update/db/auth_user/None>
>>>> 5
>>>> <https://37.16.104.194/kiinnostuneet/appadmin/update/db/t_kiinnostuneet/5>Graphite
>>>>
>>>> simi...Next great sc...Uganda bug ac...Fountain of
>>>> m...Seven-weeks-o...Wood-cock
>>>> whi...Emotions. The...I the primate...Sand-grouse i...Emotions
>>>> such...Legacy
>>>> of a f...True2016-01-16 19:37:08None
>>>> <https://37.16.104.194/kiinnostuneet/appadmin/update/db/auth_user/None>2016-01-16
>>>>
>>>> 19:37:08None
>>>> <https://37.16.104.194/kiinnostuneet/appadmin/update/db/auth_user/None>
>>>> 6
>>>> <https://37.16.104.194/kiinnostuneet/appadmin/update/db/t_kiinnostuneet/6>Ages--for
>>>>
>>>> bri...Silly ants ar...Reward of hea...Found in orde...Negroes and
>>>> t...Disguise
>>>> diff...Diaphragm cam...Contracting m...Terms of
>>>> life...Discontinuous...1.d.
>>>> Russell ...True2016-01-16 19:37:08None
>>>> <https://37.16.104.194/kiinnostuneet/appadmin/update/db/auth_user/None>2016-01-16
>>>>
>>>> 19:37:08None
>>>> <https://37.16.104.194/kiinnostuneet/appadmin/update/db/auth_user/None>
>>>> 7
>>>> <https://37.16.104.194/kiinnostuneet/appadmin/update/db/t_kiinnostuneet/7>Variable
>>>>
>>>> befo...Serves as wel...Beautiful exp...Depends. sepa...Stuck
>>>> togethe...Afford
>>>> a new ...Supplemented ...Incident is a...Deny a good i...
>>>> Unenforceabil...Exaggerate th...True2016-01-16 19:37:08None
>>>> <https://37.16.104.194/kiinnostuneet/appadmin/update/db/auth_user/None>2016-01-16
>>>>
>>>> 19:37:08None
>>>> <https://37.16.104.194/kiinnostuneet/appadmin/update/db/auth_user/None>
>>>> 8
>>>> <https://37.16.104.194/kiinnostuneet/appadmin/update/db/t_kiinnostuneet/8>Orionis
>>>>
>>>> showi...Hoofed mammal...Fishermen who...Cohesion of s...Pays an
>>>> illus...Peopled than ...Universe. our...Inconceivably...Environment.
>>>> ...Nest in their...501 c. Above ...True2016-01-16 19:37:08None
>>>> <https://37.16.104.194/kiinnostuneet/appadmin/update/db/auth_user/None>2016-01-16
>>>>
>>>> 19:37:08None
>>>> <https://37.16.104.194/kiinnostuneet/appadmin/update/db/auth_user/None>
>>>> 9
>>>> <https://37.16.104.194/kiinnostuneet/appadmin/update/db/t_kiinnostuneet/9>Lancelets
>>>>
>>>> and...Infects him h...Distinctive s...Slippery brid...Facilitates
>>>> t...Canal
>>>> round i...Travel rapidl...Scharff r. It...Elder brother...Do not in
>>>> ken...Cools to lang...True2016-01-16 19:37:08None
>>>> <https://37.16.104.194/kiinnostuneet/appadmin/update/db/auth_user/None>2016-01-16
>>>>
>>>> 19:37:08None
>>>> <https://37.16.104.194/kiinnostuneet/appadmin/update/db/auth_user/None>
>>>> 10
>>>> <https://37.16.104.194/kiinnostuneet/appadmin/update/db/t_kiinnostuneet/10>Sloth
>>>>
>>>> s eyes....
>>>> Efforts and t...Unpromising h...I.e. We have ...Field-voles p...Average
>>>> of sm...Jewels. there...Refused to 26...Practical int...Abdomen--for
>>>> ...Branch to par...True2016-01-16 19:37:08None
>>>> <https://37.16.104.194/kiinnostuneet/appadmin/update/db/auth_user/None>2016-01-16
>>>>
>>>> 19:37:08None
>>>> <https://37.16.104.194/kiinnostuneet/appadmin/update/db/auth_user/None>
>>>>
>>>
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
