Skip to content

Instantly share code, notes, and snippets.

View rdapaz's full-sized avatar

ricdeez rdapaz

View GitHub Profile
@rdapaz
rdapaz / networkMath.py
Created June 25, 2019 09:45
Clever Network Maths
import sys
import os
import sqlite3
from ipaddress import IPv4Network
from socket import inet_ntoa, inet_aton
from struct import pack, unpack
def ip2long(ip_addr):
return unpack("!L", inet_aton(ip_addr))[0]
@rdapaz
rdapaz / dummy.py
Created April 1, 2020 00:40
Increment ID column on a table
import win32com.client as c
wordApp = c.gencache.EnsureDispatch('Word.Application')
wordApp.Visible = True
path = r'<DOC_PATH_HERE>'
doc = wordApp.Documents.Open(path)
for tbl in doc.Tables:
@rdapaz
rdapaz / web_video_control.bash
Created April 16, 2020 08:41
osoyoo robot video control
cd ~/osoyoo-robot/cam-robot/mjpg-streamer/
sudo ./start.sh
sudo webiopi -d -c /etc/webiopi/config
Then navigate to http:10.11.12.122:8000
@rdapaz
rdapaz / palo_alto_get_config_in_set_format.cfg
Created April 28, 2020 08:48
Palo Alto Firewalls: Get configuration in set mode format
set cli pager off
set cli config-output-format set
configure
show
@rdapaz
rdapaz / Visio_Bulk_Find_and_Replace.py
Last active May 22, 2020 05:18
Python script to do a visio find and replace
import re
import win32com.client as c
class VisioDrawing:
def __init__(self, path, pageName):
self.path = path
self.vsdApp = c.gencache.EnsureDispatch('Visio.Application')
self.vsdApp.Visible = True
self.vsd = self.vsdApp.Documents.Open(path)
@rdapaz
rdapaz / GenerateCiscoConfig.py
Created May 22, 2020 07:00
Using Jinja2 inline template to generate cisco switch changes
import re
import win32com.client as c
from jinja2 import FileSystemLoader, Environment, Template
xlApp = c.gencache.EnsureDispatch('Excel.Application')
xlApp.Visible = True
path = r'path.xlsx'
wk = xlApp.Workbooks.Open(path)
sh = wk.Worksheets('Sheet1 (2)')
@rdapaz
rdapaz / changespreadsheet.py
Created May 22, 2020 07:04
Change values in a spreadsheet from a Python dictionary of old to new values
import re
import win32com.client as c
subs = """
One|1
Two|2
""".splitlines()
subs = {k: v for k, v in [y.split('|') for y in subs if len(y) > 0]}
xlApp = c.gencache.EnsureDispatch('Excel.Application')
@rdapaz
rdapaz / generateDocFromYAMLData.py
Last active May 22, 2020 07:06
Generate document from data
# coding: utf-8
import os
import sys
import pprint
import win32com.client
import yaml
def pretty_printer(o):
@rdapaz
rdapaz / word_search_and_replace.py
Created June 4, 2020 06:17
MS Word - Search and Replace
import win32com.client as c
import pprint
import re
class Util:
@staticmethod
def pretty_printer(o):
pp = pprint.PrettyPrinter(indent=4)
pp.pprint(o)
@rdapaz
rdapaz / extractOtter.py
Created June 18, 2020 16:28
Extract book topics from Otter export
import re
rex = re.compile(r'([A-Za-z ]+)(?:[\., ]+)?([pPaAgGeE]{4},?(?:[\., ])?\d\d?\d?)')
# Info below comes from Otter text export (no reader ID, no timestamp)
# Topics are read out and then Page Number are read at the end
# Does reasonable job
data = """
ICS concepts.