Instiki - Revision history

Brianegge at 17:50, 17 August 2006

2006-08-17T17:50:08Z

← Older revision		Revision as of 17:50, 17 August 2006
Line 1:		Line 1:
	I created a setup script to help me get Instiki running from source. So far I have it working with SQLite, but I'd like to get mysql working as ~~wel~~.		I created a setup script to help me get Instiki running from source. So far I have it working with SQLite, but I'd like to get mysql working as well.

	<pre>		<pre>

Brianegge at 03:35, 24 June 2006

2006-06-24T03:35:47Z

@@ Line 26: / Line 26: @@
      settings.each {|k,v| io.puts "  #{k}: #{v}"}
      io.puts
    end
 end
@@ Line 54: / Line 68: @@
 when "sqlite3"
    configs.each {|k,v| v['database'] = "db/#{k}.db.sqlite3"}
 end
@@ Line 81: / Line 108: @@
 when "sqlite3"
    Find.find('db') { |f| File.delete(f) if f =~ /.*\.db/ }
 end

Brianegge at 14:49, 13 June 2006

2006-06-13T14:49:57Z

← Older revision		Revision as of 14:49, 13 June 2006
Line 1:		Line 1:
	I created a setup script to help me get Instiki running from source. So far I have it working with ~~isql~~, but I'd like to get mysql working as wel.		I created a setup script to help me get Instiki running from source. So far I have it working with SQLite, but I'd like to get mysql working as wel.

	<pre>		<pre>

Brianegge at 02:27, 13 June 2006

2006-06-13T02:27:54Z

New page

I created a setup script to help me get Instiki running from source. So far I have it working with isql, but I'd like to get mysql working as wel.

<pre>
#!/usr/bin/env ruby

require 'stringio'
require 'ftools'
require 'find'

def get(prompt)
print prompt
res = readline.chomp
throw :quit_requested if res == "!"
res
end

def choose(prompt, list)
(1..list.length).each {|x| puts "#{x}) #{list[x-1]}"}
i = get(prompt + " (1-#{list.length}): ")
list[i.to_i - 1]
end

def show_configs(configs, io)
configs.each do |name,settings|
io.puts "#{name}:"
settings.each {|k,v| io.puts " #{k}: #{v}"}
io.puts
end
end

puts "This script will help you configure your database.yml file."

adapters = []

`which mysql`
if $? == 0 then
adapters << "mysql"
end

# SQLite seems to return 1 for it's normal return code
`which sqlite3`
if $? == 0 then
adapters << "sqlite3"
else
puts $?
end

adapter = choose('Select a database adapter', adapters)

configs = { 'development' => {}, 'test' => {}, 'production' => {}}

configs.each {|k,v| v['adapter'] = adapter}
case adapter
when "sqlite3"
configs.each {|k,v| v['database'] = "db/#{k}.db.sqlite3"}
end

str = StringIO.new()

show_configs(configs, str)

puts "Created database config:"
puts str.string

if File.file?('config/database.yml') then
if get("Would you like to replace database.yml with the above config? (Y/n) ").downcase == 'n' then
puts "Cancelled"
exit 1
end
# backup the svn version
if !File.file?('config/database.yml.old')
File.move("config/database.yml", "config/database.yml.old", true)
end
end

File.open("config/database.yml", "w") do |file|
show_configs(configs, file)
end

case adapter
when "sqlite3"
Find.find('db') { |f| File.delete(f) if f =~ /.*\.db/ }
end

configs.each do |env,k|
system("rake migrate RAILS_ENV=#{env}")
end
</pre>