net.namibsun.papio.lib.db.models

Class Category.Companion

net.namibsun.papio.lib.db.models.Category.Companion

Enclosing class:

Category

public static class Category.Companion

Static Methods

Method Summary

Modifier and Type	Method and Description
Category	create(DbHandler dbHandler, java.lang.String name) Creates a new Category in the database and returns the corresponding Category object. If a category with the same name already exists, no new category will be created and the existing one will be returned instead
Category	fromResultSet(java.sql.ResultSet resultSet) Generates a Category object from a ResultSet
Category	get(DbHandler dbHandler, int id) Retrieves a Category from the database by its ID
Category	get(DbHandler dbHandler, java.lang.String nameOrId) Retrieves a Category from the database by its name or ID
java.util.List<net.namibsun.papio.lib.db.models.Category>	getAll(DbHandler dbHandler) Retrieves a list of all Category objects in the database

Method Detail

fromResultSet

public Category fromResultSet(java.sql.ResultSet resultSet)

Generates a Category object from a ResultSet

Parameters:

resultSet - : The ResultSet to use to generate the Category object

Returns:

The generated Category object

get

public Category get(DbHandler dbHandler,
                    int id)

Retrieves a Category from the database by its ID

Parameters:

dbHandler - : The database handler to use

id - : The ID of the category

Returns:

The generated Category object or null if no applicable category was found

get

public Category get(DbHandler dbHandler,
                    java.lang.String nameOrId)

Retrieves a Category from the database by its name or ID

Parameters:

dbHandler - : The database handler to use

nameOrId - : The name or ID of the category

Returns:

The generated Category object or null if no applicable category was found

getAll

public java.util.List<net.namibsun.papio.lib.db.models.Category> getAll(DbHandler dbHandler)

Retrieves a list of all Category objects in the database

Parameters:

dbHandler - : The database handler to use

Returns:

The list of Category objects

create

public Category create(DbHandler dbHandler,
                       java.lang.String name)

Creates a new Category in the database and returns the corresponding Category object. If a category with the same name already exists, no new category will be created and the existing one will be returned instead

Parameters:

dbHandler - : The database handler to use for database calls

name - : The name of the category

Returns:

The Category object