Method select

piccolo/table.py:1116–1142

Get data in the form of a list of dictionaries, with each dictionary representing a row. These are all equivalent: .. code-block:: python await Band.select().columns(Band.name) await Band.select(Band.name) await Band.select('nam

(
        cls, *columns: Union[Selectable, str], exclude_secrets=False
    )

    @classmethod
    def select(
        cls, *columns: Union[Selectable, str], exclude_secrets=False
    ) -> Select:
        """
        Get data in the form of a list of dictionaries, with each dictionary
        representing a row.

        These are all equivalent:

        .. code-block:: python

            await Band.select().columns(Band.name)
            await Band.select(Band.name)
            await Band.select('name')

        :param exclude_secrets:
            If ``True``, any columns with ``secret=True`` are omitted from the
            response. For example, we use this for the password column of
            :class:`BaseUser <piccolo.apps.user.tables.BaseUser>`. Even though
            the passwords are hashed, you still don&#x27;t want them being passed
            over the network if avoidable.

        """
        _columns = cls._process_column_args(*columns)
        return Select(
            table=cls, columns_list=_columns, exclude_secrets=exclude_secrets
        )

    @classmethod
    def delete(cls, force=False) -> Delete: