[rql] Store selected variables for RQL select queries in ResultSet (#17218476) By storing the name of the selected variables for RQL select queries in the ResultSet (within the "variables" attribute), the information can be passed down to specific protocols, e.g. rqlio that may wish to pass is down further to clients. In turn, clients can then choose to present the results of RQL select queries as symbolic bindings using the names used in the query's projection, instead of ordinal arrays.

     1

from __future__ import print_function

     2

     3

from logilab.common.shellutils import generate_password

     4

from cubicweb.server.utils import crypt_password

     5

     6

for user in rql('CWUser U WHERE U cw_source S, S name "system", U upassword P, U login L').entities():

     7

    salt = user.upassword.getvalue()

     8

    if crypt_password('', salt) == salt:

     9

        passwd = generate_password()

    10

        print('setting random password for user %s' % user.login)

    11

        user.set_attributes(upassword=passwd)

    12

    13

commit()