13591799490

Committed 28 Feb 2025 03:59PM UTC coverage: 65.237% (-1.3%) from 66.563%

Build # 13591799490

Build Type

push

github

Committed by

web-flow

Commit Message

Merge pull request #14 from torand/having-support

feat: supporting the HAVING clause + IS NULL operator now supports an…

Run Details

214 of 408 branches covered (52.45%)

Branch coverage included in aggregate %.

273 of 389 new or added lines in 69 files covered. (70.18%)

3 existing lines in 3 files now uncovered.

1079 of 1574 relevant lines covered (68.55%)

3.68 hits per line

Source File
Press 'n' to go to next uncovered line, 'b' for previous

78.79

/src/main/java/io/github/torand/fastersql/expression/arithmetic/Modulo.java

package io.github.torand.fastersql.expression.arithmetic;

import io.github.torand.fastersql.Column;
import io.github.torand.fastersql.Context;
import io.github.torand.fastersql.alias.ColumnAlias;
import io.github.torand.fastersql.expression.Expression;
import io.github.torand.fastersql.order.OrderExpression;
import io.github.torand.fastersql.projection.Projection;

import java.util.Optional;
import java.util.stream.Stream;

import static io.github.torand.fastersql.dialect.Capability.MODULO_OPERATOR;
import static io.github.torand.fastersql.util.contract.Requires.requireNonBlank;
import static io.github.torand.fastersql.util.lang.StringHelper.nonBlank;
import static java.util.Objects.requireNonNull;

public class Modulo implements Expression, OrderExpression {
    private final Expression left;
    private final Expression right;
    private final ColumnAlias alias;

    Modulo(Expression left, Expression right, String alias) {
        this.left = requireNonNull(left, "No left operand specified");
        this.right = requireNonNull(right, "No right operand specified");
        this.alias = nonBlank(alias) ? new ColumnAlias(alias) : defaultAlias();
    }

    // Sql

    @Override
    public String sql(Context context) {
        if (context.getDialect().supports(MODULO_OPERATOR)) {
            String leftSql = left.sql(context);
            if (left instanceof Addition || left instanceof Subtraction) {
                leftSql = "(" + leftSql + ")";
            }

            String rightSql = right.sql(context);
            if (right instanceof Addition || right instanceof Subtraction) {
                rightSql = "(" + rightSql + ")";
            }

            return leftSql + " % " + rightSql;
        }

        return context.getDialect().formatModuloFunction(left.sql(context), right.sql(context));
    }

    @Override
    public Stream<Object> params(Context context) {
        return Stream.concat(left.params(context), right.params(context));
    }

    @Override
    public Stream<Column> columnRefs() {
        return Stream.concat(left.columnRefs(), right.columnRefs());
    }

    @Override
    public Stream<ColumnAlias> aliasRefs() {
        return Stream.concat(left.aliasRefs(), right.aliasRefs());
    }

    // Projection

    @Override
    public Projection as(String alias) {
        requireNonBlank(alias, "No alias specified");
        return new Modulo(left, right, alias);
    }

    @Override
    public Optional<ColumnAlias> alias() {
        return Optional.ofNullable(alias);
    }

    private ColumnAlias defaultAlias() {
        return ColumnAlias.generate("MODULO_");
    }
}

1	package io.github.torand.fastersql.expression.arithmetic;
2
3	import io.github.torand.fastersql.Column;
4	import io.github.torand.fastersql.Context;
5	import io.github.torand.fastersql.alias.ColumnAlias;
6	import io.github.torand.fastersql.expression.Expression;
7	import io.github.torand.fastersql.order.OrderExpression;
8	import io.github.torand.fastersql.projection.Projection;
9
10	import java.util.Optional;
11	import java.util.stream.Stream;
12
13	import static io.github.torand.fastersql.dialect.Capability.MODULO_OPERATOR;
14	import static io.github.torand.fastersql.util.contract.Requires.requireNonBlank;
15	import static io.github.torand.fastersql.util.lang.StringHelper.nonBlank;
16	import static java.util.Objects.requireNonNull;
17
18	public class Modulo implements Expression, OrderExpression {
19	private final Expression left;
20	private final Expression right;
21	private final ColumnAlias alias;
22
23	Modulo(Expression left, Expression right, String alias) {	2✔
24	this.left = requireNonNull(left, "No left operand specified");	6✔
25	this.right = requireNonNull(right, "No right operand specified");	6✔
26	this.alias = nonBlank(alias) ? new ColumnAlias(alias) : defaultAlias();	12✔
27	}	1✔
28
29	// Sql
30
31	@Override
32	public String sql(Context context) {
33	if (context.getDialect().supports(MODULO_OPERATOR)) {	5✔
34	String leftSql = left.sql(context);	5✔
35	if (left instanceof Addition \|\| left instanceof Subtraction) {	8!
36	leftSql = "(" + leftSql + ")";	×
37	}
38
39	String rightSql = right.sql(context);	5✔
40	if (right instanceof Addition \|\| right instanceof Subtraction) {	8!
41	rightSql = "(" + rightSql + ")";	×
42	}
43
44	return leftSql + " % " + rightSql;	4✔
45	}
46
47	return context.getDialect().formatModuloFunction(left.sql(context), right.sql(context));	12✔
48	}
49
50	@Override
51	public Stream<Object> params(Context context) {
52	return Stream.concat(left.params(context), right.params(context));	10✔
53	}
54
55	@Override
56	public Stream<Column> columnRefs() {
57	return Stream.concat(left.columnRefs(), right.columnRefs());	8✔
58	}
59
60	@Override
61	public Stream<ColumnAlias> aliasRefs() {
NEW 62	return Stream.concat(left.aliasRefs(), right.aliasRefs());	×
63	}
64
65	// Projection
66
67	@Override
68	public Projection as(String alias) {
69	requireNonBlank(alias, "No alias specified");	6✔
70	return new Modulo(left, right, alias);	9✔
71	}
72
73	@Override
74	public Optional<ColumnAlias> alias() {
75	return Optional.ofNullable(alias);	4✔
76	}
77
78	private ColumnAlias defaultAlias() {
79	return ColumnAlias.generate("MODULO_");	3✔
80	}
81	}

torand / FasterSQL / 13591799490

Source File Press 'n' to go to next uncovered line, 'b' for previous

Source File
Press 'n' to go to next uncovered line, 'b' for previous