github.com/minio/minio-go/v6@v6.0.57/examples/s3/selectobject.go (about)

     1  // +build ignore
     2  
     3  /*
     4   * MinIO Go Library for Amazon S3 Compatible Cloud Storage
     5   * Copyright 2018 MinIO, Inc.
     6   *
     7   * Licensed under the Apache License, Version 2.0 (the "License");
     8   * you may not use this file except in compliance with the License.
     9   * You may obtain a copy of the License at
    10   *
    11   *     http://www.apache.org/licenses/LICENSE-2.0
    12   *
    13   * Unless required by applicable law or agreed to in writing, software
    14   * distributed under the License is distributed on an "AS IS" BASIS,
    15   * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
    16   * See the License for the specific language governing permissions and
    17   * limitations under the License.
    18   */
    19  
    20  package main
    21  
    22  import (
    23  	"context"
    24  	"io"
    25  	"log"
    26  	"os"
    27  
    28  	minio "github.com/minio/minio-go/v6"
    29  )
    30  
    31  func main() {
    32  	// Note: YOUR-ACCESSKEYID, YOUR-SECRETACCESSKEY, my-bucketname, my-objectname and
    33  	// my-testfile are dummy values, please replace them with original values.
    34  
    35  	// Requests are always secure (HTTPS) by default. Set secure=false to enable insecure (HTTP) access.
    36  	// This boolean value is the last argument for New().
    37  
    38  	// New returns an Amazon S3 compatible client object. API compatibility (v2 or v4) is automatically
    39  	// determined based on the Endpoint value.
    40  	s3Client, err := minio.New("s3.amazonaws.com", "YOUR-ACCESS-KEY-HERE", "YOUR-SECRET-KEY-HERE", true)
    41  	if err != nil {
    42  		log.Fatalln(err)
    43  	}
    44  
    45  	opts := minio.SelectObjectOptions{
    46  		Expression:     "select count(*) from s3object",
    47  		ExpressionType: minio.QueryExpressionTypeSQL,
    48  		InputSerialization: minio.SelectObjectInputSerialization{
    49  			CompressionType: minio.SelectCompressionNONE,
    50  			CSV: &minio.CSVInputOptions{
    51  				FileHeaderInfo:  minio.CSVFileHeaderInfoNone,
    52  				RecordDelimiter: "\n",
    53  				FieldDelimiter:  ",",
    54  			},
    55  		},
    56  		OutputSerialization: minio.SelectObjectOutputSerialization{
    57  			CSV: &minio.CSVOutputOptions{
    58  				RecordDelimiter: "\n",
    59  				FieldDelimiter:  ",",
    60  			},
    61  		},
    62  	}
    63  
    64  	reader, err := s3Client.SelectObjectContent(context.Background(), "mycsvbucket", "mycsv.csv", opts)
    65  	if err != nil {
    66  		log.Fatalln(err)
    67  	}
    68  	defer reader.Close()
    69  
    70  	if _, err := io.Copy(os.Stdout, reader); err != nil {
    71  		log.Fatalln(err)
    72  	}
    73  }