Package Usage: go: xorm.io/xorm
Package xorm is a simple and powerful ORM for Go.
Make sure you have installed Go 1.11+ and then:
Firstly, we should create an engine for a database
Method NewEngine's parameters are the same as sql.Open which depend drivers' implementation.
Generally, one engine for an application is enough. You can define it as a package variable.
XORM supports raw SQL execution:
1. query with a SQL string, the returned results is []map[string][]byte
2. query with a SQL string, the returned results is []map[string]string
3. query with a SQL string, the returned results is []map[string]interface{}
4. execute with a SQL string, the returned results
There are 8 major ORM methods and many helpful methods to use to operate database.
1. Insert one or multiple records to database
2. Query one record or one variable from database
3. Query multiple records from database
4. Query multiple records and record by record handle, there two methods, one is Iterate,
another is Rows
or
5. Update one or more records
6. Delete one or more records, Delete MUST has condition
7. Count records
8. Sum records
The above 8 methods could use with condition methods chainable.
Notice: the above 8 methods should be the last chainable method.
1. ID, In
2. Where, And, Or
3. OrderBy, Asc, Desc
4. Limit, Top
5. SQL, let you custom SQL
6. Cols, Omit, Distinct
7. Join, GroupBy, Having
xorm could work with xorm.io/builder directly.
1. With Where
2. With In
3. With Join
4. With SetExprs
5. With SQL
6. With Query
7. With Exec
More usage, please visit http://xorm.io/docs
69 versions
Latest release: over 1 year ago
975 dependent packages
View more package details: https://packages.ecosystem.code.gouv.fr/registries/proxy.golang.org/packages/xorm.io/xorm