Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
"createdb.rb" recipe needs a templated T-SQL script to create databases
--
-- Author:: <%= @author_name %> / <%= @author_email %>
-- Cookbook Name:: windows
-- Templates:: <%= @basesql_template %>
--
-- Copyright 2010, Smashrun, Inc.
--
-- Licensed under the Apache License, Version 2.0 (the "License");
-- you may not use this file except in compliance with the License.
-- You may obtain a copy of the License at
--
-- http://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing, software
-- distributed under the License is distributed on an "AS IS" BASIS,
-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the License for the specific language governing permissions and
-- limitations under the License.
--
-- http://msdn.microsoft.com/en-us/library/ms176061.aspx
<% @database.each do |db| -%>
--
-- begin create <%= db['id'] %> for <%= db['owner'] %> with comment <%= db['comment'] %>
USE master;
GO
CREATE DATABASE <%= db['id'] %>
ON
( NAME = <%= db['id'] %>,
FILENAME = '<%= db['datadrive'] %><%= db['datadir'] %>\<%= db['datafile'] %>',
SIZE = <%= db['datainitsize'] %>,
MAXSIZE = <%= db['datamaxsize'] %>,
FILEGROWTH = 3% )
LOG ON
( NAME = <%= db['id'] %>_log,
FILENAME = '<%= db['transdrive'] %><%= db['transdir'] %>\<%= db['transfile'] %>',
SIZE = <%= db['transinitsize'] %>,
MAXSIZE = <%= db['transmaxsize'] %>,
FILEGROWTH = 10% )
COLLATE <%= db['collation'] %>;
GO
<% end -%>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment