qinjie

#!/bin/bash
###############################################
# To use: 
# wget https://raw.github.com/gist/4411254
# chmod 777 github-ubuntu.sh
# ./github-ubuntu.sh
###############################################

GIT_EMAIL=mark.qj@gmail.com
GIT_USER=qinjie

qinjie

```
sudo amazon-linux-extras install postgresql10
```

Use it to connec to Redshift database

```
psql -h <endpoint> -p <port> -d <databasename> -U <userid>
```

qinjie

#!/bin/sh

sudo yum install -y https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
sudo yum install -y mysql-community-client

qinjie

#!/bin/bash

if [ -z "$1" ]; then
    echo "waiting for the following arguments: username + max-page-number"
    exit 1
else
    name=$1
fi

if [ -z "$2" ]; then 

qinjie

Download files using requests library.

Method 1:

import requests

def download_file(url: str)->str:
    local_filename = url.split('/')[-1]
 # 注意传入参数 stream=True

qinjie

Cheat Sheet for MongoDB Shell Commands

This is a Cheat Sheet for interacting with the Mongo Shell ( mongo on your command line). This is for MongoDB Community Edition.

Preface:

Mongo Manual can help you with getting started using the Shell.

FAQ for MongoDB Fundamentals and other FAQs can be found in the side-bar after visiting that link.

qinjie

To copy a file from container to host:

docker cp <containerId>:/file/path/within/container /host/path/target

qinjie

Learning Google Apps Script

The best resource for learning Google Script is the official documentation available at developers.google.com. Here are other places that will help you get up to speed.

1. Google Apps Scripts - Snippets by +Amit Agarwal
2. Apps Script Starter - Modern development workflow for building Google Apps Script projects with Babel, Webpack and VS Code.
3. Digital Inspiration by +Amit Agarwal - Google Addons
4. Awesome Google Scripts by +Amit Agarwal
5. O'Reilly - Apps Script - by +James Ferreira
6. Apps Script Webinars - YouTube - by +Eric Koleda

qinjie

Project Title

One Paragraph of project description goes here

Getting Started

These instructions will get you a copy of the project up and running on your local machine for development and testing purposes. See deployment for notes on how to deploy the project on a live system.

Prerequisites

qinjie

#!/usr/bin/python

import os
import sys
import boto3

# get an access token, local (from) directory, and S3 (to) directory
# from the command-line
local_directory, bucket, destination = sys.argv[1:4]