Re: [Glorp-development] Why do the unit tests use #int4 to #serial foreign keys?

[Todd B. <tbl...@ma...>]

FWIW, I added a method to GlorpDatabaseType called foreignKeyType.   
It returns self.  Except on serial, where it returns int4, and  
bigserial, where it returns int8.

This is useful when building the descriptor systems from other models.


On Jan 17, 2007, at 5:58 AM, Alan Knight wrote:

> Probably because int4 worked fine on other databases. It seems a  
> bit fussy that the database won't allow comparing two integers of  
> different precisions. Or is it just that it won't allow creating a  
> foreign key constraint between them?
>
> It would probably be useful to create a database type like  
> #foreignKey which would have the same size as a serial type on that  
> database. There are some issues, like some databases not having a  
> serial type, and not necessarily knowing what the size of it is if  
> they do have one. We could hard-code it, but I wouldn't even know  
> what the size of a Postgresql serial is.
>
> At 04:20 PM 1/16/2007, Jeremy Shute wrote:
>> I'm using the SqueakMap GLORP port.
>>
>> Why do the unit tests wire int4 to serial in foreign keys?
>>
>> I'm working on support for MySQL (using the Jdm driver port) from  
>> within Squeak, and under MySQL, the serial type is a "bigint(20)  
>> unsigned" while int4 shows up to be "int(11)".  InnoDB thinks  
>> (correctly) that the types do not agree.
>>
>> I propose that there should be some way of specifying that a value  
>> is essentially a "foreign serial" instead of relying on int4.  Or,  
>> is MySQL's interpretation of serial wrong -- and serial should in  
>> fact be an int4 with some greater semantic calling?
>>
>> Jeremy
>> --------------------------------------------------------------------- 
>> ----
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to  
>> share your
>> opinions on IT & business topics through brief surveys - and earn  
>> cash
>> http://www.techsay.com/default.php? 
>> page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> Glorp-development mailing list
>> Glo...@li...
>> https://lists.sourceforge.net/lists/listinfo/glorp-development
>
> --
> Alan Knight [|], Cincom Smalltalk Development
> kn...@ac...
> ak...@ci...
> http://www.cincom.com/smalltalk
>
> "The Static Typing Philosophy: Make it fast. Make it right. Make it  
> run." - Niall Ross
> ---------------------------------------------------------------------- 
> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to  
> share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php? 
> page=join.php&p=sourceforge&CID=DEVDEV________________________________ 
> _______________
> Glorp-development mailing list
> Glo...@li...
> https://lists.sourceforge.net/lists/listinfo/glorp-development