Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitf58bea0

Browse files
authored
Improved tasks 577, 585
1 parent0f21931 commitf58bea0

File tree

2 files changed

+33
-33
lines changed

2 files changed

+33
-33
lines changed

‎src/test/java/g0501_0600/s0577_employee_bonus/MysqlTest.ktrenamed to‎src/test/java/g0501_0600/s0577_employee_bonus/MysqlTest.java

Lines changed: 19 additions & 19 deletions
Original file line numberDiff line numberDiff line change
@@ -20,25 +20,25 @@
2020
@EmbeddedDatabaseTest(
2121
compatibilityMode =CompatibilityMode.MySQL,
2222
initialSqls =
23-
"CREATE TABLE Employee(empId INTEGER PRIMARY KEY, name VARCHAR(512)"
24-
+", supervisor INTEGER, salary INTEGER);"
25-
+"INSERT INTO Employee(empId, name"
26-
+", supervisor, salary)"
27-
+" VALUES (3, 'Brad', NULL, 4000);"
28-
+"INSERT INTO Employee(empId, name"
29-
+", supervisor, salary)"
30-
+" VALUES (1, 'John', 3, 1000);"
31-
+"INSERT INTO Employee(empId, name"
32-
+", supervisor, salary)"
33-
+" VALUES (2, 'Dan', 3, 2000);"
34-
+"INSERT INTO Employee(empId, name"
35-
+", supervisor, salary)"
36-
+" VALUES (4, 'Thomas', 3, 4000);"
37-
+"CREATE TABLE Bonus(empId INTEGER, bonus INTEGER);"
38-
+"INSERT INTO Bonus(empId, bonus)"
39-
+" VALUES (2, 500);"
40-
+"INSERT INTO Bonus(empId, bonus)"
41-
+" VALUES (4, 2000);")
23+
"CREATE TABLE Employee(empId INTEGER PRIMARY KEY, name VARCHAR(512)"
24+
+", supervisor INTEGER, salary INTEGER); "
25+
+"INSERT INTO Employee(empId, name"
26+
+", supervisor, salary)"
27+
+" VALUES (3, 'Brad', NULL, 4000); "
28+
+"INSERT INTO Employee(empId, name"
29+
+", supervisor, salary)"
30+
+" VALUES (1, 'John', 3, 1000); "
31+
+"INSERT INTO Employee(empId, name"
32+
+", supervisor, salary)"
33+
+" VALUES (2, 'Dan', 3, 2000); "
34+
+"INSERT INTO Employee(empId, name"
35+
+", supervisor, salary)"
36+
+" VALUES (4, 'Thomas', 3, 4000); "
37+
+"CREATE TABLE Bonus(empId INTEGER, bonus INTEGER); "
38+
+"INSERT INTO Bonus(empId, bonus)"
39+
+" VALUES (2, 500); "
40+
+"INSERT INTO Bonus(empId, bonus)"
41+
+" VALUES (4, 2000); ")
4242
classMysqlTest {
4343
@Test
4444
voidtestScript(@EmbeddedDatabaseDataSourcedataSource)

‎src/test/java/g0501_0600/s0585_investments_in_2016/MysqlTest.ktrenamed to‎src/test/java/g0501_0600/s0585_investments_in_2016/MysqlTest.java

Lines changed: 14 additions & 14 deletions
Original file line numberDiff line numberDiff line change
@@ -20,20 +20,20 @@
2020
@EmbeddedDatabaseTest(
2121
compatibilityMode =CompatibilityMode.MySQL,
2222
initialSqls =
23-
"CREATE TABLE Insurance(pid INTEGER, tiv_2015 DECIMAL, tiv_2016 DECIMAL"
24-
+", lat DECIMAL, lon DECIMAL);"
25-
+"INSERT INTO Insurance(pid, tiv_2015, tiv_2016"
26-
+", lat, lon)"
27-
+" VALUES (1, 10, 5, 10, 10);"
28-
+"INSERT INTO Insurance(pid, tiv_2015, tiv_2016"
29-
+", lat, lon)"
30-
+" VALUES (2, 20, 20, 20, 20);"
31-
+"INSERT INTO Insurance(pid, tiv_2015, tiv_2016"
32-
+", lat, lon)"
33-
+" VALUES (3, 10, 30, 20, 20);"
34-
+"INSERT INTO Insurance(pid, tiv_2015, tiv_2016"
35-
+", lat, lon)"
36-
+" VALUES (4, 10, 40, 40, 40);")
23+
"CREATE TABLE Insurance(pid INTEGER, tiv_2015 DECIMAL, tiv_2016 DECIMAL"
24+
+", lat DECIMAL, lon DECIMAL); "
25+
+"INSERT INTO Insurance(pid, tiv_2015, tiv_2016"
26+
+", lat, lon)"
27+
+" VALUES (1, 10, 5, 10, 10); "
28+
+"INSERT INTO Insurance(pid, tiv_2015, tiv_2016"
29+
+", lat, lon)"
30+
+" VALUES (2, 20, 20, 20, 20); "
31+
+"INSERT INTO Insurance(pid, tiv_2015, tiv_2016"
32+
+", lat, lon)"
33+
+" VALUES (3, 10, 30, 20, 20); "
34+
+"INSERT INTO Insurance(pid, tiv_2015, tiv_2016"
35+
+", lat, lon)"
36+
+" VALUES (4, 10, 40, 40, 40); ")
3737
classMysqlTest {
3838
@Test
3939
voidtestScript(@EmbeddedDatabaseDataSourcedataSource)

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp