Skip to content

Instantly share code, notes, and snippets.

postgres@[local] clusto=# \d entities
Table "public.entities"
Column | Type | Modifiers
--------------------+------------------------+--------------------------------------------------------------
entity_id | integer | not null default nextval('entities_entity_id_seq'::regclass)
name | character varying(128) | not null
type | character varying(32) | not null
driver | character varying(32) | not null
version | integer | not null
deleted_at_version | integer |
import cProfile
import logging
import ConfigParser
import clusto
import time
from clusto.drivers import Pool, Driver
DB='sqlite:///:memory:'
def init_clusto():
@sloppyfocus
sloppyfocus / gist:1e6704be27c5f00930cb
Last active August 29, 2015 14:04
clusto PR 49 sql queries before
2014-07-16 22:25:09,717 sqlalchemy.engine.base.Engine INFO SELECT entities.entity_id AS entities_entity_id, entities.name AS entities_name, entities.type AS entities_type, entities.driver AS entities_driver, entities.version AS entities_version, entities.deleted_at_version AS entities_deleted_at_version
FROM entities
WHERE entities.deleted_at_version IS NULL AND entities.name = ?
2014-07-16 22:25:09,717 sqlalchemy.engine.base.Engine INFO (u'd5',)
2014-07-16 22:25:09,718 sqlalchemy.engine.base.Engine INFO SELECT entity_attrs.attr_id AS entity_attrs_attr_id, entity_attrs.entity_id AS entity_attrs_entity_id, entity_attrs."key" AS entity_attrs_key, entity_attrs.subkey AS entity_attrs_subkey, entity_attrs.number AS entity_attrs_number, entity_attrs.datatype AS entity_attrs_datatype, entity_attrs.int_value AS entity_attrs_int_value, entity_attrs.string_value AS entity_attrs_string_value, entity_attrs.datetime_value AS entity_attrs_datetime_value, entity_attrs.relation_id AS entity_attrs_relation_id, entity_attrs.
@sloppyfocus
sloppyfocus / gist:e0d91405f54da4b119e6
Last active August 29, 2015 14:04
clusto PR 49 sql queries after
2014-07-16 22:25:00,985 sqlalchemy.engine.base.Engine INFO SELECT entities.entity_id AS entities_entity_id, entities.name AS entities_name, entities.type AS entities_type, entities.driver AS entities_driver, entities.version AS entities_version, entities.deleted_at_version AS entities_deleted_at_version
FROM entities
WHERE entities.deleted_at_version IS NULL AND entities.name = ?
2014-07-16 22:25:00,985 sqlalchemy.engine.base.Engine INFO (u'd5',)
2014-07-16 22:25:00,987 sqlalchemy.engine.base.Engine INFO SELECT entity_attrs.attr_id AS entity_attrs_attr_id, entity_attrs.entity_id AS entity_attrs_entity_id, entity_attrs."key" AS entity_attrs_key, entity_attrs.subkey AS entity_attrs_subkey, entity_attrs.number AS entity_attrs_number, entity_attrs.datatype AS entity_attrs_datatype, entity_attrs.int_value AS entity_attrs_int_value, entity_attrs.string_value AS entity_attrs_string_value, entity_attrs.datetime_value AS entity_attrs_datetime_value, entity_attrs.relation_id AS entity_attrs_relation_id, entity_attrs.
@sloppyfocus
sloppyfocus / gist:8aed3b4dc9d4319c905c
Created July 16, 2014 22:27
Clusto performance testing script
import logging
import ConfigParser
import clusto
import time
from clusto.drivers import Pool, Driver
DB='sqlite:///:memory:'
def init_clusto():
conf = ConfigParser.ConfigParser()
"I loved the night. I think secretly all scientists exult in working
alone, surrounded by the urgent private quiet of the dark. I remember
the exhilaration of working through the night in the lab, drinking
thick pasty coffee that had been on the burner for hours, walking out
into the sunrise, grabbing breakfast at a diner and watching the city
come to life. To be doing something no one had ever done, to generate
rows amd columns of numbers that hinted at a solution to a problem no
one had ever solved ... to be alone and out on the edge like that,
there was no feeling like it in the world."