标题翻译
how to assert date time stamp is within 2 minutes?
问题
以下是您要翻译的内容：
我想要添加断言来确保检索到的数据在以下时间范围内：
-
打印数据1
2020-03-16 09:08:49 -
打印数据2
2020-03-16 09:09:15 -
断言数据1和数据2之间的时间间隔不超过2分钟，通过。
我有一些示例代码，这是最佳方法吗？
有什么建议，请评论。
// data1Date data1 = new Date();// data2Date data2 = new Date();// 断言assertThat(data1, DateMatchers.within(2, ChronoUnit.MINUTES, data2 ));
最新脚本：
import static org.assertj.core.api.Assertions.*import java.sql.*import java.text.SimpleDateFormatimport com.kms.katalon.core.webui.keyword.WebUiBuiltInKeywords as WebUIimport internal.GlobalVariable as GlobalVariableimport java.text.ParseExceptionimport java.text.SimpleDateFormatimport java.util.Dateimport com.kms.katalon.core.configuration.RunConfigurationGlobalVariable.TestIssueKey = nullWebUI.delay(1)// SQL 语句dbQuery2 = /SELECT * FROM drugs.sync/// 连接到 PostgresSQL，全局变量存储在配置文件中List results = CustomKeywords.'test.database.getPostgresSQLResults'(GlobalVariable.dbConnString2 , GlobalVariable.dbUsername2 , GlobalVariable.dbPassword2 ,GlobalVariable.dbDriver2 ,dbQuery2 )// SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSS'Z'")SimpleDateFormat sdf = new SimpleDateFormat("yyyy-mm-dd hh:mm:ss", Locale.ENGLISH)String date = sdf.format(new Date())// 打印 "lastupdatedwm6" 列用于 PULLString lastupdatedwm6 = results.get(0).get('lastupdatedwm6')// 将 lastupdatedwm6 存储到文件def lastupdatedwm6aft = new File(RunConfiguration.getProjectDir() + "/Data Files/lastupdatedwm6aft.txt")lastupdatedwm6aft.newWriter().withWriter { it << lastupdatedwm6 }println lastupdatedwm6aft.textWebUI.delay(2)// 在 drugsync Pull 之前读取数据def lastupdatedwm6bef = new File(RunConfiguration.getProjectDir() + "/Data Files/lastupdatedwm6bef.txt")Date data1 = sdf.parse(lastupdatedwm6bef.text);Date data2 = sdf.parse(lastupdatedwm6aft.text);long diffInMillies = Math.abs(data2.getTime() - data1.getTime());long minute_millis_2 = 2 * 60 * 1000;long diffTime = minute_millis_2 - diffInMillies;assertTrue(diffTime > 0);
希望这些翻译对您有所帮助。如果您有任何其他问题，请随时问我。
英文翻译
I want to have assertion to make sure the data retrieved is within
-
print data1
2020-03-16 09:08:49 -
print data2
2020-03-16 09:09:15 -
assertThat time gap between data1 and data2 is not more than 2 minute then Passed.
I have sample codes, is this the best way?
any suggestion, please comment.
//data1Date data1 = new Date();//data2Date data2 = new Date();//assertassertThat(data1, DateMatchers.within(2, ChronoUnit.MINUTES, data2 ));
latest script
<!-- begin snippet: js hide: false console: true babel: false -->
<!-- language: lang-html -->
import static org.assertj.core.api.Assertions.*import java.sql.*import java.text.SimpleDateFormatimport com.kms.katalon.core.webui.keyword.WebUiBuiltInKeywords as WebUIimport internal.GlobalVariable as GlobalVariableimport java.text.ParseExceptionimport java.text.SimpleDateFormatimport java.util.Dateimport com.kms.katalon.core.configuration.RunConfigurationGlobalVariable.TestIssueKey = nullWebUI.delay(1)//SQL statementdbQuery2 = /SELECT * FROM drugs.sync///Connect to PostgresSQL, global variable is stored at profileList results = CustomKeywords.'test.database.getPostgresSQLResults'(GlobalVariable.dbConnString2 , GlobalVariable.dbUsername2 , GlobalVariable.dbPassword2 ,GlobalVariable.dbDriver2 ,dbQuery2 )//SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSS'Z'")SimpleDateFormat sdf = new SimpleDateFormat("yyyy-mm-dd hh:mm:ss", Locale.ENGLISH)String date = sdf.format(new Date())//print the "lastupdatedwm6" column for PULLString lastupdatedwm6 = results.get(0).get('lastupdatedwm6')//store the lastupdatedwm6 to filedef lastupdatedwm6aft = new File(RunConfiguration.getProjectDir() + "/Data Files/lastupdatedwm6aft.txt")lastupdatedwm6aft.newWriter().withWriter { it << lastupdatedwm6 }println lastupdatedwm6aft.textWebUI.delay(2)//Read data before drugsync Pulldef lastupdatedwm6bef = new File(RunConfiguration.getProjectDir() + "/Data Files/lastupdatedwm6bef.txt")Date data1 = sdf.parse(lastupdatedwm6bef.text);Date data2 = sdf.parse(lastupdatedwm6aft.text);long diffInMillies = Math.abs(data2.getTime() - data1.getTime());long minute_millis_2 = 2 * 60 * 1000;long diffTime = minute_millis_2 - diffInMillies;assertTrue(diffTime > 0);
<!-- end snippet -->
答案1
得分: 0
@Testpublic void test() throws ParseException {SimpleDateFormat sdf = new SimpleDateFormat("yyyy-mm-dd hh:mm:ss", Locale.ENGLISH);Date data1 = sdf.parse("2020-03-16 09:08:49");Date data2 = sdf.parse("2020-03-16 09:09:49");long diffInMillies = Math.abs(data2.getTime() - data1.getTime());long minute_millis_2 = 2 * 60 * 1000;long diffTime = minute_millis_2 - diffInMillies;assertTrue(diffTime > 0);}
英文翻译
@Testpublic void test() throws ParseException {SimpleDateFormat sdf = new SimpleDateFormat("yyyy-mm-dd hh:mm:ss", Locale.ENGLISH);Date data1 = sdf.parse("2020-03-16 09:08:49");Date data2 = sdf.parse("2020-03-16 09:09:49");long diffInMillies = Math.abs(data2.getTime() - data1.getTime());long minute_millis_2 = 2 * 60 * 1000;long diffTime = minute_millis_2 - diffInMillies;assertTrue(diffTime > 0);}
答案2
得分: 0
另一种方法是使用超时。
// 如果测试时间超过1000毫秒，这个测试将会失败@Test(timeout=1000)public void test() {objectToTest.methodThatTakesALongTime();}
英文翻译
Another approach is to use timeout.
// This will fail if the test takes more than 1000 milliseconds@Test(timeout=1000)public void test() {objectToTest.methodThatTakesALongTime();}
专注分享java语言的经验与见解，让所有开发者获益！
评论