{"id":117,"date":"2014-01-18T00:09:22","date_gmt":"2014-01-17T15:09:22","guid":{"rendered":"http:\/\/lovelinux.mydns.jp\/?p=117"},"modified":"2014-04-01T13:23:47","modified_gmt":"2014-04-01T04:23:47","slug":"jqgrid%e3%81%a8ruby-on-rails%e3%81%a7%e3%82%a4%e3%83%b3%e3%82%bf%e3%83%a9%e3%82%af%e3%83%86%e3%82%a3%e3%83%96%e3%81%aacrud%e3%82%a2%e3%83%97%e3%83%aa%e3%82%b1%e3%83%bc%e3%82%b7%e3%83%a7%e3%83%b3","status":"publish","type":"post","link":"https:\/\/lovelinux.mydns.jp\/?p=117","title":{"rendered":"jqGrid\u3068Ruby on Rails4 \u3067\u30a4\u30f3\u30bf\u30e9\u30af\u30c6\u30a3\u30d6\u306aCRUD\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u4f5c\u6210\uff08\u305d\u306e\uff11\uff09"},"content":{"rendered":"

\u306f\u3058\u3081\u306b<\/h3>\n

Web\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30d5\u30ec\u30fc\u30e0\u30ef\u30fc\u30af\u3067\u3001\u81ea\u52d5\u751f\u6210\u53ef\u80fd\u306a\u30da\u30fc\u30b8\u9077\u79fb\u578b\u306eCRUD\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067\u306f\u306a\u304f\u3001\u4e00\u65e6\u30da\u30fc\u30b8\u8868\u793a\u3057\u305f\u3089\u3001\u305d\u306e\u30da\u30fc\u30b8\u304b\u3089\u79fb\u52d5\u305b\u305a\u3001CRUD\u51e6\u7406\u3092\u3059\u3079\u3066\u5b8c\u4e86\u3057\u3066\u3057\u307e\u3046\u3088\u3046\u306a\u30a4\u30f3\u30bf\u30e9\u30af\u30c6\u30a3\u30d6\u306aWeb\u30a2\u30d7\u30ea\uff08\u4fd7\u306b\u8a00\u3046SPA\uff09\u306e\u69cb\u7bc9\u65b9\u6cd5\u306b\u3064\u3044\u3066\u304a\u8a71\u3057\u307e\u3059\u3002\u4eca\u56de\u306f\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u306b jQuery\/jQuery\u306e\u30b0\u30ea\u30c3\u30c9\u30b3\u30f3\u30dd\u30fc\u30cd\u30f3\u30c8\u3068\u3057\u3066\u30e1\u30b8\u30e3\u30fc\u306ajqGrid\u3092\u5229\u7528\u3057\u3001\u901a\u4fe1\u306fjQuery\u306eajax\u6a5f\u80fd\u3092\u5229\u7528\u3057\u307e\u3059\u3002\u30b5\u30fc\u30d0\u30fc\u30b5\u30a4\u30c9\u306fRuby2.0\u3068Rails4.0\u306e\u69cb\u6210\u3068\u306a\u308a\u307e\u3059\u3002\u307e\u305f\u3001\u8a18\u8f09\u3057\u305f\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u306fgithub\u4e0a\u306e\u30d1\u30d6\u30ea\u30c3\u30af\u30ea\u30dd\u30b8\u30c8\u30ea\u306b\u516c\u958b\u3057\u307e\u3059\u306e\u3067\u3001\u8208\u5473\u306e\u3042\u308b\u65b9\u306f\u3001\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u3001\u304a\u624b\u5143\u3067\u8a66\u3057\u3066\u307f\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002<\/p>\n

Rails \u65b0\u898f\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u4f5c\u6210\u3001GitHub\u306bPush<\/h3>\n

\u4e8b\u524d\u6e96\u5099\u3068\u3057\u3066\u3001\u3054\u81ea\u8eab\u306eGitHub\u306b \u30ea\u30dd\u30b8\u30c8\u30ea\u3092\u4f5c\u6210\u3057\u3066\u304a\u304f\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002
\n\u4eca\u56de\u306f\u3000\u30ea\u30dd\u30b8\u30c8\u30ea\u540d\uff1ajqgridrails\u3000\u3068\u3057\u3066\u30ea\u30dd\u30b8\u30c8\u30ea\u3092\u4f5c\u6210\u3057\u307e\u3057\u305f\u3002<\/p>\n

[bash]
\n$ rails new jqgridrails<\/p>\n

$ cd jqgridrails
\n$ git init
\n$ git add .
\n$ git commit -m “first commit”
\n$ git config user.name “\u767b\u9332\u3057\u305f\u3044\u540d\u524d”
\n$ git config user.email “\u767b\u9332\u3057\u305f\u3044Email”<\/p>\n

XXXXX\u3000\u306f github\u306e\u30e6\u30fc\u30b6\u30fc\u540d\u3067\u3059
\n$ git remote add origin https:\/\/XXXXX@github.com\/h-mito\/jqgridrails.git
\n$ git push -u origin master<\/p>\n

[\/bash]<\/p>\n

Eclipse\u306bRails\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u53d6\u308a\u8fbc\u3080<\/h3>\n

\u30d5\u30a1\u30a4\u30eb\uff1e\uff1e\u65b0\u898f\uff1e\uff1e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8<\/p>\n

\u4e00\u822c\uff1e\uff1e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u9078\u629e
\n\"\u65b0\u898f\u30d7\u30ed\u30b8\u30a7\u30af\u30c8<\/a><\/p>\n

\u65e2\u306b\u30ed\u30fc\u30ab\u30eb\u306b\u3042\u308b\u30d5\u30a9\u30eb\u30c0\u540d\u3092\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u540d\u3068\u3059\u308b\u3002
\n\"\u65b0\u898f\u30d7\u30ed\u30b8\u30a7\u30af\u30c8<\/a><\/p>\n

\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\uff1e\uff1e\u30d7\u30ed\u30d1\u30c6\u30a3\uff1e\uff1e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u30fb\u30cd\u30fc\u30c1\u30e3\u30fc<\/p>\n

Rails\u306b\u30c1\u30a7\u30c3\u30af\u3092\u5165\u308c\u308b\u3002
\n\"jqgridrails<\/a><\/p>\n

Rails\u30b5\u30fc\u30d0\u30fc\u4f5c\u6210
\n\u540d\u524d\uff1ajqgridrails
\n\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\uff1ajqgridrails
\nHost\/IP:127.0.0.1
\n\u30dd\u30fc\u30c8\uff1a3000<\/p>\n

\"rails-server\"<\/a><\/p>\n

Rails\u30b5\u30fc\u30d0\u30fc\u30c6\u30b9\u30c8\u8d77\u52d5<\/h3>\n

\u8d77\u52d5\u3059\u308b\u3068\u30a8\u30e9\u30fc<\/p>\n

[bash]
\ncd workspace\/jqgridrails
\ncp bin script -R
\n[\/bash]<\/p>\n

\u3042\u3089\u3081\u3066\u8d77\u52d5
\nhttp:\/\/localhost:3000 \u3067\u52d5\u4f5c\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n

\u4e00\u65e6\u30b3\u30df\u30c3\u30c8\u3057\u3066\u3001Push\u3057\u3066\u304a\u304f<\/p>\n

[bash]
\n$ git add .
\n$ git commit -m “Eclipse Env create”<\/p>\n

$ git push<\/p>\n

[\/bash]<\/p>\n

Section\u30de\u30b9\u30bf\u30fc\u3092\u4f5c\u308d\u3046\uff01<\/h3>\n

[bash]
\n$ git checkout -b Sectmast
\n[\/bash]<\/p>\n

eclipse \u3067database.yml\u3092\u3000\u81ea\u8eab\u306emysql\u74b0\u5883\u306b\u66f8\u304d\u63db\u3048\u308b\u3002\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u63a5\u7d9a\u60c5\u5831\u306f\u30bb\u30ad\u30e5\u30a2\u306b\u6271\u3044\u305f\u3044\u306e\u3067\u3001.gitignore\u306bdatabase.yml\u3092\u8ffd\u8a18\u3002<\/p>\n

[bash]
\n$ nano .gitignore
\n\u6700\u7d42\u884c\u306b\u8ffd\u8a18
\nconfig\/database.yml<\/p>\n

$ git rm config\/database.yml –cached<\/p>\n

$ git add .<\/p>\n

$ git commit -m “Database Setting”
\n[\/bash]<\/p>\n

\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\u3092\u4f5c\u308d\u3046<\/h3>\n

\u4e00\u822c\u7684\u306aCRUD\u3067\u306f\u306a\u304f\u3001Ajax\u3067SPA\u3092\u4f5c\u6210\u3059\u308b\u306e\u3067\u3001\u521d\u671f\u30da\u30fc\u30b8\u8868\u793a\u7528\u306eindex\u30e1\u30bd\u30c3\u30c9\u3068\u3001\u66f4\u65b0\u7528\u306eupdate\u30e1\u30bd\u30c3\u30c9\u306e\u307f\u6307\u5b9a<\/p>\n

[bash]
\n$ rails g controller sectmasts index update
\n[\/bash]<\/p>\n

\u30e2\u30c7\u30eb\u3092\u4f5c\u308d\u3046\uff01<\/h3>\n

\u30e2\u30c7\u30eb\u3092\u4f5c\u308b\u524d\u306b\u3001Rails\u3067\u306f\u30c7\u30d5\u30a9\u30eb\u30c8\u3001sqlite\u3092\u5229\u7528\u3059\u308b\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u308b\u306e\u3067\u3001mysql\u3092\u5229\u7528\u3059\u308b\u3088\u3046\u306b\u5909\u66f4\u3059\u308b\u3002\u307e\u305a\u306fGemfile\u306e ‘sqlite3’\u306e\u884c\u3092\u30b3\u30e1\u30f3\u30c8\u30a2\u30a6\u30c8\u3057\u3001 ‘mysql2’\u306e\u884c\u3092\u8ffd\u8a18\u3059\u308b\u3002<\/p>\n

Gemfile\u306bmysql2\u3092\u8ffd\u8a18<\/p>\n

[ruby]
\n# Use sqlite3 as the database for Active Record
\n# gem ‘sqlite3’<\/p>\n

# Use mysql as the database for Active Record
\ngem ‘mysql2’, ‘0.3.13’
\n[\/ruby]<\/p>\n

\u30e2\u30c7\u30eb sectmast\u306e\u81ea\u52d5\u751f\u6210
\n[bash]
\n$ rails g model sectmast
\n[\/bash]<\/p>\n

\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\u3088\u3046<\/h3>\n

\u30e2\u30c7\u30eb\u306e\u4f5c\u6210\u6642\u306b\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u30d5\u30a1\u30a4\u30eb\u3068\u3044\u3046\u306e\u304c\u81ea\u52d5\u7684\u306b\u4f5c\u6210\u3055\u308c\u308b\u3002
\ndb\/migrate\u30d5\u30a9\u30eb\u30c0\u306b\u51fa\u6765\u305f migration\u30d5\u30a1\u30a4\u30eb\u3092\u4fee\u6b63\u3059\u308b\u3002
\n\u4fee\u6b63\u5185\u5bb9\u306f\u3000sectcd\/sectname\u306e\u8ffd\u52a0\u3002<\/p>\n

[ruby mark=”4,5″]
\nclass CreateSectmasts < ActiveRecord::Migration\n def change\n create_table :sectmasts do |t|\n t.column :sectcd, \"varchar(2)\"\n t.column :sectname, \"varchar(255)\"\n t.timestamps\n end\n end\nend\n[\/ruby]\n\n\n\n\u30c6\u30fc\u30d6\u30eb\u4f5c\u6210\u5b9f\u884c\uff01\n[bash]\n$ rake db:migrate\n[\/bash]\n\n\n\n\n\n

\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u30b5\u30a4\u30c9\u3067\u5fc5\u8981\u306a\u3001JavaScript\u3001StyleSheet\u3092\u30b3\u30d4\u30fc<\/h3>\n

jquery \/ jquery UI \/ jqgrid\u3000\u95a2\u9023\u306eJavaScript\u3001StyleSheet\u3092\u30b3\u30d4\u30fc
\n\u30b3\u30d4\u30fc\u5148\u306f app\/assets\/javascripts & app\/assets\/stylesheets<\/p>\n

\"addJsStyle\"<\/a><\/p>\n

[bash]
\n$ git add .
\n$ git commit -m “create table and add jquery\/jqueryUI\/jqGrid Javascripts and StyleSheets”
\n[\/bash]<\/p>\n

\u52d5\u4f5c\u78ba\u8a8d<\/h3>\n

\u3067\u306f\u3001\u4e00\u65e6\u52d5\u4f5c\u78ba\u8a8d<\/p>\n

Eclipse\u3088\u308a\u3001Rails\u30b5\u30fc\u30d0\u30fc\u3092\u8d77\u52d5\u3057\u307e\u3059\u3002<\/p>\n

\u30d6\u30e9\u30a6\u30b6\u30fc\u3067 http:\/\/localhost:3000\/sectmasts\/index \u3067\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u7a7a\u3063\u307d\u306e\u30da\u30fc\u30b8\u304c\u8868\u793a\u3055\u308c\u308c\u3070OK\u3067\u3059\u3002
\n\"Jqgridrails<\/a><\/p>\n

\u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u6295\u5165<\/h3>\n

[bash]
\n$ rails c<\/p>\n

> Sectmast.create :sectcd=>”01″ ,:sectname => “market section”
\n (0.3ms) BEGIN
\n SQL (0.5ms) INSERT INTO `sectmasts` (`created_at`, `sectcd`, `sectname`, `updated_at`) VALUES (‘2014-01-17 12:13:24′, ’01’, ‘market section’, ‘2014-01-17 12:13:24’)<\/p>\n

> Sectmast.all
\n Sectmast Load (0.6ms) SELECT `sectmasts`.* FROM `sectmasts`
\n =>
\n#<ActiveRecord::Relation [#<Sectmast id: 1, sectcd: “01”, sectname: “market section”, created_at: “2014-01-17 12:13:24”, updated_at: “2014-01-17 12:13:24”>, #<Sectmast id: 2, sectcd: “02”, sectname: “sales section”, created_at: “2014-01-17 12:13:42”, updated_at: “2014-01-17 12:13:42”>, #<Sectmast id: 3, sectcd: “03”, sectname: “development section”, created_at: “2014-01-17 12:13:54”, updated_at: “2014-01-17 12:13:54”>]>
\n[\/bash]<\/p>\n

\u4e00\u89a7\u753b\u9762(HTML\uff09\u4f5c\u6210<\/h3>\n

view\/sectmasts\/index.html.erb<\/p>\n

\u5185\u5bb9\u306f\u4ee5\u4e0b
\n[html]
\n<h1>Sectmasts#index<\/h1><\/p>\n

<table id=”list”><\/table>
\n<div id=”pager”><\/div>
\n[\/html]<\/p>\n

\u30e1\u30a4\u30f3\u3068\u306a\u308bJavaScript\u4f5c\u6210<\/h3>\n

app\/assets\/javascripts\/sectmasts-main.js\u3092\u4f5c\u6210<\/p>\n

[javascript]
\njQuery(function($){<\/p>\n

\t$(“#list”).jqGrid({
\n\t \turl:’\/sectmasts\/readForIndex’,
\n\t\tdatatype: “json”,
\n\t \tcolNames:[‘id’,’Section cd’, ‘Section Name’, ‘created’,’updated’],
\n\t \tcolModel:[
\n\t \t\t{name:’id’,index:’id’, width:55},
\n\t \t\t{name:’sectcd’,index:’sectcd’, width:90},
\n\t \t\t{name:’sectname’,index:’sectname’, width:200},
\n\t \t\t{name:’created_at’,index:’created_at’, width:150},
\n\t \t\t{name:’updated_at’,index:’updated_at’, width:150}
\n\t \t],
\n\t \trowNum:10,
\n\t \trowList:[10,20,30],
\n\t \tpager: ‘#pager’,
\n\t \tsortname: ‘id’,
\n\t viewrecords: true,
\n\t sortorder: “asc”,
\n\t caption:”Section master”
\n\t});<\/p>\n

\t$(“#list”).jqGrid(‘navGrid’,’#pager’,{edit:false,add:false,del:false});\t<\/p>\n

});<\/p>\n

[\/javascript]<\/p>\n

\u5168\u30c7\u30fc\u30bf\u3092\u8aad\u307f\u8fbc\u3080\u30ed\u30b8\u30c3\u30af\u3092\u5b9f\u88c5(Ruby)<\/h3>\n

[ruby]
\n def readForIndex
\n response = {status:true}<\/p>\n

recs = Sectmast.all<\/p>\n

response[“rows”] = []<\/p>\n

recs.each do |rec|
\n response[“rows”].push(rec)
\n end
\n response[“page”] = 1
\n response[“total”] = 1
\n response[“records”] = recs.count<\/p>\n

render :json => response
\n end
\n[\/ruby]<\/p>\n

\u4f5c\u6210\u3057\u305fRuby\u306e\u30e1\u30bd\u30c3\u30c9\u306b\u5bfe\u5fdc\u3059\u308b\u30eb\u30fc\u30c8\u3092\u8ffd\u8a18<\/h3>\n

config\/routes.rb<\/p>\n

[ruby mark=”4″]
\nJqgridrails::Application.routes.draw do
\n get “sectmasts\/index”
\n get “sectmasts\/update”
\n get “sectmasts\/readForIndex”
\n[\/ruby]<\/p>\n

application.js\u306e\u8abf\u6574<\/h3>\n

jQuery\u306f\u81ea\u524d\u3067\u7528\u610f\u3057\u305f\u306e\u3067\u3001\u305d\u308c\u3092\u5229\u7528\u3059\u308b\u3088\u3046\u306b\u5909\u66f4\u3002jquery_ujs \u306f\u3068\u308a\u3042\u3048\u305a\u3001\u5916\u3057\u3066\u304a\u304f\u3002
\n\u5909\u66f4\u90e8\u5206\u306e\u307f\u629c\u7c8b<\/p>\n

app\/assets\/javascripts\/application.js<\/p>\n

\u5909\u66f4\u524d
\n[javascript mark=”1,2″]
\n\/\/= require jquery
\n\/\/= require jquery_ujs
\n\/\/= require turbolinks
\n\/\/= require_tree .
\n[\/javascript]<\/p>\n

\u5909\u66f4\u5f8c
\n[javascript mark=”1″]
\n\/\/= require jquery-1.10.2
\n\/\/= require turbolinks
\n\/\/= require_tree .
\n[\/javascript]<\/p>\n

\u52d5\u4f5c\u78ba\u8a8d\uff01\uff01<\/h3>\n

\u4ee5\u4e0b\u306e\u3088\u3046\u306b jqGrid\u306b\u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u304c\u4e00\u89a7\u3055\u308c\u308c\u3070\u3001\u3081\u3067\u305f\u3057\u3081\u3067\u305f\u3057\u3002
\n\u307e\u3060\u307e\u3060\u3001\u3044\u3044\u52a0\u6e1b\u306a\u5b9f\u88c5\u3067\u3059\u306e\u3067\u3002\u6b21\u56de\u304b\u3089\u3082\u3046\u5c11\u3057\u307e\u3068\u3082\u306b\u3057\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n

\"Jqgridrails<\/a><\/p>\n

github\u3078\u30d7\u30c3\u30b7\u30e5<\/h3>\n

\u3053\u306e\u30ea\u30bd\u30fc\u30b9\u306fPublic\u30ea\u30dd\u30b8\u30c8\u30ea\u3068\u3057\u3066\u516c\u958b\u3057\u3066\u3044\u307e\u3059\u306e\u3067\u3001\u4ee5\u4e0b\u306eURL\u3067\u30bd\u30fc\u30b9\u3092\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002
\nhttps:\/\/github.com\/h-mito\/jqgridrails.git<\/a><\/p>\n

[bash]
\n$ git add .
\n$ git commit -m “Read Sectmasts Complete”
\n$ git checkout master
\n$ git merge Sectmast –no-ff
\n$ git push
\n[\/bash]<\/p>\n

\u6b21\u56de\u3078\u7d9a\u304f\u3002\u3002\u3002\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

\u306f\u3058\u3081\u306b Web\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30d5\u30ec\u30fc\u30e0\u30ef\u30fc\u30af\u3067\u3001\u81ea\u52d5\u751f\u6210\u53ef\u80fd\u306a\u30da\u30fc\u30b8\u9077\u79fb\u578b\u306eCRUD\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067\u306f\u306a\u304f\u3001\u4e00\u65e6\u30da\u30fc\u30b8\u8868\u793a\u3057\u305f\u3089\u3001\u305d\u306e\u30da\u30fc\u30b8\u304b\u3089\u79fb\u52d5\u305b\u305a\u3001CRUD\u51e6\u7406\u3092\u3059\u3079\u3066\u5b8c\u4e86\u3057\u3066\u3057\u307e\u3046\u3088\u3046\u306a\u30a4\u30f3\u30bf\u30e9\u30af\u30c6\u30a3\u30d6\u306aWeb\u30a2\u30d7\u30ea\uff08\u4fd7\u306b\u8a00\u3046SPA\uff09\u306e\u69cb\u7bc9\u65b9\u6cd5\u306b\u3064\u3044\u3066\u304a\u8a71\u3057\u307e\u3059\u3002\u4eca\u56de\u306f\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u306b jQuery\/jQuery\u306e\u30b0\u30ea\u30c3\u30c9\u30b3\u30f3\u30dd\u30fc\u30cd\u30f3\u30c8\u3068\u3057\u3066\u30e1\u30b8\u30e3\u30fc\u306ajqGrid\u3092\u5229\u7528\u3057\u3001\u901a\u4fe1\u306fjQuery\u306eajax\u6a5f\u80fd\u3092\u5229\u7528\u3057\u307e\u3059\u3002\u30b5\u30fc\u30d0\u30fc\u30b5\u30a4\u30c9\u306fRuby2.0\u3068Rails4.0\u306e\u69cb\u6210\u3068\u306a\u308a\u307e\u3059\u3002\u307e\u305f\u3001\u8a18\u8f09\u3057\u305f\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u306fgithub\u4e0a\u306e\u30d1\u30d6\u30ea\u30c3\u30af\u30ea\u30dd\u30b8\u30c8\u30ea\u306b\u516c\u958b\u3057\u307e\u3059\u306e\u3067\u3001\u8208\u5473\u306e\u3042\u308b\u65b9\u306f\u3001\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u3001\u304a\u624b\u5143\u3067\u8a66\u3057\u3066\u307f\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002 Rails \u65b0\u898f\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u4f5c\u6210\u3001GitHub\u306bPush \u4e8b\u524d\u6e96\u5099\u3068\u3057\u3066\u3001\u3054\u81ea\u8eab\u306eGitHub\u306b \u30ea\u30dd\u30b8\u30c8\u30ea\u3092\u4f5c\u6210\u3057\u3066\u304a\u304f\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002 \u4eca\u56de\u306f\u3000\u30ea\u30dd\u30b8\u30c8\u30ea\u540d\uff1ajqgridrails\u3000\u3068\u3057\u3066\u30ea\u30dd\u30b8\u30c8\u30ea\u3092\u4f5c\u6210\u3057\u307e\u3057\u305f\u3002 [bash] $ rails new jqgridrails $ cd jqgridrails $ git init $ git add . $ git commit -m “first commit” $ git config user.name “\u767b\u9332\u3057\u305f\u3044\u540d\u524d” $ git config user.email “\u767b\u9332\u3057\u305f\u3044Email” XXXXX\u3000\u306f github\u306e\u30e6\u30fc\u30b6\u30fc\u540d\u3067\u3059 $ git remote add origin https:\/\/XXXXX@github.com\/h-mito\/jqgridrails.git $ git push -u origin master [\/bash] Eclipse\u306bRails\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u53d6\u308a\u8fbc\u3080 \u30d5\u30a1\u30a4\u30eb\uff1e\uff1e\u65b0\u898f\uff1e\uff1e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8 \u4e00\u822c\uff1e\uff1e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u9078\u629e \u65e2\u306b\u30ed\u30fc\u30ab\u30eb\u306b\u3042\u308b\u30d5\u30a9\u30eb\u30c0\u540d\u3092\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u540d\u3068\u3059\u308b\u3002 \u30d7\u30ed\u30b8\u30a7\u30af\u30c8\uff1e\uff1e\u30d7\u30ed\u30d1\u30c6\u30a3\uff1e\uff1e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u30fb\u30cd\u30fc\u30c1\u30e3\u30fc Rails\u306b\u30c1\u30a7\u30c3\u30af\u3092\u5165\u308c\u308b\u3002 Rails\u30b5\u30fc\u30d0\u30fc\u4f5c\u6210 \u540d\u524d\uff1ajqgridrails \u30d7\u30ed\u30b8\u30a7\u30af\u30c8\uff1ajqgridrails Host\/IP:127.0.0.1 \u30dd\u30fc\u30c8\uff1a3000 Rails\u30b5\u30fc\u30d0\u30fc\u30c6\u30b9\u30c8\u8d77\u52d5 \u8d77\u52d5\u3059\u308b\u3068\u30a8\u30e9\u30fc [bash] cd workspace\/jqgridrails cp bin script -R [\/bash] \u3042\u3089\u3081\u3066\u8d77\u52d5 http:\/\/localhost:3000 \u3067\u52d5\u4f5c\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002 \u4e00\u65e6\u30b3\u30df\u30c3\u30c8\u3057\u3066\u3001Push\u3057\u3066\u304a\u304f [bash] $ git add . $ git commit -m “Eclipse Env create” $ git push [\/bash] Section\u30de\u30b9\u30bf\u30fc\u3092\u4f5c\u308d\u3046\uff01 [bash] $ git checkout -b Sectmast [\/bash] eclipse \u3067database.yml\u3092\u3000\u81ea\u8eab\u306emysql\u74b0\u5883\u306b\u66f8\u304d\u63db\u3048\u308b\u3002\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u63a5\u7d9a\u60c5\u5831\u306f\u30bb\u30ad\u30e5\u30a2\u306b\u6271\u3044\u305f\u3044\u306e\u3067\u3001.gitignore\u306bdatabase.yml\u3092\u8ffd\u8a18\u3002 [bash] $ nano .gitignore \u6700\u7d42\u884c\u306b\u8ffd\u8a18 config\/database.yml $ git rm config\/database.yml –cached $ git add . $ git commit -m “Database Setting” [\/bash] \u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\u3092\u4f5c\u308d\u3046 \u4e00\u822c\u7684\u306aCRUD\u3067\u306f\u306a\u304f\u3001Ajax\u3067SPA\u3092\u4f5c\u6210\u3059\u308b\u306e\u3067\u3001\u521d\u671f\u30da\u30fc\u30b8\u8868\u793a\u7528\u306eindex\u30e1\u30bd\u30c3\u30c9\u3068\u3001\u66f4\u65b0\u7528\u306eupdate\u30e1\u30bd\u30c3\u30c9\u306e\u307f\u6307\u5b9a [bash] $ rails g controller sectmasts index update [\/bash] \u30e2\u30c7\u30eb\u3092\u4f5c\u308d\u3046\uff01 \u30e2\u30c7\u30eb\u3092\u4f5c\u308b\u524d\u306b\u3001Rails\u3067\u306f\u30c7\u30d5\u30a9\u30eb\u30c8\u3001sqlite\u3092\u5229\u7528\u3059\u308b\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u308b\u306e\u3067\u3001mysql\u3092\u5229\u7528\u3059\u308b\u3088\u3046\u306b\u5909\u66f4\u3059\u308b\u3002\u307e\u305a\u306fGemfile\u306e ‘sqlite3’\u306e\u884c\u3092\u30b3\u30e1\u30f3\u30c8\u30a2\u30a6\u30c8\u3057\u3001 ‘mysql2’\u306e\u884c\u3092\u8ffd\u8a18\u3059\u308b\u3002 Gemfile\u306bmysql2\u3092\u8ffd\u8a18 [ruby] # Use sqlite3 as the database for Active Record # gem ‘sqlite3’ # Use mysql as the database for Active Record gem ‘mysql2’, ‘0.3.13’ [\/ruby] \u30e2\u30c7\u30eb sectmast\u306e\u81ea\u52d5\u751f\u6210 [bash] $ rails g model sectmast [\/bash] \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\u3088\u3046 \u30e2\u30c7\u30eb\u306e\u4f5c\u6210\u6642\u306b\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u30d5\u30a1\u30a4\u30eb\u3068\u3044\u3046\u306e\u304c\u81ea\u52d5\u7684\u306b\u4f5c\u6210\u3055\u308c\u308b\u3002 db\/migrate\u30d5\u30a9\u30eb\u30c0\u306b\u51fa\u6765\u305f migration\u30d5\u30a1\u30a4\u30eb\u3092\u4fee\u6b63\u3059\u308b\u3002 \u4fee\u6b63\u5185\u5bb9\u306f\u3000sectcd\/sectname\u306e\u8ffd\u52a0\u3002 [ruby mark=”4,5″] class CreateSectmasts < ActiveRecord::Migration def change create_table :sectmasts do |t| t.column :sectcd, \"varchar(2)\" t.column :sectname, \"varchar(255)\" t.timestamps end end end [\/ruby] \u30c6\u30fc\u30d6\u30eb\u4f5c\u6210\u5b9f\u884c\uff01 [bash] $ rake db:migrate [\/bash] \u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u30b5\u30a4\u30c9\u3067\u5fc5\u8981\u306a\u3001JavaScript\u3001StyleSheet\u3092\u30b3\u30d4\u30fc jquery \/ jquery UI \/ jqgrid\u3000\u95a2\u9023\u306eJavaScript\u3001StyleSheet\u3092\u30b3\u30d4\u30fc \u30b3\u30d4\u30fc\u5148\u306f app\/assets\/javascripts & app\/assets\/stylesheets [bash] $ git add . $ git commit -m “create table and add jquery\/jqueryUI\/jqGrid Javascripts and StyleSheets” [\/bash] \u52d5\u4f5c\u78ba\u8a8d \u3067\u306f\u3001\u4e00\u65e6\u52d5\u4f5c\u78ba\u8a8d Eclipse\u3088\u308a\u3001Rails\u30b5\u30fc\u30d0\u30fc\u3092\u8d77\u52d5\u3057\u307e\u3059\u3002 \u30d6\u30e9\u30a6\u30b6\u30fc\u3067 http:\/\/localhost:3000\/sectmasts\/index \u3067\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u7a7a\u3063\u307d\u306e\u30da\u30fc\u30b8\u304c\u8868\u793a\u3055\u308c\u308c\u3070OK\u3067\u3059\u3002 \u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u6295\u5165 [bash] $ rails c > Sectmast.create :sectcd=>”01″ ,:sectname => “market section” (0.3ms) BEGIN SQL (0.5ms) INSERT INTO `sectmasts` (`created_at`, `sectcd`, `sectname`, `updated_at`) VALUES (‘2014-01-17 12:13:24′, ’01’, ‘market section’, ‘2014-01-17 12:13:24’) > Sectmast.all Sectmast Load (0.6ms) SELECT `sectmasts`.* FROM `sectmasts` => #<ActiveRecord::Relation [#<Sectmast id: 1, sectcd: “01”, sectname: “market section”, created_at: “2014-01-17 12:13:24”,…<\/p>\n","protected":false},"author":1,"featured_media":400,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[7,6,2],"tags":[28,27,20,71],"class_list":{"0":"post-117","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-jquery","8":"category-rails","9":"category-2","10":"tag-javascript-2","11":"tag-jqgrid","12":"tag-jquery-2","13":"tag-rails"},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=\/wp\/v2\/posts\/117","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=117"}],"version-history":[{"count":15,"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=\/wp\/v2\/posts\/117\/revisions"}],"predecessor-version":[{"id":693,"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=\/wp\/v2\/posts\/117\/revisions\/693"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=\/wp\/v2\/media\/400"}],"wp:attachment":[{"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=117"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=117"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lovelinux.mydns.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}