Code Excursion

Database Changes After Adding Liferay Button Fragment

What data changes occur when adding a Container Fragment to a Page in Liferay. Pages in liferay are correllated to layouts in the database. This information was added by administrator user Test Test with email test@test.com. Keep in mind that Liferay doesn’t enforce referential integrity in the database. Instead it is “enforced” in the code.

The following table was modified but appears not to be strongly relevant.

• PortalPreferenceValue

Tables that were changed after adding a Button Fragment to a Container Fragment on Page “Types of Rocks”. This page was added to the “All About Rocks” site with GroupId 32925.

• FragmentEntryLink
  • Two rows inserted.
  • Primary key is fragmentEntryLinkId and ctCollectionId.
  • FragmentEntryLinkIds had values 33122 and 33123.
  • RenderKeys had value BASIC_COMPONENT-button.
  • HTML columns contained Freemarker template fragment.
  • Configuration columns contained JSON data related to configuring the button fragment.
  • GroupIds had value 32925.
  • UserIds had value 20123.
  • OriginalFragmentEntryLinkIds had values 0 and 33122.
  • SegmentsExperienceIds had value 33069.
  • ClassNameIds had value 20031. Which points to nothing and the com.liferay.portal.kernel.model.Layout in the ClassName_ table.
  • ClassPks was 25 and 26.
• Layout
  • Table to page data. Layouts are effectively web pages in Liferay.
  • Primary key is plId and ctCollectionId.
  • Plids had values 25 and 26.
  • MvccVersions were updated from 16 and 24 to 18 and 27. Purpose of this column is unknown.
• LayoutPageTemplateStructure
  • Primary key is layoutPageTemplateStructureId and ctCollectionId.
  • LayoutPageTemplateStructureIds had values 33070 and 33076.
  • MvccVersions were updated from 6 and 18 to 7 and 20. Purpose of this column is unknown.
• LayoutPageTemplateStructureRel
  • Primary key is lPageTemplateStructureRelId and ctCollectionId.
  • LPageTemplateStructureRelId had values 33071 and 33077.
  • MvccVersions were updated from 6 and 18 to 7 and 20. Purpose of this column is unknown.
  • Data_ column was updated to have a container object. Code shown below. The significant change being the addition of a Fragment child element.
  • There is a third order relationship between the Data_ column content and FragmentEntryLink.

JSON from Data_ column

{
    "deletedItems": [],
    "pageRules": [],
    "rootItems": {
        "dropZone": "",
        "main": "39cce44e-3191-0b20-48bc-a61e89aace06"
    },
    "items": {
        "fd47294e-736c-5972-4509-105b8cc0395e": {
            "itemId": "fd47294e-736c-5972-4509-105b8cc0395e",
            "children": [
                "06ab4225-93b6-49b0-e9da-188de671ab1e"
            ],
            "type": "container",
            "config": {
                "tablet": {
                    "styles": {}
                },
                "cssClasses": [],
                "landscapeMobile": {
                    "styles": {}
                },
                "portraitMobile": {
                    "styles": {}
                },
                "styles": {}
            },
            "parentId": "39cce44e-3191-0b20-48bc-a61e89aace06"
        },
        "06ab4225-93b6-49b0-e9da-188de671ab1e": {
            "itemId": "06ab4225-93b6-49b0-e9da-188de671ab1e",
            "children": [],
            "type": "fragment",
            "config": {
                "tablet": {
                    "styles": {}
                },
                "cssClasses": [],
                "landscapeMobile": {
                    "styles": {}
                },
                "portraitMobile": {
                    "styles": {}
                },
                "styles": {},
                "fragmentEntryLinkId": "33122"
            },
            "parentId": "fd47294e-736c-5972-4509-105b8cc0395e"
        },
        "39cce44e-3191-0b20-48bc-a61e89aace06": {
            "itemId": "39cce44e-3191-0b20-48bc-a61e89aace06",
            "children": [
                "fd47294e-736c-5972-4509-105b8cc0395e"
            ],
            "type": "root",
            "config": {},
            "parentId": ""
        }
    },
    "version": 1.1
}

Diagram is only showing the relationships most relevant.

Resources

• Before Database Dump
• After Database Dump
• PlantUML Changed Data Diagram