contentstorage/castorage/conf/castoragedb_templates/castoragedb_variant.sql
changeset 125 26079c1bb561
parent 119 50e220be30d1
equal deleted inserted replaced
123:d1dadafc5584 125:26079c1bb561
    43         {%- set GroupName = feat_tree.CaStorageDbSetting[Collections].GroupName._value[col] or '' -%}
    43         {%- set GroupName = feat_tree.CaStorageDbSetting[Collections].GroupName._value[col] or '' -%}
    44         {%- set Locked = feat_tree.CaStorageDbSetting[Collections].Locked._value[col] or false -%}
    44         {%- set Locked = feat_tree.CaStorageDbSetting[Collections].Locked._value[col] or false -%}
    45         {%- set LocalizeNames = false -%}
    45         {%- set LocalizeNames = false -%}
    46         {%- if Collections == "Collections" -%}
    46         {%- if Collections == "Collections" -%}
    47             {%- set LocalizeNames = feat_tree.CaStorageDbSetting[Collections].LocalizeNames._value[col] or false -%}
    47             {%- set LocalizeNames = feat_tree.CaStorageDbSetting[Collections].LocalizeNames._value[col] or false -%}
    48             {%- 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] or '' -%}
    49         {%- endif %}
    49             {%- if TranslationFile != "" -%}
       
    50                 {%- set TranslationFile = TranslationFile~'_' -%}
       
    51             {%- endif -%}
       
    52         {%- endif -%}
    50         {%- set IconFileName = feat_tree.CaStorageDbSetting[Collections].Icon.localPath._value[col] or '' -%}
    53         {%- set IconFileName = feat_tree.CaStorageDbSetting[Collections].Icon.localPath._value[col] or '' -%}
    51         {%- set IconSkinId = feat_tree.CaStorageDbSetting[Collections].IconSkinId._value[col] or '' -%}
    54         {%- set IconSkinId = feat_tree.CaStorageDbSetting[Collections].IconSkinId._value[col] or '' -%}
    52         {%- if IconFileName != "" -%}
    55         {%- if IconFileName != "" -%}
    53             {%- set IconFileName = stripPath(IconFileName) -%}
    56             {%- set IconFileName = stripPath(IconFileName) -%}
    54         {%- endif %}
    57         {%- endif -%}
    55         {%- if ShortName == "" -%}
    58         {%- if ShortName == "" -%}
    56             {%- set ShortName = Name -%}
    59             {%- set ShortName = Name -%}
    57         {%- endif %}
    60         {%- endif -%}
    58         {%- if TitleName == "" -%}
       
    59             {%- set TitleName = Name -%}
       
    60         {%- endif %}
       
    61         {%- if GroupName == "" -%}
    61         {%- if GroupName == "" -%}
    62             {%- set GroupName = Name -%}
    62             {%- set GroupName = Name -%}
    63         {%- endif %}        
    63         {%- endif -%}        
    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) 
    64     INSERT INTO COLLECTION (COLLECTION_NAME, COL_APP_GROUP_NAME, FLAGS{%- if TitleName -%},  COL_TITLE_NAME{%- endif %} {% if LocalizeNames -%}, TRANSLATION_FILE{%- endif %}, COL_SHORT_NAME, ICON_FILENAME, ICON_SKIN_ID) 
    65     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 %}{%- if TitleName -%}, "{{TitleName}}"{%- endif %}{% if LocalizeNames -%}, "{{TranslationFile}}"{%- endif %}, "{{ShortName}}", "{{IconFileName}}", "{{IconSkinId}}");
    66     {% endfor %}
    66     {% endfor %}
    67 {%- endmacro %}
    67 {%- endmacro %}
    68 
    68 
    69 {% macro processItems(Items) -%}
    69 {% macro processItems(Items) -%}
    70     {%- for index in range(feat_tree.CaStorageDbSetting[Items]._value|length) -%}
    70     {%- for index in range(feat_tree.CaStorageDbSetting[Items]._value|length) -%}