Perhaps you could make a wrapper for the JSON. Instead of using this:

We could use this


for multiple queries we could have another wrapper


An example of criteria:


Criteria is very useful for WHERE clauses!

Now an example of usage for the criteria above :

Quote:

this concept is very nice

+1 Trabis!

I'd also like the core team to investigate the '10%' that can't use the current API to add a couple of methods to support module install/update. Things like adding/dropping tables, updating columns (ie changing type, size, etc). While I'm at it I'll request a method to handle SELECT 'summaries' (SUM, MIN, MAX, AVG, etc) in a more straight forward method. Currently this has to be done using setGroupby, which to me seems non-intuitive.

Thank you for the information Trabis.

That is a much more elegant solution. And probably way faster and much easier.
But what you are showing me is beyond my current experience but I would love to see what the class looks like for that...

I read this on my phone as was thinking through it in class and now re-reading it I am confused. I was not aware you could call something like that.



This is syntax I have not seen before.

The $sql[] is obviously adding a record onto an array.
Are from and where both methods of $xoopsSql and you are chaining them together?

For comparison sake lets say I have these classes:


Then to use this very basic class how I am used to:



I am assuming the above code I quoted from you is chaining so I am assuming then that the following code would be the equivalent of the code just posted?



I am assuming that if indeed this is chaining that you can only chain methods and they have to be from the same class?

MUCH nicer and learn something new.
(Think .NET VBASIC chains commands like that if I remember right but seems like you could only do it with methods. You couldn't do a simple assignment of a value to a variable in the chain. Assuming the same here.)

If I am wrong about this being chaining could you please give a basic class and show me how that is used?

Thanks!

Quote:

zyspec, since I am looking into developing a new class for this it should be simple to add this sort of thing. Can you give very simple very short examples of what you have to do now and what you would like to do?

I can NOT promise it will end up in the final code but if it is there and the core programmers like it I can't see it not making it. It does make sense and should be very little coding beyond what is already being done.

I can see these as being additional fields in the above mentioned "selectRecord" class. (For the select stuff anyhow)

I can also look into providing other commands as well but it looks like you want more "maintenance" items to update the structure of the database. It does make sense since we are basically building a wrapper to allow use of the same command to a series of databases.

@trabis

I looked up chaining and I think I have it down..

So yes, your idea would be much simpler. So away I go...

Rodney

Yes some functions needed for select, insert, update, dump , ...

eg: i see some functions in publisher module that need to be revised to make it like Trabis wrote.


it means select, from, where should be separated.

@trabis
Where can I find the code for criteria and other database API type stuff?

I am trying to work your idea out but it is new to me so I am sorting out the correct method to do so. As it looks now I believe I need to build a new class.

If I put everything into this new class then you can call a single sql query with:


This will set the table to "table" the columns to "*", order to "T_ID.

If called in this manner I will clear the contents of the variables after the select is over.

So then this would work fine:


I can also look for a boolean value in the command to NOT clear the variables so then you could call this last query in this fashon. (Lets add one more deletion)



If I were to try your suggestion for multiple queries I could then have a couple commands that could stack queries as well as perform transactions easily:

stack queries:


transaction


The SQL class would be included as part of the database structure and I would extend the SQL class in the database specific file. So the sql class file would perform most of what the database class file does now.

This is the structure I am working on right now.
Note that calling a single query will execute the command and return a response.

Select statements will actually not be allowed in these stack or transaction commands. If you want to use a select in a transaction you will have to do each step like this:



But I will be using prepared statements in every case.
I am still tinkering with it but this is the structure that appears to work and I will be coding it up over the next couple days and try to have it ready for testing with 2.5.5 within the next 7 days.

(I have to figure out the preload stuff before I can get it working with 2.6.0. I still am not sure what the heck a preload is...)

Ok I am in the process of trying to code this and I have a slight glitch I am hoping someone can help out with..

I am trying out a "delete" command and I currently have it running fine with this format:


This works well enough I can use it for pretty much every command.

I am trying to duplicate the above mentioned code example to support multiple commands:


But in my case I am using:


Problem is when I use print_r to view the contents of $sqlList I have:



So it looks like the Array is storing the reference to the object instead of a copy of the object. So how can I do this and make it work?

I posted a message on stack overflow hoping to get a quick answer but I am hoping someone out here can help me quicker.

Quote:

For chaining, instead of using:


Use: