export const C6Constants = {
    // try to 1=1 match the Rest abstract class
    ADDDATE: 'ADDDATE',
    ADDTIME: 'ADDTIME',
    AS: 'AS',
    ASC: 'ASC',
    AND: 'AND',

    BETWEEN: 'BETWEEN',

    CONCAT: 'CONCAT',
    CALL: 'CALL',
    CONVERT_TZ: 'CONVERT_TZ',
    COUNT: 'COUNT',
    COUNT_ALL: 'COUNT_ALL',
    CURRENT_DATE: 'CURRENT_DATE',
    CURRENT_TIMESTAMP: 'CURRENT_TIMESTAMP',

    DAY: 'DAY',
    DAY_HOUR: 'DAY_HOUR',
    DAY_MICROSECOND: 'DAY_MICROSECOND',
    DAY_MINUTE: 'DAY_MINUTE',
    DAY_SECOND: 'DAY_SECOND',
    DAYNAME: 'DAYNAME',
    DAYOFMONTH: 'DAYOFMONTH',
    DAYOFWEEK: 'DAYOFWEEK',
    DAYOFYEAR: 'DAYOFYEAR',
    DATE: 'DATE',
    DATE_ADD: 'DATE_ADD',
    DATEDIFF: 'DATEDIFF',
    DATE_SUB: 'DATE_SUB',
    DATE_FORMAT: 'DATE_FORMAT',
    DESC: 'DESC',
    DISTINCT: 'DISTINCT',

    EXISTS: 'EXISTS',
    EXTRACT: 'EXTRACT',
    EQUAL: '=',
    EQUAL_NULL_SAFE: '<=>',

    FALSE: 'FALSE',
    FORCE: 'FORCE',
    FULL_OUTER: 'FULL_OUTER',
    FROM_DAYS: 'FROM_DAYS',
    FROM_UNIXTIME: 'FROM_UNIXTIME',

    GET_FORMAT: 'GET_FORMAT',
    GREATER_THAN: '>',
    GROUP_BY: 'GROUP_BY',
    GROUP_CONCAT: 'GROUP_CONCAT',
    GREATER_THAN_OR_EQUAL_TO: '>=',

    HAVING: 'HAVING',
    HEX: 'HEX',
    HOUR: 'HOUR',
    HOUR_MICROSECOND: 'HOUR_MICROSECOND',
    HOUR_SECOND: 'HOUR_SECOND',
    HOUR_MINUTE: 'HOUR_MINUTE',

    IN: 'IN',
    INDEX: 'INDEX',
    IS: 'IS',
    IS_NOT: 'IS_NOT',
    INNER: 'INNER',
    INTERVAL: 'INTERVAL',

    JOIN: 'JOIN',
    FROM: 'FROM',

    LEFT: 'LEFT',
    LEFT_OUTER: 'LEFT_OUTER',
    LESS_THAN: '<',
    LESS_THAN_OR_EQUAL_TO: '<=',
    LIKE: 'LIKE',
    LIT: 'LIT',
    LIMIT: 'LIMIT',
    LOCALTIME: 'LOCALTIME',
    LOCALTIMESTAMP: 'LOCALTIMESTAMP',

    MAKEDATE: 'MAKEDATE',
    MAKETIME: 'MAKETIME',
    MATCH_AGAINST: 'MATCH_AGAINST',
    MBRCONTAINS: 'MBRContains',
    MONTHNAME: 'MONTHNAME',
    MICROSECOND: 'MICROSECOND',
    MINUTE: 'MINUTE',
    MINUTE_MICROSECOND: 'MINUTE_MICROSECOND',
    MINUTE_SECOND: 'MINUTE_SECOND',
    MIN: 'MIN',
    MAX: 'MAX',
    MONTH: 'MONTH',

    NOT_LIKE: 'NOT_LIKE',
    NOT_EQUAL: '<>',
    NOT_IN: 'NOT_IN',
    NOW: 'NOW',
    NULL: 'NULL',

    ORDER: 'ORDER',
    OR: 'OR',

    INDEX_HINTS: 'INDEX_HINTS',

    FORCE_INDEX: 'FORCE INDEX',
    USE_INDEX: 'USE INDEX',
    IGNORE_INDEX: 'IGNORE INDEX',

    PAGE: 'PAGE',
    PAGINATION: 'PAGINATION',
    POLYGON: 'POLYGON',
    POINT: 'POINT',
    RIGHT_OUTER: 'RIGHT_OUTER',

    SECOND: 'SECOND',
    SECOND_MICROSECOND: 'SECOND_MICROSECOND',
    SELECT: 'SELECT',
    SUBSELECT: 'SUBSELECT',
    PARAM: 'PARAM',

    // MySQL Spatial Functions
    ST_AREA: 'ST_Area',
    ST_ASBINARY: 'ST_AsBinary',
    ST_ASTEXT: 'ST_AsText',
    ST_BUFFER: 'ST_Buffer',
    ST_CONTAINS: 'ST_Contains',
    ST_CROSSES: 'ST_Crosses',
    ST_DIFFERENCE: 'ST_Difference',
    ST_DIMENSION: 'ST_Dimension',
    ST_DISJOINT: 'ST_Disjoint',
    ST_DISTANCE: 'ST_Distance',
    ST_DISTANCE_SPHERE: 'ST_Distance_Sphere',
    ST_ENDPOINT: 'ST_EndPoint',
    ST_ENVELOPE: 'ST_Envelope',
    ST_EQUALS: 'ST_Equals',
    ST_GEOMFROMGEOJSON: 'ST_GeomFromGeoJSON',
    ST_GEOMFROMTEXT: 'ST_GeomFromText',
    ST_GEOMFROMWKB: 'ST_GeomFromWKB',
    ST_INTERSECTS: 'ST_Intersects',
    ST_LENGTH: 'ST_Length',
    ST_MAKEENVELOPE: 'ST_MakeEnvelope',
    ST_OVERLAPS: 'ST_Overlaps',
    ST_POINT: 'ST_Point',
    ST_SETSRID: 'ST_SetSRID',
    ST_SRID: 'ST_SRID',
    ST_STARTPOINT: 'ST_StartPoint',
    ST_SYMDIFFERENCE: 'ST_SymDifference',
    ST_TOUCHES: 'ST_Touches',
    ST_UNION: 'ST_Union',
    ST_WITHIN: 'ST_Within',
    ST_X: 'ST_X',
    ST_Y: 'ST_Y',

    STR_TO_DATE: 'STR_TO_DATE',
    SUBDATE: 'SUBDATE',
    SUBTIME: 'SUBTIME',
    SUM: 'SUM',
    SYSDATE: 'SYSDATE',

    TIME: 'TIME',
    TIME_FORMAT: 'TIME_FORMAT',
    TIME_TO_SEC: 'TIME_TO_SEC',
    TIMEDIFF: 'TIMEDIFF',
    TIMESTAMP: 'TIMESTAMP',
    TIMESTAMPADD: 'TIMESTAMPADD',
    TIMESTAMPDIFF: 'TIMESTAMPDIFF',
    TO_DAYS: 'TO_DAYS',
    TO_SECONDS: 'TO_SECONDS',
    TRANSACTION_TIMESTAMP: 'TRANSACTION_TIMESTAMP',
    TRUE: 'TRUE',

    UNIX_TIMESTAMP: 'UNIX_TIMESTAMP',
    UNKNOWN: 'UNKNOWN',
    UPDATE: 'UPDATE',
    UNHEX: 'UNHEX',
    UTC_DATE: 'UNHEX',
    UTC_TIME: 'UNHEX',
    UTC_TIMESTAMP: 'UNHEX',

    WHERE: 'WHERE',
    WEEKDAY: 'WEEKDAY',
    WEEKOFYEAR: 'WEEKOFYEAR',

    YEARWEEK: 'YEARWEEK',

    // carbon identifiers
    DB: 'DB',
    DEPENDANT_ON_ENTITY: 'DEPENDANT_ON_ENTITY',
    HEADERS: 'HEADERS',

    // PHP validation
    OPTIONS: 'OPTIONS',
    INSERT: 'INSERT',
    GET: 'GET',
    POST: 'POST',
    PUT: 'PUT',
    REPLACE: 'REPLACE',
    DELETE: 'DELETE',
    REST_REQUEST_PREPROCESS_CALLBACKS: 'PREPROCESS',
    PREPROCESS: 'PREPROCESS',
    REST_REQUEST_FINNISH_CALLBACKS: 'FINISH',
    FINISH: 'FINISH',
    VALIDATE_C6_ENTITY_ID_REGEX: '#^([a-fA-F0-9]{20,35})$#',

} as const;


export const C6C = C6Constants;