toyg’s gists

toyg / gist:9fb541ff3dbc8c175329

Last active August 29, 2015 14:27

	from sqlalchemy import create_engine, MetaData, Table, PrimaryKeyConstraint
	from sqlalchemy.ext.declarative import declarative_base
	from sqlalchemy.orm import sessionmaker
	from sqlalchemy.dialects.oracle import RAW, NUMBER

	from sqlalchemy.ext.compiler import compiles
	from sqlalchemy.types import BINARY

	@compiles(RAW, "oracle")
	def compile_raw_oracle(type_, compiler, **kw):

toyg / 0_reuse_code.js

Created February 11, 2016 16:30

Here are some things you can do with Gists in GistBox.

	// Use Gists to store code you would like to remember later on
	console.log(window); // log the "window" object to the console

toyg / set_login_background.sh

Last active May 25, 2016 16:05

Change Login background image in OSX. Execute with sudo; takes 1 parameter, the path to your new file (must be a PNG image).

	#!/bin/bash

	chflags nouchg /Library/Caches/com.apple.desktop.admin.png
	cp /Library/Caches/com.apple.desktop.admin.png /Library/Caches/com.apple.desktop.admin.BACKUP.png
	cp $1 /Library/Caches/com.apple.desktop.admin.png
	chflags uchg /Library/Caches/com.apple.desktop.admin.png

toyg / Synopsifier.user.js

Last active June 25, 2018 14:39

Synopsifier.user.js

	// ==UserScript==
	// @name Synopsifier
	// @namespace http://pythonaro.com/
	// @version 1.0
	// @description add movie details when browsing directories.
	// @author toyg
	// @match http://mc1.dl3enter.in/*
	// @grant GM_xmlhttpRequest
	// @connect themoviedb.org
	// ==/UserScript==

toyg / download.py

Last active August 26, 2017 09:40

IT books downloader

	# original source: https://www.reddit.com/r/opendirectories/comments/6vysrh/lots_of_italian_books_is_there_any_way_to/dm46nig/
	# plus a few tweaks from me.
	# This is a Python 2.7 script; you will also need Requests and BeautifulSoup.
	# If you have virtualenv installed:
	# $> virtualenv env
	# $> source env/bin/activate
	# $> pip install requests beautifulsoup
	# $> python download.py

	import codecs

toyg / CMakeError.log

Last active October 21, 2017 16:25

waifu2x error

	Determining if the CL_VERSION_2_0 exist failed with the following output:
	Change Dir: /Users/toyg/Dev/waifu2x-dev/CMakeFiles/CMakeTmp

	Run Build Command:"/usr/bin/make" "cmTC_90b7e/fast"
	/Applications/Xcode.app/Contents/Developer/usr/bin/make -f CMakeFiles/cmTC_90b7e.dir/build.make CMakeFiles/cmTC_90b7e.dir/build
	Building C object CMakeFiles/cmTC_90b7e.dir/CheckSymbolExists.c.o
	/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/cc -o CMakeFiles/cmTC_90b7e.dir/CheckSymbolExists.c.o -c /Users/toyg/Dev/waifu2x-dev/CMakeFiles/CMakeTmp/CheckSymbolExists.c
	/Users/toyg/Dev/waifu2x-dev/CMakeFiles/CMakeTmp/CheckSymbolExists.c:8:19: error: use of undeclared identifier 'CL_VERSION_2_0'
	return ((int*)(&CL_VERSION_2_0))[argc];
	^

toyg / error.txt

Created October 21, 2017 20:33

waifu2pico

	/usr/local/Cellar/cmake/3.9.0/bin/cmake -H/Users/toyg/Dev/waifu2x-dev -B/Users/toyg/Dev/waifu2x-dev --check-build-system CMakeFiles/Makefile.cmake 0
	/usr/local/Cellar/cmake/3.9.0/bin/cmake -E cmake_progress_start /Users/toyg/Dev/waifu2x-dev/CMakeFiles /Users/toyg/Dev/waifu2x-dev/CMakeFiles/progress.marks
	/Applications/Xcode.app/Contents/Developer/usr/bin/make -f CMakeFiles/Makefile2 all
	/Applications/Xcode.app/Contents/Developer/usr/bin/make -f CMakeFiles/conv.dir/build.make CMakeFiles/conv.dir/depend
	cd /Users/toyg/Dev/waifu2x-dev && /usr/local/Cellar/cmake/3.9.0/bin/cmake -E cmake_depends "Unix Makefiles" /Users/toyg/Dev/waifu2x-dev /Users/toyg/Dev/waifu2x-dev /Users/toyg/Dev/waifu2x-dev /Users/toyg/Dev/waifu2x-dev /Users/toyg/Dev/waifu2x-dev/CMakeFiles/conv.dir/DependInfo.cmake --color=
	/Applications/Xcode.app/Contents/Developer/usr/bin/make -f CMakeFiles/conv.dir/build.make CMakeFiles/conv.dir/build
	make[2]: Nothing to be done for `CMakeFiles/conv.dir/build'.
	[ 8%] Built target conv
	/Applications/Xcode.a

toyg / Get-ServiceUpTime.ps1

Created November 2, 2017 12:05

PowerShell Function to query each service and show the start time from the associated process

	function Get-ServiceUpTime
	{
	[CmdletBinding()]
	param
	(
	# Name of Computer(s) to query
	[Parameter(Mandatory = $false,
	Position = 1,
	ValueFromPipelineByPropertyName = $true)]
	[string[]]$ComputerName = $env:COMPUTERNAME,

toyg / query_EPM_COMPONENTS.ps1

Created November 2, 2017 12:06

Query a Foundation database to retrieve EPM Component data from SQLServer. This uses the .NET SqlClient assembly, so will work from any .NET 2.0 computer

	#requires -Version 1
	$SQLconn = New-Object -TypeName System.Data.SqlClient.SqlConnection -ArgumentList ('server=ardy-sql01; database=foundation; uid=EPMSQL; pwd=Hyp3r10n')
	$SQLconn.Open()
	$SQLcmd = $SQLconn.CreateCommand()
	$SQLcmd.CommandType = [System.Data.CommandType]::Text
	$SQLcmd.CommandText =
	'SELECT COMPONENT_NAME, PROPERTY_NAME, PROPERTY_VALUE FROM HSS_COMPONENT_PROPERTY_VALUES inner join HSS_COMPONENT on HSS_COMPONENT_PROPERTY_VALUES.COMPONENT_ID = HSS_COMPONENT.COMPONENT_ID order by component_name asc'
	$data = $SQLcmd.ExecuteReader()

	$dataTable = New-Object -TypeName 'System.Data.DataTable'

toyg / nic_metrics.ps1

Created November 2, 2017 12:06

Manually set Windows "Metrics" values for network cards. When a server has multiple cards, you are often forced to disable Windows' automatic "metrics", to make sure EPM traffic goes on the right interface.

	# To use this script, rename LAN, BACKUP etc to match relevant network card names
	# in your environment (you can add or remove lines as well),
	# and set values to match your metric preference (1 is the preferred card).

	# All cards not mentioned here will be set to 100.

	$cards = @{} # don't touch this line

	$cards.LAN = 1
	$cards.BACKUP = 99

Giacomo Lacava toyg