Mercurial Mercurial > oss > FCL > sf > mw > homescreensrv / comparison
summary | shortlog | changelog | graph | tags | bookmarks | branches | files | changeset | file | latest | revisions | annotate | diff | comparison | raw | help
Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
contentstorage/castorage/conf/castoragedb_templates/castoragedb_variant.sql
changeset 124 e36b2f4799c0
parent 121 0b3699f6c654
equal deleted inserted replaced
121:0b3699f6c654 124:e36b2f4799c0 
    10         {%- endif %}
 
    10         {%- endif %}
 
    11         {%- if cont %}
 
    11         {%- if cont %}
 
    12             {%- set Icon = c ~ Icon %}
 
    12             {%- set Icon = c ~ Icon %}
 
    13         {%- endif %}
 
    13         {%- endif %}
 
    14         {%- if loop.last -%}
 
    14         {%- if loop.last -%}
 
    15             {{ "z:\\private\\20022F35\\customsvg\\" ~ Icon }}
 
    15             {%- if Icon == "dummy" %}
 
       
    16             {% else -%}
 
       
    17                 {{ "z:\\private\\20022F35\\customsvg\\" ~ Icon }}
 
       
    18             {%- endif -%}
 
    16         {%- endif %}
 
    19         {%- endif %}
 
    17     {%- endfor %}
 
    20     {%- endfor %}
 
    18 {%- endmacro %}
 
    21 {%- endmacro %}
 
    19 
    22 
    20 {%- macro processURLs(URLs) %}
 
    23 {%- macro processURLs(URLs) %}
 
    22         {%- set URLTitle = feat_tree.CaStorageDbSetting[URLs].URLTitle._value[i] -%}
 
    25         {%- set URLTitle = feat_tree.CaStorageDbSetting[URLs].URLTitle._value[i] -%}
 
    23         {%- set URLShortTitle = feat_tree.CaStorageDbSetting[URLs].URLShortTitle._value[i] or '' -%}
 
    26         {%- set URLShortTitle = feat_tree.CaStorageDbSetting[URLs].URLShortTitle._value[i] or '' -%}
 
    24         {%- set URL = feat_tree.CaStorageDbSetting[URLs].URL._value[i] or '' -%}
 
    27         {%- set URL = feat_tree.CaStorageDbSetting[URLs].URL._value[i] or '' -%}
 
    25         {%- set URLIcon = feat_tree.CaStorageDbSetting[URLs].URLIcon.localPath._value[i] or '' -%}
 
    28         {%- set URLIcon = feat_tree.CaStorageDbSetting[URLs].URLIcon.localPath._value[i] or '' -%}
 
    26         {%- set IconSkinId = feat_tree.CaStorageDbSetting[URLs].IconSkinId._value[i] or '' -%}
 
    29         {%- set IconSkinId = feat_tree.CaStorageDbSetting[URLs].IconSkinId._value[i] or '' -%}
 
    27         {%- if IconSkinId == "" and URLIcon != "" and URLIcon != "dummy" -%}
 
    30         {%- if URLIcon != "" -%}
 
    28             {%- set URLIcon = stripPath(URLIcon) -%}
 
    31             {%- set URLIcon = stripPath(URLIcon) -%}
 
    29         {%- endif %}
 
    32         {%- endif %}
 
    30         INSERT INTO URL ( URL_TITLE, URL_SHORT_TITLE, URL_DEST, ICON_FILENAME, ICON_SKIN_ID ) 
    33         INSERT INTO URL ( URL_TITLE, URL_SHORT_TITLE, URL_DEST, ICON_FILENAME, ICON_SKIN_ID ) 
    31         VALUES ( '{{URLTitle}}', "{{URLShortTitle}}", "{{URL}}", "{{URLIcon}}", "{{IconSkinId}}" );
 
    34         VALUES ( '{{URLTitle}}', "{{URLShortTitle}}", "{{URL}}", "{{URLIcon}}", "{{IconSkinId}}" );
 
    32     {%- endfor %}
 
    35     {%- endfor %}
 
    44             {%- set LocalizeNames = feat_tree.CaStorageDbSetting[Collections].LocalizeNames._value[col] or false -%}
 
    47             {%- set LocalizeNames = feat_tree.CaStorageDbSetting[Collections].LocalizeNames._value[col] or false -%}
 
    45             {%- set TranslationFile = feat_tree.CaStorageDbSetting[Collections].TranslationFile._value[col]|string|reverse|replace('_','',1)|reverse~'_' or ''-%}
 
    48             {%- set TranslationFile = feat_tree.CaStorageDbSetting[Collections].TranslationFile._value[col]|string|reverse|replace('_','',1)|reverse~'_' or ''-%}
 
    46         {%- endif %}
 
    49         {%- endif %}
 
    47         {%- set IconFileName = feat_tree.CaStorageDbSetting[Collections].Icon.localPath._value[col] or '' -%}
 
    50         {%- set IconFileName = feat_tree.CaStorageDbSetting[Collections].Icon.localPath._value[col] or '' -%}
 
    48         {%- set IconSkinId = feat_tree.CaStorageDbSetting[Collections].IconSkinId._value[col] or '' -%}
 
    51         {%- set IconSkinId = feat_tree.CaStorageDbSetting[Collections].IconSkinId._value[col] or '' -%}
 
    49         {%- if IconSkinId == "" and IconFileName != "" and IconFileName != "dummy" -%}
 
    52         {%- if IconFileName != "" -%}
 
    50             {%- set IconFileName = stripPath(IconFileName) -%}
 
    53             {%- set IconFileName = stripPath(IconFileName) -%}
 
    51         {%- endif %}
 
    54         {%- endif %}
 
       
    55         {%- if ShortName == "" -%}
 
       
    56             {%- set ShortName = Name -%}
 
       
    57         {%- endif %}
 
       
    58         {%- if TitleName == "" -%}
 
       
    59             {%- set TitleName = Name -%}
 
       
    60         {%- endif %}
 
       
    61         {%- if GroupName == "" -%}
 
       
    62             {%- set GroupName = Name -%}
 
       
    63         {%- endif %}        
    52     INSERT INTO COLLECTION (COLLECTION_NAME, COL_APP_GROUP_NAME, FLAGS,  COL_TITLE_NAME {% if LocalizeNames -%}, TRANSLATION_FILE{%- endif %}, COL_SHORT_NAME, ICON_FILENAME, ICON_SKIN_ID) 
    64     INSERT INTO COLLECTION (COLLECTION_NAME, COL_APP_GROUP_NAME, FLAGS,  COL_TITLE_NAME {% if LocalizeNames -%}, TRANSLATION_FILE{%- endif %}, COL_SHORT_NAME, ICON_FILENAME, ICON_SKIN_ID) 
    53     VALUES ( '{{Name}}', '{{GroupName}}', {% if Locked -%} 0 {% else %} 4 {%- endif %}, "{{TitleName}}"{% if LocalizeNames -%}, "{{TranslationFile}}"{%- endif %}, "{{ShortName}}", "{{IconFileName}}", "{{IconSkinId}}");
 
    65     VALUES ( '{{Name}}', '{{GroupName}}', {% if Locked -%} 0 {% else %} 4 {%- endif %}, "{{TitleName}}"{% if LocalizeNames -%}, "{{TranslationFile}}"{%- endif %}, "{{ShortName}}", "{{IconFileName}}", "{{IconSkinId}}");
 
    54     {% endfor %}
 
    66     {% endfor %}
 
    55 {%- endmacro %}
 
    67 {%- endmacro %}
 
    56 
    68 
    68             {%- set Collection = feat_tree.CaStorageDbSetting.OperatorCollections.Name._value[0] %}
 
    80             {%- set Collection = feat_tree.CaStorageDbSetting.OperatorCollections.Name._value[0] %}
 
    69             {%- set URLs = 'OperatorURLs' -%}
 
    81             {%- set URLs = 'OperatorURLs' -%}
 
    70         {%- endif %}
 
    82         {%- endif %}
 
    71         
    83         
    72         {% if Type == "1" -%} INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE, ITEM_NAME, ITEM_DEST, COLLECTION_NAME) 
    84         {% if Type == "1" -%} INSERT INTO ITEM_TO_COLLECTION (ITEM_TYPE, ITEM_NAME, ITEM_DEST, COLLECTION_NAME) 
    73           VALUES ("application", '', {{Application}},  '{{Collection}}' );{%- endif %}
 
    85           VALUES ("application", '', {{Application|hex2dec}},  '{{Collection}}' );{%- endif %}
 
    74           
    86           
    75         {% if Type == "2" -%} INSERT INTO WIDGET_TO_COLLECTION (ITEM_TYPE, ITEM_NAME, URI, COLLECTION_NAME ) 
    87         {% if Type == "2" -%} INSERT INTO WIDGET_TO_COLLECTION (ITEM_TYPE, ITEM_NAME, URI, COLLECTION_NAME ) 
    76           VALUES ("widget", '{{HomescreenWidget}}', "{{HomescreenWidget}}", '{{Collection}}' ); {%- endif %}
 
    88           VALUES ("widget", '{{HomescreenWidget}}', "{{HomescreenWidget}}", '{{Collection}}' ); {%- endif %}
 
    77           
    89           
    78         {% if Type == "3" -%}
 
    90         {% if Type == "3" -%}
FCL/sf/mw/homescreensrv