在线时间:8:00-16:00
迪恩网络APP
随时随地掌握行业动态
扫描二维码
关注迪恩网络微信公众号
开源软件名称:go-sqlbuilder开源软件地址:https://gitee.com/iRainIoT/go-sqlbuilder开源软件介绍:SQL Builder in GoLang
Projects
开发项目由开发者Fork并持续开发: 当版本稳定时,通过PR合并到发布项目: Goals
Features
Install
UsageBase Usagesql1 := gsb.Select(). From("t_users"). OrderBy("username").ASC(). Column("password").DESC(). Limit(10). Offset(20). GetSQL()fmt.Println(sql1) Output:
Advance Usagesql1 := gsb.Select("id", "username", "password"). Distinct(). From("t_users"). Where(gsb.Group(gsb.Equal("username").And().EqualTo("password", "123456")). And(). Group(gsb.LessThen("age").Or().In("nick_name", "yoojia", "yoojiachen"))). GetSQL()fmt.Println(sql1)sql2 := gsb.Insert("t_vehicles"). Columns("id", "number", "color"). Values(1, "粤BF49883", "GREEN"). GetSQL()fmt.Println(sql2) Output: SELECT DISTINCT `id`,`username`,`password` FROM `t_users` WHERE (`username` = ? AND `password` = '123456') AND (`age` < ? OR `nick_name` IN ('yoojia','yoojiachen'));INSERT INTO `t_vehicles`(`id`, `number`, `color`) VALUES (1, '粤BF49883', 'GREEN'); Inner Selectsql := Select("id", "username"). FromSelect(Select().From("t_users_bak").Where(NotEqual("name"))). Where(Equal("password")). Limit(10).Offset(200). GetSQL()fmt.Println(sql) Output: SELECT `id`, `username` FROM (SELECT * FROM `t_users_bak` WHERE `name` <> ?) WHERE `password` = ? LIMIT 10 OFFSET 200; LicenseCopyright 2018 西安艾润物联网技术服务有限责任公司Copyright 2018 陈哈哈(chenyongjia@parkingwang, [email protected])Licensed under the Apache License, Version 2.0 (the "License");you may not use this file except in compliance with the License.You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0Unless required by applicable law or agreed to in writing, softwaredistributed under the License is distributed on an "AS IS" BASIS,WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.See the License for the specific language governing permissions andlimitations under the License. |
请发表评论