数据库相关-Spock
Spock连接数据库
import com.alibaba.fastjson.JSON
import com.google.common.reflect.TypeToken
import com.meituan.mtrace.Tracer
import com.sankuai.solarsystem.aigc.common.util.GsonUtil
import com.sankuai.solarsystem.aigc.domain.assistant.extension.AssistantApplicationService
import com.sankuai.solarsystem.aigc.domain.assistant.model.AssistantAppInfoModel
import com.sankuai.solarsystem.aigc.flow.business.botmigrate.BotManageService
import com.sankuai.solarsystem.aigc.flow.dto.business.botmigrate.BotInfoSyncExecuteRecordDTO
import groovy.sql.Sql
import org.slf4j.Logger
import org.slf4j.LoggerFactory
import org.springframework.boot.test.autoconfigure.web.servlet.AutoConfigureMockMvc
import org.springframework.boot.test.context.SpringBootTest
import org.springframework.test.context.web.WebAppConfiguration
import spock.lang.Requires
import spock.lang.Specification
import spock.lang.Unroll
Sql sql;
def setup() {
def dbUrl = "jdbc:mysql://ip:port/dbName"
def user = "rds_zjj"
def password = "xxxxxx"
def driver = "com.mysql.jdbc.Driver"
sql = Sql.newInstance(dbUrl, user, password, driver)
}
def "数据库查询测试"() {
given: "配置数据库连接"
sql
when: "执行数据库查询"
def result = this.sql.rows('select * from application_scene where id= ?', ['454'])
log.info("result : {}", JSON.toJSONString(result))
then: "验证查询结果"
assert result.size() > 0
cleanup: "关闭数据库连接"
sql.close()
}
从GroovyRowResult中获取查询结果
// 使用GroovyRowResult获取查询结果中的值
def "GroovyRowResult 获取值示例"() {
given: "已经执行了数据库查询,得到了GroovyRowResult列表"
// 假设这是从数据库查询返回的结果列表
List<GroovyRowResult> results = [
[id: 1, name: '张三', age: 30],
[id: 2, name: '李四', age: 25]
]
when: "从GroovyRowResult中获取特定的值"
// 获取第一个结果的name值
def firstName = results[0].name
// 获取第二个结果的age值
def secondAge = results[1].age
then: "验证获取的值是否符合预期"
assert firstName == '张三'
assert secondAge == 25
}