Filip Kral filipkral

## logging_to_sqlite_with_multiprocessing.py
import sqlite3
from contextlib import closing
import multiprocessing

def prepare_db(db, tbl, col):
    sql = "CREATE TABLE {0} ({1} text);".format(tbl, col)
    with closing(sqlite3.connect(db)) as cnn:
        cursor = cnn.cursor()
        cursor.execute('DROP TABLE IF EXISTS {0};'.format(tbl))
        cursor.execute(sql)

## python-cheat-sheet-basic.py
#!/usr/bin/env python

"""Basic Python Cheat Sheet by Filip Kral on 2015/02/16"""

"""
Python is a cross-platform, interpreted, object-oriented programming language.
That means you can run it on Linux, Windows, Mac, and other platforms,
you don't need to compile your code to execute it because it is compiled on
the fly, and you can use classes and objects.

## convert_sp_geojson.r
# Convert between geojson and sp spatial objects in R
require(rgdal)

# https://stat.duke.edu/~cr173/Sta523_Fa14/spatial_data.html
s <- '{ "type": "MultiPolygon", "coordinates": [
  [ [[40, 40], [20, 45], [45, 30], [40, 40]] ],
  [ [[20, 35], [10, 30], [10, 10], [30, 5], [45, 20], [20, 35]],
    [[30, 20], [20, 15], [20, 25], [30, 20]]
  ]
]}'

## reduce_repo_size.sh
# given that you accidentally added a large file to git branch feature/adding, then removed it in another commit, you can reduce the repo size by the following commands
# for more details and alternatives see https://confluence.atlassian.com/bitbucket/reduce-repository-size-321848262.html
git checkout develop
git merge --squash feature/adding
git branch -D feature/adding
#git reflog expire --expire=now --all
git gc --prune=now
git commit -m "Merged"

## read_and_write_spatialite.py
from osgeo import ogr, osr

def read_splt(db):
    drvr = ogr.GetDriverByName('SQLite')
    ds = drvr.Open(db, 0)
    layer=ds.GetLayer('pts')
    for feature in layer:
        print(feature)
        break

## snowfall_trivial.r
# A trivial example for parallel computation using R snowfall package
require(snowfall)
sfInit(paralell=TRUE, cpus=2)

fn <- function(x){
  return(x*x)
}

d <- 1:1000
result <- sfLapply(d, fn)

## gist:7441074
// to open a confirm dialog before you leave the page, enter this into the browser console (or the javascript code)
window.onbeforeunload = function(e){ var e = e || window.event; var msg ="Don't leave!"; if(e){e.returnvalue = msg;} return msg; }

## importing_osgeo_to_pyscripter.py
import sys, os
sys.path.insert(0, r'C:\OSGeo4W\apps\Python27\Lib\site-packages')
#sys.path.insert(0, r'C:\OSGeo4W\lib')
sys.path.insert(0, r'C:\OSGeo4W\bin')
#os.environ['PATH'] = os.environ['PATH'] + ';' + r'C:\OSGeo4W\lib'
os.environ['PATH'] = os.environ['PATH'] + ';' + r'C:\OSGeo4W\bin'

## mini-esri-leaflet.html
<!DOCTYPE html>
<html>
  <head>
    <title>Minimal Leaflet</title>
    <link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet-0.7.5/leaflet.css" />
    <style>
      #map{
        width: 150px;
        height:250px;
      }

## GitBasics
# https://confluence.atlassian.com/display/STASH/Basic+Git+commands

# simplest example

git clone https://github.com/some/repo repo
cd repo
# make changes to files
git commit -a -m "Commit message"
# you can check status by `git status`
git push origin master
	import sqlite3
	from contextlib import closing
	import multiprocessing

	def prepare_db(db, tbl, col):
	sql = "CREATE TABLE {0} ({1} text);".format(tbl, col)
	with closing(sqlite3.connect(db)) as cnn:
	cursor = cnn.cursor()
	cursor.execute('DROP TABLE IF EXISTS {0};'.format(tbl))
	cursor.execute(sql)
	#!/usr/bin/env python

	"""Basic Python Cheat Sheet by Filip Kral on 2015/02/16"""

	"""
	Python is a cross-platform, interpreted, object-oriented programming language.
	That means you can run it on Linux, Windows, Mac, and other platforms,
	you don't need to compile your code to execute it because it is compiled on
	the fly, and you can use classes and objects.
	# Convert between geojson and sp spatial objects in R
	require(rgdal)

	# https://stat.duke.edu/~cr173/Sta523_Fa14/spatial_data.html
	s <- '{ "type": "MultiPolygon", "coordinates": [
	[ [[40, 40], [20, 45], [45, 30], [40, 40]] ],
	[ [[20, 35], [10, 30], [10, 10], [30, 5], [45, 20], [20, 35]],
	[[30, 20], [20, 15], [20, 25], [30, 20]]
	]
	]}'
	# given that you accidentally added a large file to git branch feature/adding, then removed it in another commit, you can reduce the repo size by the following commands
	# for more details and alternatives see https://confluence.atlassian.com/bitbucket/reduce-repository-size-321848262.html
	git checkout develop
	git merge --squash feature/adding
	git branch -D feature/adding
	#git reflog expire --expire=now --all
	git gc --prune=now
	git commit -m "Merged"
	from osgeo import ogr, osr

	def read_splt(db):
	drvr = ogr.GetDriverByName('SQLite')
	ds = drvr.Open(db, 0)
	layer=ds.GetLayer('pts')
	for feature in layer:
	print(feature)
	break
	# A trivial example for parallel computation using R snowfall package
	require(snowfall)
	sfInit(paralell=TRUE, cpus=2)

	fn <- function(x){
	return(x*x)
	}

	d <- 1:1000
	result <- sfLapply(d, fn)
	// to open a confirm dialog before you leave the page, enter this into the browser console (or the javascript code)
	window.onbeforeunload = function(e){ var e = e \|\| window.event; var msg ="Don't leave!"; if(e){e.returnvalue = msg;} return msg; }
	import sys, os
	sys.path.insert(0, r'C:\OSGeo4W\apps\Python27\Lib\site-packages')
	#sys.path.insert(0, r'C:\OSGeo4W\lib')
	sys.path.insert(0, r'C:\OSGeo4W\bin')
	#os.environ['PATH'] = os.environ['PATH'] + ';' + r'C:\OSGeo4W\lib'
	os.environ['PATH'] = os.environ['PATH'] + ';' + r'C:\OSGeo4W\bin'
	<!DOCTYPE html>
	<html>
	<head>
	<title>Minimal Leaflet</title>
	<link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet-0.7.5/leaflet.css" />
	<style>
	#map{
	width: 150px;
	height:250px;
	}
	# https://confluence.atlassian.com/display/STASH/Basic+Git+commands

	# simplest example

	git clone https://github.com/some/repo repo
	cd repo
	# make changes to files
	git commit -a -m "Commit message"
	# you can check status by `git status`
	git push origin master