GorosePro(Go ORM),这个版本是Gorose的专业版

Related tags

ORM gorose-pro
Overview

GoRose-Pro for Commercial(专业版)

GoDoc Go Report Card GitHub release Gitter GitHub GitHub All Releases gorose-orm

 ██████╗  ██████╗ ██████╗  ██████╗ ███████╗███████╗    ██████╗ ██████╗  ██████╗ 
██╔════╝ ██╔═══██╗██╔══██╗██╔═══██╗██╔════╝██╔════╝    ██╔══██╗██╔══██╗██╔═══██╗
██║  ███╗██║   ██║██████╔╝██║   ██║███████╗█████╗█████╗██████╔╝██████╔╝██║   ██║
██║   ██║██║   ██║██╔══██╗██║   ██║╚════██║██╔══╝╚════╝██╔═══╝ ██╔══██╗██║   ██║
╚██████╔╝╚██████╔╝██║  ██║╚██████╔╝███████║███████╗    ██║     ██║  ██║╚██████╔╝
 ╚═════╝  ╚═════╝ ╚═╝  ╚═╝ ╚═════╝ ╚══════╝╚══════╝    ╚═╝     ╚═╝  ╚═╝ ╚═════╝ 

原版和Pro版本区别(原版没有的功能)+(猜你关心)

  • 更加适合ThinkPHP开发人员
  • 增加Nested Transaction也就是嵌套事务或者事务嵌套,目前在仿TPORM方面唯一一个支持NT功能的框架
  • 缓存支持,原版本功能已经放弃开发,本版在这个部分会使用Redis模块来支持,但是当前功能建议大家使用TuuzGoWeb来解决缓存问题
  • 对新特性支持快,replace/nested transaction只要你想它有它就能有
  • 去v2后缀,go get -u 直接升级,引入模块无需加v2后缀
  • 优先支持MySQL和MariaDB,相信90%用这个框架做商业项目的开发者都是用这两个
  • 项目文档示例支援丰富,配合NT支援,让你可以像写ThinkPHP/Laraval那样写Gorose-Pro

本项目目的

  • 本人是从PHP转过来的,至今所有项目除了AOSS项目,其他的能公开的不能公开的项目均已经切换到Golang
  • Gorose数据库框架是从我开始写Golang起就一直用的一个框架
  • 在不停写项目的过程中,我逐渐发现框架的健壮以及它所存在的不足,有些功能上的不足严重到到我不得不修它,于是才有了Pro版
  • 不想造轮子,但是向源项目PR周期太长了,一个NT功能我从第一版更新到最后一版已经半年了,做项目哪里等得起这么修哦?每次都要用replace在gomod里面替换不如我自己维护一个branch,说不定还能造福其他的小伙伴
  • 本框架我和原作者聊过了,可以发Branch,另外我名字也依然保留叫Gorose只是在后面加Pro
  • 原框架作者可能要等1.18做更新了,而且如果泛型没有性能优化,我觉得现在这种使用模式还挺方便的

修缮保证

  • 只要是我自己做项目遇到的Bug,我会小心求证后发版,新功能不会影响老功能
  • 原作者修的故障点,我这边会平移更新过来,请大家放心

故障修复/更新

  • 修复了单db连接下,where等参数的的脏数据问题(这个问题原版目前1年了依旧暂未修复,v1.2.7已修复)

文档

如下的开发实例我已经在自己的项目和多个商业项目中跑过了,代码上没有问题,在书写或者思想上如果和你有冲突你可以用你自己的模式来,这里只是给刚玩的朋友准备的

文档开发实例1

简介

gorose for Tuuz版是我从飞哥接手过来的项目,知道人家更新了好几版然后可能有点没兴趣了,但是我是做项目的 很多时候如果原作者不更新,我项目中有很多麻烦事都没办法解决,所以很无奈只能继续扛旗向前走了

因为原版框架已经很优秀了,所以这里只会做一些更新,在架构上不会做出大调整(如果大家满意这个Pro版,请Star)

安装

  • go.mod 中添加
require github.com/tobycroft/gorose-pro v1.2.5
  • go get
go get -u github.com/tobycroft/gorose-pro

支持驱动

api预览(详情请参阅文档,或如下演示)

文档开发实例3

db.Table("table_name").Fields().Where().GroupBy().Having().OrderBy().Limit().Select()
db.Table(&ModelStruct).Data().Replace()
db.Table(&ModelStruct).Data().Insert()
db.Table(....).Data().Where().Update()
db.Table(....).Where().Delete()

Thinkphp模式用法示例

package main

import (
    "github.com/tobycroft/gorose-pro"
)

func dsn() string {
    dbname := "GobotQ2"
    dbuser := "GobotQ"
    dbpass := "123456"
    dbhost := "10.0.0.170"
    conntype := "tcp"
    dbport := "3306"
    charset := "utf8mb4"
    return dbuser + ":" + dbpass + "@" + conntype + "(" + dbhost + ":" + dbport + ")/" + dbname + "?charset=" + charset + "&parseTime=true"
}

func DbConfig() *gorose.Config {
    var conf gorose.Config
    conf.Driver = "mysql"
    conf.SetMaxIdleConns = 90
    conf.SetMaxOpenConns = 300
    conf.Prefix = ""
    conf.Dsn = dsn()
    return &conf
}

func init() {
    var err error
    Database, err = gorose.Open(DbConfig())
    if err != nil {
        log.Panic(err)
    }
}

func DB() gorose.IOrm {
    return database.Database.NewOrm()
}

//这里是Model层,Model采用单例模式

//增
func Api_insert(qq, token, ip interface{}) bool {
    db := tuuz.Db().Table(table)
    data := map[string]interface{}{
        "qq":    qq,
        "token": token,
        "ip":    ip,
    }
    db.Data(data)
    _, err := db.Insert()
	//_, err := db.Replace()也可以使用replace方法,看你个人
    if err != nil {
        Log.Dbrr(err, tuuz.FUNCTION_ALL())
        return false
    } else {
        return true
    }
}

//删
func Api_delete_byToken(qq, token interface{}) bool {
    db := tuuz.Db().Table(table)
    where := map[string]interface{}{
        "qq":    qq,
        "token": token,
    }
    db.Where(where)
    _, err := db.Delete()
    if err != nil {
        Log.Dbrr(err, tuuz.FUNCTION_ALL())
        return false
    } else {
        return true
    }
}

//修改
func Api_update_password(qq, password interface{}) bool {
    db := tuuz.Db().Table(table)
    where := map[string]interface{}{
        "qq": qq,
    }
    db.Where(where)
    data := map[string]interface{}{
        "password": password,
    }
    db.Data(data)
    _, err := db.Update()
    if err != nil {
        Log.Dbrr(err, tuuz.FUNCTION_ALL())
        return false
    } else {
        return true
    }
}

//查询单条
func Api_find(qq interface{}) gorose.Data {
    db := tuuz.Db().Table(table)
    where := map[string]interface{}{
        "qq": qq,
    }
    db.Where(where)
    ret, err := db.First()
    if err != nil {
        Log.Dbrr(err, tuuz.FUNCTION_ALL())
        return nil
    } else {
        return ret
    }
}

//查询多条
func Api_select(qq interface{}) []gorose.Data {
    db := tuuz.Db().Table(table)
    where := map[string]interface{}{
        "qq": qq,
    }
    db.Where(where)
    ret, err := db.Get()
    if err != nil {
        Log.Dbrr(err, tuuz.FUNCTION_ALL())
        return nil
    } else {
        return ret
    }
}

使用建议

如果你的数据返回处理比较复杂,并且是“Long Term”项目,这里建议用原版Gorose方法处理,因为我大多数是外包项目, Thinkphp类似的操作方法可以大大降低编码复杂性,性能上并不会差太多,请放心

单例模式极好理解,你可以使用我的方式来解耦,或者也可以使用你自己喜欢的方式

配置和链接初始化

简单配置DSN

var conf gorose.Config
conf.Driver = "mysql"
conf.SetMaxIdleConns = 90
conf.SetMaxOpenConns = 300
conf.Prefix = ""
conf.Dsn = dsn()
return &conf

更多配置, 可以配置集群,甚至可以同时配置不同数据库在一个集群中, 数据库会随机选择集群的数据库来完成对应的读写操作, 其中master是写库, slave是读库, 需要自己做好主从复制, 这里只负责读写

var config1 = gorose.Config{Dsn: 上面的dsn}
var config2 = gorose.Config{Dsn:  上面的dsn}
var config3 = gorose.Config{Dsn:  上面的dsn}
var config4 = gorose.Config{Dsn:  上面的dsn}
var configCluster = &gorose.ConfigCluster{
    Master:  []gorose.Config{config3, config4},
    Slave: []gorose.Config{config1, config2},
    Driver: "sqlite3",
}

初始化使用

var engin *gorose.Engin
engin, err := Open(config)
//engin, err := Open(configCluster)

if err != nil {
    panic(err.Error())
}

这里跳过原生操作,如果你喜欢这么操作,你也不会来用这个框架,这个框架就是简单方便, 自动化没那么多JJYY的规矩,只要你会写Thinkphp或者Laravel,你就可以按照自己的编程习惯来开发, 这一点上我和原作者想法是相同的

故障排查

  • Gorose存在很多问题,有些问题你可能会遇到,下面列出:
    • 请尽量不要使用框架的主从模式,无论是TP还是Gorose,他能提供的稳定性,一定是不如你直接去买RDS之类的产品的,不要试图在该花钱的时候省钱
    • 出现锁机制:如果出现锁机制,排查起来请先看慢查询,正常如果时间太长,如果你恰好使用的是我推荐的书写模式,你就能定位超时点,对超时点进行分析即可,老版本在长期使用中确实有出现锁的问题,新版目前没有出现,但是也请大家注意,如果出现了,重启数据库即可解决,如果你对这个功能很不放心,你也可以不使用嵌套查询解决

Stargazers over time

Stargazers over time

Releases(v1.2.9)
Owner
火线兔
My name is Tuuz a Full Stack E. Got busy all the time
火线兔
Using-orm-with-db - Trying to use ORM to work with PostgreSQL

Using ORM with db This repo contains the training (rough) code, and possibly not

Pavel V 2 Jan 6, 2022
beedb is a go ORM,support database/sql interface,pq/mysql/sqlite

Beedb ❗ IMPORTANT: Beedb is being deprecated in favor of Beego.orm ❗ Beedb is an ORM for Go. It lets you map Go structs to tables in a database. It's

astaxie 709 Mar 8, 2022
A simple wrapper around sql.DB to help with structs. Not quite an ORM.

go-modeldb A simple wrapper around sql.DB to help with structs. Not quite an ORM. Philosophy: Don't make an ORM Example: // Setup require "modeldb" db

Jae Kwon 17 Nov 16, 2019
ORM-ish library for Go

We've moved! gorp is now officially maintained at: https://github.com/go-gorp/gorp This fork was created when the project was moved, and is provided f

James Cooper 53 Nov 22, 2021
Simple Go ORM for Google/Firebase Cloud Firestore

go-firestorm Go ORM (Object-relational mapping) for Google Cloud Firestore. Goals Easy to use Non intrusive Non exclusive Fast Features Basic CRUD ope

Jens Kjær Schødt 28 May 8, 2022
Database agnostic ORM for Go

If you are looking for something more lightweight and flexible, have a look at jet For questions, suggestions and general topics visit the group. Inde

Erik Aigner 693 May 6, 2022
QBS stands for Query By Struct. A Go ORM.

Qbs Qbs stands for Query By Struct. A Go ORM. 中文版 README ChangeLog 2013.03.14: index name has changed to {table name}_{column name}. For existing appl

Evan Zhou 548 May 1, 2022
Generate a Go ORM tailored to your database schema.

SQLBoiler is a tool to generate a Go ORM tailored to your database schema. It is a "database-first" ORM as opposed to "code-first" (like gorm/gorp). T

Volatile Technologies Inc. 4.9k May 12, 2022
Simple and Powerful ORM for Go, support mysql,postgres,tidb,sqlite3,mssql,oracle, Moved to https://gitea.com/xorm/xorm

xorm HAS BEEN MOVED TO https://gitea.com/xorm/xorm . THIS REPOSITORY WILL NOT BE UPDATED ANY MORE. 中文 Xorm is a simple and powerful ORM for Go. Featur

null 6.5k May 11, 2022
A better ORM for Go, based on non-empty interfaces and code generation.

reform A better ORM for Go and database/sql. It uses non-empty interfaces, code generation (go generate), and initialization-time reflection as oppose

null 1.3k May 14, 2022
100% type-safe ORM for Go (Golang) with code generation and MySQL, PostgreSQL, Sqlite3, SQL Server support. GORM under the hood.

go-queryset 100% type-safe ORM for Go (Golang) with code generation and MySQL, PostgreSQL, Sqlite3, SQL Server support. GORM under the hood. Contents

Denis Isaev 660 May 9, 2022
A better ORM for Go, based on non-empty interfaces and code generation.

A better ORM for Go and database/sql. It uses non-empty interfaces, code generation (go generate), and initialization-time reflection as opposed to interface{}, type system sidestepping, and runtime reflection. It will be kept simple.

null 1.2k May 12, 2022
Simple and performant ORM for sql.DB

Simple and performant ORM for sql.DB Main features are: Works with PostgreSQL, MySQL, SQLite. Selecting into a map, struct, slice of maps/structs/vars

Uptrace 894 May 14, 2022
An orm library support nGQL for Golang

norm An ORM library support nGQL for Golang. Overview Build insert nGQL by struct / map (Support vertex, edge). Parse Nebula execute result to struct

Zhihu 65 May 9, 2022
golang orm

korm golang orm, 一个简单易用的orm, 支持嵌套事务 安装 go get github.com/wdaglb/korm go get github.com/go-sql-driver/mysql 支持数据库 mysql https://github.com/go-sql-driv

null 6 Oct 11, 2021
Golang ORM with focus on PostgreSQL features and performance

go-pg is in a maintenance mode and only critical issues are addressed. New development happens in Bun repo which offers similar functionality but works with PostgreSQL, MySQL, and SQLite.

null 5.1k May 10, 2022
The fantastic ORM library for Golang, aims to be developer friendly

GORM The fantastic ORM library for Golang, aims to be developer friendly. Overview Full-Featured ORM Associations (Has One, Has Many, Belongs To, Many

Yadhu Sasidharan 0 Nov 11, 2021
ORM for Cloud Spanner to boost your productivity

ORM for Cloud Spanner to boost your productivity ??

Kanji Hirata 17 Apr 13, 2022
SQL mapper ORM framework for Golang

SQL mapper ORM framework for Golang English 中文 Please read the documentation website carefully when using the tutorial. DOC Powerful Features High Per

null 0 Dec 8, 2021