metaskills

# Always make it easy to edit all the script.
$ which profile
profile: aliased to subl ~/.zshkit ~/.zshkit/01_path

# Always make it easy to version control my ZSH kit. 
# Ex: `profile-save "New Docker Functions"`
$ which profile-save
profile-save () {
  pushd ~/.zshkit/
  git add .

metaskills

>> RbConfig::CONFIG.each { |k,v| puts "#{k} => #{v}\n" } ; true
DESTDIR =>
MAJOR => 2
MINOR => 4
TEENY => 0
PATCHLEVEL => 0
INSTALL => /opt/local/bin/ginstall -c
EXEEXT =>
prefix => /Users/kencollins/.rbenv/versions/2.4.0
ruby_install_name => ruby

metaskills

find_header: checking for sybfront.h... -------------------- no

"clang -o conftest -I/Users/kencollins/.rbenv/versions/2.3.1/include/ruby-2.3.0/x86_64-darwin15 -I/Users/kencollins/.rbenv/versions/2.3.1/include/ruby-2.3.0/ruby/backward -I/Users/kencollins/.rbenv/versions/2.3.1/include/ruby-2.3.0 -I../../../../ext/tiny_tds -I/Users/kencollins/.rbenv/versions/2.3.1/include  -D_XOPEN_SOURCE -D_DARWIN_C_SOURCE -D_DARWIN_UNLIMITED_SELECT -D_REENTRANT    -O3 -Wno-error=shorten-64-to-32  -pipe conftest.c  -L. -L/Users/kencollins/.rbenv/versions/2.3.1/lib -L. -L/Users/kencollins/.rbenv/versions/2.3.1/lib  -fstack-protector     -lruby-static -framework CoreFoundation  -lpthread -ldl -lobjc "
checked program was:
/* begin */
1: #include "ruby.h"
2: 
3: int main(int argc, char **argv)
4: {
5:   return 0;

metaskills

$ gem install rails
$ rails new my_application --database=sqlserver
$ cd my_application

Now setup your development and test databases.

$ export SA_PASSWORD=...

metaskills

$ gem install rails
$ rails new my_application --database=sqlserver
$ cd my_application

<TEMPORARY-HACKS>

This section is obsolete when Rails v5.0.2 comes out. Open the config/database.yml and change the contents to look like this.

metaskills

require 'tiny_tds'
puts 'Connecting to SQL Server'
@client = TinyTds::Client.new(
  host: 'localhost', port: 1433,
  username: 'sa', password: ENV['SA_PASSWORD'],
  database: 'SampleDB'
)

def execute(sql)
  @client.execute(sql).do

metaskills

require 'tiny_tds'
puts 'Connecting to SQL Server'
@client = TinyTds::Client.new(
  host: 'localhost', port: 1433,
  username: 'sa', password: ENV['SA_PASSWORD'],
)
def execute(sql)
  @client.execute(sql).do
  true
end

metaskills

$ tsql -S localhost -U sa -P $SA_PASSWORD
locale is "en_US.UTF-8"
locale charset is "UTF-8"
using default charset "UTF-8"
1> SELECT @@VERSION
2> GO

Microsoft SQL Server vNext (CTP1.3) - 14.0.304.138 (X64)
	Feb 13 2017 16:49:12
	Copyright (C) 2016 Microsoft Corporation. All rights reserved.

metaskills

$ sudo apt-get install wget
$ sudo apt-get install build-essential
$ sudo apt-get install libc6-dev

$ wget ftp://ftp.freetds.org/pub/freetds/stable/freetds-1.00.27.tar.gz
$ tar -xzf freetds-1.00.27.tar.gz
$ cd freetds-1.00.27
$ ./configure --prefix=/usr/local --with-tdsver=7.3
$ make
$ make install

metaskills

Setting up freetds-common (0.91-6.1build1) ...
Setting up libsybdb5:amd64 (0.91-6.1build1) ...
Setting up freetds-bin (0.91-6.1build1) ...
Setting up libct4:amd64 (0.91-6.1build1) ...
Setting up freetds-dev (0.91-6.1build1) ...
Processing triggers for libc-bin (2.23-0ubuntu5) ...
root@9ecf83463240:/# tsql -C
Compile-time settings (established with the "configure" script)
                            Version: freetds v0.91
             freetds.conf directory: /etc/freetds