Re: migrations with booleans and postgresql

2008-04-08 Thread Mike Schrag

I am working with the examples with using migrations.
I want to add a boolean column. Originally, I would
have used a varchar and methods to use the strings
true and false... Then I found that I can use an
external type of bool and a Data Type Boolean -
boolean c...

How can I use migrations to create the same thing with
the migrations?
newIntBooleanColumn MIGHT work here?  I use the varchar(5) variant, so  
I've just never tried.  You always have the option of using the full  
newColumn method, but you'll have to check the jdbc types, etc to see  
what ends up being the right mappings.


/**
	 * Returns a new ERXMigrationColumn with the given attributes.  This  
method is the
	 * most general-purpose of the .newXxx methods.  If this table  
already exists,
	 * calling the .newXxxColumn methods will immediate execute the SQL  
to add the
	 * columns to the table.  If this table is new, however,  
calling .newXxxColumn

 * will only return a metadata object, and you must call .create() on
 * the table.
 *
 * @param name the name of the column to create
 * @param jdbcType the JDBC type of the column (see java.sql.Types)
 * @param width the width of the column (or 0 for unspecified)
 * @param precision the precision of the column (or 0 for unspecified)
 * @param scale the scale of the column (or 0 for unspecified)
 * @param allowsNull if true, the column will allow null values
 * @return the new ERXMigrationColumn
 * @throws SQLException if the column cannot be created
 */
	public ERXMigrationColumn newColumn(String name, int jdbcType, int  
width, int precision, int scale, boolean allowsNull, String  
overrideValueType) throws SQLException {


ms ___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [EMAIL PROTECTED]

migrations with booleans and postgresql

2008-04-08 Thread Theodore Petrosky
I am working with the examples with using migrations.
I want to add a boolean column. Originally, I would
have used a varchar and methods to use the strings
true and false... Then I found that I can use an
external type of bool and a Data Type Boolean -
boolean c...

How can I use migrations to create the same thing with
the migrations?

Ted




  

You rock. That's why Blockbuster's offering you one month of Blockbuster Total 
Access, No Cost.  
http://tc.deals.yahoo.com/tc/blockbuster/text5.com
 ___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [EMAIL PROTECTED]