First of all we will need databases:
We will use "development" and "test" in our example here
In your SERVAGE CONTROL PANEL go to MySQL Databases
- Create new Database
- Name one Database biblioTest and another one biblioDev
- don't forget to type in a password
- Note all Database Connection Informations as we will need them later
In CONTROL PANEL open up Online - Filemanager
...
now go to www
(as Servage does not offer ssh you need to do the following steps externally and copy the result "biblio"-folder to the www folder and the databases contents to the databases via import-sql)
TYPE
>rails biblio
this command will create a folder named "biblio" and inside of it the following:
create
create app/controllers
create app/helpers
create app/models
create app/views/layouts
create config/environments
create components
create db
create doc
create lib
create lib/tasks
create log
create public/images
create public/javascripts
create public/stylesheets
create script/performance
create script/process
GO TO
$ cd biblio
TYPE
>./script/generate scaffold_resource Book title:string isbn:string created_at:datetime updated_at:datetime
This will create the following:
exists app/models/
exists app/controllers/
exists app/helpers/
create app/views/books
exists app/views/layouts/
exists test/functional/
exists test/unit/
create app/views/books/index.rhtml
create app/views/books/show.rhtml
create app/views/books/new.rhtml
create app/views/books/edit.rhtml
create app/views/layouts/books.rhtml
create public/stylesheets/scaffold.css
create app/models/book.rb
create app/controllers/books_controller.rb
create test/functional/books_controller_test.rb
create app/helpers/books_helper.rb
create test/unit/book_test.rb
create test/fixtures/books.yml
create db/migrate create db/migrate/001_create_books.rb
route map.resources :books
TYPE
$ rake db:migrate
If you type it here then you will receive the following error:
rake aborted!
No such file or directory - /tmp/mysql.sock
A well known error caused as until now your "biblio" don't know where to find the right database. Therefore we need to enter some database information.
GO TO
Control Panel
Online File Manager
/www/biblio/config
EDIT
database.yml
Into this
YAML(TM) Template you enter all database Values so that it looks like this:
# MySQL (default setup). Versions 4.1 and 5.0 are recommended.
#
# Install the MySQL driver:
# gem install mysql
# On MacOS X:
# gem install mysql -- --include=/usr/local/lib
# On Windows:
# gem install mysql
# Choose the win32 build.
# Install MySQL and put its /bin directory on your path.
#
# And be sure to use new-style password hashing:
# http://dev.mysql.com/doc/refman/5.0/en/old-client.html
development:
adapter: mysql
database: rorbiblioDBdev
username: rorbiblioUSdev
password: DBpassword
host: mysqlxxx.servage.net
# Warning: The database defined as 'test' will be erased and
# re-generated from your development database when you run 'rake'.
# Do not set this db to the same as development or production.
test:
adapter: mysql
database: rorbiblioDBtest
username: rorbiblioUStst
password: DBpassword
host: mysqlxxx.servage.net
production:
adapter: mysql
database: bibliothek_production
username: root
password:
host: localhost
Save and Close and try again:
TYPE
$ rake db:migrate
Now the tables will get created as you can see in the output:
(in /mounted-storage/homeservage/subservage/scservage-id/www/biblio)
== CreateBooks: migrating=====================
-- create_table(:books)
-> 0.1884s
== CreateBooks: migrated (0.1885s) ==============
GO TO
Control Panel
Online Filemanager
/www/biblio/app/views/books/new.rhtml
EDIT
New book
<%= error_messages_for :book %>
<% form_for(:book, :url => books_path) do |f| %>
Title
<%= f.text_field :title %>
Isbn
<%= f.text_field :isbn %>
Created at
<%= f.datetime_select :created_at %>
Updated at
<%= f.datetime_select :updated_at %>
<%= submit_tag "Create" %>
<% end %>
<%= link_to 'Back', books_path %>
DELETE the bold Part
CHANGE "Isbn" to "ISBN" as it will look much nicer :-)
GO TO
www/biblio/app/models/book.rb
EDIT so that it looks like this:
class Book < ActiveRecord::Base
validates_presence_of:title,:isbn
end
GO TO
www/biblio/app/controlers/book_controller.rb
EDIT and CHANGE line 5 to:
@books = Book.find(:all,:order=>'created_at DESC')
Now our book entries will get sorted. Before saving check that there is only ONE Bracket at the End of this line ;-)
GO TO
www/biblio/config/routes.rb
CHANGE line 16 to
14 # You can have the root of your site routed by hooking up ''
15 # -- just remember to delete public/index.html.
16 map.connect '', :controller => "books"
Don't forget to remove the # at line 16!!! to enable this line
GO TO
www/biblio/public/index.html
RENAME or DELETE it
GO TO
Control Panel
Web Server
View (your Host where you want to add the subdomain "biblio")
Let's fill some data in:
$ruby script/console
Now we are in the Surrounding to insert Ruby and Rails Code
>book=Book.new(:title=>'Ruby and Rails at Servage Hosting',:isbn=>'12345678')
This creates a new book
>book.save
Saves the Entry
Go to your site and ENJOY.
This post will be continued with some more testing later - happy new year
