Documentation

MySqlVisitor extends ToSqlVisitor
in package

Application

The Default MysqL/MariaDb visitor

Properties

$charset : mixed
$columnQuote : mixed
$dateMapping : array<string|int, mixed>
$tableQuote : mixed

Methods

__construct() : mixed: Default constructor
jsonValue() : mixed
visit() : mixed
visitAbs() : mixed
visitAddOperator() : string: Visit the AddOperator node
visitAliasOperator() : string: Visit the AliasOperator node
visitAlterStatement() : string: Visit the AlterStatement node
visitAndOperator() : string: Visit the AndOperator node
visitArrayJoin() : mixed
visitAscOperator() : string: Visit the AscOperator node
visitAverageFunction() : string: Visit the AverageFunction node
visitCaseNode() : string: Visit the CaseNode node
visitCast() : string: Visit the CAST node
visitCoalesce() : string: Visit the Coalesce node
visitCollate() : string: Visit the Collate node
visitCollateMatch() : string: Visit the CollateMatch node
visitColumn() : string: Visit the Column node
visitColumnType() : string: Visit type of the given Column node
visitCommentStatement() : string: Visit the CommentStatement node
visitConcatOperator() : string: Visit the ConcatOperator node
visitConstraint() : string: Visit the Constraint node
visitCountFunction() : string: Visit the CountFunction node
visitCreateStatement() : string: Visit the CreateStatement node
visitDateAddOperator() : string: Visit the DateAddOperator node
visitDateDuration() : string: Visit the DateDuration node
visitDateSubPart() : string: Visit the DateSubPart node
visitDeleteStatement() : string: Visit the DeleteStatement node
visitDescOperator() : string: Visit the DescOperator node
visitDivOperator() : string: Visit the Div node
visitDropStatement() : string: Visit the DropStatement node
visitEqualityOperator() : string: Visit the EqualityOperator node
visitExpressionList() : mixed: Visit the ExpressionList Node
visitFirstValue() : string: Visit the FirstValue node
visitFloor() : string: Visit the Floor node
visitFormat() : string: Visit the Format node
visitFormatDate() : string: Visit the FormatDate node
visitFunctionCall() : string: Visit the FunctionCall node
visitGreaterOrEqualOperator() : string: Visit the GreaterOrEqualOperator node
visitGreaterThanOperator() : string: Visit the GreaterThanOperator node
visitGroupConcatFunction() : string: Visit the GroupConcatFunction node
visitGrouping() : string: Visit the Grouping node
visitInfix() : mixed
visitInOperator() : string: Visit the InOperator node
visitInsertStatement() : string: Visit the InsertStatement node
visitIsNotNullOperator() : string: Visit the IsNotNullOperator node
visitIsNullOperator() : string: Visit the IsNullOperator node
visitJoinClause() : string: Visit the JoinClause node
visitJsonGet() : string: Visit the JsonGet node
visitJsonGroup() : mixed: Visit the JsonGroup node
visitJsonNode() : string: Visit the JsonNode node
visitLastValue() : string: Visit the FirstValue node
visitLengthOperator() : string: Visit the LengthOperator node
visitLesserOrEqualOperator() : string: Visit the LesserOrEqualOperator node
visitLesserThanOperator() : string: Visit the LesserThanOperator node
visitLiteral() : string: Visit the Literal node
visitLocate() : mixed
visitLog() : string: Visit the Log node
visitLower() : string: Visit the Lower node
visitMatchOperator() : string: Visit the MatchOperator node
visitMaximumFunction() : string: Visit the MaximumFunction node
visitMinimumFunction() : string: Visit the MinimumFunction node
visitMulOperator() : string: Visit the MulOperator node
visitNamedFn() : string: Visit the NamedFunction
visitNotEqualityOperator() : string: Visit the NotEqualityOperator node
visitNotInOperator() : string: Visit the NotInOperator node
visitNotMatchOperator() : string: Visit the NotMatchOperator node
visitNotOperator() : string: Visit the NotOperator node
visitOrOperator() : string: Visit the OrOperator node
visitOverClause() : string: Visit the OVER clause node
visitPow() : string: Visit the Pow node
visitRegexInstr() : string: Visit the RegexInstr node
visitRegexMatchOperator() : string: Visit the RegexMatchOperator node
visitRegexReplace() : string: Visit the RegexReplace node
visitRegexReplaceFunction() : string: Visit the RegexReplaceFunction node
visitRegexSubstr() : string: Visit the RegexSubStrFunction node
visitRepeat() : mixed
visitReplace() : string: Visit the Replace node
visitSelectStatement() : string: Visit the SelectStatement node
visitSubOperator() : string: Visit the SubOperator node
visitSubstring() : string: Visit the Substring node
visitSumFunction() : string: Visit the SumFunction node
visitTable() : string: Visit the Table node
visitTrim() : string: Visit the Trim node
visitTruncateStatement() : string: Visit the Truncate statement
visitTypeOption() : mixed
visitUnion() : string: visit the Union node
visitUpdateStatement() : string: Visit the UpdateStatement node
visitUpper() : string: Visit the Upper node
convertFormatTimeToSQL() : string

$charset


    public
        mixed
    $charset
     = "utf8mb4"

$columnQuote


    public
        mixed
    $columnQuote
     = "`"

$dateMapping


    public
    static    array<string|int, mixed>
    $dateMapping
     = [
    'd' => '%d',
    'a' => '%p',
    'A' => '%p',
    'D' => '%a',
    'j' => '%e',
    'W' => '%U',
    'l' => '%W',
    'N' => '%w',
    'w' => '%w',
    'z' => '%j',
    'm' => '%m',
    'M' => '%b',
    'F' => '%M',
    'n' => '%c',
    //        't' => '',
    //        'L' => '',
    'o' => '%X',
    'Y' => '%Y',
    'y' => '%y',
    'B' => '',
    'g' => '%l',
    'G' => '%k',
    'h' => '%I',
    'H' => '%H',
    'i' => '%i',
    's' => '%s',
    //        'u' => '',
    //        'v' => '',
    'e' => '%z',
    //        'I' => '',
    'O' => '%z',
    'P' => '%z',
    'T' => '%Z',
    //        'Z' => '',
    'c' => '%Y-%m-%dT%H:%i:%s',
    'r' => '%a, %d %b %Y %H:%i:%s',
    'U' => '%s',
]

$tableQuote


    public
        mixed
    $tableQuote
     = "`"

__construct()

Default constructor


    public
                    __construct() : mixed

jsonValue()


    public
                    jsonValue(mixed $value) : mixed

Parameters

$value : mixed

visit()


    public
                    visit(mixed $node) : mixed

Parameters

$node : mixed

visitAbs()


    public
                    visitAbs(mixed $node) : mixed

Parameters

$node : mixed

visitAddOperator()

Visit the AddOperator node


    public
                    visitAddOperator(AddOperator $node) : string

Parameters

$node : AddOperator: the node

Return values

string —

the SQL string

visitAliasOperator()

Visit the AliasOperator node


    public
                    visitAliasOperator(AliasOperator $node) : string

Parameters

$node : AliasOperator: the node

Return values

string —

the SQL string

visitAlterStatement()

Visit the AlterStatement node


    public
                    visitAlterStatement(mixed $node) : string

Parameters

$node : mixed: AlterStatement the node

Return values

string —

the SQL string

visitAndOperator()

Visit the AndOperator node


    public
                    visitAndOperator(AndOperator $node) : string

Parameters

$node : AndOperator: the node

Return values

string —

the SQL string

visitArrayJoin()


    public
                    visitArrayJoin(mixed $arr, mixed $sep) : mixed

Parameters

$arr : mixed
$sep : mixed

visitAscOperator()

Visit the AscOperator node


    public
                    visitAscOperator(AscOperator $node) : string

Parameters

$node : AscOperator: the node

Return values

string —

the SQL string

visitAverageFunction()

Visit the AverageFunction node


    public
                    visitAverageFunction(AverageFunction $node) : string

Parameters

$node : AverageFunction: the node

Return values

string —

the SQL string

visitCaseNode()

Visit the CaseNode node


    public
                    visitCaseNode(CaseNode $node) : string

Parameters

$node : CaseNode: the node

Return values

string —

the SQL string

visitCast()

Visit the CAST node


    public
                    visitCast(mixed $node) : string

Parameters

$node : mixed: the node

Return values

string —

the SQL string

visitCoalesce()

Visit the Coalesce node


    public
                    visitCoalesce(Coalesce $node) : string

Parameters

$node : Coalesce: the node

Return values

string —

the SQL string

visitCollate()

Visit the Collate node


    public
                    visitCollate(mixed $node) : string

Parameters

$node : mixed: Collate the node

Return values

string —

the SQL string

visitCollateMatch()

Visit the CollateMatch node


    public
                    visitCollateMatch(CollateMatch $node) : string

Parameters

$node : CollateMatch: the node

Return values

string —

the SQL string

visitColumn()

Visit the Column node


    public
                    visitColumn(Column $node) : string

Parameters

$node : Column: the node

Return values

string —

the SQL string

visitColumnType()

Visit type of the given Column node


    public
                    visitColumnType(Column $node, bool $parameters) : string

Parameters

$node : Column
$parameters : bool

Return values

string

visitCommentStatement()

Visit the CommentStatement node


    public
                    visitCommentStatement(mixed $node) : string

Parameters

$node : mixed: CommentStatement the node

Return values

string —

the SQL string

visitConcatOperator()

Visit the ConcatOperator node


    public
                    visitConcatOperator(ConcatOperator $node) : string

Parameters

$node : ConcatOperator: the node

Return values

string —

the SQL string

visitConstraint()

Visit the Constraint node


    public
                    visitConstraint(Constraint $node) : string

Parameters

$node : Constraint: the node

Return values

string —

the SQL string

visitCountFunction()

Visit the CountFunction node


    public
                    visitCountFunction(CountFunction $node) : string

Parameters

$node : CountFunction: the node

Return values

string —

the SQL string

visitCreateStatement()

Visit the CreateStatement node


    public
                    visitCreateStatement(CreateStatement $node) : string

Parameters

$node : CreateStatement: the node

Return values

string —

the SQL string

visitDateAddOperator()

Visit the DateAddOperator node


    public
                    visitDateAddOperator(DateAddOperator $node) : string

Parameters

$node : DateAddOperator: the node

Return values

string —

the SQL string

visitDateDuration()

Visit the DateDuration node


    public
                    visitDateDuration(mixed $node) : string

Parameters

$node : mixed: DateDuration the node

Return values

string —

the SQL string

visitDateSubPart()

Visit the DateSubPart node


    public
                    visitDateSubPart(mixed $node) : string

Parameters

$node : mixed: the node

Return values

string —

the SQL string

visitDeleteStatement()

Visit the DeleteStatement node


    public
                    visitDeleteStatement(DeleteStatement $node) : string

Parameters

$node : DeleteStatement: the node

Return values

string —

the SQL string

visitDescOperator()

Visit the DescOperator node


    public
                    visitDescOperator(DescOperator $node) : string

Parameters

$node : DescOperator: the node

Return values

string —

the SQL string

visitDivOperator()

Visit the Div node


    public
                    visitDivOperator(Div $node) : string

Parameters

$node : Div: the node

Return values

string —

the SQL string

visitDropStatement()

Visit the DropStatement node


    public
                    visitDropStatement(DropStatement $node) : string

Parameters

$node : DropStatement: the node

Return values

string —

the SQL string

visitEqualityOperator()

Visit the EqualityOperator node


    public
                    visitEqualityOperator(EqualityOperator $node) : string

Parameters

$node : EqualityOperator: the node

Return values

string —

the SQL string

visitExpressionList()

Visit the ExpressionList Node


    public
                    visitExpressionList(ExpressionList $node) : mixed

Parameters

$node : ExpressionList: the node

Return values

mixed —

the SQL string

visitFirstValue()

Visit the FirstValue node


    public
                    visitFirstValue(FirstValue $node) : string

Parameters

$node : FirstValue: the node

Return values

string —

the SQL string

visitFloor()

Visit the Floor node


    public
                    visitFloor(Floor $node) : string

Parameters

$node : Floor: the node

Return values

string —

the SQL string

visitFormat()

Visit the Format node


    public
                    visitFormat(Format $node) : string

Parameters

$node : Format: the node

Return values

string —

the SQL string

visitFormatDate()

Visit the FormatDate node


    public
                    visitFormatDate(FormatDate $node) : string

Parameters

$node : FormatDate: the node

Return values

string —

the SQL string

visitFunctionCall()

Visit the FunctionCall node


    public
                    visitFunctionCall(FunctionCall $node) : string

Parameters

$node : FunctionCall: the node

Return values

string —

the SQL string

visitGreaterOrEqualOperator()

Visit the GreaterOrEqualOperator node


    public
                    visitGreaterOrEqualOperator(GreaterOrEqualOperator $node) : string

Parameters

$node : GreaterOrEqualOperator: the node

Return values

string —

the SQL string

visitGreaterThanOperator()

Visit the GreaterThanOperator node


    public
                    visitGreaterThanOperator(GreaterThanOperator $node) : string

Parameters

$node : GreaterThanOperator: the node

Return values

string —

the SQL string

visitGroupConcatFunction()

Visit the GroupConcatFunction node


    public
                    visitGroupConcatFunction(GroupConcatFunction $node) : string

Parameters

$node : GroupConcatFunction: the node

Return values

string —

the SQL string

visitGrouping()

Visit the Grouping node


    public
                    visitGrouping(Grouping $node) : string

Parameters

$node : Grouping: the node

Return values

string —

the SQL string

visitInfix()


    public
                    visitInfix(mixed $node, mixed $operator) : mixed

Parameters

$node : mixed
$operator : mixed

visitInOperator()

Visit the InOperator node


    public
                    visitInOperator(InOperator $node) : string

Parameters

$node : InOperator: the node

Return values

string —

the SQL string

visitInsertStatement()

Visit the InsertStatement node


    public
                    visitInsertStatement(InsertStatement $node) : string

Parameters

$node : InsertStatement: the node

Return values

string —

the SQL string

visitIsNotNullOperator()

Visit the IsNotNullOperator node


    public
                    visitIsNotNullOperator(IsNotNullOperator $node) : string

Parameters

$node : IsNotNullOperator: the node

Return values

string —

the SQL string

visitIsNullOperator()

Visit the IsNullOperator node


    public
                    visitIsNullOperator(IsNullOperator $node) : string

Parameters

$node : IsNullOperator: the node

Return values

string —

the SQL string

visitJoinClause()

Visit the JoinClause node


    public
                    visitJoinClause(JoinClause $node) : string

Parameters

$node : JoinClause: the node

Return values

string —

the SQL string

visitJsonGet()

Visit the JsonGet node


    public
                    visitJsonGet(JsonGet $node) : string

Parameters

$node : JsonGet: the node

Return values

string —

the SQL string

visitJsonGroup()

Visit the JsonGroup node


    public
                    visitJsonGroup(JsonGroup $node) : mixed

Parameters

$node : JsonGroup: the node

Return values

mixed —

the SQL string

visitJsonNode()

Visit the JsonNode node


    public
                    visitJsonNode(JsonNode $node) : string

Parameters

$node : JsonNode: the node

Return values

string —

the SQL string

visitLastValue()

Visit the FirstValue node


    public
                    visitLastValue(FirstValue $node) : string

Parameters

$node : FirstValue: the node

Return values

string —

the SQL string

visitLengthOperator()

Visit the LengthOperator node


    public
                    visitLengthOperator(LengthOperator $node) : string

Parameters

$node : LengthOperator: the node

Return values

string —

the SQL string

visitLesserOrEqualOperator()

Visit the LesserOrEqualOperator node


    public
                    visitLesserOrEqualOperator(LesserOrEqualOperator $node) : string

Parameters

$node : LesserOrEqualOperator: the node

Return values

string —

the SQL string

visitLesserThanOperator()

Visit the LesserThanOperator node


    public
                    visitLesserThanOperator(LesserThanOperator $node) : string

Parameters

$node : LesserThanOperator: the node

Return values

string —

the SQL string

visitLiteral()

Visit the Literal node


    public
                    visitLiteral(Literal $node) : string

Parameters

$node : Literal: the node

Return values

string —

the SQL string

visitLocate()


    public
                    visitLocate(mixed $node) : mixed

Parameters

$node : mixed

visitLog()

Visit the Log node


    public
                    visitLog(Log $node) : string

Parameters

$node : Log: the node

Return values

string —

the SQL string

visitLower()

Visit the Lower node


    public
                    visitLower(Lower $node) : string

Parameters

$node : Lower: the node

Return values

string —

the SQL string

visitMatchOperator()

Visit the MatchOperator node


    public
                    visitMatchOperator(MatchOperator $node) : string

Parameters

$node : MatchOperator: the node

Return values

string —

the SQL string

visitMaximumFunction()

Visit the MaximumFunction node


    public
                    visitMaximumFunction(MaximumFunction $node) : string

Parameters

$node : MaximumFunction: the node

Return values

string —

the SQL string

visitMinimumFunction()

Visit the MinimumFunction node


    public
                    visitMinimumFunction(MinimumFunction $node) : string

Parameters

$node : MinimumFunction: the node

Return values

string —

the SQL string

visitMulOperator()

Visit the MulOperator node


    public
                    visitMulOperator(MulOperator $node) : string

Parameters

$node : MulOperator: the node

Return values

string —

the SQL string

visitNamedFn()

Visit the NamedFunction


    public
                    visitNamedFn(NamedFunction $node) : string

Parameters

$node : NamedFunction: the node

Return values

string —

the SQL string

visitNotEqualityOperator()

Visit the NotEqualityOperator node


    public
                    visitNotEqualityOperator(NotEqualityOperator $node) : string

Parameters

$node : NotEqualityOperator: the node

Return values

string —

the SQL string

visitNotInOperator()

Visit the NotInOperator node


    public
                    visitNotInOperator(NotInOperator $node) : string

Parameters

$node : NotInOperator: the node

Return values

string —

the SQL string

visitNotMatchOperator()

Visit the NotMatchOperator node


    public
                    visitNotMatchOperator(NotMatchOperator $node) : string

Parameters

$node : NotMatchOperator: the node

Return values

string —

the SQL string

visitNotOperator()

Visit the NotOperator node


    public
                    visitNotOperator(NotOperator $node) : string

Parameters

$node : NotOperator: the node

Return values

string —

the SQL string

visitOrOperator()

Visit the OrOperator node


    public
                    visitOrOperator(OrOperator $node) : string

Parameters

$node : OrOperator: the node

Return values

string —

the SQL string

visitOverClause()

Visit the OVER clause node


    public
                    visitOverClause(mixed $node) : string

Parameters

$node : mixed

Return values

string

visitPow()

Visit the Pow node


    public
                    visitPow(Pow $node) : string

Parameters

$node : Pow: the node

Return values

string —

the SQL string

visitRegexInstr()

Visit the RegexInstr node


    public
                    visitRegexInstr(RegexInstr $node) : string

Parameters

$node : RegexInstr: the node

Return values

string —

the SQL string

visitRegexMatchOperator()

Visit the RegexMatchOperator node


    public
                    visitRegexMatchOperator(RegexMatchOperator $node) : string

Parameters

$node : RegexMatchOperator: the node

Return values

string —

the SQL string

visitRegexReplace()

Visit the RegexReplace node


    public
                    visitRegexReplace(RegexReplace $node) : string

Parameters

$node : RegexReplace: the node

Return values

string —

the SQL string

visitRegexReplaceFunction()

Visit the RegexReplaceFunction node


    public
                    visitRegexReplaceFunction(RegexReplaceFunction $node) : string

Parameters

$node : RegexReplaceFunction: the node

Return values

string —

the SQL string

visitRegexSubstr()

Visit the RegexSubStrFunction node


    public
                    visitRegexSubstr(RegexSubStrFunction $node) : string

Parameters

$node : RegexSubStrFunction: the node

Return values

string —

the SQL string

visitRepeat()


    public
                    visitRepeat(mixed $node) : mixed

Parameters

$node : mixed

visitReplace()

Visit the Replace node


    public
                    visitReplace(mixed $node) : string

Parameters

$node : mixed: the node

Return values

string —

the SQL string

visitSelectStatement()

Visit the SelectStatement node


    public
                    visitSelectStatement(SelectStatement $node) : string

Parameters

$node : SelectStatement: the node

Return values

string —

the SQL string

visitSubOperator()

Visit the SubOperator node


    public
                    visitSubOperator(SubOperator $node) : string

Parameters

$node : SubOperator: the node

Return values

string —

the SQL string

visitSubstring()

Visit the Substring node


    public
                    visitSubstring(Substring $node) : string

Parameters

$node : Substring: the node

Return values

string —

the SQL string

visitSumFunction()

Visit the SumFunction node


    public
                    visitSumFunction(SumFunction $node) : string

Parameters

$node : SumFunction: the node

Return values

string —

the SQL string

visitTable()

Visit the Table node


    public
                    visitTable(Table $node) : string

Parameters

$node : Table: the node

Return values

string —

the SQL string

visitTrim()

Visit the Trim node


    public
                    visitTrim(Trim $node) : string

Parameters

$node : Trim: the node

Return values

string —

the SQL string

visitTruncateStatement()

Visit the Truncate statement


    public
                    visitTruncateStatement(mixed $node) : string

Parameters

$node : mixed

Return values

string

visitTypeOption()


    public
                    visitTypeOption(Type $type, array<string|int, mixed> $options) : mixed

Parameters

$type : Type
$options : array<string|int, mixed>

visitUnion()

visit the Union node


    public
                    visitUnion(Union $node) : string

Parameters

$node : Union

Return values

string —

the SQL string

visitUpdateStatement()

Visit the UpdateStatement node


    public
                    visitUpdateStatement(UpdateStatement $node) : string

Parameters

$node : UpdateStatement: the node

Return values

string —

the SQL string

visitUpper()

Visit the Upper node


    public
                    visitUpper(Upper $node) : string

Parameters

$node : Upper: the node

Return values

string —

the SQL string

convertFormatTimeToSQL()


    protected
                    convertFormatTimeToSQL(string $time, array<string|int, mixed> $dateMapping) : string

Parameters

$time : string
$dateMapping : array<string|int, mixed>

Return values

string

MySqlVisitor extends ToSqlVisitor in package Application

Table of Contents

Properties

Methods

Properties

$charset

$columnQuote

$dateMapping

$tableQuote

Methods

__construct()

jsonValue()

Parameters

visit()

Parameters

visitAbs()

Parameters

visitAddOperator()

Parameters

Return values

visitAliasOperator()

Parameters

Return values

visitAlterStatement()

Parameters

Return values

visitAndOperator()

Parameters

Return values

visitArrayJoin()

Parameters

visitAscOperator()

Parameters

Return values

visitAverageFunction()

Parameters

Return values

visitCaseNode()

Parameters

Return values

visitCast()

Parameters

Return values

visitCoalesce()

Parameters

Return values

visitCollate()

Parameters

Return values

visitCollateMatch()

Parameters

Return values

visitColumn()

Parameters

Return values

visitColumnType()

Parameters

Return values

visitCommentStatement()

Parameters

Return values

visitConcatOperator()

Parameters

Return values

visitConstraint()

Parameters

Return values

visitCountFunction()

Parameters

Return values

visitCreateStatement()

Parameters

Return values

visitDateAddOperator()

Parameters

Return values

visitDateDuration()

Parameters

Return values

visitDateSubPart()

MySqlVisitor extends ToSqlVisitor
in package

Application