homescreenapp/hsapplication/conf/base/implml/homescreendb_templates/fill.sql
changeset 39 4e8ebe173323
parent 36 cdae8c6c3876
child 51 4785f57bf3d4
--- a/homescreenapp/hsapplication/conf/base/implml/homescreendb_templates/fill.sql	Fri Apr 16 14:54:01 2010 +0300
+++ b/homescreenapp/hsapplication/conf/base/implml/homescreendb_templates/fill.sql	Mon May 03 12:24:59 2010 +0300
@@ -2,7 +2,11 @@
 {%- set landscapeWallpaper = feat_tree.HomeScreenDbSettings.landscapeWallpaper._value or '' -%}
 {%- set defaultPageId = feat_tree.HomeScreenDbSettings.defaultPageId._value -%}
 {%- set maximumPageCount = feat_tree.HomeScreenDbSettings.maximumPageCount._value -%}
-INSERT INTO Scene (portraitWallpaper, landscapeWallpaper, defaultPageId, maximumPageCount) VALUES ('{{portraitWallpaper}}', '{{landscapeWallpaper}}', {{defaultPageId}}, {{maximumPageCount}});
+{%- set maximumWidgetHeight = feat_tree.HomeScreenDbSettings.maximumWidgetHeight._value -%}
+{%- set maximumWidgetWidth = feat_tree.HomeScreenDbSettings.maximumWidgetWidth._value -%}
+{%- set minimumWidgetHeight = feat_tree.HomeScreenDbSettings.minimumWidgetHeight._value -%}
+{%- set minimumWidgetWidth = feat_tree.HomeScreenDbSettings.minimumWidgetWidth._value -%}
+INSERT INTO Scene (portraitWallpaper, landscapeWallpaper, defaultPageId, maximumPageCount, maximumWidgetHeight, maximumWidgetWidth, minimumWidgetHeight, minimumWidgetWidth) VALUES ('{{portraitWallpaper}}', '{{landscapeWallpaper}}', {{defaultPageId}}, {{maximumPageCount}}, {{maximumWidgetHeight}}, {{maximumWidgetWidth}}, {{minimumWidgetHeight}}, {{minimumWidgetWidth}});
 
 {% for index in range(feat_tree.HomeScreenDbSettings.Pages._value|length) -%}
     {%- set id = feat_tree.HomeScreenDbSettings.Pages.id._value[index] -%}
@@ -22,12 +26,10 @@
     {%- set key = feat_tree.HomeScreenDbSettings.WidgetPresentations.key._value[index] or '' -%}
     {%- set x = feat_tree.HomeScreenDbSettings.WidgetPresentations.x._value[index] -%}
     {%- set y = feat_tree.HomeScreenDbSettings.WidgetPresentations.y._value[index] -%}
-    {%- set width = feat_tree.HomeScreenDbSettings.WidgetPresentations.width._value[index] -%}
-    {%- set height = feat_tree.HomeScreenDbSettings.WidgetPresentations.height._value[index] -%}
     {%- set zValue = feat_tree.HomeScreenDbSettings.WidgetPresentations.zValue._value[index] -%}
     {%- set widgetId = feat_tree.HomeScreenDbSettings.WidgetPresentations.widgetId._value[index] -%}
     
-    INSERT INTO WidgetPresentations (key, x, y, width, height, zValue, widgetId) VALUES ('{{key}}', {{x}}, {{y}}, {{width}}, {{height}}, {{zValue}}, {{widgetId}});
+    INSERT INTO WidgetPresentations (key, x, y, zValue, widgetId) VALUES ('{{key}}', {{x}}, {{y}}, {{zValue}}, {{widgetId}});
 {% endfor %}
 
 {% for index in range(feat_tree.HomeScreenDbSettings.WidgetPreferences._value|length) -%}