SQLObject

On Fri, Sep 23, 2005 at 01:59:17PM -0400, Matthew Cahn wrote:
> I have modified SQLObject 0.6.1 to support Oracle

   WOW!!!

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            phd@...
           Programmers don't die, they just GOSUB without RETURN.

On 9/24/05, Oleg Broytmann <phd@...> wrote:
> On Fri, Sep 23, 2005 at 01:59:17PM -0400, Matthew Cahn wrote:
> > I have modified SQLObject 0.6.1 to support Oracle
>
>    WOW!!!

That was my thought, too!


Kevin

"Hey, wait a minute. Wasn't there a sword hilt sticking out of this stone a
minute ago?"

Looking forward to seeing Matthew's code... I'm actually hawking Python to
my local Oracle group on Oct. 27, and maybe maybe maybe maybe to the
national IOUG convention next April, and it would be great to have an
Oracle-capable SQLObject for them...

On 9/24/05, Kevin Dangoor <dangoor@...> wrote:
>
> On 9/24/05, Oleg Broytmann <phd@...> wrote:
> > On Fri, Sep 23, 2005 at 01:59:17PM -0400, Matthew Cahn wrote:
> > > I have modified SQLObject 0.6.1 to support Oracle
> >
> > WOW!!!
>
> That was my thought, too!
>
>
> Kevin
>

--
- Catherine
http://catherinedevlin.blogspot.com/

Matthew,

If you get your Oracle code rolled into 0.7 in the next few days, I can
try it out, since I'm already doing some work with a project that needs
to support Oracle.  If you can send me your modified 0.6.1 I might even
be able to find time to try that.

Thanks,
Alan

>I have modified SQLObject 0.6.1 to support Oracle (except for the
ability to
>create classes from an existing database, which I still hope to get to).
>Shortly I'll be merging these changes into 0.7 and putting them into the
>subversion repository.
>If anyone would like to try my modified 0.6.1 I'd be happy to supply it.
>Matthew Cahn

I wanted to update those who expressed interest in Oracle support for 
SQLObject and have waited so patiently (I presume).  As I said a while 
back, I had 0.6.1 working.  Since then I've learned to run the unit 
tests (I'm embarrassed to say), some of which fail, and have not found 
enough time to fix these, or to do a 0.7 merge.  If anyone wants to see 
it in this condition, I'll post it or email it.  Otherwise I hope to get 
back to it in the not-to-distant future.

A few details...

There was some concern about quoting special characters, but this seems 
to just work.

BLOBS don't really work right, as the DB module for Oracle, cx_Oracle, 
doesn't have a binary method.  I wrote code to convert between Python 
and Oracle ascii hex, but this only works up to the 4,000 characters 
that can be in-line in a sql statement.  The proposed usage of 
parameters lists should make this problem go away.  (The same limitation 
applies to PickleCol since it uses BLOBCol).

Oracle doesn't have a data type for a date without a time, so at this 
point DateCol and DateTimeCol do the same thing (but the unit test fails).

Matthew

Matthew Cahn wrote:

> I have modified SQLObject 0.6.1 to support Oracle (except for the 
> ability to create classes from an existing database, which I still 
> hope to get to).  Shortly I'll be merging these changes into 0.7 and 
> putting them into the subversion repository.
>  
> If anyone would like to try my modified 0.6.1 I'd be happy to supply it.
>  
> Matthew Cahn
>  


-- 
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
%  Matthew Cahn
%  Principal Systems Analyst
%  Bristol-Myers Squibb Company
%  Mailbox code: H23-05
%  P.O. Box 4000
%  Princeton, NJ 08543-4000
%
%  Phone: (609) 252-3477
%  Fax:   (609) 252-6030
%  Email: Matthew.Cahn@...
%  Wireless email: matthew_cahn@...
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

Hello! Thank you for notifing us!

On Thu, Oct 13, 2005 at 11:45:46AM -0400, Matthew Cahn wrote:
> There was some concern about quoting special characters, but this seems 
> to just work.

   Fine!

> Oracle doesn't have a data type for a date without a time, so at this 
> point DateCol and DateTimeCol do the same thing (but the unit test fails).

   Then modify the test.

if conection.dbName == "oracle":
   ...
else:
   ...

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            phd@...
           Programmers don't die, they just GOSUB without RETURN.

Matthew Cahn wrote on 10/13/2005 10:45:46 AM:
> If anyone wants to see it in this condition, I'll post it or email it. 

Yup. I am very much interested in seeing it in its current (for SO v0.6.1) 
condition.

- Jason

Is 0.6.1 in the svn repository somewhere?  (I only see 0.6 and of course 
the 0.7x versions).  I'd like to do a proper checkout/checkin of my 
Oracle additions, but unfortunately I didn't start with a checkout, just 
a download of the then-current 0.6.1 tarball.

Matthew

-- 
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
%  Matthew Cahn
%  Principal Systems Analyst
%  Bristol-Myers Squibb Company
%  Mailbox code: H23-05
%  P.O. Box 4000
%  Princeton, NJ 08543-4000
%
%  Phone: (609) 252-3477
%  Fax:   (609) 252-6030
%  Email: Matthew.Cahn@...
%  Wireless email: matthew_cahn@...
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

On Tue, Oct 18, 2005 at 10:53:19AM -0400, Matthew Cahn wrote:
> Is 0.6.1 in the svn repository somewhere?

   It was not tagged, IIRC.

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            phd@...
           Programmers don't die, they just GOSUB without RETURN.

So that means I can't check out an svn-controlled 0.6.1, correct?  Does 
it make sense for me to do an svn import of my version into home/cahnm 
so others can see it?

Matthew

Oleg Broytmann wrote:

>On Tue, Oct 18, 2005 at 10:53:19AM -0400, Matthew Cahn wrote:
>  
>
>>Is 0.6.1 in the svn repository somewhere?
>>    
>>
>
>   It was not tagged, IIRC.
>
>Oleg.
>  
>

-- 
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
%  Matthew Cahn
%  Principal Systems Analyst
%  Bristol-Myers Squibb Company
%  Mailbox code: H23-05
%  P.O. Box 4000
%  Princeton, NJ 08543-4000
%
%  Phone: (609) 252-3477
%  Fax:   (609) 252-6030
%  Email: Matthew.Cahn@...
%  Wireless email: matthew_cahn@...
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

On Tue, Oct 18, 2005 at 11:21:43AM -0400, Matthew Cahn wrote:
> So that means I can't check out an svn-controlled 0.6.1, correct?  Does 

   You can do it with some troubles. Find a revision number for 0.6.1 or
date when it was released - and checkout by the tag or date.

> it make sense for me to do an svn import of my version into home/cahnm 
> so others can see it?

   It depends if there are people who want to see it or even better - to
work on it. Are there?

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            phd@...
           Programmers don't die, they just GOSUB without RETURN.

Yes, several people have expressed interest in using it, and a couple 
have offered to help.  But if others want to work on it, starting by 
importing an uncontrolled version seemed like it might not be a good idea.

Matthew

Oleg Broytmann wrote:

>On Tue, Oct 18, 2005 at 11:21:43AM -0400, Matthew Cahn wrote:
>  
>
>>So that means I can't check out an svn-controlled 0.6.1, correct?  Does 
>>    
>>
>
>   You can do it with some troubles. Find a revision number for 0.6.1 or
>date when it was released - and checkout by the tag or date.
>
>  
>
>>it make sense for me to do an svn import of my version into home/cahnm 
>>so others can see it?
>>    
>>
>
>   It depends if there are people who want to see it or even better - to
>work on it. Are there?
>
>Oleg.
>  
>

-- 
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
%  Matthew Cahn
%  Principal Systems Analyst
%  Bristol-Myers Squibb Company
%  Mailbox code: H23-05
%  P.O. Box 4000
%  Princeton, NJ 08543-4000
%
%  Phone: (609) 252-3477
%  Fax:   (609) 252-6030
%  Email: Matthew.Cahn@...
%  Wireless email: matthew_cahn@...
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

On Tue, Oct 18, 2005 at 12:04:44PM -0400, Matthew Cahn wrote:
> Yes, several people have expressed interest in using it, and a couple 
> have offered to help.

   Ok, then. Do you have write access to the repository? If no - ask Ian.

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            phd@...
           Programmers don't die, they just GOSUB without RETURN.

Yes I do.

Oleg Broytmann wrote:

>On Tue, Oct 18, 2005 at 12:04:44PM -0400, Matthew Cahn wrote:
>  
>
>>Yes, several people have expressed interest in using it, and a couple 
>>have offered to help.
>>    
>>
>
>   Ok, then. Do you have write access to the repository? If no - ask Ian.
>
>Oleg.
>  
>

-- 
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
%  Matthew Cahn
%  Principal Systems Analyst
%  Bristol-Myers Squibb Company
%  Mailbox code: H23-05
%  P.O. Box 4000
%  Princeton, NJ 08543-4000
%
%  Phone: (609) 252-3477
%  Fax:   (609) 252-6030
%  Email: Matthew.Cahn@...
%  Wireless email: matthew_cahn@...
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

Matthew Cahn wrote:
> I wanted to update those who expressed interest in Oracle support for
> SQLObject and have waited so patiently (I presume).  As I said a while
> back, I had 0.6.1 working.  Since then I've learned to run the unit
> tests (I'm embarrassed to say), some of which fail, and have not found
> enough time to fix these, or to do a 0.7 merge.  If anyone wants to see
> it in this condition, I'll post it or email it.  Otherwise I hope to get
> back to it in the not-to-distant future.

You should feel free to check it in in a 0.6 state, perhaps in
branches/0.6-oracle/ -- stuff definitely doesn't have to be complete
before it gets checked in to the repository (especially in a branch).

-- 
Ian Bicking  |  ianb@...  |  http://blog.ianbicking.org

Oleg Broytmann wrote:
> On Tue, Oct 18, 2005 at 10:53:19AM -0400, Matthew Cahn wrote:
> 
>>Is 0.6.1 in the svn repository somewhere?
> 
> 
>    It was not tagged, IIRC.

I'm not 100% sure I got the revision right (221), but I put something in
SQLObject/tags/0.6.1 with:

  svn cp -r 221 http://svn.colorstudy.com/trunk/SQLObject
http://svn.colorstudy.com/SQLObject/tags/0.6.1

That might help here.

-- 
Ian Bicking  |  ianb@...  |  http://blog.ianbicking.org