Java Doc for TestDMLMisc.java in  » Database-DBMS » axion » org » axiondb » functional » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Java Source Code / Java Documentation
1. 6.0 JDK Core
2. 6.0 JDK Modules
3. 6.0 JDK Modules com.sun
4. 6.0 JDK Modules com.sun.java
5. 6.0 JDK Modules sun
6. 6.0 JDK Platform
7. Ajax
8. Apache Harmony Java SE
9. Aspect oriented
10. Authentication Authorization
11. Blogger System
12. Build
13. Byte Code
14. Cache
15. Chart
16. Chat
17. Code Analyzer
18. Collaboration
19. Content Management System
20. Database Client
21. Database DBMS
22. Database JDBC Connection Pool
23. Database ORM
24. Development
25. EJB Server geronimo
26. EJB Server GlassFish
27. EJB Server JBoss 4.2.1
28. EJB Server resin 3.1.5
29. ERP CRM Financial
30. ESB
31. Forum
32. GIS
33. Graphic Library
34. Groupware
35. HTML Parser
36. IDE
37. IDE Eclipse
38. IDE Netbeans
39. Installer
40. Internationalization Localization
41. Inversion of Control
42. Issue Tracking
43. J2EE
44. JBoss
45. JMS
46. JMX
47. Library
48. Mail Clients
49. Net
50. Parser
51. PDF
52. Portal
53. Profiler
54. Project Management
55. Report
56. RSS RDF
57. Rule Engine
58. Science
59. Scripting
60. Search Engine
61. Security
62. Sevlet Container
63. Source Control
64. Swing Library
65. Template Engine
66. Test Coverage
67. Testing
68. UML
69. Web Crawler
70. Web Framework
71. Web Mail
72. Web Server
73. Web Services
74. Web Services apache cxf 2.0.1
75. Web Services AXIS2
76. Wiki Engine
77. Workflow Engines
78. XML
79. XML UI
Java
Java Tutorial
Java Open Source
Jar File Download
Java Articles
Java Products
Java by API
Photoshop Tutorials
Maya Tutorials
Flash Tutorials
3ds-Max Tutorials
Illustrator Tutorials
GIMP Tutorials
C# / C Sharp
C# / CSharp Tutorial
C# / CSharp Open Source
ASP.Net
ASP.NET Tutorial
JavaScript DHTML
JavaScript Tutorial
JavaScript Reference
HTML / CSS
HTML CSS Reference
C / ANSI-C
C Tutorial
C++
C++ Tutorial
Ruby
PHP
Python
Python Tutorial
Python Open Source
SQL Server / T-SQL
SQL Server / T-SQL Tutorial
Oracle PL / SQL
Oracle PL/SQL Tutorial
PostgreSQL
SQL / MySQL
MySQL Tutorial
VB.Net
VB.Net Tutorial
Flash / Flex / ActionScript
VBA / Excel / Access / Word
XML
XML Tutorial
Microsoft Office PowerPoint 2007 Tutorial
Microsoft Office Excel 2007 Tutorial
Microsoft Office Word 2007 Tutorial
Java Source Code / Java Documentation » Database DBMS » axion » org.axiondb.functional 
Source Cross Reference  Class Diagram Java Document (Java Doc) 


org.axiondb.functional.AbstractFunctionalTest
   org.axiondb.functional.TestDMLMisc

TestDMLMisc
public class TestDMLMisc extends AbstractFunctionalTest (Code)
Database Modification Language tests.
version:
   $Revision: 1.5 $ $Date: 2005/12/20 18:32:44 $
author:
   Ritesh Adval
author:
   Ahimanikya Satapathy



Constructor Summary
public  TestDMLMisc(String testName)
    

Method Summary
public  voidsetUp()
    
public static  Testsuite()
    
public  voidtearDown()
    
public  voidtestAddBatchFailsImmediatelyOnParseError()
    
public  voidtestAlterTable()
    
public  voidtestAlterTableOnAutonumberColumn()
    
public  voidtestAlterTableOnIndexedTable()
    
public  voidtestAutonumberColumn()
    
public  voidtestAutonumberColumn2()
    
public  voidtestAutonumberColumn3()
    
public  voidtestCreateTableWithAlwaysGeneratedIdenity()
    
public  voidtestCreateTableWithGeneratedByDefaultIdenity()
    
public  voidtestDefalutValuesClauseInInsertCommand()
    
public  voidtestDefragTable()
    
public  voidtestInsertSelectThreeTableJoinWithIsNullWhereCondition1()
    
public  voidtestInsertSelectThreeTableJoinWithIsNullWhereCondition2()
    
public  voidtestInsertSelectWithGroupBy()
    
public  voidtestInsertWithFunctions()
    
public  voidtestInsertWithLiteralDefault()
    
public  voidtestInsertWithUnspecifiedColumns()
    
public  voidtestInvalidInsert()
    
public  voidtestSimpleView()
    
public  voidtestSqlExceptionWhenExistingRowsViolateNewConstraint()
    
public  voidtestTruncateOnIndexedTable()
    
public  voidtestTruncateTable()
    
public  voidtest_insert_select_cases()
     Tests insert-select when "case-when" used is used more than once in the Select statement.
public  voidtest_insert_select_counts()
     Tests insert-select when "count" function used is used more than once in the Select statement.
public  voidtest_insert_select_maxs()
     Tests insert-select when "max" function used is used more than once in the Select statement.
public  voidtest_insert_when_via_pstmt()
    


Constructor Detail
TestDMLMisc
public TestDMLMisc(String testName)(Code)




Method Detail
setUp
public void setUp() throws Exception(Code)



suite
public static Test suite()(Code)



tearDown
public void tearDown() throws Exception(Code)



testAddBatchFailsImmediatelyOnParseError
public void testAddBatchFailsImmediatelyOnParseError() throws Exception(Code)



testAlterTable
public void testAlterTable() throws Exception(Code)



testAlterTableOnAutonumberColumn
public void testAlterTableOnAutonumberColumn() throws Exception(Code)



testAlterTableOnIndexedTable
public void testAlterTableOnIndexedTable() throws Exception(Code)



testAutonumberColumn
public void testAutonumberColumn() throws Exception(Code)



testAutonumberColumn2
public void testAutonumberColumn2() throws Exception(Code)



testAutonumberColumn3
public void testAutonumberColumn3() throws Exception(Code)



testCreateTableWithAlwaysGeneratedIdenity
public void testCreateTableWithAlwaysGeneratedIdenity() throws Exception(Code)



testCreateTableWithGeneratedByDefaultIdenity
public void testCreateTableWithGeneratedByDefaultIdenity() throws Exception(Code)



testDefalutValuesClauseInInsertCommand
public void testDefalutValuesClauseInInsertCommand() throws Exception(Code)



testDefragTable
public void testDefragTable() throws Exception(Code)



testInsertSelectThreeTableJoinWithIsNullWhereCondition1
public void testInsertSelectThreeTableJoinWithIsNullWhereCondition1() throws Exception(Code)



testInsertSelectThreeTableJoinWithIsNullWhereCondition2
public void testInsertSelectThreeTableJoinWithIsNullWhereCondition2() throws Exception(Code)



testInsertSelectWithGroupBy
public void testInsertSelectWithGroupBy() throws Exception(Code)



testInsertWithFunctions
public void testInsertWithFunctions() throws Exception(Code)



testInsertWithLiteralDefault
public void testInsertWithLiteralDefault() throws Exception(Code)



testInsertWithUnspecifiedColumns
public void testInsertWithUnspecifiedColumns() throws Exception(Code)



testInvalidInsert
public void testInvalidInsert() throws Exception(Code)



testSimpleView
public void testSimpleView() throws Exception(Code)



testSqlExceptionWhenExistingRowsViolateNewConstraint
public void testSqlExceptionWhenExistingRowsViolateNewConstraint() throws Exception(Code)



testTruncateOnIndexedTable
public void testTruncateOnIndexedTable() throws Exception(Code)



testTruncateTable
public void testTruncateTable() throws Exception(Code)



test_insert_select_cases
public void test_insert_select_cases() throws Exception(Code)
Tests insert-select when "case-when" used is used more than once in the Select statement. To test Engine handles it without throwing duplicate "CASEWHEN" alias/column name.
throws:
  Exception -



test_insert_select_counts
public void test_insert_select_counts() throws Exception(Code)
Tests insert-select when "count" function used is used more than once in the Select statement. To test Engine handles it without throwing duplicate "CASEWHEN" alias/column name.
throws:
  Exception -



test_insert_select_maxs
public void test_insert_select_maxs() throws Exception(Code)
Tests insert-select when "max" function used is used more than once in the Select statement. To test Engine handles it without throwing duplicate "CASEWHEN" alias/column name.
throws:
  Exception -



test_insert_when_via_pstmt
public void test_insert_when_via_pstmt() throws Exception(Code)



Fields inherited from org.axiondb.functional.AbstractFunctionalTest
final protected static int NUM_ROWS_IN_BAR(Code)(Java Doc)
final protected static int NUM_ROWS_IN_FOO(Code)(Java Doc)
final protected static int NUM_ROWS_IN_X(Code)(Java Doc)
final protected static int NUM_ROWS_IN_Y(Code)(Java Doc)
final protected static int NUM_ROWS_IN_Z(Code)(Java Doc)
protected AxionConnection _conn(Code)(Java Doc)
protected ResultSet _rset(Code)(Java Doc)
protected Statement _stmt(Code)(Java Doc)

Methods inherited from org.axiondb.functional.AbstractFunctionalTest
protected void assertException(String query)(Code)(Java Doc)
protected void assertExceptionOnRead(String query) throws SQLException(Code)(Java Doc)
protected void assertNRows(int n, String query) throws SQLException(Code)(Java Doc)
protected void assertNRows(int n, ResultSet rset) throws SQLException(Code)(Java Doc)
protected void assertNoRows(String query) throws SQLException(Code)(Java Doc)
protected void assertNoRows(ResultSet rset) throws SQLException(Code)(Java Doc)
protected void assertNullResult(String query) throws SQLException(Code)(Java Doc)
protected void assertObjectResult(Object expected, ResultSet rset) throws SQLException(Code)(Java Doc)
protected void assertObjectResult(Object expected, String query) throws SQLException(Code)(Java Doc)
protected void assertOneRow(String query) throws SQLException(Code)(Java Doc)
protected void assertResult(Object[] expected, ResultSet rset) throws SQLException(Code)(Java Doc)
protected void assertResult(Object[] expected, String query) throws SQLException(Code)(Java Doc)
protected void assertResult(String expected, ResultSet rset) throws SQLException(Code)(Java Doc)
protected void assertResult(String expected, String query) throws SQLException(Code)(Java Doc)
protected void assertResult(int expected, ResultSet rset) throws SQLException(Code)(Java Doc)
protected void assertResult(int expected, String query) throws SQLException(Code)(Java Doc)
protected void assertResult(float expected, String query) throws SQLException(Code)(Java Doc)
protected void assertResult(boolean expected, String query) throws SQLException(Code)(Java Doc)
protected void createAndPopulateDual() throws Exception(Code)(Java Doc)
protected void createIndexOnFoo() throws Exception(Code)(Java Doc)
protected void createSequenceFooSeq() throws Exception(Code)(Java Doc)
protected void createTableBar() throws Exception(Code)(Java Doc)
protected void createTableFoo(boolean includeIndex) throws Exception(Code)(Java Doc)
protected void createTableFoo() throws Exception(Code)(Java Doc)
protected void createTableStates() throws Exception(Code)(Java Doc)
protected void createTableWords() throws Exception(Code)(Java Doc)
protected void createTableX() throws Exception(Code)(Java Doc)
protected void createTableY() throws Exception(Code)(Java Doc)
protected void createTableZ() throws Exception(Code)(Java Doc)
protected boolean deleteFile(File file) throws Exception(Code)(Java Doc)
protected void dropSequenceFooSeq() throws Exception(Code)(Java Doc)
protected void dropTableX() throws Exception(Code)(Java Doc)
protected void dropTableY() throws Exception(Code)(Java Doc)
protected void dropTableZ() throws Exception(Code)(Java Doc)
protected String getConnectString()(Code)(Java Doc)
protected File getDatabaseDirectory()(Code)(Java Doc)
protected void populateTableBar() throws Exception(Code)(Java Doc)
protected void populateTableFoo() throws Exception(Code)(Java Doc)
protected void populateTableStates() throws Exception(Code)(Java Doc)
protected void populateTableWords() throws Exception(Code)(Java Doc)
protected void populateTableX() throws Exception(Code)(Java Doc)
protected void populateTableY() throws Exception(Code)(Java Doc)
protected void populateTableZ() throws Exception(Code)(Java Doc)
public void setUp() throws Exception(Code)(Java Doc)
public void tearDown() throws Exception(Code)(Java Doc)

www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.