fwidjaya20 / goloquent Goto Github PK

-- Insert data doesn't returning any data, only sql.result

Change generated QUERY into Named Query

Provide executor for:

• DeleteMany by PrimaryKey
• BulkDelete by Array of Model object

The where methods will compare the column against a value:

• Where
• OrWhere

The whereIn method verifies that a given column's value is contained within the given array:

• WhereIn
• OrWhereIn

The whereNotIn method verifies that the given column's value is not contained in the given array:

• Except
• OrWhereExcept

The whereBetween method verifies that a column's value is between two values:

• WhereBetween
• OrWhereBetween

The whereNotBetween method verifies that a column's value lies outside of two values:

• WhereNotBetween
• OrWhereNotBetween

The whereNull method verifies that the value of the given column is NULL:

• WhereNull
• OrWhereNull

The whereNotNull method verifies that the value of the given column is NOT NULL:

• WhereNotNull
• OrWhereNotNull

The whereColumn method may be used to verify that two columns are equal:

• WhereColumn
• OrWhereColumn

The orderBy method allows you to sort the result of the query by a given column.
The first argument to the orderBy method should be the column you wish to sort by, while the second argument controls the direction of the sort and may be either asc or desc:

• OrderBy

The groupBy and having methods may be used to group the query results.
The having method's signature is similar to that of the where method:

• GroupBy
• Having

To limit the number of results returned from the query, or to skip a given number of results in the query, you may use the skip and take methods:

• Skip
• Take

The query builder may also be used to write join statements. To perform a basic "inner join", "left join", "right join", "full outer join", you may use the join method on a query builder instance.
The first argument passed to the join method is the name of the table you need to join to, while the remaining arguments specify the column constraints for the join.
You can even join to multiple tables in a single query:

• Join
• LeftJoin
• RightJoin
• FullOuterJoin

The query builder also provides a quick way to "union" two queries together. For example, you may create an initial query and use the union method to union it with a second query:

• Union

Require:

• Aggregate
• Binding
• Builder
• Column
• Condition
• Model
• Query
• Reference
• Schema

Required:

• Count
• Max
• Min
• Sum
• Avg

Missing Method

• First() -> retrieve first record of data
• All() -> retrieve all record of data
• Paginate() -> retrieve record based on given limit & offset