/** * This class is generated by jOOQ */ package org.jooq.example.chart.db; import java.math.BigDecimal; import javax.annotation.Generated; import org.jooq.Configuration; import org.jooq.Field; import org.jooq.Result; import org.jooq.example.chart.db.tables.Actor; import org.jooq.example.chart.db.tables.ActorInfo; import org.jooq.example.chart.db.tables.Address; import org.jooq.example.chart.db.tables.Category; import org.jooq.example.chart.db.tables.City; import org.jooq.example.chart.db.tables.Country; import org.jooq.example.chart.db.tables.Customer; import org.jooq.example.chart.db.tables.CustomerList; import org.jooq.example.chart.db.tables.Film; import org.jooq.example.chart.db.tables.FilmActor; import org.jooq.example.chart.db.tables.FilmCategory; import org.jooq.example.chart.db.tables.FilmInStock; import org.jooq.example.chart.db.tables.FilmList; import org.jooq.example.chart.db.tables.FilmNotInStock; import org.jooq.example.chart.db.tables.Inventory; import org.jooq.example.chart.db.tables.Language; import org.jooq.example.chart.db.tables.NicerButSlowerFilmList; import org.jooq.example.chart.db.tables.Payment; import org.jooq.example.chart.db.tables.PaymentP2007_01; import org.jooq.example.chart.db.tables.PaymentP2007_02; import org.jooq.example.chart.db.tables.PaymentP2007_03; import org.jooq.example.chart.db.tables.PaymentP2007_04; import org.jooq.example.chart.db.tables.PaymentP2007_05; import org.jooq.example.chart.db.tables.PaymentP2007_06; import org.jooq.example.chart.db.tables.Rental; import org.jooq.example.chart.db.tables.RewardsReport; import org.jooq.example.chart.db.tables.SalesByFilmCategory; import org.jooq.example.chart.db.tables.SalesByStore; import org.jooq.example.chart.db.tables.SchemaVersion; import org.jooq.example.chart.db.tables.Staff; import org.jooq.example.chart.db.tables.StaffList; import org.jooq.example.chart.db.tables.Store; import org.jooq.example.chart.db.tables.records.FilmInStockRecord; import org.jooq.example.chart.db.tables.records.FilmNotInStockRecord; import org.jooq.example.chart.db.tables.records.RewardsReportRecord; import org.jooq.impl.DSL; /** * Convenience access to all tables in public */ @Generated( value = { "http://www.jooq.org", "jOOQ version:3.8.0", "schema version:public_2", }, date = "2016-06-30T15:44:15.143Z", comments = "This class is generated by jOOQ" ) @SuppressWarnings({ "all", "unchecked", "rawtypes" }) public class Tables { /** * The table <code>public.actor</code>. */ public static final Actor ACTOR = org.jooq.example.chart.db.tables.Actor.ACTOR; /** * The table <code>public.actor_info</code>. */ public static final ActorInfo ACTOR_INFO = org.jooq.example.chart.db.tables.ActorInfo.ACTOR_INFO; /** * The table <code>public.address</code>. */ public static final Address ADDRESS = org.jooq.example.chart.db.tables.Address.ADDRESS; /** * The table <code>public.category</code>. */ public static final Category CATEGORY = org.jooq.example.chart.db.tables.Category.CATEGORY; /** * The table <code>public.city</code>. */ public static final City CITY = org.jooq.example.chart.db.tables.City.CITY; /** * The table <code>public.country</code>. */ public static final Country COUNTRY = org.jooq.example.chart.db.tables.Country.COUNTRY; /** * The table <code>public.customer</code>. */ public static final Customer CUSTOMER = org.jooq.example.chart.db.tables.Customer.CUSTOMER; /** * The table <code>public.customer_list</code>. */ public static final CustomerList CUSTOMER_LIST = org.jooq.example.chart.db.tables.CustomerList.CUSTOMER_LIST; /** * The table <code>public.film</code>. */ public static final Film FILM = org.jooq.example.chart.db.tables.Film.FILM; /** * The table <code>public.film_actor</code>. */ public static final FilmActor FILM_ACTOR = org.jooq.example.chart.db.tables.FilmActor.FILM_ACTOR; /** * The table <code>public.film_category</code>. */ public static final FilmCategory FILM_CATEGORY = org.jooq.example.chart.db.tables.FilmCategory.FILM_CATEGORY; /** * The table <code>public.film_in_stock</code>. */ public static final FilmInStock FILM_IN_STOCK = org.jooq.example.chart.db.tables.FilmInStock.FILM_IN_STOCK; /** * Call <code>public.film_in_stock</code>. */ public static Result<FilmInStockRecord> FILM_IN_STOCK(Configuration configuration, Integer pFilmId, Integer pStoreId) { return DSL.using(configuration).selectFrom(FilmInStock.FILM_IN_STOCK.call(pFilmId, pStoreId)).fetch(); } /** * Get <code>public.film_in_stock</code> as a table. */ public static FilmInStock FILM_IN_STOCK(Integer pFilmId, Integer pStoreId) { return FilmInStock.FILM_IN_STOCK.call(pFilmId, pStoreId); } /** * Get <code>public.film_in_stock</code> as a table. */ public static FilmInStock FILM_IN_STOCK(Field<Integer> pFilmId, Field<Integer> pStoreId) { return FilmInStock.FILM_IN_STOCK.call(pFilmId, pStoreId); } /** * The table <code>public.film_list</code>. */ public static final FilmList FILM_LIST = org.jooq.example.chart.db.tables.FilmList.FILM_LIST; /** * The table <code>public.film_not_in_stock</code>. */ public static final FilmNotInStock FILM_NOT_IN_STOCK = org.jooq.example.chart.db.tables.FilmNotInStock.FILM_NOT_IN_STOCK; /** * Call <code>public.film_not_in_stock</code>. */ public static Result<FilmNotInStockRecord> FILM_NOT_IN_STOCK(Configuration configuration, Integer pFilmId, Integer pStoreId) { return DSL.using(configuration).selectFrom(FilmNotInStock.FILM_NOT_IN_STOCK.call(pFilmId, pStoreId)).fetch(); } /** * Get <code>public.film_not_in_stock</code> as a table. */ public static FilmNotInStock FILM_NOT_IN_STOCK(Integer pFilmId, Integer pStoreId) { return FilmNotInStock.FILM_NOT_IN_STOCK.call(pFilmId, pStoreId); } /** * Get <code>public.film_not_in_stock</code> as a table. */ public static FilmNotInStock FILM_NOT_IN_STOCK(Field<Integer> pFilmId, Field<Integer> pStoreId) { return FilmNotInStock.FILM_NOT_IN_STOCK.call(pFilmId, pStoreId); } /** * The table <code>public.inventory</code>. */ public static final Inventory INVENTORY = org.jooq.example.chart.db.tables.Inventory.INVENTORY; /** * The table <code>public.language</code>. */ public static final Language LANGUAGE = org.jooq.example.chart.db.tables.Language.LANGUAGE; /** * The table <code>public.nicer_but_slower_film_list</code>. */ public static final NicerButSlowerFilmList NICER_BUT_SLOWER_FILM_LIST = org.jooq.example.chart.db.tables.NicerButSlowerFilmList.NICER_BUT_SLOWER_FILM_LIST; /** * The table <code>public.payment</code>. */ public static final Payment PAYMENT = org.jooq.example.chart.db.tables.Payment.PAYMENT; /** * The table <code>public.payment_p2007_01</code>. */ public static final PaymentP2007_01 PAYMENT_P2007_01 = org.jooq.example.chart.db.tables.PaymentP2007_01.PAYMENT_P2007_01; /** * The table <code>public.payment_p2007_02</code>. */ public static final PaymentP2007_02 PAYMENT_P2007_02 = org.jooq.example.chart.db.tables.PaymentP2007_02.PAYMENT_P2007_02; /** * The table <code>public.payment_p2007_03</code>. */ public static final PaymentP2007_03 PAYMENT_P2007_03 = org.jooq.example.chart.db.tables.PaymentP2007_03.PAYMENT_P2007_03; /** * The table <code>public.payment_p2007_04</code>. */ public static final PaymentP2007_04 PAYMENT_P2007_04 = org.jooq.example.chart.db.tables.PaymentP2007_04.PAYMENT_P2007_04; /** * The table <code>public.payment_p2007_05</code>. */ public static final PaymentP2007_05 PAYMENT_P2007_05 = org.jooq.example.chart.db.tables.PaymentP2007_05.PAYMENT_P2007_05; /** * The table <code>public.payment_p2007_06</code>. */ public static final PaymentP2007_06 PAYMENT_P2007_06 = org.jooq.example.chart.db.tables.PaymentP2007_06.PAYMENT_P2007_06; /** * The table <code>public.rental</code>. */ public static final Rental RENTAL = org.jooq.example.chart.db.tables.Rental.RENTAL; /** * The table <code>public.rewards_report</code>. */ public static final RewardsReport REWARDS_REPORT = org.jooq.example.chart.db.tables.RewardsReport.REWARDS_REPORT; /** * Call <code>public.rewards_report</code>. */ public static Result<RewardsReportRecord> REWARDS_REPORT(Configuration configuration, Integer minMonthlyPurchases, BigDecimal minDollarAmountPurchased) { return DSL.using(configuration).selectFrom(RewardsReport.REWARDS_REPORT.call(minMonthlyPurchases, minDollarAmountPurchased)).fetch(); } /** * Get <code>public.rewards_report</code> as a table. */ public static RewardsReport REWARDS_REPORT(Integer minMonthlyPurchases, BigDecimal minDollarAmountPurchased) { return RewardsReport.REWARDS_REPORT.call(minMonthlyPurchases, minDollarAmountPurchased); } /** * Get <code>public.rewards_report</code> as a table. */ public static RewardsReport REWARDS_REPORT(Field<Integer> minMonthlyPurchases, Field<BigDecimal> minDollarAmountPurchased) { return RewardsReport.REWARDS_REPORT.call(minMonthlyPurchases, minDollarAmountPurchased); } /** * The table <code>public.sales_by_film_category</code>. */ public static final SalesByFilmCategory SALES_BY_FILM_CATEGORY = org.jooq.example.chart.db.tables.SalesByFilmCategory.SALES_BY_FILM_CATEGORY; /** * The table <code>public.sales_by_store</code>. */ public static final SalesByStore SALES_BY_STORE = org.jooq.example.chart.db.tables.SalesByStore.SALES_BY_STORE; /** * The table <code>public.schema_version</code>. */ public static final SchemaVersion SCHEMA_VERSION = org.jooq.example.chart.db.tables.SchemaVersion.SCHEMA_VERSION; /** * The table <code>public.staff</code>. */ public static final Staff STAFF = org.jooq.example.chart.db.tables.Staff.STAFF; /** * The table <code>public.staff_list</code>. */ public static final StaffList STAFF_LIST = org.jooq.example.chart.db.tables.StaffList.STAFF_LIST; /** * The table <code>public.store</code>. */ public static final Store STORE = org.jooq.example.chart.db.tables.Store.STORE; }