aisayko

try:
    page_number = int(cur_page)
except ValueError:
    raise Http404

try:
    page_obj = paginator.page(page_number)
except InvalidPage:
    raise Http404

aisayko

-- show running queries (pre 9.2)
SELECT procpid, age(query_start, clock_timestamp()), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(query_start, clock_timestamp()), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

aisayko

def bulk_upsert(model, fields, values, by):
    stmt = """
    WITH
    -- write the new values
    data_set(%s) AS (
      VALUES %s
    ),
    -- update existing rows
    upsert AS (
      UPDATE %s t

aisayko

def bulk_upsert(model, fields, values, by):
    """
    Return the tuple of (inserted, updated) ids
    """
    result = (None, None)

    if values:
        stmt = """
        WITH data_set AS (
            INSERT INTO %s (%s)