Skip to content

Commit ca53ee5

Browse files
nmariznmariz
committed
Fix mysqlx_crud failing tests
Change-Id: I8f6469770d98060c1b3132444c4571b9e38f6802
1 parent d4b2ace commit ca53ee5

File tree

1 file changed

+24
-16
lines changed

1 file changed

+24
-16
lines changed

‎tests/test_mysqlx_crud.py

Lines changed: 24 additions & 16 deletions
Original file line numberDiff line numberDiff line change
@@ -3266,19 +3266,21 @@ def test_having(self):
32663266

32673267
self.session.sql(
32683268
f"""
3269-
CREATE TABLE {table_name} "
3270-
(age, name VARCHAR(50) PRIMARY KEY, gender CHAR(1))
3269+
CREATE TABLE {table_name}
3270+
(id INT PRIMARY KEY, age INT, name VARCHAR(50), gender CHAR(1))
32713271
"""
32723272
).execute()
3273-
self.session.sql(f"INSERT INTO {table_name} VALUES (21, 'Fred', 'M')").execute()
32743273
self.session.sql(
3275-
f"INSERT INTO {table_name} VALUES (28, 'Barney', 'M')"
3274+
f"INSERT INTO {table_name} VALUES (1, 21, 'Fred', 'M')"
3275+
).execute()
3276+
self.session.sql(
3277+
f"INSERT INTO {table_name} VALUES (2, 28, 'Barney', 'M')"
32763278
).execute()
32773279
self.session.sql(
3278-
f"INSERT INTO {table_name} VALUES (42, 'Wilma', 'F')"
3280+
f"INSERT INTO {table_name} VALUES (3, 42, 'Wilma', 'F')"
32793281
).execute()
32803282
self.session.sql(
3281-
f"INSERT INTO {table_name} VALUES (67, 'Betty', 'F')"
3283+
f"INSERT INTO {table_name} VALUES (4, 67, 'Betty', 'F')"
32823284
).execute()
32833285

32843286
table = self.schema.get_table("test")
@@ -4025,18 +4027,20 @@ def test_having(self):
40254027
self.session.sql(
40264028
f"""
40274029
CREATE TABLE {table_name}
4028-
(age INT, name VARCHAR(50) PRIMARY KEY, gender CHAR(1))
4030+
(id INT PRIMARY KEY, age INT, name VARCHAR(50), gender CHAR(1))
40294031
"""
40304032
).execute()
4031-
self.session.sql(f"INSERT INTO {table_name} VALUES (21, 'Fred', 'M')").execute()
40324033
self.session.sql(
4033-
f"INSERT INTO {table_name} VALUES (28, 'Barney', 'M')"
4034+
f"INSERT INTO {table_name} VALUES (1, 21, 'Fred', 'M')"
40344035
).execute()
40354036
self.session.sql(
4036-
f"INSERT INTO {table_name} VALUES (42, 'Wilma', 'F')"
4037+
f"INSERT INTO {table_name} VALUES (2, 28, 'Barney', 'M')"
40374038
).execute()
40384039
self.session.sql(
4039-
f"INSERT INTO {table_name} VALUES (67, 'Betty', 'F')"
4040+
f"INSERT INTO {table_name} VALUES (3, 42, 'Wilma', 'F')"
4041+
).execute()
4042+
self.session.sql(
4043+
f"INSERT INTO {table_name} VALUES (4, 67, 'Betty', 'F')"
40404044
).execute()
40414045

40424046
defined_as = f"SELECT age, name, gender FROM {table_name}"
@@ -4071,11 +4075,14 @@ def test_having(self):
40714075
self.assertEqual(21, rows[1]["age"])
40724076

40734077
def test_insert(self):
4074-
table_name = "{0}.{1}".format(self.schema_name, self.table_name)
4078+
table_name = f"{self.schema_name}.{self.table_name}"
40754079

40764080
self.session.sql(
4077-
"CREATE TABLE {0} (age INT, name VARCHAR(50) PRIMARY KEY, "
4078-
"gender CHAR(1))".format(table_name)
4081+
f"""
4082+
CREATE TABLE {table_name}
4083+
(id INT AUTO_INCREMENT PRIMARY KEY, age INT, name VARCHAR(50),
4084+
gender CHAR(1))
4085+
"""
40794086
).execute()
40804087
defined_as = "SELECT age, name, gender FROM {0}".format(table_name)
40814088
view = create_view(self.schema, self.view_name, defined_as)
@@ -4104,12 +4111,13 @@ def test_insert(self):
41044111
self.assertEqual(6, len(rows))
41054112

41064113
def test_update(self):
4107-
table_name = "{0}.{1}".format(self.schema_name, self.table_name)
4114+
table_name = f"{self.schema_name}.{self.table_name}"
41084115

41094116
self.session.sql(
41104117
f"""
41114118
CREATE TABLE {table_name}
4112-
(age INT, name VARCHAR(50) PRIMARY KEY, gender CHAR(1))
4119+
(id INT AUTO_INCREMENT PRIMARY KEY, age INT, name VARCHAR(50),
4120+
gender CHAR(1))
41134121
"""
41144122
).execute()
41154123
defined_as = f"SELECT age, name, gender FROM {table_name}"

0 commit comments

Comments
 (0)