You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-dev@db.apache.org by mp...@apache.org on 2003/12/03 18:30:25 UTC
cvs commit: db-torque/src/generator/src/test/org/apache/torque/engine/database/transform mysql.sql SQLToAppDataTest.java
mpoeschl 2003/12/03 09:30:25
Added: src/generator/src/test/org/apache/torque/engine/database/transform
mysql.sql SQLToAppDataTest.java
Log:
add a simple test for SQLToAppData
Revision Changes Path
1.1 db-torque/src/generator/src/test/org/apache/torque/engine/database/transform/mysql.sql
Index: mysql.sql
===================================================================
# -----------------------------------------------------------------------
# course
# -----------------------------------------------------------------------
drop table if exists course;
CREATE TABLE course
(
id INTEGER NOT NULL,
col_a CHAR (5),
PRIMARY KEY(id)
);
1.1 db-torque/src/generator/src/test/org/apache/torque/engine/database/transform/SQLToAppDataTest.java
Index: SQLToAppDataTest.java
===================================================================
package org.apache.torque.engine.database.transform;
/* ====================================================================
* The Apache Software License, Version 1.1
*
* Copyright (c) 2003 The Apache Software Foundation. All rights
* reserved.
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions
* are met:
*
* 1. Redistributions of source code must retain the above copyright
* notice, this list of conditions and the following disclaimer.
*
* 2. Redistributions in binary form must reproduce the above copyright
* notice, this list of conditions and the following disclaimer in
* the documentation and/or other materials provided with the
* distribution.
*
* 3. The end-user documentation included with the redistribution,
* if any, must include the following acknowledgment:
* "This product includes software developed by the
* Apache Software Foundation (http://www.apache.org/)."
* Alternately, this acknowledgment may appear in the software itself,
* if and wherever such third-party acknowledgments normally appear.
*
* 4. The names "Apache" and "Apache Software Foundation" and
* "Apache Torque" must not be used to endorse or promote products
* derived from this software without prior written permission. For
* written permission, please contact apache@apache.org.
*
* 5. Products derived from this software may not be called "Apache",
* "Apache Torque", nor may "Apache" appear in their name, without
* prior written permission of the Apache Software Foundation.
*
* THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
* WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
* OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
* DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR
* ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
* SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
* LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
* USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
* ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
* OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
* OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
* SUCH DAMAGE.
* ====================================================================
*
* This software consists of voluntary contributions made by many
* individuals on behalf of the Apache Software Foundation. For more
* information on the Apache Software Foundation, please see
* <http://www.apache.org/>.
*/
import junit.framework.TestCase;
import org.apache.torque.engine.database.model.Database;
import org.apache.torque.engine.database.model.Table;
/**
* @author <a href="mailto:mpoeschl@marmot.at">Martin Poeschl</a>
* @version $Id: SQLToAppDataTest.java,v 1.1 2003/12/03 17:30:25 mpoeschl Exp $
*/
public class SQLToAppDataTest extends TestCase
{
/**
* Class to test for void SQLToAppData(String, String)
*/
public void testMySql() throws Exception
{
SQLToAppData sqlToAppData = new SQLToAppData(
"src/test/org/apache/torque/engine/database/transform/mysql.sql",
"mysql");
Database db = sqlToAppData.execute();
assertTrue(db.getTables().size() > 0);
Table course = db.getTable("course");
assertTrue(course != null);
}
}
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org
Re: cvs commit: db-torque/src/generator/src/test/org/apache/torque/engine/database/transform
mysql.sql SQLToAppDataTest.java
Posted by Daniel Rall <dl...@collab.net>.
Martin Poeschl wrote:
> Daniel Rall wrote:
>
>> Woo, more tests!
>>
>> mpoeschl@apache.org wrote:
>> ...
>>
>>> public class SQLToAppDataTest extends TestCase
>>> {
>>> /**
>>> * Class to test for void SQLToAppData(String, String)
>>> */
>>> public void testMySql() throws Exception
>>> {
>>> SQLToAppData sqlToAppData = new SQLToAppData(
>>>
>>> "src/test/org/apache/torque/engine/database/transform/mysql.sql",
>>> "mysql");
>>> Database db = sqlToAppData.execute();
>>> assertTrue(db.getTables().size() > 0);
>>> Table course = db.getTable("course");
>>> assertTrue(course != null);
>>
>>
>>
>> The above two lines could be written as:
>>
>> assertNotNull(db.getTable("course"));
>
>
> right .. but there will be more tests using the table soon ;-)
Nice. ;-)
You could still take advatage of the easily human-readable assertNotNull() API,
as opposed to inlining the null check and calling assertTrue().
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org
Re: cvs commit: db-torque/src/generator/src/test/org/apache/torque/engine/database/transform
mysql.sql SQLToAppDataTest.java
Posted by Martin Poeschl <mp...@marmot.at>.
Daniel Rall wrote:
> Woo, more tests!
>
> mpoeschl@apache.org wrote:
> ...
>
>> public class SQLToAppDataTest extends TestCase
>> {
>> /**
>> * Class to test for void SQLToAppData(String, String)
>> */
>> public void testMySql() throws Exception
>> {
>> SQLToAppData sqlToAppData = new SQLToAppData(
>>
>> "src/test/org/apache/torque/engine/database/transform/mysql.sql",
>> "mysql");
>> Database db = sqlToAppData.execute();
>> assertTrue(db.getTables().size() > 0);
>> Table course = db.getTable("course");
>> assertTrue(course != null);
>
>
> The above two lines could be written as:
>
> assertNotNull(db.getTable("course"));
right .. but there will be more tests using the table soon ;-)
martin
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org
Re: cvs commit: db-torque/src/generator/src/test/org/apache/torque/engine/database/transform
mysql.sql SQLToAppDataTest.java
Posted by Daniel Rall <dl...@finemaltcoding.com>.
Woo, more tests!
mpoeschl@apache.org wrote:
...
> public class SQLToAppDataTest extends TestCase
> {
>
> /**
> * Class to test for void SQLToAppData(String, String)
> */
> public void testMySql() throws Exception
> {
> SQLToAppData sqlToAppData = new SQLToAppData(
> "src/test/org/apache/torque/engine/database/transform/mysql.sql",
> "mysql");
> Database db = sqlToAppData.execute();
> assertTrue(db.getTables().size() > 0);
> Table course = db.getTable("course");
> assertTrue(course != null);
The above two lines could be written as:
assertNotNull(db.getTable("course"));
> }
>
> }
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org