logger.debug("loaded filetype: {}", mimetypeMap);
        }
    }

    public void add(final String mimetype, final String filetype) {
        mimetypeMap.put(mimetype, filetype);
    }

    public String get(final String mimetype) {
        final String filetype = mimetypeMap.get(mimetype);
        if (StringUtil.isBlank(filetype)) {
            return defaultValue;
        }

        final int fileType;
        if (fileName.startsWith("system") && fileName.endsWith(".properties")) {
            fileType = 1;
        } else if (fileName.startsWith("gsa") && fileName.endsWith(".xml")) {
            fileType = 2;
        } else if (fileName.endsWith(".bulk")) {
            fileType = 3;

    public static final String AS_OQ = "oq";

    public static final String AS_EPQ = "epq";

    public static final String AS_Q = "q";

    public static final String AS_FILETYPE = "filetype";

    public static final String AS_SITESEARCH = "sitesearch";

    public static final String AS_OCCURRENCE = "occt";

    public static final String AS_TIMESTAMP = "timestamp";

     * labels.facet_filetype_title:labels.facet_filetype_html=filetype:html	labels.facet_filetype_word=filetype:word	labels.facet_filetype_excel=filetype:excel	labels.facet_filetype_powerpoint=filetype:powerpoint	labels.facet_filetype_odt=filetype:odt	labels.facet_filetype_ods=filetype:ods	labels.facet_filetype_odp=filetype:odp	labels.facet_filetype_pdf=filetype:pdf	labels.facet_filetype_txt=filetype:txt	labels.facet_filetype_others=filetype:others<br>

                    queryBuf.append(' ').append(nq);
                }));
        stream(conditions.get(SearchRequestParams.AS_FILETYPE))
                .of(stream -> stream.filter(q -> StringUtil.isNotBlank(q) && q.length() <= maxQueryLength)
                        .forEach(q -> queryBuf.append(" filetype:\"").append(q.trim()).append('"')));
        stream(conditions.get(SearchRequestParams.AS_SITESEARCH))

		if stmt.Schema != nil {
			if field := stmt.Schema.LookUpField(field); field != nil {
				fileType := m.FullDataTypeOf(field)
				return m.DB.Exec(
					"ALTER TABLE ? ALTER COLUMN ? TYPE ?",
					m.CurrentTable(stmt), clause.Column{Name: field.DBName}, fileType,
				).Error

			}
		}
		return fmt.Errorf("failed to look up field with name: %s", field)
	})
}

            assertTrue(sortValue >= prevVal);
            prevVal = sortValue;
        }
    }

    @Test
    public void searchTestWithWildcard() throws Exception {
        String field = "filetype";
        String query = "others";
        String wcQuery1 = "othe*";
        String wcQuery2 = "oth??s";
        Map<String, String> params = new HashMap<>();
        params.put("q", field + ":" + query);

        // mimetype
        putResultDataBody(dataMap, fessConfig.getIndexFieldMimetype(), mimeType);
        if (fileTypeHelper != null) {
            // filetype
            putResultDataBody(dataMap, fessConfig.getIndexFieldFiletype(), fileTypeHelper.get(mimeType));
        }
        // content_length

        assertEquals("labels.facet_contentLength_title", view2.getTitle());
        assertEquals(5, view2.getQueryMap().size());
        FacetQueryView view3 = list.get(2);
        assertEquals("labels.facet_filetype_title", view3.getTitle());
        assertEquals(10, view3.getQueryMap().size());
    }

    public void test_getUrlLink() throws IOException {
        ComponentUtil.setFessConfig(new FessConfig.SimpleImpl() {

# vim: filetype=bash
#
# Copyright 2022 The TensorFlow Authors. All Rights Reserved.
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#     http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,