[Bond-users] Last Post

[Dru]

Colin Close wrote:
> Hi Dru,
> 
  > I have many questions to ask about Bond I hope you have plenty of 
patience!!
> There are two that are burning in my mind.
> 
> The first is if Bonddb carries on and executes SQL code irrespective of 
> whether it understands it What happens?
> Clearly the message is ultimately delivered via a wrapped pgexec so 
> results are returned but what happens to them.

Yes it will always execute what is passed to it, whether it understands 
it or not.

> The second is that if results can be somehow returned what does Bond 
> need to know to be able to insert them in a field.

Inserting records you mean? For inserting new records bond needs to 
understand the sql statement to know what tables are in the from statement.

> If my initial read of the code (very superficial) it seems there has to 
> be a database object both in the server db and Bonddb so Bond doesn't 
> seem to be a full client - server arrangement but has an intermediate 
> stage as in Bonddb which appears to load data before Bond itself can 
> really do anything.  I can see no reason why Bonddb shouldn't be told 
> that an object will come into existence and what data type it will be 
> returned (although all data will be returned as text or binary).  
> Including the type would be advantageous since that would leave open the 
> potential for conversion. I suppose one could take advantage of Bonddbs 
> existing mechanisms and create a dummy table in the server-db with no 
> data and perhaps assign the SQL to that table. I'm kind of groping for 
> understanding here.

bonddb is a wrapper around the postgresql client libraries that make 
dealing with things like inserting/deleting/updating records a lot 
easier. it doesnt do a whole lot of stuff. bonddbfield.c/h is the 
individual descriptions on the fields returned from the select query and 
what there datatypes are.

> I'll give the developer docs a read and try and improve the clarity of 
> my questions.
> BTW some of the code comment caused considerable amusement 'specially 
> the bit with the shopping list!!!

lol. yes. it even got a mention on slashdot article for bad commenting 
styles.

> 
> Best
> 
> Colin Close
> 
> 
> Dru wrote:
>>  
>> Hello. sorry in delay in replying. I had written a large email to 
>> previous email but my comptuer died half way though and only just kind 
>> come back online.
>>
>> If the parser fails it still goes to the SQL server. it doesnt stop the 
>> sql running just warns about it.
>> Have you got any example sql + xml that i can test from my end if it 
>> doesnt work?
>>
>> If you can email me a username and password I can give you access.
>>
>>
>> Colin Close wrote:
>>   
>>> Hi Dru,
>>>
>>> Seems I missed the point on livesql I have just found the example sorry 
>>> for the misunderstanding.  Is there any way of sending raw SQL to the 
>>> server without having to go through the parser? Does it get sent anyway 
>>> if the parser fails?
>>> The libpq wrappers seem to indicate this but my understanding of C is 
>>> alas fairly lowly. I have a friend who very proficient in C who will 
>>> help by adding any extra functionality required. This would of course be 
>>> contributed back.
>>> In order to determine what I need I have to understand the way the 
>>> software is structured so I can give him some idea of what I require. 
>>> For this I need the developer docs which are not in the download. I 
>>> tried to get them from the svn repositry but all I get is the directory 
>>> structure all the files are giving access denied presumably because of 
>>> lack of permissions. Do you think you could fix the repositry so I can 
>>> download them.
>>>
>>> Thanks
>>>
>>> Colin Close
>>>
>>>
>>> _______________________________________________
>>> Bond-users mailing list
>>> Bond-users at hcoop.net
>>> http://hcoop.net/cgi-bin/mailman/listinfo/bond-users
>>>     
>>
>>   
> 
> 
> _______________________________________________
> Bond-users mailing list
> Bond-users at hcoop.net
> http://hcoop.net/cgi-bin/mailman/listinfo/bond-users


-- 
Andrew Hill
treshna Enterprises Ltd
Tel: 03 366 3649
Cel: 021 660 819
Web: www.treshna.com
IT Consultancy - Websites - Database development - Computer tech support