README
¶
services: mssql platforms: go author: joshgav
Azure MSSQL Samples
This package demonstrates how to manage SQL databases and their data.
Contents
- How to run all samples
- Management
- CreateServer
- CreateDatabase
- CreateFirewallRules
- Data plane
- Open
- CreateTable
- Insert
- Query
How to run all samples
- Get this repo and all dependencies.
export PROJECT=github.com/Azure-Samples/azure-sdk-for-go-samples/compute
go get -u $PROJECT
cd ${GOPATH}/src/${PROJECT}
dep ensure
- Create an Azure service principal with the [Azure CLI][] command
az ad sp create-for-rbac. - Set the following environment variables based on output properties of this
command. You can fill in these variables in
.env.tplin this directory and rename that to.env.
| EnvVar | Value |
|---|---|
| AZURE_CLIENT_ID | service principal/application ID |
| AZURE_CLIENT_SECRET | service principal/application secret |
| AZURE_TENANT_ID | your tenant id |
| AZURE_SUBSCRIPTION_ID | your subscription ID |
| AZURE_BASE_GROUP_NAME | base resource group name |
| AZURE_LOCATION_DEFAULT | location for all resources |
- Run the sample.
go test -v
More information
Please refer to Azure SDK for Go for more information.
This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments.
Documentation
¶
Overview ¶
Package sql tests basic functionality for an existing mssql db
Example (CreateDatabase) ¶
Example_createDatabase creates a SQL server and database, then creates a table and inserts a record.
var groupName = config.GenerateGroupName("DatabaseQueries")
config.SetGroupName(groupName)
serverName = strings.ToLower(serverName)
ctx := context.Background()
defer resources.Cleanup(ctx)
_, err := resources.CreateGroup(ctx, config.GroupName())
if err != nil {
util.LogAndPanic(err)
}
_, err = CreateServer(ctx, serverName, dbLogin, dbPassword)
if err != nil {
util.LogAndPanic(fmt.Errorf("cannot create sql server: %+v", err))
}
util.PrintAndLog("sql server created")
_, err = CreateDB(ctx, serverName, dbName)
if err != nil {
util.LogAndPanic(fmt.Errorf("cannot create sql database: %+v", err))
}
util.PrintAndLog("database created")
err = CreateFirewallRules(ctx, serverName)
if err != nil {
util.LogAndPanic(err)
}
util.PrintAndLog("database firewall rules set")
err = testSQLDataplane(serverName, dbName, dbLogin, dbPassword)
if err != nil {
util.LogAndPanic(err)
}
util.PrintAndLog("database operations performed")
Output: sql server created database created database firewall rules set database operations performed
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 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 Query(db *sql.DB) error
Examples ¶
Constants ¶
This section is empty.
Variables ¶
This section is empty.
Functions ¶
func CreateFirewallRules ¶
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
Types ¶
This section is empty.
Source Files
Click to show internal directories.
Click to hide internal directories.