Author |
Message |
Topic: Statement...the pain. |
aaronc542
Replies: 38
Views: 143333
|
Forum: DDBI Posted: Sun Feb 01, 2009 1:13 pm Subject: Statement...the pain. |
http://dev.mysql.com/doc/refman/5.0/en/c-api-multiple-queries.html
See the part that says "Failure to process the result this way may result in a dropped connection to the server" |
Topic: Statement...the pain. |
aaronc542
Replies: 38
Views: 143333
|
Forum: DDBI Posted: Sun Feb 01, 2009 12:46 pm Subject: Statement...the pain. |
I think I have a strategy for how to solve this in a better fashion though, but I would like to hear your thoughts on what all the issues are;
* Result/Statement needs the MYSQL* to do some ... |
Topic: Statement...the pain. |
aaronc542
Replies: 38
Views: 143333
|
Forum: DDBI Posted: Sun Feb 01, 2009 12:45 pm Subject: Statement...the pain. |
I think I have a strategy for how to solve this in a better fashion though, but I would like to hear your thoughts on what all the issues are;
* Result/Statement needs the MYSQL* to do some ... |
Topic: Statement...the pain. |
aaronc542
Replies: 38
Views: 143333
|
Forum: DDBI Posted: Sat Jan 31, 2009 2:39 pm Subject: Statement...the pain. |
detachResult is not a good compromise because it means you need to have the decoupled version there in any case, but only invoking in on request.
Well I think the idea with detachResult is to hide ... |
Topic: Statement...the pain. |
aaronc542
Replies: 38
Views: 143333
|
Forum: DDBI Posted: Sat Jan 31, 2009 2:06 pm Subject: Statement...the pain. |
In any case, going away from decoupled interfaces needs good reasons, not the opposite.
I think the burden is on us both. I think you have good points and I think I have good points. And I hope w ... |
Topic: Statement...the pain. |
aaronc542
Replies: 38
Views: 143333
|
Forum: DDBI Posted: Sat Jan 31, 2009 11:56 am Subject: Statement...the pain. |
It seems that decoupling:
1) introduces a cyclic import dependency - this is how Mysql trunk is - unless you get around it with an interface
Please point me to the cyclic dependencies.
... |
Topic: Statement...the pain. |
aaronc542
Replies: 38
Views: 143333
|
Forum: DDBI Posted: Thu Jan 29, 2009 8:45 pm Subject: Statement...the pain. |
Ok, I still need to be convinced that Database and Result should be decoupled.
A technical reason? I don't have one.
It's a matter of expectations. As an end user, I see a class named Database a ... |
Topic: Statement...the pain. |
aaronc542
Replies: 38
Views: 143333
|
Forum: DDBI Posted: Thu Jan 29, 2009 8:28 pm Subject: Statement...the pain. |
That's not a "MultiResult" - this is just row by row fetching.
Okay. The fact remains that I don't see how to accomplish this in ddbi or in your fork.
Hmm... well Mysql doesn't allow ... |
Topic: Statement...the pain. |
aaronc542
Replies: 38
Views: 143333
|
Forum: DDBI Posted: Thu Jan 29, 2009 8:22 pm Subject: Statement...the pain. |
Oh! I finally understand Statement now!
Statement.execute executes a query. This query can return multiple rows, but you don't actually retrieve them in this step.
Statement.fetch retrieves a ro ... |
Topic: Statement...the pain. |
aaronc542
Replies: 38
Views: 143333
|
Forum: DDBI Posted: Thu Jan 29, 2009 11:14 am Subject: Statement...the pain. |
Ok, I still need to be convinced that Database and Result should be decoupled.
It seems that decoupling:
1) introduces a cyclic import dependency - this is how Mysql trunk is - unless you get arou ... |
Topic: Statement...the pain. |
aaronc542
Replies: 38
Views: 143333
|
Forum: DDBI Posted: Thu Jan 29, 2009 10:26 am Subject: Statement...the pain. |
Additionally, you don't allow anyone to bind anything without using strong typing, and you don't allow people to bind one argument to a Statement at a time. This means that I wouldn't be able to u ... |
Topic: Statement...the pain. |
aaronc542
Replies: 38
Views: 143333
|
Forum: DDBI Posted: Thu Jan 29, 2009 8:49 am Subject: Statement...the pain. |
Ok, with regards to prepared statements and multi-result sets, can you please mention a database that supports this feature?
You didn't quote me, so I assume you're talking about this:
It isn' ... |
Topic: Statement...the pain. |
aaronc542
Replies: 38
Views: 143333
|
Forum: DDBI Posted: Wed Jan 28, 2009 10:49 pm Subject: Statement...the pain. |
If you had Tango-style variadic functions (that is, a variadic function, as well as a function that takes _arguments and _argptr), I could work with that quite well. While it's hard to support both ... |
Topic: Statement...the pain. |
aaronc542
Replies: 38
Views: 143333
|
Forum: DDBI Posted: Wed Jan 28, 2009 10:41 pm Subject: Statement...the pain. |
Looking through the code, for instance, it's doing string catenation on MysqlDatabase.setXXX methods for binding parameters to the database's current query. Eugh. If you're worried about efficiency, ... |
Topic: Statement...the pain. |
aaronc542
Replies: 38
Views: 143333
|
Forum: DDBI Posted: Tue Jan 27, 2009 10:38 pm Subject: Statement...the pain. |
Ok, I would like to make a decision fairly soon as to whether not this gets merged into the trunk - and if not what API changes need to be made. FYI, I believe this code is fairly stable - I currentl ... |
|