tpitale

SELECT created_on, note_count, sum(note_count) OVER (ORDER BY created_on ASC)
FROM (
  SELECT date_trunc('day', created_at) AS created_on, count(1) AS note_count
  FROM notes
  GROUP BY created_on
  ORDER BY created_on DESC
) AS note_counting;
-- WHERE created_on >= '2013-01-01'

tpitale

[1,2,3,4,5].each_cons(2).each_with_index do |(a, b), i|
  p a
  p b
  p i
end

tpitale

# connection and profile selection skipped

class Pageview
  extend Legato::Model
 
  metrics :pageviews
  dimensions :pagePath, :date
  filter :for_path, &lambda { |path| contains(:pagePath, path) }
end

tpitale

def wait_for_notify(&block)
  io = pg_connection.socket_io

  while @listening do
    Celluloid::IO.wait_readable(io) # blocks execution, but unblocks this actor
    pg_connection.consume_input # fetch any input on this connection

    # read the NOTIFY messages off the socket
    while notification = pg_connection.notifies do
      block.call(

tpitale

tpitale

import os; path=sublime.packages_path(); (os.makedirs(path) if not os.path.exists(path) else None); window.run_command('exec', {'cmd': ['git', 'clone', 'https://github.com/titoBouzout/SideBarEnhancements', 'SideBarEnhancements'], 'working_dir': path})

import os; path=sublime.packages_path(); window.run_command('exec', {'cmd': ['git', 'checkout', '37429739a0452a2dc36343fb7875ba7fcbeb88a9'], 'working_dir': os.path.join(path, 'SideBarEnhancements')})

tpitale

// Added to the bottom of tests/unit/model/errors_test.js

var env, store, Person, Dog;

module("unit/model/errors - model.save() triggers errors", {
  setup: function() {
    Person = DS.Model.extend({
      firstName: DS.attr(),
      lastName: DS.attr()
    });

tpitale

function convertId(id) { 
	if (id == null) return id;
	id = id.replace(/\"/g, '');
	if (id.length != 15) {
		return null;
	}
	var suffix = "";
	for (var i = 0; i < 3; i++) {
		var flags = 0;
		for (var j = 0; j < 5; j++) {

tpitale

import sublime_plugin


class AlwaysCenterCommand(sublime_plugin.EventListener):
    def on_modified(self, view):
        sel = view.sel()
        region = sel[0] if len(sel) == 1 else None
        if region != None:
            view.show_at_center(region)

tpitale

CREATE OR REPLACE VIEW next_episode_ids AS (
  SELECT id, ROW_NUMBER() OVER(PARTITION BY show_id ORDER BY airs_on) AS r
  FROM episodes
  WHERE airs_on >= NOW()
);

CREATE OR REPLACE VIEW next_episodes AS (
  SELECT * FROM episodes WHERE id IN (
    SELECT id FROM next_episode_ids WHERE r = 1
  )