sql

Documentation

Overview

Package sql tests basic functionality for an existing mssql db

Index

• func CreateDB(ctx context.Context, serverName, dbName string) (db sql.Database, err error)
• func CreateFirewallRules(ctx context.Context, serverName string) error
• func CreateServer(ctx context.Context, serverName, dbLogin, dbPassword string) (server sql.Server, err error)
• func CreateTable(db *sql.DB) error
• func DbOperations(server, database, username, password string) error
• func DeleteDB(ctx context.Context, serverName, dbName string) (autorest.Response, error)
• func Insert(db *sql.DB) error
• func Open(server, database, username, password string) (*sql.DB, error)
• func PrintInfo()
• func Query(db *sql.DB) error

Functions

func CreateDB

func CreateDB(ctx context.Context, serverName, dbName string) (db sql.Database, err error)

CreateDB creates a new SQL Database on a given server

func CreateFirewallRules

func CreateFirewallRules(ctx context.Context, serverName string) error

CreateFirewallRules creates new firewall rules for a given server

func CreateServer

func CreateServer(ctx context.Context, serverName, dbLogin, dbPassword string) (server sql.Server, err error)

CreateServer creates a new SQL Server

func CreateTable

func CreateTable(db *sql.DB) error

CreateTable creates an SQL table

func DbOperations

func DbOperations(server, database, username, password string) error

DbOperations executes some simple SQL queries

func DeleteDB

func DeleteDB(ctx context.Context, serverName, dbName string) (autorest.Response, error)

DeleteDB deletes an existing database from a server

func Insert

func Insert(db *sql.DB) error

Insert adds a row to the SQL datablase

func Open

func Open(server, database, username, password string) (*sql.DB, error)

Open opens a connection to the SQL server

func PrintInfo

func PrintInfo()

PrintInfo logs information on SQL user agent and ARM client

func Query

func Query(db *sql.DB) error

Query queries the SQL database