Package simpleorm.drivers

Class SDriverPostgres

  • public class SDriverPostgres
extends SDriver
    This contains PostgreSQL specific code.

    VARCHAR without size means unlimited. No artificial upper size? TEXT has the same behaviour as VARCHAR, apparently.

    • Constructor Detail

      • SDriverPostgres

        public SDriverPostgres()

    • Method Detail

      • driverName

        protected java.lang.String driverName()
        Description copied from class: SDriver
        The driver name to be compared to getMetaData().getDriverName()
        Overrides:
        driverName in class SDriver

      • maxIdentNameLength

        public int maxIdentNameLength()
        Description copied from class: SDriver
        The maximum size for table names and foreign key constraint names.
        Overrides:
        maxIdentNameLength in class SDriver

      • columnTypeSQL

        protected java.lang.String columnTypeSQL​(SFieldScalar field,
                                         java.lang.String defalt)
        Never need to specify byteSize for varchar
        Overrides:
        columnTypeSQL in class SDriver

      • createSequenceDDL

        protected java.lang.String createSequenceDDL​(java.lang.String name)
        Overrides:
        createSequenceDDL in class SDriver

      • dropSequenceDDL

        protected java.lang.String dropSequenceDDL​(java.lang.String name)
        Overrides:
        dropSequenceDDL in class SDriver

      • getOffsetStrategy

        protected SDriver.OffsetStrategy getOffsetStrategy()
        Description copied from class: SDriver
        JDBC prefered, if jdbc driver has a sensible scrollable resultset implemntation QUERY if database would handle it better via some proprietary sql extension (eg. LIMIT) BULK Simpleorm will get the whole resultset and skip de first row. Worst case scenario :(

        Defaults to BULK

        Overrides:
        getOffsetStrategy in class SDriver

      • limitSQL

        protected java.lang.String limitSQL​(long offset,
                                    long limit)
        Description copied from class: SDriver
        Drivers that choose to implement a QUERY offset strategy should return the limit statment here
        Overrides:
        limitSQL in class SDriver
        Parameters:
        offset - number of rows to skip
        limit - number of rows to retrieve
        Returns:
        LIMIT + OFFSET string statment