Skip to content

Instantly share code, notes, and snippets.

View gileno's full-sized avatar

Gileno Filho gileno

View GitHub Profile
@gileno
gileno / date_utils.py
Created February 28, 2012 13:55
Script para contar apenas dias da semana
# -*- coding: utf-8 -*-
from datetime import date, timedelta
def add_weekdays(initial_date, days):
final_date = initial_date
for i in xrange(1, days + 1):
final_date = final_date + timedelta(days=1)
while final_date.weekday() in [5, 6]:
final_date = final_date + timedelta(days=1)
@gileno
gileno / setup.py
Created March 28, 2012 13:46
Exemplo de setup.py para gerar .exe
from distutils.core import setup
import py2exe
setup(
windows=[{
'script': 'main.py',
'icon_resources': [(1, "icon.ico")],
}],
options={
'py2exe': {
@gileno
gileno / export.sql
Created April 21, 2012 21:51
Exportar coluna
select address from mailer_email into outfile '/home/gileno/emails3.txt';
@gileno
gileno / gist:2602936
Created May 5, 2012 14:36
Uso do Select Extra
alternatives = Alternative.objects.filter(exercise=exercise)
select_sql = u'''select courses_solveexercise.response
from courses_solveexercise where
courses_solveexercise.user_id=%s and
courses_solveexercise.alternative_id=courses_alternative.id'''
alternatives = alternatives.extra(select=SortedDict([('user_response', select_sql)]),
select_params=[user.id])
@gileno
gileno / local_settings.py
Created May 28, 2012 22:37
Settings para Django e Gmail
# E-mails
DEFAULT_FROM_EMAIL = 'Nome <email@gmail.com>'
EMAIL_USE_TLS = True
EMAIL_HOST = 'smtp.gmail.com'
EMAIL_HOST_USER = 'email@gmail.com'
EMAIL_HOST_PASSWORD = 'senha'
EMAIL_PORT = 587
@gileno
gileno / fabfile.py
Created May 28, 2012 22:54
Sample of Fabric File
# -*- coding: utf-8 -*-
import os
import time
import settings
from fabric.contrib.console import confirm
from fabric.api import local, settings as fabric_settings, env, cd, run, sudo
env.hosts = ['domain_or_ip']
@gileno
gileno / pagination.html
Created June 23, 2012 03:32
Pagination Template Tag
{% if is_paginated %}
<div class="pagination pagination-right">
<ul>
{% if page_obj.has_previous %}
<li>
<a href="?page={{ page_obj.previous_page_number }}{{ getvars }}">&lsaquo;&lsaquo; anterior</a>
</li>
{% endif %}
{% for page in pages %}
{% if page %}
@gileno
gileno / utils.py
Created July 19, 2012 14:52
Servir arquivos estáticos protegidos com apache (x-sendfile) e django
# -*- coding: utf-8 -*-
import posixpath
import urllib
import os
from django.conf import settings
from django.views.static import serve
from django.http import HttpResponse
from django.utils.encoding import smart_str
@gileno
gileno / gunicorn.conf.py
Created August 18, 2013 14:03
Supervisor Conf / Guncorn Conf
#!/usr/bin/python
# -*- coding: utf-8 -*-
import os
import sys
bind = '127.0.0.1:9999'
workers = 2
logfile = '/tmp/gunicorn_project.log'
@gileno
gileno / models.py
Created October 30, 2013 23:03
Django values_list
from django.db import models
class Propriedade(models.Model):
pass
class PropriedadeRef(models.Model):