records-delete/truncate postgres table in appadmin

[Mirek Zvolský]

I am trying delete all records with appadmin.

Error message is not very descriptive.

Any idea?

Traceback (most recent call last):

  File "/home/www-data/web2py/gluon/main.py", line 464, in wsgibase

    session._try_store_in_db(request, response)

  File "/home/www-data/web2py/gluon/globals.py", line 1180, in _try_store_in_db

    if not table._db(table.id == record_id).update(**dd):

  File "/home/www-data/web2py/gluon/packages/dal/pydal/objects.py", line 2054, in update

    ret = db._adapter.update("%s" % table._tablename, self.query, fields)

  File "/home/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", line 1031, in update

    raise e

ProgrammingError: ('ERROR', '25P02', 'current transaction is aborted, commands ignored until end of transaction block')

ln 1026 - 1035:

        except Exception:

            e = sys.exc_info()[1]

            table = self.db[tablename]

            if hasattr(table,'_on_update_error'):

                return table._on_update_error(table,query,fields,e)

            raise e

        try:

            return self.cursor.rowcount

        except:

            return None

[Mirek Zvolský]

Probably something with foreign key integrity (cascade, restrict, ...) because after deleting of records in other tables it works.

However, how to understand such error tickets?

Dne pondělí 22. srpna 2016 13:31:50 UTC+2 Mirek Zvolský napsal(a):

[黄祥]

this is what i do in dev environment :

controllers/truncate.py

from gluon.admin import *

auth.requires(has_membership_admin)(lambda: None)()

def index():

for table in db.tables:

db[table].truncate()

app = request.application

clean = app_cleanup(app, request)

redirect(URL('default', 'index') )

best regards,

stifan

[Alex Glaros]

what does app_cleanup do?

can I truncate only one table and then run this one line clean = app_cleanup(app, request)?

thanks

Alex Glaros

[黄祥]

app_cleanup is the admin function cleanup to clean session, cache, dll (same like on admin page).
yes, you can, app_cleanup is a prevention, because i created the function that truncate all tables including auth_user, so while u are logged in and run truncate for all table it will raises an error after it done, said about privilege because the auth user is empty now.

best regards,

stifan