-
- GitHub
- GitLab
- Bitbucket
-
By logging in you accept
our terms of service
and privacy policy
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://gitea.com/MadX/xorm/docs
go get gitea.com/MadX/xorm
The Tidelift Subscription provides access to a continuously curated stream of human-researched and maintainer-verified data on open source packages and their licenses, releases, vulnerabilities, and development practices.
Learn more →Login to resync this project