duchenpaul

'''Convert windows path to wsl path'''
import sys
windows_path = sys.argv[1]

MOUNT_PATH = '/mnt'

windows_path_split = windows_path.split(':\\')
diskLabel, path = windows_path_split[0].lower(), windows_path_split[1].replace('\\', r'''/''').replace(' ', r'''\ ''')

wsl_path = '/'.join((MOUNT_PATH, diskLabel, path))

duchenpaul

• Add sudoer

# Config editor
sudo update-alternatives --config editor

#add user to sudoer
vi /etc/sudoers (visudo)

## Allow root to run any commands anywhere

duchenpaul

1. Open putty
2. Set host name: hostname.onedumb.com, port: 203
3. In category, go to Connection->SSH->Tunnels, set Source port: 1433, Destination: sqlhost:1433
4. Click Add button
5. Click open, login as: pi password: 1qazxsw2
6. It should be connected to the server, keep it in hte background
7. Open SQLServer client
8. Servername: 127.0.0.1
9. Login: SA
10. Password: passWORD

duchenpaul

sudo pip install git+git://github.com/powerline/powerline
wget https://github.com/powerline/powerline/blob/develop/font/PowerlineSymbols.otf?raw=true -O PowerlineSymbols.otf
sudo mv PowerlineSymbols.otf /usr/share/fonts/
fc-cache -vf /usr/share/fonts/
wget https://raw.githubusercontent.com/powerline/powerline/develop/font/10-powerline-symbols.conf
sudo mv 10-powerline-symbols.conf /etc/fonts/conf.d/
echo "set rtp+=/usr/lib/python2.7/site-packages/powerline/bindings/vim/" >> ~/.vimrc
echo "set laststatus=2" >> ~/.vimrc
echo "set t_Co=256" >> ~/.vimrc

duchenpaul

import time
import pyautogui

print('ready')
time.sleep(3)

print('start')
for i in range(30):
    pyautogui.click(1689,444)
    time.sleep(.5)

duchenpaul

import json
import sqlparse
import xmltodict

from pprint import pprint

def xml2dict(xmlString):
    '''Return json object'''
    jsonString = json.dumps(xmltodict.parse(xmlString), indent=4)
    xml_in_dict = json.loads(jsonString)

duchenpaul

import os


def split(filehandler, delimiter=',', row_limit=1000,
          output_name_template='output_%s.csv', output_path='.', keep_headers=True):
    import csv
    reader = csv.reader(filehandler, delimiter=delimiter)
    current_piece = 1
    current_out_path = os.path.join(
        output_path,

duchenpaul

#!/bin/bash

if [ $# -lt 1 ]; then
  echo -e "Shrink the size of raspberry pi image.\nUsage: bash $0 xxx.img "
  ls -l *.img
  exit
fi

IMG=$1

duchenpaul

from tqdm import tqdm

import pandas as pd
from sqlalchemy import create_engine, MetaData

SOURCE_TABLE_NAME_LIST = ['individual_tagging_sd', ]


def chunker(seq, size):
    return (seq[pos:pos + size] for pos in range(0, len(seq), size))

duchenpaul

from datetime import datetime

with open('test.txt') as f:
    date_list = f.read().split('\n')

date_list = [ x.replace('"', '').strip() for x in date_list if x]

for x in date_list:
    try:
        datetime.strptime(x, '%m/%d/%Y')