Skip to content

Instantly share code, notes, and snippets.

View roelvanduijnhoven's full-sized avatar

Roel van Duijnhoven roelvanduijnhoven

17 followers · 22 following
View GitHub Profile
@roelvanduijnhoven
roelvanduijnhoven / index.htm
Created January 14, 2013 15:08 — forked from hbi99/index.htm
<!DOCTYPE html>
<html>
<head>
<title></title>
<meta charset="UTF-8" />
<link rel="stylesheet/less" type="text/css" href="test.less">
<script type="text/javascript" src="less.js"></script>
<script type="text/javascript">
window.onload = function() {
@roelvanduijnhoven
roelvanduijnhoven / gist:6477492
Last active November 3, 2017 11:39
Vagrant debug log
INFO global: Vagrant version: 1.3.1
INFO manager: Registered plugin: ssh communicator
INFO manager: Registered plugin: file
INFO manager: Registered plugin: chef
INFO manager: Registered plugin: shell
INFO manager: Registered plugin: ansible
INFO manager: Registered plugin: CFEngine Provisioner
INFO manager: Registered plugin: salt
INFO manager: Registered plugin: puppet
INFO manager: Registered plugin: Arch guest
@roelvanduijnhoven
roelvanduijnhoven / update-to-v4.php
Created January 26, 2015 16:03
Update existing records for slm/queue-doctrine to latest version
public function up(Schema $schema)
{
$jobs = $this->connection->query("
SELECT id, data
FROM queue_default
")->fetchAll(Query::HYDRATE_ARRAY);
foreach ($jobs as $job) {
// Skip already correct instances
$data = json_decode($job['data'], true);
@roelvanduijnhoven
roelvanduijnhoven / migration-1.php
Last active March 7, 2023 15:55
Data for pinned migrations
<?php
// SELECT website.id
// FROM website
// INNER JOIN page ON page.websiteId = website.id
// INNER JOIN pageContent ON page.pageContentId = pageContent.id
// INNER JOIN element nonPinnedElement ON nonPinnedElement.parent_id = pageContent.footerElementId AND nonPinnedElement.pluginName != 'pin'
// WHERE website.deletedAt IS NULL
// AND website.id IN (
// SELECT website.id