in sample_scenarios/sample_data.py [0:0]
def get_document_ids(transaction_executor, table_name, field, value):
"""
Gets the document IDs from the given table.
:type transaction_executor: :py:class:`pyqldb.session.executor.Executor`
:param transaction_executor: An Executor object allowing for execution of statements within a transaction.
:type table_name: str
:param table_name: The table name to query.
:type field: str
:param field: A field to query.
:type value: str
:param value: The key of the given field.
:rtype: list
:return: A list of document IDs.
"""
query = "SELECT id FROM {} AS t BY id WHERE t.{} = '{}'".format(table_name, field, value)
cursor = transaction_executor.execute_statement(query)
list_of_ids = map(lambda table: table.get('id'), cursor)
return list_of_ids