Method insert

piccolo/table.py:1061–1077

Insert rows into the database. .. code-block:: python await Band.insert( Band(name="Pythonistas", popularity=500, manager=1) )

(
        cls: type[TableInstance], *rows: TableInstance
    )

    @classmethod
    def insert(
        cls: type[TableInstance], *rows: TableInstance
    ) -> Insert[TableInstance]:
        """
        Insert rows into the database.

        .. code-block:: python

            await Band.insert(
                Band(name="Pythonistas", popularity=500, manager=1)
            )

        """
        query = Insert(table=cls).returning(cls._meta.primary_key)
        if rows:
            query.add(*rows)
        return query

    @classmethod
    def raw(cls, sql: str, *args: Any) -> Raw: