[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.
from yams.constraints import UniqueConstraint
from cubicweb.schema import PURE_VIRTUAL_RTYPES
from cubicweb.server.checkintegrity import expected_indexes, database_indexes
source = repo.system_source
for rschema in schema.relations():
if rschema.rule or rschema in PURE_VIRTUAL_RTYPES:
continue
if rschema.final or rschema.inlined:
for rdef in rschema.rdefs.values():
table = 'cw_{0}'.format(rdef.subject)
column = 'cw_{0}'.format(rdef.rtype)
if any(isinstance(cstr, UniqueConstraint) for cstr in rdef.constraints):
source.create_index(cnx, table, column, unique=True)
commit(ask_confirm=False)
if rschema.inlined or rdef.indexed:
source.create_index(cnx, table, column)
commit(ask_confirm=False)
schema_indices = expected_indexes(cnx)
db_indices = database_indexes(cnx)
for additional_index in (db_indices - set(schema_indices)):
try:
sql('DROP INDEX %s' % additional_index)
commit()
except:
# ignore if this is not an index but a constraint
pass
if source.dbhelper == 'postgres' and 'appears_words_idx' not in db_indices:
sql('CREATE INDEX appears_words_idx ON appears USING gin(words)')
db_indices.add('appears_words_idx')
for missing_index in (set(schema_indices) - db_indices):
print('WARNING: missing index', missing_index)