Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>EDIT: This is a more in depth example based on use of the connection library you seem to be using. Please note, some of this is javascript psuedo code. Things like adding objects to the resultsArray are clearly not complete, the only thing I took time to make sure was correct is the "flow of logic" as it pertains to callbacks. Everything else is for you to implement. In order to support multiple calls to the same callback function and maintain state from call to call, the best way is to wrap the set of callbacks in a closure. This allows the callbacks to share some state with the main event loop. This allows you to pass arguments to the callbacks, without actually having to pass them as arguments, much like class variables in c++, or even globals in javascript, but we haven't poluted the global scope :)</p> <pre><code>function queryDataBase(query) { //wrap the whole query in a function so the callbacks can share some //variables with similar scope. This is called a closure int rowCounter = 0; var dataRowsFromStep2; var resultsArray = {}; connection.query(query, dataBaseQueryStep2); function dataBaseQueryStep2(err, rows) { //do something with err and rows dataRowsFromStep2 = rows; var query = getQueryFromRow(dataRowsFromStep2[rowCounter++]);//Always zero the first time. Might need to double check rows isn't empty! connection.query(query, dataBaseQueryStep3); } function dataBaseQueryStep3(err, rows) { //do something with err and rows if(rowCounter &lt; dataRowsFromStep2.size) { resultsArray.add(rows);//Probably needs to be more interesting, but you get the idea //since this is within the same closure, rowCounter maintains it's state var query = getQueryFromRow(dataRowsFromStep2[rowCounter++]); //recursive call query using dataBaseQueryStep3 as it's callback repeatedly until //we run out of rows to call it on. connection.query(query, dataBaseQueryStep3) } else { //when the if statement fails we have no more rows to run queries on so return to main program flow returnToMainProgramLogic(resultsArray); } } } function returnToMainProgramLogic(results) { //continue running your program here } </code></pre> <p>I personally like the above logic better than the syntax async produces... I believe the heart of your problem rests in your nested calls to async, and the fact that ASYN itself, runs the series of functions asynchronously, but in order(confusing I know). If you write your program like this, you won't have to worry about it!</p>
    singulars
    1. This table or related slice is empty.
    1. POBest method to string together variety of DB calls in Node js
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USChrisCM
    1. USChrisCM
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POBest method to string together variety of DB calls in Node js
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COYeah I'm aware of these but I've been using async to get around them and it's been working fine until i used concat i guess. I will try to reorganize it and see if i can figure it out.. Thanks
      singulars
      1. PO
      1. USTolga E
    2. COI've been playing with your code, I'm very suspect of your bracketing...
      singulars
      1. PO
      1. USChrisCM
    3. COThis is great, thanks! I think i can follow the logic here, and it makes sense.. Much simpler the async hell i put myself into.
      singulars
      1. PO
      1. USTolga E
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload