// This Source Code is in the Public Domain per: http://unlicense.org
package org.litesoft.sql;

import java.sql.*;

import org.litesoft.db.*;

public class SQLProductSpecificHelperMySQL extends SQLProductSpecificAbstractHelper
{
    /**
     * @param pProductVersion       - Of The DataBase
     * @param pTableName            - Of the Schema's Table Name
     * @param pSelectColumns        - Of the Table (comma separated)
     * @param pSelectionWhereClause - null means all
     * @param pOrderBy              - null means order immaterial
     * @param pOffset               - Rows to Skip (>= 0 verified)
     * @param pLimit                - Max Rows to return (>= 1 verified) @return !Null
     */
    @Override
    public String buildQuery( String pProductVersion, String pTableName, //
                              String pSelectColumns, String pSelectionWhereClause, String pOrderBy, //
                              long pOffset, int pLimit )
    {
        return "SELECT" + //
               " " + pSelectColumns + //
               " FROM " + pTableName + //
               " " + pSelectionWhereClause + //
               " " + pOrderBy + //
               " LIMIT " + pLimit + //
               " OFFSET " + pOffset;
    }

    @Override
    public boolean validateConnection( Connection pConnection, DBinfo pDBinfo )
            throws SQLException
    {
        return LLvalidateConWith( pConnection, //
                                  "SELECT 1 AS Yup" );
    }

    @Override
    public boolean tableExists( Connection pConnection, DBinfo pDBinfo, String pTableName )
            throws SQLException, MultipleTablesException
    {
        return LLtableExists( pConnection, pDBinfo, pTableName, //
                              "SELECT 1 AS Yup FROM " + pTableName + " LIMIT 1" );
    }

    @Override
    public boolean columnExists( Connection pConnection, DBinfo pDBinfo, String pTableName, String pColumnName )
            throws SQLException, MultipleTablesException
    {
        return LLcolumnExists( pConnection, pDBinfo, pTableName, pColumnName,  //
                               "SELECT " + pColumnName + " AS Yup FROM " + pTableName + " LIMIT 1" );
    }
}