Skip to content

Instantly share code, notes, and snippets.

View gonz's full-sized avatar

Gonz Saavedra gonz

  • Montevideo, Uruguay
View GitHub Profile
;; Join next line or join all lines in region
(defun smart-join-line ()
"Join the current line with the line beneath it or all region lines."
(interactive)
(if (use-region-p)
(save-excursion
(let ((start-line (line-number-at-pos (region-beginning)))
(current-line (line-number-at-pos (region-end))))
(goto-char (region-end))
(while (> current-line start-line)
# -*- encoding: utf-8 -*-
from datetime import datetime
from scrapy.item import Item, Field
from scrapy.contrib.loader.processor import TakeFirst
from scrapy.contrib.loader import ItemLoader as ScrapyItemLoader
from sqlalchemy import DateTime
from sqlalchemy.orm import class_mapper
from sqlalchemy.orm.properties import ColumnProperty
from kickscraper.db.models import Project, User, Location, Category
@gonz
gonz / dict_get_dot.py
Last active December 19, 2015 03:08
get_dot(adict, 'key1.key2')
def get_dot(self, d, dotkey):
"""Get value from a dict with dot notation keys"""
try:
value = d
for key in dotkey.split('.'):
value = value.get(key)
return value
except AttributeError:
return None
@gonz
gonz / ger.py
Created July 4, 2013 16:13
sqlalchemy query
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, ForeignKey, String
from sqlalchemy.orm import relationship, sessionmaker, aliased
from sqlalchemy import create_engine, func
DATABASE_URI = 'postgresql://gonz@localhost:5432/ger'
engine = create_engine(DATABASE_URI, echo=True)
Session = sessionmaker(bind=engine)
function doQuery(type, user) {
var d = $q.defer();
var result = Alert.get({ 'type': type, 'user': user.id }, function() {
d.resolve(result);
});
return d.promise;
}
function getAllAlerts(user, alertsConfigured){
var d,
import json
from flask import Flask, abort
app = Flask(__name__)
data = {
1: {'id': 1}
}
@gonz
gonz / gist:5988527
Last active December 19, 2015 17:08
SQLAlchemy Talk references
* Python Database API Spec (PEP 243):

http://www.python.org/dev/peps/pep-0249/
* PostgreSQL DBAPI2 Implementations:

http://wiki.python.org/moin/PostgreSQL
* PostgreSQL DBAPI2 Implementations:

http://wiki.python.org/moin/MySQL
* psycopg2 documentation:
@gonz
gonz / gist:6032530
Last active December 19, 2015 23:08
Local ansible vagrantfile
# -*- mode: ruby -*-
# vi: set ft=ruby :
$script = <<SCRIPT
set -e
if [ ! -f /usr/local/bin/ansible-playbook ]
then
sudo apt-get update
sudo apt-get -y install python-setuptools python-dev
sudo easy_install pip
@gonz
gonz / gist:6065551
Last active December 20, 2015 03:39
Dict mapper
def get_dot(d, dotkey):
"""Get value from a dict-like object with dot notation keys"""
try:
value = d
for key in dotkey.split('.'):
value = value.get(key, {})
return value if value else None
except AttributeError:
return None
@gonz
gonz / gist:6156840
Created August 5, 2013 15:31
python/js flymake syntax check
(when (load "flymake" t)
;; python syntax check
(defun flymake-pyflakes-init ()
(let* ((temp-file (flymake-init-create-temp-buffer-copy
'flymake-create-temp-inplace))
(local-file (file-relative-name
temp-file
(file-name-directory buffer-file-name)))
(pycheck-bin (concat my-emacs-bin-directory