1 INSERT INTO Scene (id) VALUES (1);

     2 

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

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

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

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

     7 {% endfor %}

     8 

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

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

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

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

    13     

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

    15 {% endfor %}

    16 

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

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

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

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

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

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

    23     

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

    25 {% endfor %}

    26 

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

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

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

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

    31     

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

    33 {% endfor %}

    34 

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

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

    37     {%- set value = feat_tree.HomeScreenDbSettings.Configuration.value._value[index] -%}

    38     

    39     INSERT INTO Configuration (key, value) VALUES ('{{key}}', '{{value}}');

    40 {% endfor %}