mysql

package
v0.2.1 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Oct 8, 2024 License: Apache-2.0 Imports: 8 Imported by: 0

Documentation

Overview

Copyright 2023 The Cloud-Barista Authors.

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

This section is empty.

Variables

This section is empty.

Functions

func EnsureCharsetAndCollate added in v0.2.1

func EnsureCharsetAndCollate(query, charSet, collate string) string

EnsureCharsetAndCollate ensures that the charset is utf8mb4 and collate is utf8mb4_general_ci in the SQL query.

func FormatNCPDatabaseCreateSQL added in v0.2.1

func FormatNCPDatabaseCreateSQL(targetProvider models.Provider, dbCreateSql *string)

func ReplaceCharsetAndCollate added in v0.2.1

func ReplaceCharsetAndCollate(sql string) string

ReplaceCharsetAndCollate replaces any charset and collate in the SQL statement with utf8mb4 and utf8mb4_general_ci.

func ReplaceEscapeString added in v0.2.1

func ReplaceEscapeString(input string) string

Types

type MysqlDBMS

type MysqlDBMS struct {
	// contains filtered or unexported fields
}

mysqlDBMS struct

func New

func New(provider models.Provider, sqlDB *sql.DB, opts ...MysqlDBOption) *MysqlDBMS

func (*MysqlDBMS) DeleteDB

func (d *MysqlDBMS) DeleteDB(dbName string) error

Delete database

func (*MysqlDBMS) Exec

func (d *MysqlDBMS) Exec(query string) error

Functions that execute EXEC commands in sql

func (*MysqlDBMS) GetInsert

func (d *MysqlDBMS) GetInsert(dbName, tableName string, insertSql *[]string) error

Get Insert sql

func (*MysqlDBMS) GetProvdier added in v0.2.1

func (d *MysqlDBMS) GetProvdier() models.Provider

func (*MysqlDBMS) GetTargetProvdier added in v0.2.1

func (d *MysqlDBMS) GetTargetProvdier() models.Provider

func (*MysqlDBMS) ListDB

func (d *MysqlDBMS) ListDB(dst *[]string) error

Get database list

func (*MysqlDBMS) ListTable

func (d *MysqlDBMS) ListTable(dbName string, dst *[]string) error

Get table list

func (*MysqlDBMS) SetProvdier added in v0.2.1

func (d *MysqlDBMS) SetProvdier(provider models.Provider)

func (*MysqlDBMS) SetTargetProvdier added in v0.2.1

func (d *MysqlDBMS) SetTargetProvdier(provider models.Provider)

func (*MysqlDBMS) ShowCreateDBSql

func (d *MysqlDBMS) ShowCreateDBSql(dbName string, dbCreateSql *string) error

ShowCreateDBSql modifies the CREATE DATABASE SQL and returns it

func (*MysqlDBMS) ShowCreateTableSql

func (d *MysqlDBMS) ShowCreateTableSql(dbName, tableName string, tableCreateSql *string) error

Get table create sql

type MysqlDBOption

type MysqlDBOption func(*MysqlDBMS)

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL