Instantly share code, notes, and snippets.

Chenny Du duchenpaul

View GitHub Profile
View nwqs_data_extract.py
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)
View robot_click.py
import time
import pyautogui
print('ready')
time.sleep(3)
print('start')
for i in range(30):
pyautogui.click(1689,444)
time.sleep(.5)
View vim_powerline.sh
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
View port_forward_using_SSH.md
  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
View initialize_unix_profile.md
  • Add sudoer
# Config editor
sudo update-alternatives --config editor

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

## Allow root to run any commands anywhere
View win_path2wsl_path.py
'''Convert windows path to wsl path'''
windows_path = r'''C:\Users\chdu\Desktop\Portal\Management\Google Cloud Training'''
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))
View data_group.py
def cluster(data, maxgap):
'''Arrange data into groups where successive elements
differ by no more than *maxgap*
>>> cluster([1, 6, 9, 100, 102, 105, 109, 134, 139], maxgap=10)
[[1, 6, 9], [100, 102, 105, 109], [134, 139]]
>>> cluster([1, 6, 9, 99, 100, 102, 105, 134, 139, 141], maxgap=10)
[[1, 6, 9], [99, 100, 102, 105], [134, 139, 141]]
View caffeine.vbs
Dim objResult
Set objShell = WScript.CreateObject("WScript.Shell")
Do While True
Wscript.Sleep(3000)
objResult = objShell.sendkeys("{SCROLLLOCK}")
Wscript.Sleep(100)
objResult = objShell.sendkeys("{SCROLLLOCK}")
Wscript.Sleep(100)
View VDI Recovery checklist.md

Suggest print with scale 150% - 200%

  • DB tools:

    • DBeaver
      • Import projects
        • Carters
  • Software:

    • Chrome
      • config
View service_controller.sh
#!/bin/bash
TARGET_SERVICE=server_status_web
service_start_cmd='/home/pi/run/server_statisic/FlaskApp/server_status_web.py'
usage(){
echo -e "Usage: bash $0 [ start | stop | restart ] "
exit 1
}
start_service(){