tnew stuff - scripts - random scripts HTML git clone git://parazyd.org/scripts.git DIR Log DIR Files DIR Refs --- DIR commit 24c4f622a4f5311abcc5c76c234173be8d56b680 DIR parent 860f0a8df966820bb28a8cd9289638dbe0aabba3 HTML Author: parazyd <parazyd@dyne.org> Date: Fri, 1 Sep 2017 10:59:25 +0200 new stuff Diffstat: T elem | 0 R obsolete/addrepo.sh -> notinpath/o… | 0 R obsolete/auphone -> notinpath/obso… | 0 R obsolete/beepop -> notinpath/obsol… | 0 R obsolete/blink.sh -> notinpath/obs… | 0 R obsolete/bright -> notinpath/obsol… | 0 R obsolete/catfact.py -> notinpath/o… | 0 R obsolete/disco -> notinpath/obsole… | 0 R obsolete/dmenu.sh -> notinpath/obs… | 0 R obsolete/img -> notinpath/obsolete… | 0 R obsolete/ix -> notinpath/obsolete/… | 0 R obsolete/lock -> notinpath/obsolet… | 0 R obsolete/mycosmos -> notinpath/obs… | 0 R obsolete/pio -> notinpath/obsolete… | 0 A notinpath/obsolete/popup | 2 ++ R obsolete/powertoptune.sh -> notinp… | 0 R obsolete/rotmon -> notinpath/obsol… | 0 R obsolete/scream.sh -> notinpath/ob… | 0 R obsolete/signrelease -> notinpath/… | 0 R obsolete/spin -> notinpath/obsolet… | 0 R obsolete/startcups.sh -> notinpath… | 0 R obsolete/startdwm -> notinpath/obs… | 0 R obsolete/startvbox.sh -> notinpath… | 0 R obsolete/surf.sh -> notinpath/obso… | 0 R obsolete/torrentnotif.sh -> notinp… | 0 R obsolete/translate -> notinpath/ob… | 0 R obsolete/updatepw.sh -> notinpath/… | 0 R obsolete/weepop.sh -> notinpath/ob… | 0 R obsolete/xkcd -> notinpath/obsolet… | 0 R obsolete/xkcd.py -> notinpath/obso… | 0 R obsolete/ydl -> notinpath/obsolete… | 0 R obsolete/ys -> notinpath/obsolete/… | 0 R obsolete/yt -> notinpath/obsolete/… | 0 D obsolete/popup | 2 -- M p | 2 ++ M radio | 6 ++++-- M wd | 4 ++-- M wifi | 2 +- M xkcd | 18 ++++++------------ A xlstojson.py | 68 +++++++++++++++++++++++++++++++ 40 files changed, 85 insertions(+), 19 deletions(-) --- DIR diff --git a/elem b/elem DIR diff --git a/obsolete/addrepo.sh b/notinpath/obsolete/addrepo.sh DIR diff --git a/obsolete/auphone b/notinpath/obsolete/auphone DIR diff --git a/obsolete/beepop b/notinpath/obsolete/beepop DIR diff --git a/obsolete/blink.sh b/notinpath/obsolete/blink.sh DIR diff --git a/obsolete/bright b/notinpath/obsolete/bright DIR diff --git a/obsolete/catfact.py b/notinpath/obsolete/catfact.py DIR diff --git a/obsolete/disco b/notinpath/obsolete/disco DIR diff --git a/obsolete/dmenu.sh b/notinpath/obsolete/dmenu.sh DIR diff --git a/obsolete/img b/notinpath/obsolete/img DIR diff --git a/obsolete/ix b/notinpath/obsolete/ix DIR diff --git a/obsolete/lock b/notinpath/obsolete/lock DIR diff --git a/obsolete/mycosmos b/notinpath/obsolete/mycosmos DIR diff --git a/obsolete/pio b/notinpath/obsolete/pio DIR diff --git a/notinpath/obsolete/popup b/notinpath/obsolete/popup t@@ -0,0 +1 @@ +beepop +\ No newline at end of file DIR diff --git a/obsolete/powertoptune.sh b/notinpath/obsolete/powertoptune.sh DIR diff --git a/obsolete/rotmon b/notinpath/obsolete/rotmon DIR diff --git a/obsolete/scream.sh b/notinpath/obsolete/scream.sh DIR diff --git a/obsolete/signrelease b/notinpath/obsolete/signrelease DIR diff --git a/obsolete/spin b/notinpath/obsolete/spin DIR diff --git a/obsolete/startcups.sh b/notinpath/obsolete/startcups.sh DIR diff --git a/obsolete/startdwm b/notinpath/obsolete/startdwm DIR diff --git a/obsolete/startvbox.sh b/notinpath/obsolete/startvbox.sh DIR diff --git a/obsolete/surf.sh b/notinpath/obsolete/surf.sh DIR diff --git a/obsolete/torrentnotif.sh b/notinpath/obsolete/torrentnotif.sh DIR diff --git a/obsolete/translate b/notinpath/obsolete/translate DIR diff --git a/obsolete/updatepw.sh b/notinpath/obsolete/updatepw.sh DIR diff --git a/obsolete/weepop.sh b/notinpath/obsolete/weepop.sh DIR diff --git a/obsolete/xkcd b/notinpath/obsolete/xkcd DIR diff --git a/obsolete/xkcd.py b/notinpath/obsolete/xkcd.py DIR diff --git a/obsolete/ydl b/notinpath/obsolete/ydl DIR diff --git a/obsolete/ys b/notinpath/obsolete/ys DIR diff --git a/obsolete/yt b/notinpath/obsolete/yt DIR diff --git a/obsolete/popup b/obsolete/popup t@@ -1 +0,0 @@ -beepop -\ No newline at end of file DIR diff --git a/p b/p t@@ -2,3 +2,5 @@ ff=/usr/bin/firefox exec $ff -no-remote -ProfileManager + +#sudo -u ff firefox -no-remote -ProfileManager DIR diff --git a/radio b/radio t@@ -13,6 +13,7 @@ list of radios: 6. YAMMAT 7. KLFM 8. NOPE + 9. Radio Paradise EOM exit 1 } t@@ -27,9 +28,10 @@ case "$1" in 3|blurfm) play "http://radio.dyne.org/blurfm02.m3u" ;; 4|auroville) play "http://radio.dyne.org/auroville.mp3.m3u" ;; 5|2f30) play "http://radio.2f30.org:8000/live.mp3" ;; - 6|yammat) play "http://192.240.102.131:9107" ;; - 7|klfm) play "http://klfm.streamradio.com.hr:5000/listen.pls" ;; + 6|yammat) play "http://192.240.102.133:12430/" ;; + 7|klfm) play "http://klfm.streamradio.com.hr:2199/tunein/klfm1.pls" ;; 8|nope) play "http://radionope.streamguys1.com/listen.pls" ;; + 9|paradise) play "http://stream-eu1.radioparadise.com:80/mp3-128" ;; *) usage ;; esac DIR diff --git a/wd b/wd t@@ -1,3 +1,3 @@ #!/bin/sh - -exec surf http://rpi/wd +exec surf http://rpi/$(basename $0) +#exec surf http://rpi:8000/$(basename $0) DIR diff --git a/wifi b/wifi t@@ -1,6 +1,6 @@ #!/bin/sh -dev=wlan0 +dev=${dev:=wlan0} wpasup=/etc/wpa_supplicant/wpa_supplicant.conf usage() { DIR diff --git a/xkcd b/xkcd t@@ -39,11 +39,8 @@ def add_text(image, title, alt, tfont=download_dir+'xkcd.ttf', draw = ImageDraw.Draw(img) lheight_total = line_padding for i in lines: - draw.text((w/2-tfont.getsize(" ".join(i))[0]/2, - lheight_total), - " ".join(i), - font=tfont, - fill=0xffffff) + draw.text((w/2-tfont.getsize(" ".join(i))[0]/2, lheight_total), + " ".join(i), font=tfont, fill=0xffffff) lheight_total += lheight + line_padding lheight_total = line_padding lines = text_wrap(afont, alt, w) t@@ -57,11 +54,8 @@ def add_text(image, title, alt, tfont=download_dir+'xkcd.ttf', for i in lines: if not i: continue - draw.text((w/2-afont.getsize(" ".join(i))[0]/2, - lheight_total), - " ".join(i), - font=afont, - fill=0xffffff) + draw.text((w/2-afont.getsize(" ".join(i))[0]/2, lheight_total), + " ".join(i), font=afont, fill=0xffffff) lheight_total += lheight + line_padding img.save(image) t@@ -108,8 +102,8 @@ def main(): info = get("https://xkcd.com/"+str(randrange(1, info['num']) + 1)+"/info.0.json").json() title = info['safe_title'] - alt = info['alt'] - num = str(info['num']) + alt = info['alt'] + num = str(info['num']) image = num+search("\.([a-z])+$", info['img']).group() DIR diff --git a/xlstojson.py b/xlstojson.py t@@ -0,0 +1,68 @@ +#!/usr/bin/env python3 +import xlrd +import json +import os.path +import sys + +def getColNames(sheet): + rowSize = sheet.row_len(0) + colValues = sheet.row_values(0, 0, rowSize ) + columnNames = [] + + for value in colValues: + columnNames.append(value) + + return columnNames + +def getRowData(row, columnNames): + rowData = {} + counter = 0 + + for cell in row: + rowData[columnNames[counter]] = cell.value + counter +=1 + + return rowData + +def getSheetData(sheet, columnNames): + nRows = sheet.nrows + sheetData = [] + counter = 1 + + for idx in range(1, nRows): + row = sheet.row(idx) + rowData = getRowData(row, columnNames) + sheetData.append(rowData) + + return sheetData + +def getWorkBookData(workbook): + nsheets = workbook.nsheets + counter = 0 + workbookdata = {} + + for idx in range(0, nsheets): + worksheet = workbook.sheet_by_index(idx) + columnNames = getColNames(worksheet) + sheetdata = getSheetData(worksheet, columnNames) + workbookdata[worksheet.name] = sheetdata + + return workbookdata + +def main(): + filename = sys.argv[1] + + if os.path.isfile(filename): + workbook = xlrd.open_workbook(filename, encoding_override="cp1252") + workbookdata = getWorkBookData(workbook) + output = \ + open((filename.replace("xlsx", "json")).replace("xls", "json"), "w") + output.write(json.dumps(workbookdata, sort_keys=True, indent=4, separators=(',', ": "))) + output.close() + print("%s was created" % output.name) + else: + print("Sorry, that was not a valid filename") + + + +main()