executedAndNotSkipped(":signMavenPublication")

        and:
        file("build", "libs", "sign-1.0.jar.asc").text
        file("build", "publications", "maven", "module.json.asc").text
        file("build", "publications", "ivy", "module.json.asc").text
    }

    def "allows signing Gradle metadata if version is a snapshot"() {
        when:
        buildFile << """

                fileName = Files.getNameWithoutExtension(fileName); // removes the .asc
                IvyArtifactName base = DefaultIvyArtifactName.forFileName(fileName, null);
                return new DefaultIvyArtifactName(
                    base.getName(),
                    "asc",
                    base.getExtension() + ".asc"
                );
            }

            @Override

            ORG_GRADLE_PROJECT_password: password
        ])
        succeeds("signJar")

        then:
        executed(":signJar")
        file("build", "libs", "sign-1.0.jar.asc").exists()
    }

    def "signs with custom signatory"() {
        given:
        buildFile << """
            signing {
                useInMemoryPgpKeys('foo', 'bar')
                signatories {

						</la:option>
						<la:option value="filename.asc">
							<la:message key="labels.search_result_sort_filename_asc" />
						</la:option>
						<la:option value="filename.desc">
							<la:message key="labels.search_result_sort_filename_desc" />
						</la:option>
						<la:option value="created.asc">
							<la:message key="labels.search_result_sort_created_asc" />
						</la:option>

        when:
        inDirectory(projectDir)

        and:
        run "signRuntimeElements"

        then:
        projectDir.file("build/libs/gnupg-signatory-1.0.jar.asc").assertExists()

        cleanup:
        GpgCmdFixture.cleanupGpgCmd(symlink)

        where:
        dsl << ['groovy', 'kotlin']
    }

    @UsesSample('signing/maven-publish')

						</la:option>
						<la:option value="filename.asc">
							<la:message key="labels.search_result_sort_filename_asc" />
						</la:option>
						<la:option value="filename.desc">
							<la:message key="labels.search_result_sort_filename_desc" />
						</la:option>
						<la:option value="created.asc">
							<la:message key="labels.search_result_sort_created_asc" />
						</la:option>

                if (SortOrder.DESC.toString().equalsIgnoreCase(values[1])) {
                    sortOrder = SortOrder.DESC;
                } else if (SortOrder.ASC.toString().equalsIgnoreCase(values[1])) {
                    sortOrder = SortOrder.ASC;
                } else {
                    throw new InvalidQueryException(

            module = norm(tableDataElements.get(0))
            def artifactText = norm(tableDataElements.get(1))
            artifact = artifactText - ' (.asc)'
            hasSignature = artifactText.contains(" (.asc)")
            tableDataElements.get(2).select("p").collect(problems) {
                norm(it)
            }
        }

        String getArtifactTooltip() {

	// first
	sql = DB.ToSQL(func(tx *gorm.DB) *gorm.DB {
		return tx.Model(&User{}).Where(&User{Name: "foo", Age: 20}).Limit(10).Offset(5).Order("name ASC").First(&User{})
	})
	assertEqualSQL(t, `SELECT * FROM "users" WHERE ("users"."name" = 'foo' AND "users"."age" = 20) AND "users"."deleted_at" IS NULL ORDER BY name ASC,"users"."id" LIMIT 1 OFFSET 5`, sql)

	// last and unscoped
	sql = DB.ToSQL(func(tx *gorm.DB) *gorm.DB {

                Set.of(), //
                "{\"timestamp\":{\"order\":\"asc\"}}", //
                buildQuery("sort:timestamp"));
        assertQueryContext(query, Map.of(), //
                Set.of(), //
                "{\"timestamp\":{\"order\":\"asc\"}}", //
                buildQuery("sort:timestamp.asc"));
        assertQueryContext(query, Map.of(), //
                Set.of(), //