summaryrefslogtreecommitdiff
path: root/examples/s3/selectobject.go
diff options
context:
space:
mode:
Diffstat (limited to 'examples/s3/selectobject.go')
-rw-r--r--examples/s3/selectobject.go73
1 files changed, 73 insertions, 0 deletions
diff --git a/examples/s3/selectobject.go b/examples/s3/selectobject.go
new file mode 100644
index 0000000..e23ccf8
--- /dev/null
+++ b/examples/s3/selectobject.go
@@ -0,0 +1,73 @@
+// +build ignore
+
+/*
+ * Minio Go Library for Amazon S3 Compatible Cloud Storage
+ * Copyright 2018 Minio, Inc.
+ *
+ * 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.
+ */
+
+package main
+
+import (
+ "context"
+ "io"
+ "log"
+ "os"
+
+ minio "github.com/minio/minio-go"
+)
+
+func main() {
+ // Note: YOUR-ACCESSKEYID, YOUR-SECRETACCESSKEY, my-bucketname, my-objectname and
+ // my-testfile are dummy values, please replace them with original values.
+
+ // Requests are always secure (HTTPS) by default. Set secure=false to enable insecure (HTTP) access.
+ // This boolean value is the last argument for New().
+
+ // New returns an Amazon S3 compatible client object. API compatibility (v2 or v4) is automatically
+ // determined based on the Endpoint value.
+ s3Client, err := minio.New("s3.amazonaws.com", "YOUR-ACCESS-KEY-HERE", "YOUR-SECRET-KEY-HERE", true)
+ if err != nil {
+ log.Fatalln(err)
+ }
+
+ opts := minio.SelectObjectOptions{
+ Expression: "select count(*) from s3object",
+ ExpressionType: minio.QueryExpressionTypeSQL,
+ InputSerialization: minio.SelectObjectInputSerialization{
+ CompressionType: minio.SelectCompressionNONE,
+ CSV: &minio.CSVInputOptions{
+ FileHeaderInfo: minio.CSVFileHeaderInfoNone,
+ RecordDelimiter: "\n",
+ FieldDelimiter: ",",
+ },
+ },
+ OutputSerialization: minio.SelectObjectOutputSerialization{
+ CSV: &minio.CSVOutputOptions{
+ RecordDelimiter: "\n",
+ FieldDelimiter: ",",
+ },
+ },
+ }
+
+ reader, err := s3Client.SelectObjectContent(context.Background(), "mycsvbucket", "mycsv.csv", opts)
+ if err != nil {
+ log.Fatalln(err)
+ }
+ defer reader.Close()
+
+ if _, err := io.Copy(os.Stdout, reader); err != nil {
+ log.Fatalln(err)
+ }
+}