BrickCoreTest/database-demo-patch.sql at master · banzhuan-Ke/BrickCoreTest · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
# 补导入演示数据（已导入过旧版 database.sql 且在第 6 行报错时使用）
# 用法: docker exec -i fastapi_mysql mysql --default-character-set=utf8mb4 -uadmin -pBrickCore123456 fastapi < database-demo-patch.sql
INSERT IGNORE INTO `test_catalog` (`id`, `name`, `project_id`, `parent_id`, `sort`, `description`, `username`, `is_del`, `create_time`, `update_time`) VALUES (1, 'BrickCore', 1, NULL, 0, NULL, 'admin', 0, '2024-09-11 06:49:18.262924', '2024-09-11 06:49:18.262924');
INSERT IGNORE INTO `case` (`id`, `name`, `create_time`, `steps`, `username`, `project_id`, `level`, `catalog_id`) VALUES (1, 'BrickCore', '2025-04-11 14:10:31.236836', '[{\"id\": 1744380635262, \"desc\": \"打开浏览器\", \"method\": \"open_browser\", \"params\": {\"browser_type\": \"chromium\"}, \"keyword\": \"打开浏览器\"}, {\"id\": 1744380638937, \"desc\": \"访问小说\", \"method\": \"open_url\", \"params\": {\"url\": \"/user/login.html\", \"timeout\": 30000, \"wait_until\": \"load\"}, \"keyword\": \"访问页面url\"}, {\"id\": 1744380677755, \"desc\": \"帐号输入\", \"method\": \"fill_value\", \"params\": {\"value\": \"18326074762\", \"locator\": \"//*[@id=\\\"txtUName\\\"]\", \"timeout\": 20000}, \"keyword\": \"元素输入\"}, {\"id\": 1744380723977, \"desc\": \"密码输入\", \"method\": \"fill_value\", \"params\": {\"value\": \"${{password}}\", \"locator\": \"//*[@id=\\\"txtPassword\\\"]\", \"timeout\": 20000}, \"keyword\": \"元素输入\"}, {\"id\": 1744380999018, \"desc\": \"点击登录\", \"method\": \"click_ele\", \"params\": {\"count\": 1, \"button\": \"left\", \"locator\": \"//*[@id=\\\"btnLogin\\\"]\", \"timeout\": 20000}, \"keyword\": \"点击元素\"}, {\"id\": 1744381033288, \"desc\": \"强制等待时间\", \"method\": \"wait_for_time\", \"params\": {\"timeout\": 4000}, \"keyword\": \"强制等待时间\"}, {\"id\": 1744381040783, \"desc\": \"断言页面标题\", \"method\": \"assert_page_title\", \"params\": {\"is_equal\": \"true\", \"expect_results\": \"读书屋_原创小说网站\"}, \"keyword\": \"断言页面标题\"}, {\"id\": 1745392400509, \"desc\": \"点击元素\", \"method\": \"click_ele\", \"params\": {\"count\": 1, \"button\": \"left\", \"locator\": \"//*[@id=\\\"navModule\\\"]/li[5]/a\", \"timeout\": 20000}, \"keyword\": \"点击元素\"}, {\"id\": 1745393086279, \"desc\": \"强制等待时间\", \"method\": \"wait_for_time\", \"params\": {\"timeout\": 4000}, \"keyword\": \"强制等待时间\"}, {\"id\": 1745392520917, \"desc\": \"切换页面\", \"method\": \"switch_to_page\", \"params\": {\"tag\": \"\", \"url\": \"\", \"index\": \"1\", \"title\": \"\"}, \"keyword\": \"切换页面\"}, {\"id\": 1745392182538, \"desc\": \"关闭页面\", \"method\": \"close_page\", \"params\": {\"tag\": \"\", \"url\": \"\", \"index\": \"0\", \"title\": \"\"}, \"keyword\": \"关闭页面\"}]', 'admin', 1, 'P2', 1);
INSERT IGNORE INTO `suite` (`id`, `name`, `create_time`, `pre_actions`, `suite_type`, `catalog_id`, `project_id`, `username`) VALUES (1, 'BrickCore', '2024-09-13 01:36:13.945627', '[]', '1', 1, 1, 'admin');
INSERT IGNORE INTO `step` (`id`, `sort`, `skip`, `cases_id`, `suite_id`) VALUES (1, 0, 0, 1, 1);
INSERT IGNORE INTO `task` (`id`, `name`, `create_time`, `project_id`, `username`) VALUES (1, 'BrickCore', '2024-09-13 01:37:56.593898', 1, 'admin');
INSERT IGNORE INTO `task_suite` (`task_id`, `suite_id`) VALUES (1, 1);
INSERT IGNORE INTO `project` (`id`, `name`, `create_time`, `user_id`, `username`) VALUES (2, 'BrickCore', '2024-09-11 04:56:35.453287', 1, 'admin');
INSERT IGNORE INTO `environment` (`id`, `name`, `create_time`, `host`, `global_vars`, `username`, `project_id`) VALUES (2, 'BrickCore', '2024-09-11 06:48:43.295441', 'https://www.ketangpai.com/', '{\"password\": \"8142354py\"}', 'admin', 2);
INSERT IGNORE INTO `test_catalog` (`id`, `name`, `project_id`, `parent_id`, `sort`, `description`, `username`, `is_del`, `create_time`, `update_time`) VALUES (2, 'BrickCore', 2, NULL, 0, NULL, 'admin', 0, '2024-09-11 06:49:18.262924', '2024-09-11 06:49:18.262924');
INSERT IGNORE INTO `case` (`id`, `name`, `create_time`, `steps`, `username`, `project_id`, `level`, `catalog_id`) VALUES (2, 'BrickCore', '2025-05-22 08:00:27.906734', '[{\"desc\": \"打开浏览器\", \"params\": {\"browser_type\": \"chromium\"}, \"keyword\": \"打开浏览器\"}, {\"id\": 1747900571114, \"desc\": \"访问页面url\", \"method\": \"open_url\", \"params\": {\"url\": \"/#/login\", \"timeout\": 30000, \"wait_until\": \"load\"}, \"keyword\": \"访问页面url\"}, {\"id\": 1747900614969, \"desc\": \"默认等待时间\", \"method\": \"set_default_timeout\", \"params\": {\"timeout\": 20000}, \"keyword\": \"默认等待时间\"}, {\"id\": 1747900623297, \"desc\": \"输入账号\", \"method\": \"fill_value\", \"params\": {\"value\": \"18326074762\", \"locator\": \"//input[@placeholder=\\\"请输入邮箱/手机号/账号\\\"]\", \"timeout\": 20000}, \"keyword\": \"元素输入\"}, {\"id\": 1747900655473, \"desc\": \"输入密码\", \"method\": \"fill_value\", \"params\": {\"value\": \"${{password}}\", \"locator\": \"//input[@placeholder=\\\"请输入密码\\\"]\", \"timeout\": 20000}, \"keyword\": \"元素输入\"}, {\"id\": 1747900682849, \"desc\": \"点击登录\", \"method\": \"click_ele\", \"params\": {\"count\": 1, \"button\": \"left\", \"locator\": \"//div[@class=\\\"margin-top\\\"]/button\", \"timeout\": 20000}, \"keyword\": \"点击元素\"}, {\"id\": 1747900701379, \"desc\": \"强制等待时间\", \"method\": \"wait_for_time\", \"params\": {\"timeout\": 2000}, \"keyword\": \"强制等待时间\"}, {\"id\": 1747900798819, \"desc\": \"断言名称\", \"method\": \"except_to_have_text\", \"params\": {\"locator\": \"//*[@id=\\\"app\\\"]/div[2]/div[1]/div/span\", \"is_equal\": \"true\", \"expect_results\": \"py\"}, \"keyword\": \"断言元素文本值\"}]', 'admin', 2, 'P2', 2);
INSERT IGNORE INTO `suite` (`id`, `name`, `create_time`, `pre_actions`, `suite_type`, `catalog_id`, `project_id`, `username`) VALUES (2, 'BrickCore', '2024-09-13 01:36:13.945627', '[]', '2', 2, 2, 'admin');
INSERT IGNORE INTO `step` (`id`, `sort`, `skip`, `cases_id`, `suite_id`) VALUES (2, 0, 0, 2, 2);
INSERT IGNORE INTO `task` (`id`, `name`, `create_time`, `project_id`, `username`) VALUES (2, 'BrickCore', '2024-09-13 01:37:56.593898', 2, 'admin');
INSERT IGNORE INTO `task_suite` (`task_id`, `suite_id`) VALUES (2, 2);