/
getQuery.go
152 lines (133 loc) · 5.12 KB
/
getQuery.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
// Code generated by the Pulumi Terraform Bridge (tfgen) Tool DO NOT EDIT.
// *** WARNING: Do not edit by hand unless you're certain you know what you are doing! ***
package mssql
import (
"context"
"reflect"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
"github.com/pulumi/pulumi/sdk/v3/go/pulumix"
"github.com/pulumiverse/pulumi-mssql/sdk/go/mssql/internal"
)
// Retrieves arbitrary SQL query result.
//
// > **Note** This data source is meant to be an escape hatch for all cases not supported by the provider's data sources. Whenever possible, use dedicated data sources, which offer better plan, validation and error reporting.
//
// ## Example Usage
//
// ```go
// package main
//
// import (
//
// "github.com/pulumi/pulumi/sdk/v3/go/pulumi"
// "github.com/pulumiverse/pulumi-mssql/sdk/go/mssql"
//
// )
//
// func main() {
// pulumi.Run(func(ctx *pulumi.Context) error {
// test, err := mssql.LookupDatabase(ctx, &mssql.LookupDatabaseArgs{
// Name: "test",
// }, nil)
// if err != nil {
// return err
// }
// column, err := mssql.GetQuery(ctx, &mssql.GetQueryArgs{
// DatabaseId: test.Id,
// Query: "SELECT [column_id], [name] FROM sys.columns WHERE [object_id] = OBJECT_ID('test_table')",
// }, nil)
// if err != nil {
// return err
// }
// var splat0 []string
// for _, val0 := range column.Results {
// splat0 = append(splat0, val0.Name)
// }
// ctx.Export("columnNames", splat0)
// return nil
// })
// }
//
// ```
func GetQuery(ctx *pulumi.Context, args *GetQueryArgs, opts ...pulumi.InvokeOption) (*GetQueryResult, error) {
opts = internal.PkgInvokeDefaultOpts(opts)
var rv GetQueryResult
err := ctx.Invoke("mssql:index/getQuery:getQuery", args, &rv, opts...)
if err != nil {
return nil, err
}
return &rv, nil
}
// A collection of arguments for invoking getQuery.
type GetQueryArgs struct {
// ID of database. Can be retrieved using `Database` or `SELECT DB_ID('<db_name>')`.
DatabaseId string `pulumi:"databaseId"`
// SQL query returning single result set, with any number of rows, where all columns are strings
Query string `pulumi:"query"`
}
// A collection of values returned by getQuery.
type GetQueryResult struct {
// ID of database. Can be retrieved using `Database` or `SELECT DB_ID('<db_name>')`.
DatabaseId string `pulumi:"databaseId"`
Id string `pulumi:"id"`
// SQL query returning single result set, with any number of rows, where all columns are strings
Query string `pulumi:"query"`
// Results of the SQL query, represented as list of maps, where the map key corresponds to column name and the value is the value of column in given row.
Results []map[string]string `pulumi:"results"`
}
func GetQueryOutput(ctx *pulumi.Context, args GetQueryOutputArgs, opts ...pulumi.InvokeOption) GetQueryResultOutput {
return pulumi.ToOutputWithContext(context.Background(), args).
ApplyT(func(v interface{}) (GetQueryResult, error) {
args := v.(GetQueryArgs)
r, err := GetQuery(ctx, &args, opts...)
var s GetQueryResult
if r != nil {
s = *r
}
return s, err
}).(GetQueryResultOutput)
}
// A collection of arguments for invoking getQuery.
type GetQueryOutputArgs struct {
// ID of database. Can be retrieved using `Database` or `SELECT DB_ID('<db_name>')`.
DatabaseId pulumi.StringInput `pulumi:"databaseId"`
// SQL query returning single result set, with any number of rows, where all columns are strings
Query pulumi.StringInput `pulumi:"query"`
}
func (GetQueryOutputArgs) ElementType() reflect.Type {
return reflect.TypeOf((*GetQueryArgs)(nil)).Elem()
}
// A collection of values returned by getQuery.
type GetQueryResultOutput struct{ *pulumi.OutputState }
func (GetQueryResultOutput) ElementType() reflect.Type {
return reflect.TypeOf((*GetQueryResult)(nil)).Elem()
}
func (o GetQueryResultOutput) ToGetQueryResultOutput() GetQueryResultOutput {
return o
}
func (o GetQueryResultOutput) ToGetQueryResultOutputWithContext(ctx context.Context) GetQueryResultOutput {
return o
}
func (o GetQueryResultOutput) ToOutput(ctx context.Context) pulumix.Output[GetQueryResult] {
return pulumix.Output[GetQueryResult]{
OutputState: o.OutputState,
}
}
// ID of database. Can be retrieved using `Database` or `SELECT DB_ID('<db_name>')`.
func (o GetQueryResultOutput) DatabaseId() pulumi.StringOutput {
return o.ApplyT(func(v GetQueryResult) string { return v.DatabaseId }).(pulumi.StringOutput)
}
func (o GetQueryResultOutput) Id() pulumi.StringOutput {
return o.ApplyT(func(v GetQueryResult) string { return v.Id }).(pulumi.StringOutput)
}
// SQL query returning single result set, with any number of rows, where all columns are strings
func (o GetQueryResultOutput) Query() pulumi.StringOutput {
return o.ApplyT(func(v GetQueryResult) string { return v.Query }).(pulumi.StringOutput)
}
// Results of the SQL query, represented as list of maps, where the map key corresponds to column name and the value is the value of column in given row.
func (o GetQueryResultOutput) Results() pulumi.StringMapArrayOutput {
return o.ApplyT(func(v GetQueryResult) []map[string]string { return v.Results }).(pulumi.StringMapArrayOutput)
}
func init() {
pulumi.RegisterOutputType(GetQueryResultOutput{})
}