Method objects

piccolo/table.py:1195–1233

Returns a list of table instances (each representing a row), which you can modify and then call 'save' on, or can delete by calling 'remove'. .. code-block:: python pythonistas = await Band.objects().where( Band.name == 'Pythonistas'

(
        cls: type[TableInstance],
        *prefetch: Union[ForeignKey, list[ForeignKey]],
    )

    @classmethod
    def objects(
        cls: type[TableInstance],
        *prefetch: Union[ForeignKey, list[ForeignKey]],
    ) -> Objects[TableInstance]:
        """
        Returns a list of table instances (each representing a row), which you
        can modify and then call 'save' on, or can delete by calling 'remove'.

        .. code-block:: python

            pythonistas = await Band.objects().where(
                Band.name == 'Pythonistas'
            ).first()

            pythonistas.name = 'Pythonistas Reborn'

            await pythonistas.save()

            # Or to remove it from the database:
            await pythonistas.remove()

        :param prefetch:
            Rather than returning the primary key value of this related table,
            a nested object will be returned for the row on the related table.

            .. code-block:: python

                # Without nested
                band = await Band.objects().first()
                >>> band.manager
                1

                # With nested
                band = await Band.objects(Band.manager).first()
                >>> band.manager
                <Band 1>

        """
        return Objects[TableInstance](table=cls, prefetch=prefetch)

    @classmethod
    def count(