author | Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> |
Fri, 17 Sep 2010 08:27:54 +0300 | |
changeset 92 | 6727c5d0afc7 |
permissions | -rw-r--r-- |
92
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
1 |
INSERT INTO Scene (id) VALUES (1); |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
2 |
|
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
3 |
{% for index in range(feat_tree.HomeScreenDbSettings.Pages._value|length) -%} |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
4 |
{%- set id = feat_tree.HomeScreenDbSettings.Pages.id._value[index] -%} |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
5 |
{%- set indexPosition = feat_tree.HomeScreenDbSettings.Pages.indexPosition._value[index] -%} |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
6 |
INSERT INTO Pages (id, indexPosition) VALUES ({{id}}, {{indexPosition}}); |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
7 |
{% endfor %} |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
8 |
|
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
9 |
{% for index in range(feat_tree.HomeScreenDbSettings.Widgets._value|length) -%} |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
10 |
{%- set id = feat_tree.HomeScreenDbSettings.Widgets.id._value[index] -%} |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
11 |
{%- set uri = feat_tree.HomeScreenDbSettings.Widgets.uri._value[index] or '' -%} |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
12 |
{%- set pageId = feat_tree.HomeScreenDbSettings.Widgets.pageId._value[index] -%} |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
13 |
|
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
14 |
INSERT INTO Widgets (id, uri, pageId) VALUES ({{id}}, '{{uri}}', {{pageId}}); |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
15 |
{% endfor %} |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
16 |
|
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
17 |
{% for index in range(feat_tree.HomeScreenDbSettings.WidgetPresentations._value|length) -%} |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
18 |
{%- set key = feat_tree.HomeScreenDbSettings.WidgetPresentations.key._value[index] or '' -%} |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
19 |
{%- set x = feat_tree.HomeScreenDbSettings.WidgetPresentations.x._value[index] -%} |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
20 |
{%- set y = feat_tree.HomeScreenDbSettings.WidgetPresentations.y._value[index] -%} |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
21 |
{%- set zValue = feat_tree.HomeScreenDbSettings.WidgetPresentations.zValue._value[index] -%} |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
22 |
{%- set widgetId = feat_tree.HomeScreenDbSettings.WidgetPresentations.widgetId._value[index] -%} |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
23 |
|
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
24 |
INSERT INTO WidgetPresentations (key, x, y, zValue, widgetId) VALUES ('{{key}}', {{x}}, {{y}}, {{zValue}}, {{widgetId}}); |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
25 |
{% endfor %} |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
26 |
|
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
27 |
{% for index in range(feat_tree.HomeScreenDbSettings.WidgetPreferences._value|length) -%} |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
28 |
{%- set key = feat_tree.HomeScreenDbSettings.WidgetPreferences.key._value[index] or '' -%} |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
29 |
{%- set value = feat_tree.HomeScreenDbSettings.WidgetPreferences.value._value[index] -%} |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
30 |
{%- set widgetId = feat_tree.HomeScreenDbSettings.WidgetPreferences.widgetId._value[index] -%} |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
31 |
|
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
32 |
INSERT INTO WidgetPreferences (key, value, widgetId) VALUES ('{{key}}', '{{value}}', {{widgetId}}); |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
33 |
{% endfor %} |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
34 |
|
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
35 |
{% for index in range(feat_tree.HomeScreenDbSettings.Configuration._value|length) -%} |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
36 |
{%- set key = feat_tree.HomeScreenDbSettings.Configuration.key._value[index] or '' -%} |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
37 |
{%- set value = feat_tree.HomeScreenDbSettings.Configuration.value._value[index] -%} |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
38 |
|
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
39 |
INSERT INTO Configuration (key, value) VALUES ('{{key}}', '{{value}}'); |
6727c5d0afc7
Revision: 201036
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
diff
changeset
|
40 |
{% endfor %} |