GQL

GSQL

GSQL very simple so that users can access / modify relational database.
For example:

/**//**
* Test to verify valid construction of default DDL
*
* @ Author <a href="mailto:jeremy.rayner@bigfoot.com"> Jeremy Rayner </ a>
* @ Version $ Revision: 1.2 $
* /
Package org.javanicus.gsql

Import java.io. *

Class SqlGeneratorTest extends GroovyTestCase property database
Property sqlGenerator

Void setUp () = new TypeMap typeMap ()
Build new RelationalBuilder = (typeMap)
SqlGenerator = new SqlGenerator (typeMap, System.getProperty ( "line.separator", "\ n"))

Database = build.database (name: 'genealogy') table (name: 'event') column (name: 'event_id', type: 'integer', size: 10, primaryKey: true, required: true)
Column (name: 'description', type: 'varchar' size: 30)
)
Table (name: 'individual') column (name: 'individual_id', type: 'integer', size: 10, required: true, primaryKey: true, autoIncrement: true)
Column (name: 'surname', type: 'varchar', size: 15, required: true)
Column (name: 'event_id', type: 'integer' size: 10)
ForeignKey (foreignTable: 'event') reference (local: 'event_id' foreign: 'event_id')
)
Index (name: 'surname_index') indexColumn (name: 'surname')
)
)
)
)

Void testGenerateDDL () = testWriter new PrintWriter (new FileOutputStream ( "SqlGeneratorTest.sql"))
SqlGenerator.writer = testWriter
SqlGenerator.createDatabase (database, true)
TestWriter.flush ()
)

)

Posted on 2005-02-28 10:26 carob reading (261) Comments (0) edit their collections quoted Category: Groovy

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.