nmandery

create or replace function public.hexcolor_to_mapserver(hexcolor text) returns text as
$body$
declare
	thexcolor text;
	color_r int;
	color_g int;
	color_b int;
begin
	thexcolor := trim(both ' ' from hexcolor);
	if not thexcolor ~ '^#[0-9a-fA-F]{6}$' then

nmandery

create or replace view public.size_schemata as 
select table_schema,
 pg_size_pretty(sum(pg_total_relation_size(table_schema || '."' || table_name || '"')::bigint)::bigint) As fulltblsize, 
 pg_size_pretty(sum(pg_relation_size(table_schema || '."' || table_name || '"')::bigint)::bigint) As justthetblsize
from information_schema.tables
where table_catalog = current_database()
group by table_schema

nmandery

function wget_github {
    GHUSER=$1
    GHREPO=$2
    wget --no-check-certificate "https://nodeload.github.com/$GHUSER/$GHREPO/tarball/master" -O "./$GHUSER-$GHREPO.tar.gz"
}

nmandery

#!/usr/bin/python

import alsaaudio, time, audioop
import sys
import piggyphoto


# init camera
try:
    C = piggyphoto.camera()

nmandery

CREATE OR REPLACE FUNCTION posting_set_keywords(postingid integer, kw_array text[])
  RETURNS void AS
$BODY$
begin
	-- remove keywords which do not anymore exist
	delete from test.posting_keyword where 
		posting_id=postingid and 
		keyword_id in (
			select pl.keyword_id 
				from test.posting_keyword lk

nmandery

# -*- coding: utf-8 -*-

from mapmatters.client import wms as wmsclient
from mapmatters.parser import wms as wmsparser

WMS_URL = "http://www.example.com/wms"

wms = wmsclient.WmsClient(WMS_URL)

parser = wmsparser.Service(wms.capabilities)

nmandery

#!/usr/bin/lua
--[[
a parser for google-like search queries
]]--


lex_keywords = {
  -- keywords with quotes
  "([a-zA-Z]+)%s*:%s*[\"\']([^\"\']+)[\"\']",
  -- keywords without quotes