x-ream/sqli

orm sql query builder, API: QB, QB.X, QrB

sqli's Issues

Builder add bool api

SourceScriptBuilder.checkSourceAndAlia throw ParsingException

Add can not null assert to In API

SORT shoud not contain SPACE

ClickhouseDialect mark final class

Maybe there will be no a database dialect extends ClickhouseDialect

Automatic Completion Plugin of IDEA

1. It's easy to make mistakes when code class name or property name
2. Code method name, or property name for Java reflection, IDEA can automatic complete the code
3. Other ways, like code generation, helper class, lambda.... maybe not good resolution

Add ignoreTotalRows(boolean ignored)

Add "LIMIT 1" to select by pk

Remove SQL Injection Filter of NativeRepository

Developer knows the SQL Injection while coding native SQL.
The native api: execute(sql)

Issues and pull requests

1 issue description
2. fix bug, enhance....
3. git commit -m "issue name (#issue number)"

use Jackson instead of Fastjson

Add LIMIT to DELETE or UPDATE

SQLI only support delete by PK, and safe update by PK, consider it, add LIMIT

ResultMapCriteria one table unworkable

CriteriaBuilder.ResultMapBuilder builder = CriteriaBuilder.resultMapBuilder();
builder.resultKey("id");
builder.resultKey("name");
builder.eq("id", 1);
Criteria criteria = builder.build();// OK

Criteria.ResultMapCriteria criteria = builder.build();// unworkable
if add code: builder.sourceBuilder().source("foo"); //unworkable

Anyway, CriteriaBuilder.ResultMapBuilder should get Criteria.ResultMapCriteria

ResultMapBuilder designed for JOIN, and should support one table.

Add schema to create table

Mismatched type of property and db field, throw exception

Remove MySQL forceIndex dialect

SourceScriptBuilder IllegalArgumentException is unreasonable

use CriteriaSyntaxException

Add builder api resultKeys(String... keys)

comment out the pugin of "maven-gpg-plugin"

                        <plugin>
			<groupId>org.apache.maven.plugins</groupId>
			<artifactId>maven-gpg-plugin</artifactId>
			<version>1.6</version>
			<executions>
				<execution>
					<id>sign-artifacts</id>
					<phase>verify</phase>
					<goals>
						<goal>sign</goal>
					</goals>
				</execution>
			</executions>
		</plugin>

查询指定字段时响应的数据封装成对象

查询数据库单表指定的某几个字段时，希望能把响应的结果List<Map<String, Object>>封装成List

LocalDateTime support

sql出错提示不友好

用一个CriteriaBuilder.ResultMapBuilder查询的时候，如果参数是list，in函数写成eq，报错不友好

Add sql exportor for test

SqlExportor.exportor().source(Cat.class).build("testSub",resultMapCriteria).export("CriterialToSqlTester");

optimize parameters

DaoHelper Rename As SqlBuilder

DaoHelper can not describe the logical, it is SqlBuilder

Add method builder.sourceScript(sql, Object...vs);

Wrap RuntimeException Interceptor

if (e instance of RuntimeException){
throw （RuntimeException) e;
}

Add TDengine Dialect

@X.Tag
@X.Tag{ boolean isKey() default false; }

CriteriaToSql.toSql(condition...) rename as toConditionSql

It is not override method, the method only generate part of sql, "where ...."

DataObjectConverter throw ParsingException

contains(".")
throw ParsingException

add Criteria clzz assert to DefaultRepository

handle SQLIntegrityConstraintViolationException, Column cannot be null

throw new SqliRumtimeException

It is bug to comment out ignore of SqlNormalizer (#19）

boolean ignore = false;

....
Not test? @chengyunyong

Remove BigDecimal default value 0 while insert

ParserUtil, add ParsingException if CriteriaBuilder.builder(Class) key contains ‘.’

ParserUtil.getClzName(alia, aliaMap)

Add Dialect Customizer

Customizer should be call at SqliListener

Support MySQL8: WITH cte AS

Add API: resultMapBuilder.sourceBuilder().with(Sub).alia(name);
like resultMapBuilder.sourceBuilder().sub(Sub).alia(name);

readme 增加特别提醒: Retry和Fallback的正确姿势

特别提醒
Retry和Fallback的正确姿势: add retry at controller, or remote client
不能在代码的service和repository层加retry, 和fallback
在不适合或没必要用分布式框架(seata, x-ream/reliable)的情况下, 做fallback的时候, 需要小心

Amend annotation X.Tag(isKey=true)

X.Tag(isKey = true) should be X.TagTarget

Repository debug no log

FooRepository extends BaseRepository, ResultMapRepository,

invoke find(resultMapCriteria), debug no log

Add API: builder.paged().last(long last)

last(long last):
if last != 0
where orderBy > last ... LIMIT ... (ASC)
where orderBy < last ... LIMIT ... (DESC)
else
OFFSET ...

Add Enum Serializer & Deserializer

EnumSerializer
EnumDeserializer

需要增加一个是否存在的查询API：exists

select count(1) from table where name = ? limit 1

Add builder API: InRequired

something wrong with SqlNormalizer

test: userId>=((((((id*10))))+@xxx-1))
expected: user_id >= (((((( id * 10 )))) + @xxx - 1 ))
not got the result

in把能拼接""

"error": "StatementCallback; bad SQL grammar [SELECT * FROM Equipment WHERE ( barCode IN ( 'lb1649400074854' ) OR RFID IN ( ) OR nfc IN ( ) OR recorderCode IN ( ) )]; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') OR nfc IN ( ) OR recorderCode IN ( ) )' at line 1",

Avoid unused imports

Sometimes forgot

Other db dialect, can not execute create table sql (#2)

if (dialect.getKey().contains("mysql") && SqliStringUtil.isNotNull(createSql)) {
nativeSupport.execute(clz, createSql);
}

X.Tag isKey() (#24)

@X.Tag { boolean isKey() default false; }

JsonUtil e

throw e