Thread: Re: [SQLObject] Support for SQL Server and Oracle
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Matthew C. <mat...@gm...> - 2005-09-23 18:06:42
|
I have modified SQLObject 0.6.1 to support Oracle (except for the ability t= o 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 |
From: Alan M. <ala...@es...> - 2005-09-26 02:54:08
|
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 |
From: Oleg B. <ph...@ph...> - 2005-09-24 15:26:54
|
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/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: Kevin D. <da...@gm...> - 2005-09-24 15:55:39
|
On 9/24/05, Oleg Broytmann <ph...@ph...> 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 |
From: Catherine D. <cat...@gm...> - 2005-09-24 19:22:49
|
"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 <da...@gm...> wrote: > > On 9/24/05, Oleg Broytmann <ph...@ph...> 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/ |
From: Matthew C. <mat...@bm...> - 2005-10-13 15:49:07
|
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: Mat...@bm... % Wireless email: mat...@im... %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% |
From: Oleg B. <ph...@ma...> - 2005-10-13 15:56:39
|
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/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: Matthew C. <mat...@bm...> - 2005-10-18 14:55:19
|
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: Mat...@bm... % Wireless email: mat...@im... %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% |
From: Oleg B. <ph...@ph...> - 2005-10-18 15:00:32
|
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/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: Matthew C. <mat...@bm...> - 2005-10-18 15:23:45
|
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: Mat...@bm... % Wireless email: mat...@im... %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% |
From: Oleg B. <ph...@ph...> - 2005-10-18 15:49:55
|
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/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: Matthew C. <mat...@bm...> - 2005-10-18 16:06:54
|
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: Mat...@bm... % Wireless email: mat...@im... %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% |
From: Oleg B. <ph...@ph...> - 2005-10-18 16:24:02
|
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/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: Ian B. <ia...@co...> - 2005-10-22 23:28:50
|
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 | ia...@co... | http://blog.ianbicking.org |
From: Jason R H. <JRH...@th...> - 2005-10-17 18:39:12
|
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 |
From: Ian B. <ia...@co...> - 2005-10-22 19:48:23
|
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 | ia...@co... | http://blog.ianbicking.org |
From: Matthew C. <mat...@bm...> - 2005-10-18 17:19:09
|
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: Mat...@bm... % Wireless email: mat...@im... %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% |