Function main

_examples/database/orm/sqlx/main.go:39–113

()

);`

func main() {
	app := iris.New()

	db, err := sqlx.Connect("sqlite3", "./test.db")
	if err != nil {
		app.Logger().Fatalf("db failed to initialized: %v", err)
	}
	iris.RegisterOnInterrupt(func() {
		db.Close()
	})

	db.MustExec(schema)

	app.Get("/insert", func(ctx iris.Context) {
		res, err := db.NamedExec(`INSERT INTO person (first_name,last_name,email) VALUES (:first,:last,:email)`,
			map[string]interface{}{
				"first": "John",
				"last":  "Doe",
				"email": "johndoe@example.com",
			})

		if err != nil {
			// Note: on production, don't give the error back to the user.
			// However for the sake of the example we do:
			ctx.StopWithError(iris.StatusInternalServerError, err)
			return
		}

		id, err := res.LastInsertId()
		if err != nil {
			ctx.StopWithError(iris.StatusInternalServerError, err)
			return
		}

		ctx.Writef("person inserted: id: %d", id)
	})

	app.Get("/get", func(ctx iris.Context) {
		// Select all persons.
		people := []Person{}
		db.Select(&people, "SELECT * FROM person ORDER BY first_name ASC")
		if err != nil {
			ctx.StopWithError(iris.StatusInternalServerError, err)
			return
		}

		if len(people) == 0 {
			ctx.Writef("no persons found, use /insert first.")
			return
		}

		ctx.Writef("persons found: %#v", people)
		/* Select a single or more with a first name of John from the database:
		person := Person{FirstName: "John"}
		rows, err := db.NamedQuery(`SELECT * FROM person WHERE first_name=:first_name`, person)
		if err != nil { ... }
		defer rows.Close()
		for rows.Next() {