非rails使用ActiveRecord示例

require 'active_record'
#establish connection
#sqlite3
ActiveRecord::Base.establish_connection(:adapter => "sqlite3", :database  => "C:/Users/ln/Desktop/mytest.sqlite3")
#mysql
ActiveRecord::Base.establish_connection(
:adapter => "mysql",
:host => "dbserver.com",
:database => "online",
:username => "username",
:password => "password")


#create table
class CreateArticles < ActiveRecord::Migration[5.0]
  # def change
    create_table :articles do |t|
      t.string :title
      t.text :text

      t.timestamps
    end 
  # end
end

#add row
class Article < ActiveRecord::Base
end
a=Article.create(title:'test1',text:'test1')

#excute raw sql
p ActiveRecord::Base.connection.respond_to?(:execute)
connection = ActiveRecord::Base.connection

connection.execute('DROP TABLE articles')