Skip to content

Instantly share code, notes, and snippets.

View daniel70's full-sized avatar

Daniel van der Meulen daniel70

  • Single Source B.V.
  • Amsterdam, Netherlands
View GitHub Profile
@daniel70
daniel70 / purge_backups.py
Last active January 24, 2017 13:30
Purge backups with this simple script.
#!/usr/bin/env python
# author: Daniel van der Meulen
# email:
# purpose: Delete older backup files from directory
# We keep files younger than 1 month AND
# from the first day of the month from this year AND
# from the first day of the year
# Files that should not be deleted can be put in the exempt list
# curl -L https://gist.github.com/daniel70/6269559/download | tar xz --strip-components=1
@daniel70
daniel70 / designer.html
Created August 20, 2014 12:54
designer
<link rel="import" href="../core-scaffold/core-scaffold.html">
<link rel="import" href="../core-header-panel/core-header-panel.html">
<link rel="import" href="../core-menu/core-menu.html">
<link rel="import" href="../core-item/core-item.html">
<link rel="import" href="../core-icon-button/core-icon-button.html">
<link rel="import" href="../core-toolbar/core-toolbar.html">
<link rel="import" href="../core-menu/core-submenu.html">
<polymer-element name="imeneja-scaffold">
create extension if not exists hstore
drop table public.product;
create table public.product (
id serial,
nr int not null,
name varchar(100) not null,
names hstore null,
growing_months int[] null constraint valid_month check (growing_months <@ ARRAY[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12]),