Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

model作成 #38

Open
pyar6329 opened this issue Oct 16, 2014 · 11 comments
Open

model作成 #38

pyar6329 opened this issue Oct 16, 2014 · 11 comments
Labels
機能拡張

Comments

@pyar6329
Copy link
Member

ER図
pyar6329 added a commit that referenced this issue Oct 17, 2014
@pyar6329
#38 rails g model path parent:string current:string depth:integer
e15e5fa
pyar6329 added a commit that referenced this issue Oct 17, 2014
@pyar6329
#38 rails g model season name:string
ee90dab
pyar6329 added a commit that referenced this issue Oct 17, 2014
@pyar6329
#38 rails g model size size:integer high:boolean blu_ray:boolean
b31e9c8
pyar6329 added a commit that referenced this issue Oct 17, 2014
@pyar6329
#38 rails g model bitcasa_time created_at:datetime modified_at:dateti…
4035f0e 
…me changed_at:datetime
pyar6329 added a commit that referenced this issue Oct 17, 2014
@pyar6329
#38 rails g model tag name:string
8c8bb25
pyar6329 added a commit that referenced this issue Oct 17, 2014
@pyar6329
#38 rails g model media name:string
651b263
pyar6329 added a commit that referenced this issue Oct 17, 2014
@pyar6329
#38 rails g model broadcast onair:boolean movie:boolean ova:boolean c…
f494c66 
…omplete:boolean year:integer season:references
pyar6329 added a commit that referenced this issue Oct 17, 2014
@pyar6329
#38 rails g model extension name:string media:references
9371fa7
pyar6329 added a commit that referenced this issue Oct 17, 2014
@pyar6329
#38 rails g model category name:string media:references
bf12e70
pyar6329 added a commit that referenced this issue Oct 17, 2014
@pyar6329
#38 rails g model genre name:string category:references
753b7fa
pyar6329 added a commit that referenced this issue Oct 17, 2014
@pyar6329
#38 rails g model folder name:string path:references genre:references…
367223d 
… bitcasa_time:references size:references
pyar6329 added a commit that referenced this issue Oct 17, 2014
@pyar6329
#38 rails g model bitcasa_file name:string file_id:string path:refere…
e7a4c1d 
…nces broadcast:references size:references extension:references genre:references bitcasa_time:references
pyar6329 added a commit that referenced this issue Oct 17, 2014
@pyar6329
#38 rm bitcasa_files table
c821b46
pyar6329 added a commit that referenced this issue Oct 17, 2014
@pyar6329
#38 rails g model bitcasa_time created_at:datetime modified_at:dateti…
0e1d2b8 
…me changed_at:datetime
pyar6329 added a commit that referenced this issue Oct 17, 2014
@pyar6329
#38 rails g model bitcasa_folder name:string path:references genre:re…
5f09525 
…ferences bitcasa_time:references size:references
pyar6329 added a commit that referenced this issue Oct 17, 2014
@pyar6329
#38 rails g model bitcasa_file name:string file_id:string path:refere…
1a6d239 
…nces broadcast:references size:references extension:references genre:references bitcasa_time:references
pyar6329 added a commit that referenced this issue Oct 17, 2014
@pyar6329
#38 rails g model play count:integer played_at:datetime user:referenc…
8ab949e 
…es bitcasa_file:references
pyar6329 added a commit that referenced this issue Oct 17, 2014
@pyar6329
#38 rails g model bookmark count:integer flag:boolean user:references…
ea04a3a 
… bitcasa_file:references
pyar6329 added a commit that referenced this issue Oct 17, 2014
@pyar6329
#38 rails g model bitcasa_file_tag bitcasa_file:references tag:refere…
76bf030 
…nces
pyar6329 added a commit that referenced this issue Oct 17, 2014
@pyar6329
#38 rails g model bitcasa_folder_tag bitcasa_folder:references tag:re…
3552a42 
…ferences
pyar6329 added a commit that referenced this issue Oct 17, 2014
@pyar6329
#38 has_many add
f19d64f
pyar6329 added a commit that referenced this issue Oct 17, 2014
@pyar6329
#38 rails g model bitcasa_folder name:string path:references genre:re…
5aa5d36 
…ferences bitcasa_time:references size:references broadcast:references
pyar6329 added a commit that referenced this issue Oct 17, 2014
@pyar6329
#38 db schima finish
d8e4f0e
pyar6329 added a commit that referenced this issue Oct 17, 2014
@pyar6329
#38 db schima finish
2209a99
pyar6329 added a commit that referenced this issue Oct 17, 2014
@pyar6329
#38 all rm
334eba3
pyar6329 added a commit that referenced this issue Oct 17, 2014
@pyar6329
#38 all rm
6612072
pyar6329 added a commit that referenced this issue Oct 17, 2014
@pyar6329
#38 make models
d41a66b
@pyar6329
Copy link
Member Author

間違えてたので全部作り直し。

以下のコマンドで作成。

rails g model season name:string broadcast:references --no-timestamps
rails g model path parent:string current:string depth:integer bitcasa_file:references bitcasa_folder:references
rails g model size size:integer high:boolean blu_ray:boolean bitcasa_file:references bitcasa_folder:references --no-timestamps
rails g model bitcasa_time created_at:datetime modified_at:datetime changed_at:datetime bitcasa_file:references bitcasa_folder:references --no-timestamps
rails g model media name:string category:references extension:references --no-timestamps
rails g model broadcast onair:boolean movie:boolean ova:boolean complete:boolean year:integer bitcasa_file:references bitcasa_folder:references --no-timestamps
rails g model extension name:string bitcasa_file:references --no-timestamps
rails g model category name:string genre:references --no-timestamps
rails g model genre name:string bitcasa_file:references bitcasa_folder:references --no-timestamps
rails g model bitcasa_folder name:string
rails g model bitcasa_file name:string file_id:string play:references bookmark:references
rails g model play count:integer played_at:datetime --no-timestamps
rails g model bookmark count:integer flag:boolean
rails g model tag name:string
rails g model bitcasa_file_tag bitcasa_file:references tag:references
rails g model bitcasa_folder_tag bitcasa_folder:references tag:references

pyar6329 added a commit that referenced this issue Oct 17, 2014
@pyar6329
#38 dependency all finish
d6c74ec
pyar6329 added a commit that referenced this issue Oct 17, 2014
@pyar6329
#38 SQL limit add
cd8a598
pyar6329 added a commit that referenced this issue Oct 18, 2014
@pyar6329
#38 all fix
1bc150c
@pyar6329
Copy link
Member Author

作り直しもう一回

以下のコマンドで作成

rails g model season name:string --no-timestamps
rails g model year year:integer --no-timestamps
rails g model broadcast onair:boolean movie:boolean ova:boolean complete:boolean year:references season:references bitcasa_file:references bitcasa_folder:references --no-timestamps
rails g model path parent:string current:string depth:integer bitcasa_file:references bitcasa_folder:references
rails g model size size:integer high:boolean blu_ray:boolean bitcasa_file:references bitcasa_folder:references --no-timestamps
rails g model bitcasa_time created_at:datetime modified_at:datetime changed_at:datetime bitcasa_file:references bitcasa_folder:references --no-timestamps
rails g model tag name:string
rails g model bitcasa_file_tag bitcasa_file:references tag:references
rails g model bitcasa_folder_tag bitcasa_folder:references tag:references
rails g model bitcasa_folder name:string genre:references
rails g model bitcasa_file name:string file_id:string genre:references extension:references
rails g model genre name:string category:references --no-timestamps
rails g model category name:string media:references --no-timestamps
rails g model extension name:string media:references --no-timestamps
rails g model media name:string --no-timestamps
rails g model play count:integer played_at:datetime user:references bitcasa_file:references --no-timestamps
rails g model bookmark count:integer flag:boolean user:references bitcasa_file:references

pyar6329 added a commit that referenced this issue Oct 18, 2014
@pyar6329
#38 all make again
e20d9e2
@pyar6329
Copy link
Member Author

更に作り直し

rails g model year year:integer --no-timestamps
rails g model season name:string --no-timestamps
rails g model tag name:string
rails g model bitcasa_file_tag bitcasa_file:references tag:references
rails g model bitcasa_folder_tag bitcasa_folder:references tag:references
rails g model play count:integer played_at:datetime user:references bitcasa_file:references --no-timestamps
rails g model bookmark count:integer flag:boolean user:references bitcasa_file:references
rails g model genre name:string --no-timestamps
rails g model category name:string --no-timestamps
rails g model extension name:string --no-timestamps
rails g model media name:string --no-timestamps
rails g model extension_media extension:references media:references --no-timestamps
rails g model category_media category:references media:references --no-timestamps
rails g model category_genre category:references genre:references --no-timestamps
rails g model bitcasa_folder name:string category:references media:references genre:references
rails g model bitcasa_file name:string file_id:string extension:references category:references media:references genre:references
rails g model detail parent_path:string current_path:string depth:integer bitcasa_created_at:datetime bitcasa_modified_at:datetime bitcasa_changed_at:datetime size:integer high_definition:boolean blu_ray:boolean onair:boolean movie:boolean ova:boolean complete:boolean year:references season:references bitcasa_file:references bitcasa_folder:references

pyar6329 added a commit that referenced this issue Oct 18, 2014
@pyar6329
#38 add seed
692f8e4
pyar6329 added a commit that referenced this issue Oct 18, 2014
@pyar6329
#38 mimetype add
46ea173
@pyar6329
Copy link
Member Author

mimetypeを追加した

rails g model year year:integer --no-timestamps
rails g model season name:string --no-timestamps
rails g model tag name:string
rails g model bitcasa_file_tag bitcasa_file:references tag:references
rails g model bitcasa_folder_tag bitcasa_folder:references tag:references
rails g model play count:integer played_at:datetime user:references bitcasa_file:references --no-timestamps
rails g model bookmark count:integer flag:boolean user:references bitcasa_file:references
rails g model genre name:string --no-timestamps
rails g model category name:string --no-timestamps
rails g model extension name:string --no-timestamps
rails g model media name:string --no-timestamps
rails g model category_media category:references media:references --no-timestamps
rails g model category_genre category:references genre:references --no-timestamps
rails g model bitcasa_folder name:string category:references media:references genre:references
rails g model detail parent_path:string current_path:string depth:integer bitcasa_created_at:datetime bitcasa_modified_at:datetime bitcasa_changed_at:datetime size:integer high_definition:boolean blu_ray:boolean onair:boolean movie:boolean ova:boolean complete:boolean year:references season:references bitcasa_file:references bitcasa_folder:references
rails g model mimetype name:string --no-timestamps
rails g model bitcasa_file name:string file_id:string mimetype:references extension:references category:references media:references genre:references
rails g model extension_media mimetype:references extension:references media:references --no-timestamps

pyar6329 added a commit that referenced this issue Oct 18, 2014
@pyar6329
#38 add seed files
cfbd5af
pyar6329 added a commit that referenced this issue Oct 19, 2014
@pyar6329
#38 create again as anti-pattern
9f7044d
@pyar6329
Copy link
Member Author

SQLアンチパターン込で再設計、作り直し。

rails g model year year:integer --no-timestamps
rails g model season name:string --no-timestamps
rails g model tag name:string
rails g model play count:integer played_at:datetime user:references bitcasa_file:references --no-timestamps
rails g model bookmark count:integer flag:boolean user:references bitcasa_file:references
rails g model media name:string --no-timestamps
rails g model extension name:string media:references --no-timestamps
rails g model mimetype name:string media:references --no-timestamps
rails g model category name:string media:references --no-timestamps
rails g model genre name:string category:references --no-timestamps
rails g model bitcasa_file name:string file_id:string mimetype:references extension:references detail:references --no-timestamps
rails g model bitcasa_folder name:string detail:references --no-timestamps
rails g model detail path:string bitcasa_created_at:datetime bitcasa_modified_at:datetime bitcasa_changed_at:datetime size:integer high_definition:boolean blu_ray:boolean onair:boolean movie:boolean ova:boolean complete:boolean year:references season:references category:references media:references genre:references
rails g model detail_tag detail:references tag:references
rails g model detail_closure depth:integer detail:references --no-timestamps

pyar6329 added a commit that referenced this issue Oct 21, 2014
@pyar6329
#38 postgres and foreigh key add
afdf2a8
@pyar6329
Copy link
Member Author

mediaの単数形がmediumだったので修正

rails g model year year:integer --no-timestamps
rails g model season name:string --no-timestamps
rails g model tag name:string
rails g model play count:integer played_at:datetime user:references bitcasa_file:references --no-timestamps
rails g model bookmark count:integer flag:boolean user:references bitcasa_file:references
rails g model genre name:string category:references --no-timestamps
rails g model bitcasa_file name:string file_id:string mimetype:references extension:references detail:references --no-timestamps
rails g model bitcasa_folder name:string detail:references --no-timestamps
rails g model detail path:string bitcasa_created_at:datetime bitcasa_modified_at:datetime bitcasa_changed_at:datetime size:integer high_definition:boolean blu_ray:boolean onair:boolean movie:boolean ova:boolean complete:boolean year:references season:references category:references media:references genre:references
rails g model detail_tag detail:references tag:references
rails g model detail_closure depth:integer detail:references --no-timestamps
rails g model medium name:string --no-timestamps
rails g model extension name:string medium:references --no-timestamps
rails g model mimetype name:string medium:references --no-timestamps
rails g model category name:string medium:references --no-timestamps
rails g model detail path:string bitcasa_created_at:datetime bitcasa_modified_at:datetime bitcasa_changed_at:datetime size:integer high_definition:boolean blu_ray:boolean onair:boolean movie:boolean ova:boolean complete:boolean year:references season:references category:references medium:references genre:references

@pyar6329
Copy link
Member Author

  • 外部キー制約ができないので、sqliteからpostgreSQLに変更

pyar6329 added a commit that referenced this issue Oct 21, 2014
@pyar6329
#38 foreigh key add
ae9779a
@pyar6329
Copy link
Member Author

一度テーブルを作ってからじゃないと外部キー制約追加できなかった。
のでmigrationした。

rails g migration AddForeignKeyToPlays
rails g migration AddForeignKeyToBookmarks
rails g migration AddForeignKeyToGenres
rails g migration AddForeignKeyToBitcasaFiles
rails g migration AddForeignKeyToBitcasaFolders
rails g migration AddForeignKeyToDetailTags
rails g migration AddForeignKeyToDetailClosures
rails g migration AddForeignKeyToExtensions
rails g migration AddForeignKeyToMimetypes
rails g migration AddForeignKeyToCategories
rails g migration AddForeignKeyToDetails

pyar6329 added a commit that referenced this issue Oct 22, 2014
@pyar6329
#38 restrict add
b3ac480
@pyar6329
Copy link
Member Author

外部キー(forienger)は無効化した。
理由としては、

  • model側で制御すればいい
  • ActiveRecord依存のdestroyが上手く動作しない
  • いろいろ操作が厄介
  • postgresqlに依存してしまう

@pyar6329
Copy link
Member Author

外部キー(forienger)追加したmigrationデータはforeign-key-plusブランチへ移動した

pyar6329 added a commit that referenced this issue Oct 22, 2014
@pyar6329
#38 closure relation delete
55fb1ac
pyar6329 added a commit that referenced this issue Oct 23, 2014
@pyar6329
#38 genre update
05d6d08
pyar6329 added a commit that referenced this issue Oct 24, 2014
@pyar6329
#38 dropbox fix
ceeee76
@pyar6329
Copy link
Member Author

Dropbox用に修正

rails g model year year:integer --no-timestamps
rails g model season name:string --no-timestamps
rails g model tag name:string
rails g model genre name:string category:references --no-timestamps
rails g model detail_tag detail:references tag:references
rails g model detail_closure depth:integer detail:references --no-timestamps
rails g model medium name:string --no-timestamps
rails g model extension name:string medium:references --no-timestamps
rails g model mimetype name:string medium:references --no-timestamps
rails g model category name:string medium:references --no-timestamps
rails g model detail_file name:string file_modified_at:datetime mimetype:references extension:references detail:references --no-timestamps
rails g model detail_folder name:string hash:string detail:references --no-timestamps
rails g model detail path:string is_dir:boolean dropbox_modified_at:datetime size:integer high_definition:boolean blu_ray:boolean onair:boolean movie:boolean ova:boolean complete:boolean year:references season:references category:references medium:references genre:references
rails g model play count:integer played_at:datetime user:references detail_file:references --no-timestamps
rails g model bookmark count:integer flag:boolean user:references detail_file:references

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
機能拡張
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@pyar6329