Need help with sqlingo?
Click the “chat” button below for chat support from the developer who created it, or find similar developers for support.

About the developer

lqs
137 Stars 10 Forks MIT License 151 Commits 0 Opened issues

Description

💥 A lightweight DSL & ORM which helps you to write SQL in Go.

Services available

!
?

Need anything else?

Contributors list

# 197,586
C
Shell
hls
m3u8
142 commits

Mentioned in Awesome Go go.dev Travis CI Go Report Card codecov MIT license last commit

sqlingo is a SQL DSL (a.k.a. SQL Builder or ORM) library in Go. It generates code from the database and lets you write SQL queries in an elegant way.

Features

  • Auto-generating DSL objects and model structs from the database so you don't need to manually keep things in sync
  • SQL DML (SELECT / INSERT / UPDATE / DELETE) with some advanced SQL query syntaxes
  • Many common errors could be detected at compile time
  • Your can use the features in your editor / IDE, such as autocompleting the fields and queries, or finding the usage of a field or a table
  • Context support
  • Transaction support
  • Interceptor support

Database Support Status

| Database | Status | ------------- | -------------- | MySQL | stable | | PostgreSQL | experimental | | SQLite | experimental |

Tutorial

Install and use sqlingo code generator

The first step is to generate code from the database. In order to generate code, sqlingo requires your tables are already created in the database.

$ go get -u github.com/lqs/sqlingo/sqlingo-gen-mysql
$ mkdir -p generated/sqlingo
$ sqlingo-gen-mysql root:[email protected]/database_name >generated/sqlingo/database_name.dsl.go

Write your application

Here's a demonstration of some simple & advanced usage of sqlingo. ```go package main

import ( "github.com/lqs/sqlingo" . "./generated/sqlingo" )

func main() { db, err := sqlingo.Open("mysql", "root:[email protected]/database_name") if err != nil { panic(err) }

// a simple query
var customers []*CustomerModel
db.SelectFrom(Customer).
    Where(Customer.Id.In(1, 2)).
    OrderBy(Customer.Name.Desc()).
    FetchAll(&customers)

// query from multiple tables var customerId int64 var orderId int64 err = db.Select(Customer.Id, Order.Id). From(Customer, Order). Where(Customer.Id.Equals(Order.CustomerId), Order.Id.Equals(1)). FetchFirst(&customerId, &orderId)

// subquery and count count, err := db.SelectFrom(Order) Where(Order.CustomerId.In(db.Select(Customer.Id). From(Customer). Where(Customer.Name.Equals("Customer One")))). Count()

// group-by with auto conversion to map var customerIdToOrderCount map[int64]int64 err = db.Select(Order.CustomerId, f.Count(1)). From(Order). GroupBy(Order.CustomerId). FetchAll(&customerIdToOrderCount) if err != nil { println(err) }

// insert some rows customer1 := &CustomerModel{name: "Customer One"} customer2 := &CustomerModel{name: "Customer Two"} _, err = db.InsertInto(Customer). Models(customer1, customer2). Execute()

// insert with on-duplicate-key-update _, err = db.InsertInto(Customer). Fields(Customer.Id, Customer.Name). Values(42, "Universe"). OnDuplicateKeyUpdate(). Set(Customer.Name, Customer.Name.Concat(" 2")). Execute()

} ```

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.