def base_context(fun):
def decorate_maker(nums,*args):
fun.func_globals['nums'] = nums
return fun(*args)
return decorate_maker
@base_context
def fun(pow):
return [(k,v**pow) for k,v in nums.iteritems()]
nums = {'one':1,'two':2,'four':4}
>>>>fun(nums,2)
[('four', 16), ('two', 4), ('one', 1)]
>>>>fun(nums,3)
[('four', 64), ('two', 8), ('one', 1)]
def base_context(fun):
def decorate_maker(request, slug, var):
context = {}
context['info'] = slug
fun.func_globals['context']=context
return fun(request, var)
return decorate_maker
SELECT a.category_id AS id, COUNT(b.product_id) AS p_count
FROM a
LEFT JOIN b ON a.product_id=b.product_id and b.manufacturer_id = 'Мелкософт'
GROUP BY id
CASE
WHEN (duration > (extract(epoch from (time - '2015-08-29 12:36:50'))) )
THEN extract(epoch from (time - '2015-08-29 12:36:50'))
ELSE duration
END AS trim_duration
LEAST(duration, extract(epoch from (time - '2015-08-29 12:36:50')))
select distinct c.client_id
from clients c
left join (select client_id
from clients
where service_id = 5) s on s.client_id = c.client_id
where s.client_id is null
UPDATE products p
JOIN update_info ui ON t.id = ui.id
SET p.price = ui.price
$all_sales_select = mysql_query('
SELECT sc.*, wpu.money, scm.value
FROM sales_catalog sc
LEFT JOIN wp_users wpu
ON sc.sale_provider_id = wpu.ID
LEFT JOIN (select sale_id, max(value) as value
from sales_catalog_meta
WHERE type = "image"
group by sale_id) scm
ON sc.sale_id = scm.sale_id
WHERE sc.sale_provider_id="'.$user_id.'"
ORDER BY sc.insert_date, sc.sale_id') or die(mysql_error());
Warning
Never, never, NEVER use Python string concatenation (+) or string parameters interpolation (%) to pass variables to a SQL query string. Not even at gunpoint.