Skip to content

Instantly share code, notes, and snippets.

View ikks's full-sized avatar

Igor Támara ikks

View GitHub Profile
@ikks
ikks / gist:3344613
Created August 13, 2012 22:42
Añadir un dato a una tabla con hstore
INSERT INTO producto (nombre, atributos) VALUES (
'Bicicleta',
'color => "verde",
ruedas => 2,
tipo => "monareta"'
);
@ikks
ikks / gist:3344804
Created August 13, 2012 23:27
Algunas operaciones sobre hstore
-- Obtener las llaves como arreglo
SELECT nombre, akeys(atributos) FROM producto;
-- Saber si un producto tiene cierta característica
SELECT nombre, atributos -> talla FROM producto WHERE atributos ? 'talla';
-- Obtener el conjunto de características y sus valores para un producto
SELECT each(atributos) FROM producto WHERE name='pizza';
@ikks
ikks / gist:3371167
Created August 16, 2012 15:41
Colored Image in hover
img {
-webkit-transition: -webkit-filter 1s;
-webkit-filter: grayscale(1); /* Chrome */
filter: url(filters.svg#grayscale); /* Firefox 3.5+ */
filter: gray; /* IE6-9 */
}
img:hover {
-webkit-filter: grayscale(0); /* Chrome */
filter: none; /* Applies to FF + IE */
}
@ikks
ikks / gist:3497717
Created August 28, 2012 12:44
Install django-autocomplete-light
pip install django-autocomplete-light
@ikks
ikks / gist:3497811
Created August 28, 2012 13:02
urls for django-autocomplete-light
url(r'autocomplete/', include('autocomplete_light.urls')),
@ikks
ikks / gist:3497819
Created August 28, 2012 13:04
load django-automplete-light for admin
import autocomplete_light
autocomplete_light.autodiscover()
@ikks
ikks / gist:3497830
Created August 28, 2012 13:07
extending admin for django-autocomplete-light
{% extends "admin/base.html" %}
{% block extrahead %}
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js" type="text/javascript"></script>
{% include 'autocomplete_light/static.html' %}
{% endblock %}
@ikks
ikks / gist:3497909
Created August 28, 2012 13:21
Sample of autocomplete_light_registry.py
import autocomplete_light
from cities_light.models import City
autocomplete_light.register(City, search_fields=('search_names',),
autocomplete_js_attributes={'placeholder': 'city name ..'})
@ikks
ikks / gist:3497949
Created August 28, 2012 13:26
Extending a form for use django-autocomplete-light
from django.contrib import admin
import autocomplete_light
from models import Address
class AddressAdmin(admin.ModelAdmin):
form = autocomplete_light.modelform_factory(Address)
admin.site.register(Address, AddressAdmin)
@ikks
ikks / gist:3775774
Created September 24, 2012 12:45
Cart Sale Model Sample
class CartSale(models.Model):
first_name = models.CharField(
max_length=100,
)
last_name = models.CharField(
max_length=100,
)
date_sale = models.DateTimeField(
auto_now_add=True,
)