make rails connect with database

i'm newbie in rails. i have problem with how to connect rails with
database. before i can connect it with command
"rake db:create" to create database.
and "rake db:migrate" to migrate schema to database.

but, i want to connect rails with database that i have before, not
create it via rails. can you help me?

i'm newbie in rails. i have problem with how to connect rails with
database. before i can connect it with command
"rake db:create" to create database.
and "rake db:migrate" to migrate schema to database.

but, i want to connect rails with database that i have before, not
create it via rails. can you help me?

just setup your config/database.yml and that should work. however, when
you want to collaborate with someone, you have to depend on schema.rb
rather than migrations to create the database.

i have been setup database.yml, with same name database that i want to
use.
but then what i should do?
Should i to run "rails generate scaffold"?
let say my command
"rails generate scaffold members name:string email:string" to create
schema??
and then run "rake db:migrate"?

i try open schema.rb, and i saw this code

i try open schema.rb, and i saw this code
------------------------------------------------
ActiveRecord::Schema.define(:version => 20121201063411) do

  create_table "anggota", :force => true do |t|
    t.string "nama"
    t.text "alamat"
    t.text "no_telp"
    t.datetime "waktu_daftar"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
  end

  create_table "bukus", :force => true do |t|
    t.string "isbn"
    t.string "judul"
    t.string "penulis"
    t.string "penerbit"
    t.string "kategori"
    t.integer "edisi"
    t.integer "jumlah"
    t.integer "jumlah_dipinjam"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
  end

  create_table "posts", :force => true do |t|
    t.string "name"
    t.string "title"
    t.text "content"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
  end

end
----------------------------------------------------------

it say create_table "name of table", but the problem is i have been have
that table in my database, and i didn't want to change that table.

first run rake db:schema:dump to generate your schema from the current
database.
Then if you want to run a scaffold (I've just tested this one, I don't
actually use
scaffold), use

rails g scaffold <singular_table_name> --migration false

i can't understand this command
"rails g scaffold <singular_table_name> --migration false"

can you describe it more?

i can't understand this command
"rails g scaffold <singular_table_name> --migration false"

can you describe it more?

if you have a table called comments in your current database, and you want
to generate
the model, controller and views for that table, you need to run

rails g scaffold comment

but that will generate a migration file for creating the table on the db.
since you
already have the tables, you can pass --migration false to skip creating
the migration.

I always see, every table in rails given the name of the plural form.
however I have a table with a singular form. let say my table name
"member" not "members", could this create problems?
then the rails command writing table name usually begins with a capital
letter and using the singular form. Can I have a table named in the
singular form, and run the command with the same name?

I have tried, but it can not display the contents of my database. there
are things that make me confused, it was formed six lines of command
"show, edit, and destroy", an amount equal to the number of records in
the table "member". but does not display the contents of the table
"member" it.

I always see, every table in rails given the name of the plural form.
however I have a table with a singular form. let say my table name
"member" not "members", could this create problems?
then the rails command writing table name usually begins with a capital
letter and using the singular form. Can I have a table named in the
singular form, and run the command with the same name?

I have tried, but it can not display the contents of my database. there
are things that make me confused, it was formed six lines of command
"show, edit, and destroy", an amount equal to the number of records in
the table "member". but does not display the contents of the table
"member" it.

try looking for set_table_name syntax to set the table name that you want
to use

did you mean add this syntax

  set_table_name "member"

in app\models\member.rb??

i have been try it, but it didn't work..

did you mean add this syntax

  set_table_name "member"

in app\models\member.rb??

i have been try it, but it didn't work..

well just saying it didn't work won't help you at all. describe what
happens and why
you concluded it didn't work.

i try to add this syntax

set_table_name "member"

in member.rb at folder app\models\

but same as before it can't show record in table member, and i try to
click new member, i saw this error

"ActiveRecord::StatementInvalid in MemberController#create"

and this error

app/controllers/anggota_controller.rb:46:in `block in create'
app/controllers/anggota_controller.rb:45:in `create'

can you help me??

i try to add this syntax

set_table_name "member"

in member.rb at folder app\models\

but same as before it can't show record in table member, and i try to
click new member, i saw this error

"ActiveRecord::StatementInvalid in MemberController#create"

and this error

app/controllers/anggota_controller.rb:46:in `block in create'
app/controllers/anggota_controller.rb:45:in `create'

can you post your code on anggota_controller?

class AnggotaController < ApplicationController
  # GET /anggota
  # GET /anggota.json
  def index
    @anggota = Anggotum.all

    respond_to do |format|
      format.html # index.html.erb
      format.json { render json: @anggota }
    end
  end

  # GET /anggota/1
  # GET /anggota/1.json
  def show
    @anggotum = Anggotum.find(params[:id])

    respond_to do |format|
      format.html # show.html.erb
      format.json { render json: @anggotum }
    end
  end

  # GET /anggota/new
  # GET /anggota/new.json
  def new
    @anggotum = Anggotum.new

    respond_to do |format|
      format.html # new.html.erb
      format.json { render json: @anggotum }
    end
  end

  # GET /anggota/1/edit
  def edit
    @anggotum = Anggotum.find(params[:id])
  end

  # POST /anggota
  # POST /anggota.json
  def create
    @anggotum = Anggotum.new(params[:anggotum])

    respond_to do |format|
      if @anggotum.save
        format.html { redirect_to @anggotum, notice: 'Anggotum was
successfully created.' }
        format.json { render json: @anggotum, status: :created,
location: @anggotum }
      else
        format.html { render action: "new" }
        format.json { render json: @anggotum.errors, status:
:unprocessable_entity }
      end
    end
  end

  # PUT /anggota/1
  # PUT /anggota/1.json
  def update
    @anggotum = Anggotum.find(params[:id])

    respond_to do |format|
      if @anggotum.update_attributes(params[:anggotum])
        format.html { redirect_to @anggotum, notice: 'Anggotum was
successfully updated.' }
        format.json { head :no_content }
      else
        format.html { render action: "edit" }
        format.json { render json: @anggotum.errors, status:
:unprocessable_entity }
      end
    end
  end

  # DELETE /anggota/1
  # DELETE /anggota/1.json
  def destroy
    @anggotum = Anggotum.find(params[:id])
    @anggotum.destroy

    respond_to do |format|
      format.html { redirect_to anggota_url }
      format.json { head :no_content }
    end
  end
end

class AnggotaController < ApplicationController
  # GET /anggota
  # GET /anggota.json
  def index
    @anggota = Anggotum.all

    respond_to do |format|
      format.html # index.html.erb
      format.json { render json: @anggota }
    end
  end

  # GET /anggota/1
  # GET /anggota/1.json
  def show
    @anggotum = Anggotum.find(params[:id])

    respond_to do |format|
      format.html # show.html.erb
      format.json { render json: @anggotum }
    end
  end

  # GET /anggota/new
  # GET /anggota/new.json
  def new
    @anggotum = Anggotum.new

    respond_to do |format|
      format.html # new.html.erb
      format.json { render json: @anggotum }
    end
  end

  # GET /anggota/1/edit
  def edit
    @anggotum = Anggotum.find(params[:id])
  end

  # POST /anggota
  # POST /anggota.json
  def create
    @anggotum = Anggotum.new(params[:anggotum])

    respond_to do |format|
      if @anggotum.save
        format.html { redirect_to @anggotum, notice: 'Anggotum was
successfully created.' }
        format.json { render json: @anggotum, status: :created,
location: @anggotum }
      else
        format.html { render action: "new" }
        format.json { render json: @anggotum.errors, status:
:unprocessable_entity }
      end
    end
  end

  # PUT /anggota/1
  # PUT /anggota/1.json
  def update
    @anggotum = Anggotum.find(params[:id])

    respond_to do |format|
      if @anggotum.update_attributes(params[:anggotum])
        format.html { redirect_to @anggotum, notice: 'Anggotum was
successfully updated.' }
        format.json { head :no_content }
      else
        format.html { render action: "edit" }
        format.json { render json: @anggotum.errors, status:
:unprocessable_entity }
      end
    end
  end

  # DELETE /anggota/1
  # DELETE /anggota/1.json
  def destroy
    @anggotum = Anggotum.find(params[:id])
    @anggotum.destroy

    respond_to do |format|
      format.html { redirect_to anggota_url }
      format.json { head :no_content }
    end
  end
end

-------------------------------------------------------------

that the code of anggota_controller.rb
-----------------------------------------

Where do you use the member table? I think you need to read on the MVC
architecture first before you start working on this one. I really can't
help you
if you have no firsthand knowledge of how the models and controllers are
connected.

no, i didn't use member table, i use member word just to describe to you
singular and plural form. because i little confuse tell you plural form
from word "anggota"

no, i didn't use member table, i use member word just to describe to you
singular and plural form. because i little confuse tell you plural form
from word "anggota"

ok. Just make sure that you're using the table name on the db on the
Anggota
model. If you're doing that and still gets errors, I don't know what your
issue is.
I can't see any errors on your controller. It seems like it's the one
generated by
the scaffold generator so there shouldn't be any errors in there.

Try running the console and see if Anggota.first retrieves the first record.

1. Rails new First_app
2. Change config database.yml
3. Rake db:schema:dump
4. Rails g scaffold Anggota –migration false
5. Change First_app\app\model\anggotum.rb with this syntax

1. Rails new First_app
2. Change config database.yml
3. Rake db:schema:dump
4. Rails g scaffold Anggota –migration false
5. Change First_app\app\model\anggotum.rb with this syntax

-------------------------------------
class Anggotum < ActiveRecord::Base
  set_table_name "anggota"
end
---------------------------------------

i have try to make new rails app, and that is the step by step that i
did.
did i do wrong step??

everything looks ok. did you try it on the console?

i didn't understand your instruction. what must i run in console? did
you mean "rails server"? or what else?