ShinyCMS Developer Notes

Copying data from Perl version to Ruby version

General

We're assuming MySQL at Perl end, Postgres at Ruby end.

Tables (for features that have been re-implemented)

user -> User

role -> [ set of Capability ]

user_role -> [ set of UserCapability ]

cms_page -> ShinyPages::Page id (int-> bigint) name url_title -> slug title description template -> template_id section -> section_id menu_position -> sort_order show_on_site (tinyint -> boolean) -> show_in_menus created -> created_at, updated_at

cms_page_element -> ShinyPages::PageElements id (int-> bigint) page - page_id name content type -> element_type created -> created_at, updated_at

cms_template -> ShinyPages::Template id (int-> bigint) name -> description template_file -> filename created -> created_at, updated_at

cms_template_element -> ShinyPages::TemplateElement id (int-> bigint) template -> template_id name -> content type -> element_type created -> created_at, updated_at

cms_section -> ShinyPages::Section id (int-> bigint) name description -> title url_name -> slug default_page -> default_page_id -> section_id menu_position -> sort_order show_on_site (tinyint -> boolean) -> show_in_menus created -> created_at, updated_at

shared_content -> ShinyInserts::Element id (int-> bigint) name content type -> element_type -> set_id created -> created_at, updated_at

blog_post -> ShinyBlog::Post id (int -> bigint) title url_title -> slug body hidden -> show_on_site (tinyint -> boolean) blog -> [ gone ] author -> user_id posted -> posted_at, created_at, updated_at discussion -> [ gone - replaced by wibbly-wobbly polymorphy stuff ]

news_item -> ShinyNews::Post id (int -> bigint) title url_title -> slug body hidden -> show_on_site (tinyint -> boolean) author -> user_id posted -> posted_at, created_at, updated_at discussion -> [ gone - replaced by wibbly-wobbly polymorphy stuff ]

discussion -> Discussion id (int -> bigint) resource_id (int -> bigint) resource_type (DBIC class -> AR class)

comment -> Comment -> CommentAuthor uid -> id (int -> bigint) id -> number discussion -> discussion_id (int -> bigint) ...

mail_recipient -?> EmailRecipient -> confirmed_at ?? :-\

mailing_list -> ShinyLists::List subscription -> ShinyLists::Subscription -> ConsentVersion?? :-\

newsletter -> ShinyNewsletters::Edition -> ShinyNewsletters::Send newsletter_element -> ShinyNewsletters::EditionElement newsletter_template -> ShinyNewsletters::Template newsletter_template_element -> ShinyNewsletters::TemplateElement

tag tagset -> taggings ?? -> acts-as-taggable-on gem

comment_like -> votable gem :-\