Support upsert and insert ignore

mssql

Microsoft SQL Server adapter for REL.

Example

package main

import (
	"context"

	_ "github.com/microsoft/go-mssqldb"
	"github.com/go-rel/mssql"
	"github.com/go-rel/rel"
)

func main() {
	// open mssql connection.
	adapter, err := mssql.Open("sqlserver://sa:REL2021-mssql@localhost:1433?database=rel")
	if err != nil {
		panic(err)
	}
	defer adapter.Close()

	// initialize REL's repo.
	repo := rel.New(adapter)
	repo.Ping(context.TODO())
}

Supported Driver

github.com/microsoft/go-mssqldb
github.com/denisenkom/go-mssqldb

Supported Database

Microsoft SQL Server 2017
Microsoft SQL Server 2019

Testing

Start Microsoft SQL server in Docker

docker run -it --rm -p 1434:1433 -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=REL2021-mssql" -e "MSSQL_PID=Developer"  mcr.microsoft.com/mssql/server:2019-latest

Run tests

MSSQL_DATABASE="sqlserver://sa:REL2021-mssql@localhost:1434" go test ./...

	case rel.String:
	typ = "VARCHAR"
	m = column.Limit
	if m == 0 {
	m = 255
	}

go-rel / mssql Goto Github PK

mssql's Introduction

mssql

Example

Supported Driver

Supported Database

Testing

Start Microsoft SQL server in Docker

Run tests

mssql's People

Contributors

Stargazers

Watchers

Forkers

mssql's Issues

Recommend Projects

Recommend Topics

Recommend Org