|
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 %} |