Carlos C. Leite cadu-leite

Download and Install Postgres.app

Before we can setup PostGIS we need to have a local version of Postgresql installed and running. The most effecient way to do this is to download and install Postgres.app.

Spatially Enable your Postgres Database

Once Postgres.app is installed in your computers /Applications directory. Open the Terminal and enter the following two commands

psql -d DATABASE_NAME -f /Applications/Postgres.app/Contents/Versions/9.3/share/postgresql/contrib/postgis-2.1/postgis.sql

	-- show running queries (pre 9.2)
	SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(clock_timestamp(), query_start), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

	'''

	get key values based on dot path

	based on dict or json

	d = {
	'd1': 1,
	'd2': {
	'a': 2, 'b': 3, },

	// http://localhost:8080/contact/form/
	// oReq.open("GET", "http://localhost:8080/contact/form");
	// id_SubmitContact


	var container = "header";
	var formId = "id-contactform";
	var url_post = "/contact/form/"

	function callBackLoad(){

	import unittest
	import xml
	from unittest.mock import Mock, patch

	import modulo1
	from modulo1 import get_tag_content


	class TestMockXML(unittest.TestCase):

	fswatch -l 45 -r . -e ".*" -i "\\.py$" -o \| xargs -n1 -I{} python -m unittest


	fswatch -l 15 -r . -e ".*" -i "\\.py$" -o \| xargs -n1 -I{} python -m unittest --verbose