testsuite.simple

Class UpdatabilityTest

java.lang.Object

testsuite.BaseTestCase

testsuite.simple.UpdatabilityTest

public class UpdatabilityTest
extends BaseTestCase

Tests for updatable result sets

Nested Class Summary

Nested classes/interfaces inherited from class testsuite.BaseTestCase

BaseTestCase.MockConnectionConfiguration

Field Summary

Fields inherited from class testsuite.BaseTestCase

conn, dbClass, dbName, dbUrl, isOpenSSL, mainConnectionUrl, pstmt, rs, serverVersion, stmt, timeZoneFreeDbUrl

Constructor Summary

Constructors

Constructor and Description
UpdatabilityTest()

Method Summary

Modifier and Type	Method and Description
private void	createTestTable()
void	setUp()
void	tearDown()
void	testAliasedTables() Tests if aliased tables work as updatable result sets.
void	testBogusTable() Tests that the driver does not let you update result sets that come from tables that don't have primary keys
void	testMultiKeyTable() Tests that the driver does not let you update result sets that come from queries that haven't selected all primary keys
void	testUpdatability()

Methods inherited from class testsuite.BaseTestCase

appendRequiredProperties, assertByteArrayEquals, assertConnectionsHistory, assertEqualsFSAware, assertNonSecureConnection, assertResultSetLength, assertResultSetsEqual, assertSecureConnection, assertSecureConnection, assertSessionStatusEquals, assertThrows, assertThrows, assertThrows, assertThrows, cleanupTempFiles, createDatabase, createDatabase, createFunction, createFunction, createProcedure, createProcedure, createSchemaObject, createSchemaObject, createTable, createTable, createTable, createTable, createUser, createUser, createView, createView, currentTimeMillis, dropDatabase, dropDatabase, dropFunction, dropFunction, dropProcedure, dropProcedure, dropSchemaObject, dropSchemaObject, dropTable, dropTable, dropUser, dropUser, dropView, dropView, fillPrimitiveDefaults, getConnectionWithProps, getConnectionWithProps, getConnectionWithProps, getConnectionWithProps, getEncodedHostFromTestsuiteUrl, getEncodedHostPortPairFromTestsuiteUrl, getFailoverConnection, getFailoverConnection, getHostFreePropertiesFromTestsuiteUrl, getHostFreePropertiesFromTestsuiteUrl, getHostFromTestsuiteUrl, getInstanceNumber, getLoadBalancedConnection, getLoadBalancedConnection, getLoadBalancedConnection, getMysqlVariable, getMysqlVariable, getNewConnection, getNoDbUrl, getPort, getPortFreeHostname, getPortFromTestsuiteUrl, getPropertiesFromTestsuiteUrl, getPropertiesFromUrl, getRowCount, getSingleIndexedValueWithQuery, getSingleIndexedValueWithQuery, getSingleValue, getSingleValueWithQuery, getSourceReplicaReplicationConnection, getSourceReplicaReplicationConnection, getSourceReplicaUrl, getSourceReplicaUrl, getUnreliableFailoverConnection, getUnreliableFailoverConnection, getUnreliableLoadBalancedConnection, getUnreliableLoadBalancedConnection, getUnreliableMultiHostConnection, getUnreliableReplicationConnection, getUnreliableReplicationConnection, getUnreliableReplicationConnection, isClassAvailable, isCommunityEdition, isEnterpriseEdition, isMysqlRunningLocally, isRunningOnJRockit, isServerRunningOnWindows, isSysPropDefined, logDebug, newTempBinaryFile, randomString, removeHostRelatedProps, removeSqlMode, runLongTests, setUpBase, supportsLoadLocalInfile, supportsTestCachingSha2PasswordKeys, supportsTestCertificates, supportsTestSha256PasswordKeys, supportsTimeZoneNames, supportsTLSv1_2, tearDownBase, versionMeetsMinimum, versionMeetsMinimum

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

UpdatabilityTest

public UpdatabilityTest()

Method Detail

setUp

@BeforeEach
public void setUp()
                       throws java.lang.Exception

Throws:

java.lang.Exception

tearDown

@AfterEach
public void tearDown()
                         throws java.lang.Exception

Throws:

java.lang.Exception

testAliasedTables

@Test
public void testAliasedTables()
                             throws java.lang.Exception

Tests if aliased tables work as updatable result sets.

Throws:

java.lang.Exception

testBogusTable

@Test
public void testBogusTable()
                          throws java.sql.SQLException

Tests that the driver does not let you update result sets that come from tables that don't have primary keys

Throws:

java.sql.SQLException

testMultiKeyTable

@Test
public void testMultiKeyTable()
                             throws java.sql.SQLException

Tests that the driver does not let you update result sets that come from queries that haven't selected all primary keys

Throws:

java.sql.SQLException

testUpdatability

@Test
public void testUpdatability()
                            throws java.sql.SQLException

Throws:

java.sql.SQLException

createTestTable

private void createTestTable()
                      throws java.sql.SQLException

Throws:

java.sql.SQLException