Skip to content

Instantly share code, notes, and snippets.

@LuciferSam86
LuciferSam86 / gist:b3c3f30336272f1f523c6cf0f48f10fb
Created September 13, 2022 13:53 — forked from dmckeone/gist:69334e2d8b27f586414a
Using virtualenv under PostgreSQL PL/Python

(All of this code tested in Enterprise DB PostgreSQL 9.4 Beta 1 and Python 3.3)

As of Virtualenv 1.3 (https://pypi.python.org/pypi/virtualenv) (and excluding Python 3.4's venv) there is an activate_this.py file within a virtualenv package that allows activation of a virtual environment within an embedded version of Python (like PostgreSQL's PL/Python). A Python 2/3 compatible version looks like this:

exec(open('/Some/VirtualEnv/Directory/myvirtualenv/bin/activate_this.py').read(), 
     dict(__file__='/Some/VirtualEnv/Directory/myvirtualenv/bin/activate_this.py'))

Where /Some/VirtualEnv/Directory is a directory and myvirtualenv is the name of the virtual environment in use. On Windows replace bin with Scripts.

@LuciferSam86
LuciferSam86 / network drive to UNC.cs
Last active July 14, 2020 13:08
Converting a mapped drive letter to a network path using C#
// Source: https://www.wiredprairie.us/blog/index.php/archives/22
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Runtime.InteropServices;
using System.IO;
namespace WiredPrairie.Samples