Skip to content

Instantly share code, notes, and snippets.

View jwhitehorn's full-sized avatar

Jason Whitehorn jwhitehorn

56 followers · 15 following
View GitHub Profile
@jwhitehorn
jwhitehorn / toc.xhtml
Created August 6, 2018 03:33
<html xmlns="http://www.w3.org/1999/xhtml" xmlns:epub="http://www.idpf.org/2007/ops">
<head></head>
<body>
<nav epub:type="toc" id="toc">
<h1>Table of contents</h1>
<ol>
<li><a href="intro.xhtml">Introduction</a> </li>
<li><a href="part1.xhtml">Part 1: Server to Client Updates</a> </li>
<li> <a href="chapter1.xhtml">Chapter 1: Whole Database Synchronization</a></li>
<li> <a href="chapter2.xhtml">Chapter 2: Delta-based Synchronization</a></li>
@jwhitehorn
jwhitehorn / trigger.sql
Last active May 2, 2018 04:44
create or replace function do_record_deleted_campground_reviews()
returns trigger as
$BODY$
begin
insert into deleted_records(table_name,record_id,deleted_at)
select 'campground_reviews', OLD.id, now();
end;
$BODY$
language plpgsql;
@jwhitehorn
jwhitehorn / database.js
Created April 30, 2018 17:33
var CampgroundReview = db.define("campground_reviews", {
headline: String,
body: String,
rating: Number,
campground_id: Number,
updated_at: Date
}, {
hooks: {
beforeSave: function(next){
this.updated_at = new Date();
@jwhitehorn
jwhitehorn / database.js
Created April 30, 2018 17:23
var DeletedRecord = db.define("deleted_records", {
table_name: String,
record_id: Number,
deleted_at: Date
}, {
hooks: {
beforeSave: function(next){
this.deleted_at = new Date();
next();
}
@jwhitehorn
jwhitehorn / NSArray+Construction.m
Created March 1, 2018 18:01
#import "NSArray+Construction.h"
@implementation NSArray (Construction)
+ (NSArray *) arrayWith:(int)count copiesOf:(NSString *)str {
NSMutableArray *result = [NSMutableArray new];
for(int i = 0; i != count; i++){
[result addObject:str];
}
return result;
@jwhitehorn
jwhitehorn / NSArray+Construction.h
Created March 1, 2018 18:01
#import <Foundation/Foundation.h>
@interface NSArray (Construction)
+ (NSArray *) arrayWith:(int)count copiesOf:(NSString *)str;
@end
@jwhitehorn
jwhitehorn / MostlyLastDayOfFeb.js
Created February 23, 2018 21:43
The oh so overshadowed, mostly last day of February
var isMostlyLastDayOfFebruary = function(){
var now = new Date();
var isFeb28 = now.getMonth() == 1 && now.getDate() == 28;
var year = now.GetFullYear();
var isLeapYear = year % 4 == 0 && !(year % 100 == 0 && year % 400 != 0);
return isFeb28 && !isLeapYear;
}
@jwhitehorn
jwhitehorn / database.js
Created February 5, 2018 18:14
var CampgroundPhoto = db.define("campground_photos", {
photo_url: String,
campground_id: Number,
updated_at: Date
}, {
hooks: {
beforeSave: function(next){
this.updated_at = new Date();
next();
}
@jwhitehorn
jwhitehorn / api.js
Created January 16, 2018 04:40
app.get('/api/updates/:model', function (req, res) {
@jwhitehorn
jwhitehorn / Sync.m
Created January 13, 2018 03:45
dispatch_async(syncQueue, ^{