Library DatabaseLibrary
Library SSHLibrary
1.密码直连(sql server举例,mysql同理)
Connect To Database Using Custom Params pyodbc "DRIVER={SQL Server};SERVER=101.37.***.***,1433;DATABASE=catfish;UID=***;PWD=Vy7TCnNu5cyF-FJa"
${id} query SELECT TOP 1 Id FROM SellerCommissionObjects WHERE SellerId='12044612-FF27-4FEB-824E-97C9E3F2BFCF' ORDER BY StartTime DESC
log ${id[0]}
${idd} Set Variable ${id[0]}
log ${idd[0]}
1)DRIVER:何种数据库;
SERVER:ip地址
DATABASE:数据库的名字
UID:登录账号名
PWD:密码
query:用来执行后面的SQL语句的,然后搜索出来的赋值给${id}
注意:搜索出来的结果已二维数组形式返回,所以取${id[0][0]},如下所示:
${id} = [(u'BCEADC59-692B-465