db

Documentation

Overview

MySql引擎层

Index

• Variables
• func CreateLike(column string) string
• func CreatePage(page, limit uint64) uint64
• func NewKafkaAsyncProduce(host []string, username, pwd string) (conn sarama.AsyncProducer, err error)
• func NewKafkaSyncProduce(host []string, username, pwd string) (conn sarama.SyncProducer, err error)
• func NewRedisPool(addr, passwd string, db, maxIdle, MaxActive int) *redis.Pool
• func NewSQLX(driverName, dbSource string, maxOpenConns, maxIdleConns int) (db *sqlx.DB, err error)
• type And
• type Eq
• type Gt
• type GtOrEq
• type Gte
• type InsertBuilder
• type Like
• type Lt
• type LtOrEq
• type Lte
• type NotEq
• type Or
• type SelectBuilder
• type UpdateBuilder

Variables

var ClickHouseSqlx *sqlx.DB

var KafkaASyncProducer sarama.AsyncProducer

var KafkaClient sarama.Client

var KafkaSyncProducer sarama.SyncProducer

var RedisPool *redis.Pool

var SqlBuilder = squirrel.StatementBuilder

用squirrel生成sql语句

var Sqlx *sqlx.DB

sqlx 全局变量

Functions

func CreateLike

func CreateLike(column string) string

创建模糊查询

func CreatePage

func CreatePage(page, limit uint64) uint64

创建分页查询

func NewKafkaAsyncProduce

func NewKafkaAsyncProduce(host []string, username, pwd string) (conn sarama.AsyncProducer, err error)

func NewKafkaSyncProduce

func NewKafkaSyncProduce(host []string, username, pwd string) (conn sarama.SyncProducer, err error)

func NewRedisPool

func NewRedisPool(addr, passwd string, db, maxIdle, MaxActive int) *redis.Pool

NewRedisPool 新建一个Redis连接池 URL优先

func NewSQLX

func NewSQLX(driverName, dbSource string, maxOpenConns, maxIdleConns int) (db *sqlx.DB, err error)

NewMySQL 创建一个连接MySQL的实体池

Types

type And

type And = squirrel.And

type Eq

type Eq = squirrel.Eq

type Gt

type Gt = squirrel.Gt

type GtOrEq

type GtOrEq = squirrel.GtOrEq

type Gte

type Gte = squirrel.GtOrEq

type InsertBuilder

type InsertBuilder = squirrel.InsertBuilder

type Like

type Like = squirrel.Like

type Lt

type Lt = squirrel.Lt

type LtOrEq

type LtOrEq = squirrel.LtOrEq

type Lte

type Lte = squirrel.LtOrEq

type NotEq

type NotEq = squirrel.NotEq

type Or

type Or = squirrel.Or

type SelectBuilder

type SelectBuilder = squirrel.SelectBuilder

type UpdateBuilder

type UpdateBuilder = squirrel.UpdateBuilder