Carl Karsten wrote:
> Ed Leafe wrote:
>> On Jan 10, 2007, at 6:13 AM, Uwe Grauer wrote:
>>
>>> is there a special dabo-datatype for the uuid's?
>>> I don't think so.
>> No, there isn't.
>>
>>> So how should dabo know how to display it?
>
> I'll write the code.
>
>> Better question: *why* should we be displaying them?
>
> Same reason there is a ^D/Debug option: for debugging.
>
>> They are
>> completely meaningless.
>
> Not to me :)
>
>> If you want to see them for some reason, why
>> not handle it in your own app?
>
> Do you think someone else may want to see them?
>
> Regardless of where the code goes, I think I need to add a 'dabo datatype'
> which
> I am a little unsure about.
>
> What relies on the 'dabo datatype'? For instance, if I just add U here:
>
> # dabo/db/dbMsSQL.py
> def _fieldTypeNativeToDabo(self, nativeType):
> """ converts the results of
> select DATA_TYPE from INFORMATION_SCHEMA.COLUMNS
> to a dabo datatype.
> """
> try:
> ret = {
> "BINARY": "I",
> ...
> "UNIQUEIDENTIFIER": "U",
>
>
> What side effects will this have?
>
> I also found
> # dabo/db/dCursorMixin.py
> def getFieldInfoFromDescription(self):
> """ Get field information from the cursor description.
> Returns a tuple of 3-tuples, where the 3-tuple's elements are:
> 0: the field name (string)
> 1: the field type ('I', 'N', 'C', 'M', 'B', 'D', 'T'), or None.
>
> If there isn't any formal documentation and or definition, now would be a
> good
> time to make it. Is there something, or should I take a stab at it?
>
> Carl K
>
There are different implementations of what a GUID/UUID really is.
Of cause there is a MS-representation of what it should be.
But, as i said before, people in the database world are using different
representations of UUID's.
So i do not think that we can agree about what a dabo datatype for all
the supported databases should look like.
I you really want to support this, try to do it in a generic way.
(Look at http://en.wikipedia.org/wiki/UUID).
Uwe
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
