38 lines
3.4 KiB
Properties
38 lines
3.4 KiB
Properties
camel.karavan.projectId=camel-jdbc-yml
|
|
camel.karavan.projectName=camel-jdbc-yml
|
|
camel.jbang.gav=org.camel.karavan.demo:cameljdbcyml:1
|
|
camel.jbang.runtime=camel-main
|
|
camel.jbang.version=4.10.0
|
|
camel.jbang.dependencies=camel-console,camel-platform-http-main
|
|
camel.jbang.jib-maven-plugin-version=3.4.4
|
|
camel.server.enabled=true
|
|
camel.server.healthCheckEnabled=true
|
|
camel.server.devConsoleEnabled=true
|
|
camel.main.name=camel-jdbc-yml
|
|
camel.main.tracingStandby=true
|
|
camel.trace.enabled=true
|
|
camel.main.autoConfigurationFailFast=false
|
|
camel.routecontroller.superviseEnabled=true
|
|
camel.routecontroller.backoffDelay=5000
|
|
camel.routecontroller.backoffMaxAttempts=100
|
|
camel.routecontroller.initialDelay=1000
|
|
camel.routecontroller.threadPoolSize=3
|
|
camel.context.dev-console=true
|
|
camel.health.enabled=true
|
|
camel.health.exposure-level=full
|
|
jkube.version=1.18.0
|
|
jib.from.image=gcr.io/distroless/java17@sha256:68e2373f7bef9486c08356bd9ffd3b40b56e6b9316c5f6885eb58b1d9093b43d
|
|
|
|
# SQL查询配置
|
|
sqlQueries.getAllUsers=SELECT id, username, email, full_name, phone, create_time, update_time, active FROM users ORDER BY id
|
|
sqlQueries.getUserById=SELECT id, username, email, full_name, phone, create_time, update_time, active FROM users WHERE id = :?id
|
|
sqlQueries.getUserByUsername=SELECT id, username, email, full_name, phone, create_time, update_time, active FROM users WHERE username = :?username
|
|
sqlQueries.getUsersPaged=SELECT id, username, email, full_name, phone, create_time, update_time, active FROM users ORDER BY id LIMIT :?limit OFFSET :?offset
|
|
sqlQueries.countUsers=SELECT COUNT(*) as total FROM users
|
|
|
|
# 高级分页查询SQL
|
|
sqlQueries.getUsersAdvanced=SELECT id, username, email, full_name, phone, create_time, update_time, active FROM users WHERE 1=1 #{if}(:?username != '') AND username LIKE '%' || :?username || '%'#{end} #{if}(:?email != '') AND email LIKE '%' || :?email || '%'#{end} #{if}(:?phone != '') AND phone LIKE '%' || :?phone || '%'#{end} #{if}(:?active != null) AND active = :?active#{end} #{if}(:?fromDate != '') AND create_time >= TO_TIMESTAMP(:?fromDate, 'YYYY-MM-DD')#{end} #{if}(:?toDate != '') AND create_time <= TO_TIMESTAMP(:?toDate, 'YYYY-MM-DD') + INTERVAL '1 day'#{end} ORDER BY #{if}(:?sortField = 'username') username#{end} #{if}(:?sortField = 'email') email#{end} #{if}(:?sortField = 'createTime') create_time#{end} #{if}(:?sortField = '') id#{end} #{if}(:?sortOrder = 'ASC') ASC #{else} DESC#{end} LIMIT :?limit OFFSET :?offset
|
|
sqlQueries.countUsersAdvanced=SELECT COUNT(*) as total FROM users WHERE 1=1 #{if}(:?username != '') AND username LIKE '%' || :?username || '%'#{end} #{if}(:?email != '') AND email LIKE '%' || :?email || '%'#{end} #{if}(:?phone != '') AND phone LIKE '%' || :?phone || '%'#{end} #{if}(:?active != null) AND active = :?active#{end} #{if}(:?fromDate != '') AND create_time >= TO_TIMESTAMP(:?fromDate, 'YYYY-MM-DD')#{end} #{if}(:?toDate != '') AND create_time <= TO_TIMESTAMP(:?toDate, 'YYYY-MM-DD') + INTERVAL '1 day'#{end}
|
|
sqlQueries.createUser=INSERT INTO users (username, email, password, full_name, phone, active, create_time, update_time) VALUES (:?username, :?email, :?password, :?fullName, :?phone, :?active, NOW(), NOW()) RETURNING id
|
|
sqlQueries.updateUser=UPDATE users SET username = :?username, email = :?email, password = CASE WHEN :?password = '' THEN password ELSE :?password END, full_name = :?fullName, phone = :?phone, active = :?active, update_time = NOW() WHERE id = :?id
|
|
sqlQueries.deleteUser=DELETE FROM users WHERE id = :?id |