sqlite

SQLite

This is a no CGO sqlite driver for GOE ORM based on https://pkg.go.dev/modernc.org/sqlite.

Features

• 🪝 Connection Hook
• 🧪 In Memory Database

Usage

Basic

package main

import (
	"github.com/azhai/goent"
	"github.com/azhai/goent/drivers/sqlite"
)

type User struct {
	ID    int
	Name  string
	Email string `goe:"unique"`
}

type Database struct {
	User *User
	*goent.DB
}

func main() {
	logger := slog.New(slog.NewTextHandler(os.Stdout, nil))
	cfg := sqlite.NewConfig(sqlite.Config{
		Logger: logger, IncludeArguments: true,
	})
	db, err := goent.Open[Database](sqlite.Open("goent.db", cfg))
}

Connection Hook

package main

import (
	"github.com/azhai/goent"
	"github.com/azhai/goent/drivers/sqlite"
)

type User struct {
	ID    int
	Name  string
	Email string `goe:"unique"`
}

type Database struct {
	User *User
	*goent.DB
}

func main() {
	db, err := goent.Open[Database](sqlite.Open(filepath.Join(os.TempDir(), "goent.db"), sqlite.NewConfig(
		sqlite.Config{
			ConnectionHook: func(conn sqlite.ExecQuerierContext, dsn string) error {
				conn.ExecContext(context.Background(), "PRAGMA foreign_keys = OFF;", nil)
				return nil
			},
		},
	)))
}

In Memory Database

package main

import (
	"github.com/azhai/goent"
	"github.com/azhai/goent/drivers/sqlite"
)

type User struct {
	ID    int
	Name  string
	Email string `goe:"unique"`
}

type Database struct {
	User *User
	*goent.DB
}

func main() {
	cfg := sqlite.NewConfig(sqlite.Config{})
	db, err := goent.Open[Database](sqlite.OpenInMemory(cfg))
}