mydb

Documentation

Overview

Copyright 2017 by GoSpider author. 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.0

Unless required by applicable law or agreed to in writing, software distributed 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 and limitations under the License.

Index

• Constants
• func NewMysqlUrl(c DbConfig) string
• func NewPqUrl(c DbConfig) string
• type DbConfig
• type MyDb
  • func NewDb(config MyDbConfig) (*MyDb, error)
  • func (db *MyDb) CreateTables(beanOrTableName interface{}) error
  • func (db *MyDb) Delete(bean interface{}) (int64, error)
  • func (db *MyDb) DropTables(beans ...interface{}) error
  • func (db *MyDb) Exec(sql string, args ...interface{}) (sql.Result, error)
  • func (db *MyDb) Insert(beans ...interface{}) (int64, error)
  • func (db *MyDb) InsertOne(beans interface{}) (int64, error)
  • func (db *MyDb) IsTableExist(beanOrTableName interface{}) (bool, error)
  • func (db *MyDb) Ping() error
  • func (db *MyDb) Query(sql string, paramStr ...interface{}) (resultsSlice []map[string][]byte, err error)
  • func (db *MyDb) Update(bean interface{}, condiBean ...interface{}) (int64, error)
• type MyDbConfig

Constants

const (
	PG    = "postgres"
	MYSQL = "mysql"
)

Functions

func NewMysqlUrl

func NewMysqlUrl(c DbConfig) string

func NewPqUrl

func NewPqUrl(c DbConfig) string

Types

type DbConfig

type DbConfig struct {
	Name    string
	Host    string
	User    string
	Pass    string
	Port    string
	Sslmode string // sslmode=verify-full require
}

type MyDb

type MyDb struct {
	Config MyDbConfig
	Client *xorm.Engine
}

func NewDb

func NewDb(config MyDbConfig) (*MyDb, error)

func (*MyDb) CreateTables

func (db *MyDb) CreateTables(beanOrTableName interface{}) error

func (*MyDb) Delete

func (db *MyDb) Delete(bean interface{}) (int64, error)

func (*MyDb) DropTables

func (db *MyDb) DropTables(beans ...interface{}) error

func (*MyDb) Exec

func (db *MyDb) Exec(sql string, args ...interface{}) (sql.Result, error)

sql = "update `userinfo` set username=? where id=?" res, err := engine.Exec(sql, "xiaolun", 1)

func (*MyDb) Insert

func (db *MyDb) Insert(beans ...interface{}) (int64, error)

func (*MyDb) InsertOne

func (db *MyDb) InsertOne(beans interface{}) (int64, error)

func (*MyDb) IsTableExist

func (db *MyDb) IsTableExist(beanOrTableName interface{}) (bool, error)

func (*MyDb) Ping

func (db *MyDb) Ping() error

func (*MyDb) Query

func (db *MyDb) Query(sql string, paramStr ...interface{}) (resultsSlice []map[string][]byte, err error)

func (*MyDb) Update

func (db *MyDb) Update(bean interface{}, condiBean ...interface{}) (int64, error)

type MyDbConfig

type MyDbConfig struct {
	DriverName string
	DbConfig
	MaxIdleConns int
	MaxOpenConns int
	DebugToFile  bool
	Debug        bool
}