m-kus

samlexrod

PostgreSQL Challenges

1. You need to build a pivot table WITHOUT using CROSSTAB function. Having two tables products and details you need to select a pivot table of products with counts of details occurrences (possible details values are ['good', 'ok', 'bad'].

SELECT
  distinct pro.name,
  (SELECT count(*) FROM details det2 WHERE det2.detail = 'good' AND det2.product_id = det.product_id) AS good,
  (SELECT count(*) FROM details det2 WHERE det2.detail = 'ok' AND det2.product_id = det.product_id) AS ok,
 (SELECT count(*) FROM details det2 WHERE det2.detail = 'bad' AND det2.product_id = det.product_id) AS bad

rmoff

erikaris

PhantomJS vs PyQt4 Crawler

PhantomJS usage

phantomjs crawl.js [URI] [OutDir]

PyQt4 usage

python crawl.py [URI] [OutDir]

IamAdiSri

First install pip for Python2. Download the get-pip.py file from https://bootstrap.pypa.io/get-pip.py
$ cd <download location>
$ sudo -H python ./get-pip.py

Installing pip also installs Python3
To run Python3
$ python3

Install pip3 by just executing the same file as in the step above, but this time using Python3
$ sudo -H python3 ./get-pip.py

subfuzion

Common Options

-#, --progress-bar Make curl display a simple progress bar instead of the more informational standard meter.

-b, --cookie <name=data> Supply cookie with request. If no =, then specifies the cookie file to use (see -c).

-c, --cookie-jar <file name> File to save response cookies to.

perrygeo

"""
topo2geojson.py
Convert topojson to geojson

Example Usage:
  python topo2geojson.py data.topojson data.geojson 


The topojson tested here was created using the mbostock topojson CLI
created with --spherical coords and --properties turned on

jaw111

{
  "@context": {
    "skos": "http://www.w3.org/2004/02/skos/core#"
  },
  "@type": "skos:ConceptScheme",
  "skos:hasTopConcept": {
    "@type": "skos:Concept"
  }
}

rickcnagy

#!/Library/Frameworks/Python.framework/Versions/2.7/bin/python

import csv


class CSV_IO(object):
    """class for reading/writing CSV objects
    can work standalone or as the backbone for CSVMatch"""

    def __init__(self, filepath):

hfossli

#!/bin/bash
 
# Created by Håvard Fossli <[email protected]> in 2013
# This is free and unencumbered software released into the public domain.
# For more information, please refer to <http://unlicense.org/>
#
# Description
# A bash script for reversing videos using ffmpeg and sox.
#
# Keywords