Skip to content

Instantly share code, notes, and snippets.

$data = SomeModel:join('table2', 'column1', 'column2')
->join('table3', 'column1', 'column2')
->where table1.some_column = 'x'
->where table2.some_column = 'y'
->where table3.some_column = 'z'
->orderBy('table2.score')
->select('column1,column2,column3')
->distinct();
When i do a ->toSql() and review the query i see it includes deleted rows of table 2 or table 3 so i have to explicitly remove with something like this:
DB::table('tasks')->insert(
[
'name' => 'TestTaskJob1',
'command_name' => 'command:testtaskjob1',
'number_of_params' => 2
],[
'name' => 'TestTaskJob2',
'command_name' => 'command:testtaskjob2',
'number_of_params' => 3
]
// ==UserScript==
// @name Block LibertyBaller Trolls (aka the HellzBellz1970 blocker)
// @namespace http://tampermonkey.net/
// @version 0.1
// @description try to take over the world!
// @author armyofda12mnkeys aka persianninja
// @include http://www.libertyballers.com/*
// @include http://libertyballers.com/*
// @include https://www.libertyballers.com/*
// @include https://libertyballers.com/*
@armyofda12mnkeys
armyofda12mnkeys / index.js
Created January 23, 2012 17:23
process.nextTick example
var http = require('http')
var MyConstructor = require('./myconstructor')
http.createServer(function(request, response) {
var c = new MyConstructor();
c.on('data', function(data) {
console.log(data);
});
c.on('end', function(){ console.log('end'); } );
@armyofda12mnkeys
armyofda12mnkeys / KitchenTimer.js
Created January 18, 2012 15:49
KitchenTimer (Node OOP example)
var oop = require('oop');
var EventEmitter = require('events').EventEmitter;
var util = require('util');
//console.dir(oop); doesnt have inherits method?
function KitchenTimer(properties) {
this._interval = null;
this._timeout = null;
this._minutes = null;
@armyofda12mnkeys
armyofda12mnkeys / index.js
Created January 17, 2012 15:23
simple request handler/router server (requires formidable module installed)
var server = require("./server");
var router = require("./router");
var requestHandlers = require("./requestHandlers");
var handle = {}
handle["/"] = requestHandlers.start1;
handle["/start1"] = requestHandlers.start1;
handle["/upload1"] = requestHandlers.upload1;
handle["/start2"] = requestHandlers.start2;
handle["/upload2"] = requestHandlers.upload2;