code: def count(self):
          
          cmd = ("select COUNT(*) from {table} "
                 "{join_clause}{where_clause}{order_clause}").format(
                      table=self.table_name,
                      where_clause=self.where_clause,
                      join_clause=self.join_clause,
                      order_clause=self.order_clause).rstrip()
          return Repo.db.execute(cmd, self.where_values)
docs: Count the number of records in the table, subject to the query.