How to mail the movie list from the remote host

2020-01-10

Contents

Sometimes I upload videos for my family but don’t know if they already exist on the computer. At this time, I can think of a way to automatically email the titles of the videos already in the video library to myself for reference on a regular basis.

~/Downloads
➤ cat 2021-12-03-movie_list.txt -r :10
───────┬────────────────────────────────────────────────────────────────────────────────────────────────
       │ File: 2021-12-03-movie_list.txt
───────┼────────────────────────────────────────────────────────────────────────────────────────────────
   1   │ 2021-12-03 Movie List
   2   │
   3   │ CreationTime             Name
   4   │ ------------             ----
   5   │ 2021/11/13 下午 05:03:45 紅色通緝令
   6   │ 2021/11/12 下午 04:03:19 高玩殺手
   7   │ 2021/11/12 下午 04:03:17 007生死交戰
   8   │ 2021/11/12 下午 03:57:13 芬奇的旅程
   9   │ 2021/11/12 下午 03:46:12 沙丘
  10   │ 2021/9/21 下午 03:28:33  最佳销售员
───────┴────────────────────────────────────────────────────────────────────────────────────────────────

Gmail low security settings must be turned on

Go to Account Settings
Click Security in the list on the left.
At the bottom of the low security restriction click Turn on access.

In this way, emails can be sent through the smtp.gmail.com api.

Consolidate video titles into text files


    echo "Starting Mailing Task"
    cd C:\Users\user\Documents\movie_list

    # Remove all .txt file
    Get-ChildItem $Path | Where{$_.Name -Match ".*.txt"} | Remove-Item 
    
    # init file
    echo "$(get-date -f yyyy-MM-dd) Movie List" > "$(get-date -f yyyy-MM-dd)-movie_list.txt"
    
    # Movies
    Get-ChildItem 'D:\Movies' | Where-Object { $_.CreationTime.Date -lt (Get-Date).Date } | Sort CreationTime -Descending | Select-Object CreationTime,Name | Format-Table -Wrap >> "$(get-date -f yyyy-MM-dd)-movie_list.txt"
    
    # Movies Details
    tree 'D:\Movies' /F >> "$(get-date -f yyyy-MM-dd)-movie_list.txt"
    
    # TV-Series
    Get-ChildItem 'D:\TV-Series' | Where-Object { $_.CreationTime.Date -lt (Get-Date).Date } | Sort CreationTime -Descending | Select-Object CreationTime,Name | Format-Table -Wrap >> "$(get-date -f yyyy-MM-dd)-movie_list.txt"
    
    # TV-Details
    Get-ChildItem 'D:\TV-Details' -Depth 1 | Where-Object { $_.CreationTime.Date -lt (Get-Date).Date } | Sort CreationTime -Descending | Format-Table -Wrap >> "$(get-date -f yyyy-MM-dd)-movie_list.txt"
    
    # Start Email process
    Start-Process -FilePath "C:\Users\user\Documents\movie_list\send_email.exe"
    echo "Done!"

Find the latest archive listing


    package main

    import (
        "crypto/tls"
        "fmt"
        "os"
        "path/filepath"

        "gopkg.in/mail.v2"
    )

    func WalkMatch(root, pattern string) ([]string, error) {
        var matches []string
        err := filepath.Walk(root, func(path string, info os.FileInfo, err error) error {
            if err != nil {
                return err
            }
            if info.IsDir() {
                return nil
            }
            if matched, err := filepath.Match(pattern, filepath.Base(path)); err != nil {
                return err
            } else if matched {
                matches = append(matches, path)
            }
            return nil
        })
        if err != nil {
            return nil, err
        }
        return matches, nil
    }

Email the result list file


    func main() {
        fmt.Println("Start mailing process...")
        files, err := WalkMatch("C:/Users/user/Documents/movie_list", "*.txt")
        if err != nil {
            panic(err)
        }

        m := mail.NewMessage()
        m.SetHeader("From", "destination@gmail.com")
        m.SetHeader("To", "youremail@gmail.com")
        m.SetHeader("Subject", "Movie List")
        m.Attach(files[0])

        d := mail.NewDialer("smtp.gmail.com", 587, "destination@gmail.com", "yourpassword")
        d.TLSConfig = &tls.Config{InsecureSkipVerify: true}
        d.StartTLSPolicy = mail.MandatoryStartTLS

        if err := d.DialAndSend(m); err != nil {
            panic(err)
        }
        fmt.Println("Successfully sent list to youremail@gmail.com")
    }

Finally just put the Script into the schedler of the operating system! Cheers~ 🍻