1 {%- set portraitWallpaper = feat_tree.HomeScreenDbSettings.portraitWallpaper._value or '' -%}

     2 {%- set landscapeWallpaper = feat_tree.HomeScreenDbSettings.landscapeWallpaper._value or '' -%}

     3 {%- set defaultPageId = feat_tree.HomeScreenDbSettings.defaultPageId._value -%}

     4 {%- set maximumPageCount = feat_tree.HomeScreenDbSettings.maximumPageCount._value -%}

     5 INSERT INTO Scene (portraitWallpaper, landscapeWallpaper, defaultPageId, maximumPageCount) VALUES ('{{portraitWallpaper}}', '{{landscapeWallpaper}}', {{defaultPageId}}, {{maximumPageCount}});

     6 

     7 {% for index in range(feat_tree.HomeScreenDbSettings.Pages._value|length) -%}

     8     {%- set id = feat_tree.HomeScreenDbSettings.Pages.id._value[index] -%}

     9     {%- set indexPosition = feat_tree.HomeScreenDbSettings.Pages.indexPosition._value[index] -%}

    10     INSERT INTO Pages (id, indexPosition) VALUES ({{id}}, {{indexPosition}});

    11 {% endfor %}

    12 

    13 {% for index in range(feat_tree.HomeScreenDbSettings.Widgets._value|length) -%}

    14     {%- set id = feat_tree.HomeScreenDbSettings.Widgets.id._value[index] -%}

    15     {%- set uri = feat_tree.HomeScreenDbSettings.Widgets.uri._value[index] or '' -%}

    16     {%- set pageId = feat_tree.HomeScreenDbSettings.Widgets.pageId._value[index] -%}

    17     

    18     INSERT INTO Widgets (id, uri, pageId) VALUES ({{id}}, '{{uri}}', {{pageId}});

    19 {% endfor %}

    20 

    21 {% for index in range(feat_tree.HomeScreenDbSettings.WidgetPresentations._value|length) -%}

    22     {%- set key = feat_tree.HomeScreenDbSettings.WidgetPresentations.key._value[index] or '' -%}

    23     {%- set x = feat_tree.HomeScreenDbSettings.WidgetPresentations.x._value[index] -%}

    24     {%- set y = feat_tree.HomeScreenDbSettings.WidgetPresentations.y._value[index] -%}

    25     {%- set width = feat_tree.HomeScreenDbSettings.WidgetPresentations.width._value[index] -%}

    26     {%- set height = feat_tree.HomeScreenDbSettings.WidgetPresentations.height._value[index] -%}

    27     {%- set zValue = feat_tree.HomeScreenDbSettings.WidgetPresentations.zValue._value[index] -%}

    28     {%- set widgetId = feat_tree.HomeScreenDbSettings.WidgetPresentations.widgetId._value[index] -%}

    29     

    30     INSERT INTO WidgetPresentations (key, x, y, width, height, zValue, widgetId) VALUES ('{{key}}', {{x}}, {{y}}, {{width}}, {{height}}, {{zValue}}, {{widgetId}});

    31 {% endfor %}

    32 

    33 {% for index in range(feat_tree.HomeScreenDbSettings.WidgetPreferences._value|length) -%}

    34     {%- set key = feat_tree.HomeScreenDbSettings.WidgetPreferences.key._value[index] or '' -%}

    35     {%- set value = feat_tree.HomeScreenDbSettings.WidgetPreferences.value._value[index] -%}

    36     {%- set widgetId = feat_tree.HomeScreenDbSettings.WidgetPreferences.widgetId._value[index] -%}

    37     

    38     INSERT INTO WidgetPreferences (key, value, widgetId) VALUES ('{{key}}', '{{value}}', {{widgetId}});

    39 {% endfor %}