Trevor Copeland sicks
sicks
/ gist:15ced9b3e44d8ee90b51c2a76b6e07d7
Created
January 21, 2017 00:48
pg_restore in a docker container
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| docker cp backup_file_name db_container_name:backup_file_name | |
| docker exec db_container_name sh -c "pg_restore -C -d target_database_name backup_file_name" |
sicks
/ csv_for_excel.rb
Created
August 2, 2017 17:50
— forked from aghuddleston/csv_for_excel.rb
Write a CSV file using Ruby 2.2.2 which can open in Excel, properly displaying accents.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| require 'csv' | |
| module DownloadService | |
| OPEN_MODE = "w+:UTF-16LE:UTF-8" | |
| BOM = "\xEF\xBB\xBF" #Byte Order Mark | |
| def student_list | |
| File.open("#{file_name}.tsv", OPEN_MODE) do |f| | |
| csv_file = CSV.generate({:col_sep => "\t"}) do |csv| | |
| # header row |