goodls was updated to v.1.1.1

• v1.1.1 (November 13, 2018)

  1. Version of go-getfilelist was updated. Because the structure of drive.File got to be able to be used, I also updated this application.

The detail information and how to get this are https://github.com/tanaikech/goodls.

go-getfilelist was updated to v1.0.1

• v1.0.1 (November 13, 2018)

  1. From this version, in order to retrieve files and file information, “google.golang.org/api/drive/v3” is used.
     • By this, when the values are retrieved from this library, users can use the structure of drive.File.
     • Script using this library can be seen at goodls.

You can get this from https://github.com/tanaikech/go-getfilelist

ImgApp was updated to v1.2.1.

• v1.2.1 (November 5, 2018)

  Efficiency of each loop was enhanced by this benchmark.

You can see the detail information here https://github.com/tanaikech/ImgApp

ggsrun was updated to v.1.5.2

• v1.5.2 (November 4, 2018)
  1. About downloading folders, when files are downloaded from a folder, you can download Google Docs files with the mimeType you want. For example, when you download files from the folder, if -e txt is used, Google Docs are downloaded as the text file. When -e pdf is used, they are downloaded as the PDF file. Of course, there are mimeType which cannot be converted.
     • $ ggsrun d -f [folderName] -e txt -j
  2. About uploading files, when files are uploaded from your local PC, the files got to be able to be converted to Google Docs. For this, new option of --convertto, -c is added. For example, when a text file is uploaded, if you use -c doc, the text file is uploaded as Google Document.
     • $ ggsrun u -f [fileName] -c doc -j

You can check ggsrun at https://github.com/tanaikech/ggsrun.

goodls was updated to v.1.1.0

• v1.1.0 (November 4, 2018)

  1. By using API key, files from the shared folder got to be able to be downloaded while keeping the folder structure.
     • This demonstration can be seen at Demo.
  2. By using API key, the information of shared file and folder can be also retrieved.
  3. About the option of --extension and -e, when -e ms is used, Google Docs (Document, Spreadsheet, Slides) are converted to Microsoft Docs (Word, Excel, Powerpoint), respectively.

The detail information and how to get this are https://github.com/tanaikech/goodls.

ggsrun was updated to v.1.5.1

• v1.5.1 (November 2, 2018)
  1. Removed a bug.
     • When a file information was retrieved, createdTime and modifiedTime couldn’t be seen and the information was incomplete.

You can check ggsrun at https://github.com/tanaikech/ggsrun.

Overview

This is a Golang library to retrieve the file list with the folder tree from the specific folder of Google Drive.

Description

When I create applications for using Google Drive, I often retrieve a file list from a folder in the application. So far, I had created the script for retrieving a file list from a folder for each application. Recently, I thought that if there is the script for retrieving the file list with the folder tree from the folder of Google Drive as a library, it will be useful for me and other users. So I created this.

ggsrun was updated to v.1.5.0

• v1.5.0 (October 27, 2018)
  1. From this version, ggsrun got to be able to download all files and folders in the specific folder in Google Drive. When all files are downloaded from a folder, the same folder structure of Google Drive is created to the local PC.
     • $ ggsrun d -f folderName or folderId
       • When the project file is downloaded, it is downloaded as a zip file. All scripts in the project is put in the zip file.
       • Also when you download a single project, you can use an option --zip or -z. By this, the downloaded project is saved as a zip file.
       • This new function can be also used for the shared folders. When you want to download the files from the shared folder, please use the folder ID of the shared folder.
  2. The file list with the folder tree in the specific folder got to be able to be retrieved.
  3. When the files are downloaded, the progression got to be able to be seen. When you want to see the progression, please use -j when you download files and folders.
  4. Files with large size got to be able to be used. In order to download files with large size (several gigabytes), files are saved by chunks.
  5. Some modifications.

You can check ggsrun at https://github.com/tanaikech/ggsrun.

Gists

This is a sample script for creating a downloaded file as a zip file using Golang. The downloaded file is not created to a file as a temporal file. The zip file is directly created. When you use this, please modify url, downloadedFileName and zipFileName.

Sample script:

package main

import (
    "archive/zip"
    "bytes"
    "fmt"
    "io"
    "io/ioutil"
    "log"
    "net/http"
    "os"
    "time"
)

func main() {
    url := "https://localhost/sample.png"
    downloadedFileName := "sample.png"
    zipFileName := "sample.zip"

    res, err := http.Get(url)
    if err != nil {
        log.Fatal(err)
    }
    body, err := ioutil.ReadAll(res.Body)
    if err != nil {
        fmt.Fprintf(os.Stderr, "Error: %v. ", err)
        os.Exit(1)
    }
    defer res.Body.Close()
    buf := new(bytes.Buffer)
    w := zip.NewWriter(buf)
    fh := &zip.FileHeader{
        Name:     downloadedFileName,
        Modified: time.Now(),
        Method:   8,
    }
    f, err := w.CreateHeader(fh)
    if err != nil {
        log.Fatal(err)
    }
    if _, err := f.Write(body); err != nil {
        log.Fatal(err)
    }
    err = w.Close()
    if err != nil {
        log.Fatal(err)
    }
    file, err := os.Create(zipFileName)
    if err != nil {
        log.Fatal(err)
    }
    if _, err = io.Copy(file, buf); err != nil {
        log.Fatal(err)
    }
    file.Close()
    fmt.Println("Done.")
}

Note:

As an important point, when the file is downloaded, os.FileInfo cannot be used. So in this situation, it uses zip.FileHeader. At that time, please remember to set Method. Method is 0 as the default. This means no compression. The sample script uses 8 to Method. This means the DEFLATE method.

Gists

Benchmark: Reading and Writing Spreadsheet using Google Apps Script

Introduction

Please be careful! This result can be only used for Google Apps Script.

There are a limit executing time for Google Apps Script (GAS). That is 6 minutes for Consumer and Google Apps free edition, and 30 minutes for G Suite and Early Access. ¹ So many users always have to pay attention to reducing the process cost of scripts. So it is very important to know the process cost of various situations. I have already reported the costs for various processes as the reports. ² In this report, the process cost for reading and writing values for Spreadsheet using GAS has been investigated.