Skip to content

Instantly share code, notes, and snippets.

View fadur's full-sized avatar

Feisal Adur fadur

View GitHub Profile
match (s:Session)-[r:HAS_SEEN]->(p:Product)
where r.event_timestamp > (timestamp()/1000 - 60*60*24)
with s, p, r
return p.id as product, count(distinct r) as seen
order by seen limit 20
{
"9373092": {
"price": {
"editing": false,
"data": "129,00",
"priceChangeOptions": false
},
"products": [
{
"style": "AC1428",
@fadur
fadur / Dockerfile
Last active February 25, 2016 13:23
simple container
FROM ubuntu:14.04
MAINTAINER Feisal Adur <[email protected]>
RUN apt-get update && apt-get install -y build-essential
RUN apt-get install -y python2.7 \
python-dev \
wget \
python-distribute \
xvfb \
firefox \
libpq-dev \
select date_trunc('month', start_date), sum(count(user_id))
over (
PARTITION by date_trunc('month', start_date)
ROWS BETWEEN 24 PRECEDING AND 1 PRECEDING
)
from cart_orders
where status in (1,2)
group by 1
order by 1;
fadur)fadur@~/Development/fadur/unisport/storefront:$ ./manage.py test catalog.tests.test_views.test_cms.test_categories
Creating test database for alias 'default'...
Got an error creating the test database: database "test_storefront" already exists
Type 'yes' if you would like to try deleting the test database 'test_storefront', or 'no' to cancel: yes
Destroying old test database 'default'...
Raven is not configured (logging is disabled). Please see the documentation for more information.
Raven is not configured (logging is disabled). Please see the documentation for more information.
.....
----------------------------------------------------------------------
(workers)www-data@worker-1:~/workers/current/storefront$ ./manage.py cache_catalog --special-categories latest
02/02/2015 09:46:52 AM [INFO] Caching "Latest"...
Traceback (most recent call last):
File "./manage.py", line 10, in <module>
execute_from_command_line(sys.argv)
File "/var/www/workers/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 399, in execute_from_command_line
utility.execute()
File "/var/www/workers/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 392, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/var/www/workers/local/lib/python2.7/site-packages/django/core/management/base.py", line 242, in run_from_argv

Keybase proof

I hereby claim:

  • I am fadur on github.
  • I am fadur (https://keybase.io/fadur) on keybase.
  • I have a public key whose fingerprint is F447 67A8 7EA4 A200 1DBF 46ED B0FD 827E 9BA8 A2DD

To claim this, I am signing this object:

@fadur
fadur / gist:10561015
Last active August 29, 2015 13:59
preseed.cfg
# Installation
# ============
# Installation of Ubuntu Server 13.04 “Raring Ringtail” is automated by
# 'preseeding' configuration options with the values expected for vagrant. The
# `ubuntu-server/raring64/preseed.cfg` file defines these options.
# Clock and Timezone
# ------------------
@fadur
fadur / gist:10457824
Created April 11, 2014 10:50
repack git repository
//pack is far too short to be a packfile
//github.com did not send all necessary objects
git config repack.usedeltabaseoffset false
git repack -a -d
@fadur
fadur / gist:9729828
Created March 23, 2014 21:05
filter orders,.. i want any filter
def tryk(self):
"""Orders that need print"""
initial = {'cms_status': 1, 'status': 1}
query = self.filter(**initial)
items = query.select_related('item_set__product', 'item_set').filter(
item_set__product__varetype_id=9,
item_set__product__delivery_id__in=(1,6)
).filter(Q(
~Q(item_set__player_flag__in = ['0', ''])|
~Q(item_set__number= '' )|