• Home
  • Features
  • Pricing
  • Docs
  • Announcements
  • Sign In

torand / FasterSQL / 13367709795

17 Feb 2025 10:06AM UTC coverage: 58.785% (+2.0%) from 56.762%
13367709795

push

github

torand
feat: support length function

148 of 338 branches covered (43.79%)

Branch coverage included in aggregate %.

10 of 17 new or added lines in 7 files covered. (58.82%)

66 existing lines in 9 files now uncovered.

829 of 1324 relevant lines covered (62.61%)

3.33 hits per line

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

0.0
/src/main/java/io/github/torand/fastersql/dialect/PostgreSqlDialect.java
1
/*
2
 * Copyright (c) 2024 Tore Eide Andersen
3
 *
4
 * Licensed under the Apache License, Version 2.0 (the "License");
5
 * you may not use this file except in compliance with the License.
6
 * You may obtain a copy of the License at
7
 *
8
 *      http://www.apache.org/licenses/LICENSE-2.0
9
 *
10
 * Unless required by applicable law or agreed to in writing, software
11
 * distributed under the License is distributed on an "AS IS" BASIS,
12
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13
 * See the License for the specific language governing permissions and
14
 * limitations under the License.
15
 */
16
package io.github.torand.fastersql.dialect;
17

18
import java.util.EnumSet;
19
import java.util.List;
20
import java.util.Optional;
21

22
import static io.github.torand.fastersql.dialect.Capability.CONCAT_OPERATOR;
23
import static io.github.torand.fastersql.dialect.Capability.LIMIT_OFFSET;
24
import static io.github.torand.fastersql.util.lang.StringHelper.generate;
25

UNCOV
26
public class PostgreSqlDialect implements Dialect {
×
UNCOV
27
    private static final EnumSet<Capability> SUPPORTED_CAPS = EnumSet.of(LIMIT_OFFSET, CONCAT_OPERATOR);
×
28

29
    @Override
30
    public String getProductName() {
UNCOV
31
        return "PostgreSQL";
×
32
    }
33

34
    @Override
35
    public Optional<String> formatRowOffsetClause() {
UNCOV
36
        return Optional.of("offset ?");
×
37
    }
38

39
    @Override
40
    public Optional<String> formatRowLimitClause() {
UNCOV
41
        return Optional.of("limit ?");
×
42
    }
43

44
    @Override
45
    public Optional<String> formatRowNumLiteral() {
UNCOV
46
        return Optional.empty();
×
47
    }
48

49
    @Override
50
    public String formatToNumberFunction(String operand, int precision, int scale) {
51
        StringBuilder mask = new StringBuilder();
×
UNCOV
52
        if (precision-scale > 0) {
×
53
            mask.append(generate("9", precision-scale));
×
54
        }
UNCOV
55
        if (scale > 0) {
×
UNCOV
56
            mask.append(".").append(generate("9", scale));
×
57
        }
58

UNCOV
59
        return "to_number(" + operand + ", '" + mask + "')";
×
60
    }
61

62
    @Override
63
    public String formatSubstringFunction(String operand, int startPos, int length) {
UNCOV
64
        return "substring(" + operand + ", " + startPos + ", " + length + ")";
×
65
    }
66

67
    @Override
68
    public String formatConcatFunction(List<String> operands) {
UNCOV
69
        throw new UnsupportedOperationException("Use the concat infix operator for PostgreSql");
×
70
    }
71

72
    @Override
73
    public String formatLengthFunction(String operand) {
NEW
74
        return "char_length(" + operand + ")";
×
75
    }
76

77
    @Override
78
    public boolean supports(Capability capability) {
UNCOV
79
        return SUPPORTED_CAPS.contains(capability);
×
80
    }
81
}
STATUS · Troubleshooting · Open an Issue · Sales · Support · CAREERS · ENTERPRISE · START FREE · SCHEDULE DEMO
ANNOUNCEMENTS · TWITTER · TOS & SLA · Supported CI Services · What's a CI service? · Automated Testing

© 2026 Coveralls, Inc