Skip to content
Branch: master
Find file Copy path
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
75 lines (58 sloc) 1.8 KB
// Package main shows how an orm can be used within your web app
// it just inserts a column and select the first.
package main
import (
_ ""
go get -u
go get -u
If you're on win64 and you can't install go-sqlite3:
1. Download:
2. Select "x86_x64" and "posix"
3. Add C:\Program Files\mingw-w64\x86_64-7.1.0-posix-seh-rt_v5-rev1\mingw64\bin
to your PATH env variable.
// User is our user table structure.
type User struct {
ID int64 // auto-increment by-default by xorm
Version string `xorm:"varchar(200)"`
Salt string
Username string
Password string `xorm:"varchar(200)"`
Languages string `xorm:"varchar(200)"`
CreatedAt time.Time `xorm:"created"`
UpdatedAt time.Time `xorm:"updated"`
func main() {
app := iris.New()
orm, err := xorm.NewEngine("sqlite3", "./test.db")
if err != nil {
app.Logger().Fatalf("orm failed to initialized: %v", err)
iris.RegisterOnInterrupt(func() {
err = orm.Sync2(new(User))
if err != nil {
app.Logger().Fatalf("orm failed to initialized User table: %v", err)
app.Get("/insert", func(ctx iris.Context) {
user := &User{Username: "kataras", Salt: "hash---", Password: "hashed", CreatedAt: time.Now(), UpdatedAt: time.Now()}
ctx.Writef("user inserted: %#v", user)
app.Get("/get", func(ctx iris.Context) {
user := User{ID: 1}
if ok, _ := orm.Get(&user); ok {
ctx.Writef("user found: %#v", user)
// http://localhost:8080/insert
// http://localhost:8080/get
app.Run(iris.Addr(":8080"), iris.WithoutServerError(iris.ErrServerClosed))
You can’t perform that action at this time.