SQL Package

And creates a new clause with operator `AND`.

Between creates a new clause that checks if a field is between two values.

Count counts the number of records from the database.

DecryptEq creates a new clause with operator `=` and the value decrypted.

DecryptIn creates a new clause with operator `IN` and the values decrypted.

DecryptLike creates a new clause with operator `LIKE` and the value decrypted.

DecryptNeq creates a new clause with operator `<>` and the value decrypted.

DecryptNotIn creates a new clause with operator `NOT IN` and the values decrypted.

DecryptNotLike creates a new clause with operator `NOT LIKE` and the value decrypted.

DecryptNotSimilar creates a new clause with operator "NOT LIKE" and the value "%value%" decrypted.

DecryptSimilar creates a new clause with operator "LIKE" and the value "%value%" decrypted.

Delete deletes a record from the database.

DeleteAll deletes all records from the database.

DeleteBy deletes records from the database by a clause.

Eq creates a new clause with operator `=`.

FindAll finds all records from the database.

FindAllComplex finds all records from the database with pagination and sorting.

FindOne finds one record from the database.

Gt creates a new clause with operator `>`.

Gte creates a new clause with operator `>=`.

In creates a new clause with operator `IN`.

IsNotNull creates a new clause with operator `IS NOT NULL`.

IsNull creates a new clause with operator `IS NULL`.

Like creates a new clause with operator `LIKE`.

Lt creates a new clause with operator `<`.

Lte creates a new clause with operator `<=`.

MySQL connects to a MySQL database and returns a gorm.DB object.

Neq creates a new clause with operator `<>`.

NotBetween creates a new clause that checks if a field is not between two values.

NotIn creates a new clause with operator `NOT IN`.

NotLike creates a new clause with operator `NOT LIKE`.

NotSimilar creates a new clause with operator "NOT LIKE" and the value "%value%".

Or creates a new clause with operator `OR`.

Paginate creates a new *Pagination.

Save saves a record to the database.

SaveAll saves all records to the database.

SetEncryptKey sets the encryption key for the database.

Similar creates a new clause with operator "LIKE" and the value "%value%".

Sort creates a new *Sorting.

Sqlite connects to a SQLite database and returns a gorm.DB object.

SqliteMem connects to a SQLite database in memory and returns a gorm.DB object.