- Add sudoer
# Config editor
sudo update-alternatives --config editor
#add user to sudoer
vi /etc/sudoers (visudo)
## Allow root to run any commands anywhere
'''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)) |
# Config editor
sudo update-alternatives --config editor
#add user to sudoer
vi /etc/sudoers (visudo)
## Allow root to run any commands anywhere
hostname.onedumb.com
, port: 203
1433
, Destination: sqlhost:1433
pi
password: 1qazxsw2
127.0.0.1
SA
passWORD
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 |
import time | |
import pyautogui | |
print('ready') | |
time.sleep(3) | |
print('start') | |
for i in range(30): | |
pyautogui.click(1689,444) | |
time.sleep(.5) |
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) |
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, |
#!/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 |
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)) |
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') |