James Lambie jimlambie

## postgres

# export to CSV file
psql -d <database> -c "COPY (SELECT * FROM <table_name>) TO '/full/path/to.csv' WITH CSV"

# import from CSV
psql -d <database> -c "COPY <table_name> FROM '/full/path/to.csv' DELIMITER ',' CSV"

# import SQL file
psql -d <database> -f <filename>

## RefineryCMS
# Creating an engine, RefineryCMS 2.0.9
rails generate refinery:engine home_image title:string description:text image:image

## Gemfile
source "https://rubygems.org"

#ruby "1.9.3"

gem "rails", "3.2.14"
gem "pg"
gem "unicorn"

group :development do
  gem "heroku_san"

## recursive remove .AppleDouble directories
find . -name \.AppleDouble -exec rm -rf {} \;

## Remove local git branches
git branch --merged | grep -v "\*" | xargs -n 1 git branch -d

## heroku cache flush
cache = Dalli::Client.new
cache.flush

## create_branch_from_tag
-Go to the starting point of the project
>> git checkout origin master
-fetch all objects
>> git fetch origin
-Make the branch from the tag
>> git branch new_branch tag_name
-Checkout the branch
>> git checkout new_branch
-Push the branch up
>> git push origin new_branch

## kirby.js
'use strict'

const _ = require('underscore')
const fs = require('fs')
const path = require('path')
const readDir = require('readdir')
const templateStore = require(path.join(__dirname, '/../templates/store'))
const walk = require('walkdir')

const visiblePageRe = /^\d+-/

## pyncheon-migrator.js
#! /usr/bin/node

const fs = require('fs')
const path = require('path')

const args = process.argv

if (!args && args[2]) {
  process.exit(1)
}

## add.md

      
        
          
            
              
              1 file
            
          
          
            
              
              0 forks
            
          
          
            
              
              0 comments
            
          
          
            
              
              0 stars
            
          
        
        
          
              
          
          
            
                jimlambie
                / add.md
            
            
              Created
              November 16, 2017 21:09
            
          
        
      
        
  
      
    0x0078E498b87A1E683A7A7CdF5E4EDfEb463dA763

	# export to CSV file
	psql -d <database> -c "COPY (SELECT * FROM <table_name>) TO '/full/path/to.csv' WITH CSV"

	# import from CSV
	psql -d <database> -c "COPY <table_name> FROM '/full/path/to.csv' DELIMITER ',' CSV"

	# import SQL file
	psql -d <database> -f <filename>
	# Creating an engine, RefineryCMS 2.0.9
	rails generate refinery:engine home_image title:string description:text image:image
	source "https://rubygems.org"

	#ruby "1.9.3"

	gem "rails", "3.2.14"
	gem "pg"
	gem "unicorn"

	group :development do
	gem "heroku_san"
	-Go to the starting point of the project
	>> git checkout origin master
	-fetch all objects
	>> git fetch origin
	-Make the branch from the tag
	>> git branch new_branch tag_name
	-Checkout the branch
	>> git checkout new_branch
	-Push the branch up
	>> git push origin new_branch
	'use strict'

	const _ = require('underscore')
	const fs = require('fs')
	const path = require('path')
	const readDir = require('readdir')
	const templateStore = require(path.join(__dirname, '/../templates/store'))
	const walk = require('walkdir')

	const visiblePageRe = /^\d+-/
	#! /usr/bin/node

	const fs = require('fs')
	const path = require('path')

	const args = process.argv

	if (!args && args[2]) {
	process.exit(1)
	}