Also, what database are you using? There are plenty of tools available to do direct data manipulation to get rid of those unwanted records really quickly and easily.
MySQL - I use SQLyog - look for the community version Sqlite - I use the SQLite Manager Firefox addon -Jim On Saturday, January 16, 2016 at 1:10:38 PM UTC-6, 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.
