Webアプリ開発入門 Sinatra編4:ActiveRecordでデータベースを操作しよう

# ActiveRecordでMySQLに接続する
require 'mysql2'
require 'active_record'

# client = Mysql2::Client.new(:host => "localhost", :username => "root",  :database => "mydb")

ActiveRecord::Base.establish_connection(
    "adapter" =>"mysql2",
    "database" => "mydb",
    "host" => "localhost",
    "username" => "root",
    "password" => "",
    "encoding" => "utf8"
)

class Player < ActiveRecord::Base
end

# sql = "SELECT * FROM players"
# statement = client.prepare(sql)

results = Player.all

results.each do |row|
    p row
end

- [Active Record の基礎 | Rails ガイド]
https://railsguides.jp/active_record_basics.html

- [オブジェクト関係マッピング - Qiita]
https://qiita.com/yk-nakamura/items/acd071f16cda844579b9

- [ActiveRecord入門 - Qiita]
https://qiita.com/kimioka0/items/8c10e01def23fdbf3aa6