<div dir="ltr"><div class="gmail_default" style="font-family:'courier new',monospace"><br></div><div class="gmail_extra"><br><br><div class="gmail_quote">2014-05-30 22:45 GMT+08:00 Atul Pratap singh <span dir="ltr"><<a href="mailto:atulpratapsingh05@gmail.com" target="_blank">atulpratapsingh05@gmail.com</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div class=""><div class="h5">On May 30, 2014 6:15:51 PM GMT+05:30, Edward Cheng <<a href="mailto:c4150221@gmail.com">c4150221@gmail.com</a>> wrote:<br>
>2014-05-30 19:08 GMT+08:00 Atul Pratap Singh<br>
><<a href="mailto:atulpratapsingh05@gmail.com">atulpratapsingh05@gmail.com</a>>:<br>
><br>
>> Edward,<br>
>><br>
>> On Fri, May 30, 2014 at 2:02 PM, Edward Cheng <<a href="mailto:c4150221@gmail.com">c4150221@gmail.com</a>><br>
>wrote:<br>
>><br>
>>> I'm writting AJAX part now.<br>
>>> Have a look at this commit:<br>
>>><br>
>>><br>
><a href="https://github.com/WhaleWatching/phpmyadmin/commit/a382070ee42b72474842d20e805ae2a087e4b8c7" target="_blank">https://github.com/WhaleWatching/phpmyadmin/commit/a382070ee42b72474842d20e805ae2a087e4b8c7</a><br>
>>> See my comment on it:<br>
>>> For get response data I add a param, run between requestHandler<br>
>and<br>
>>> responseHandler.<br>
>>><br>
>><br>
>> As I understand, this mid-handler is your responsehandler that<br>
>> subsequently makes a call to the generic responsehandler of ajax.js.<br>
>So it<br>
>> is not a real custom handler (that requests + handles response<br>
>independent<br>
>> of the generic one)<br>
>><br>
>> Also, as I understand from your code, the proposed console would<br>
>store a<br>
>> log of run queries and on running a query from console, the results<br>
>will be<br>
>> displayed in the same way as happens when running a query from SQL<br>
>tab.<br>
>> Right ?<br>
>><br>
>Sometimes people'll run queries on console while they're browsing<br>
>other pages, not SQL tab.<br>
><br>
>><br>
>> As per this understanding, you need a real custom handler because<br>
>> executing SQL and handling its response in PMA involves many custom<br>
>checks<br>
>> and calls not only at response stage but also at request stage. For<br>
>ex:-<br>
>> -<br>
>> <br>
>> checkSqlQuery()<br>
>><br>
>Sorry I don't get this :), just run it if some errors we<br>
>can wait response to tell users<br>
><br>
>> - bookmark handling<br>
>> <br>
>><br>
>Bookmark handling will use another functions and send another<br>
>AJAX request, old way is not good enough.<br>
><br>
>> -<br>
>> <br>
>> reloading navigation for certain queries<br>
>><br>
><br>
><br>
>reloading navigation, global handlers take this job is better<br>
><br>
>> - refreshing main panel for certain queries<br>
>><br>
>Do you main #page_content ?<br>
><br>
>> - triggering grid edit for results<br>
>> etc. see in sql.js near $("#sqlqueryform.ajax").live('submit',<br>
>function<br>
>> (event) {<br>
>><br>
>I have noticed this handler.<br>
><br>
>><br>
>> Or did you plan to duplicate above checks and calls into your<br>
>midhandler?<br>
>> <br>
>><br>
>No, midhandler just get result and append to console<br>
>corresponding message(e.g. shows under query string "SELECT<br>
>* FROM `mysql`.`user`")<br>
><br>
</div></div>Ok, so you plan to display query results in the console itself. I misunderstood some details from your proposal and thought that query results will be displayed in the main panel and query logs in the console. My previous reply was according to that understanding. Also, please tell me about the following details..<br>
<br>
- I am still unclear about warnings etc. that we display for certain queries like DROP, will we warn the user when executing such queries from console? Or would it be totally like mysql console?</blockquote><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<br>
- Also in case user puts a USE query in console, do we change the selected database and update the navigation and main panel? Same will be required for ALTER queries etc.. Here I am pointing to the overall relation and synchronization between console and rest of the application.</blockquote>
<div class="gmail_default" style="font-family:'courier new',monospace">These features can be added later, before execute there's</div><div class="gmail_default" style="font-family:'courier new',monospace">
PMA_console.execute(), after execute there's midHandler.</div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<br>
- And would you store the sql query logs only or the sql results history as well? I think as the results may change at any time, storing queries only should be fine.<br></blockquote><div class="gmail_default" style="font-family:'courier new',monospace">
Yeah, data may change any time, but we still can store</div><div class="gmail_default" style="font-family:'courier new',monospace">results, users know when a query should be re executed.</div><div class="gmail_default" style="font-family:'courier new',monospace">
<br></div><div class="gmail_default" style="font-family:'courier new',monospace">Alright, I'll change my design, store queries only, with</div><div class="gmail_default" style="font-family:'courier new',monospace">
bookmarks and history.</div><div class="gmail_default" style="font-family:'courier new',monospace"><br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<span class=""><font color="#888888"><br>
<br>
<br>
--<br>
Atul Pratap Singh<br>
<br>
------------------------------------------------------------------------------<br>
Time is money. Stop wasting it! Get your web API in 5 minutes.<br>
<a href="http://www.restlet.com/download" target="_blank">www.restlet.com/download</a><br>
<a href="http://p.sf.net/sfu/restlet" target="_blank">http://p.sf.net/sfu/restlet</a><br>
_______________________________________________<br>
Phpmyadmin-devel mailing list<br>
<a href="mailto:Phpmyadmin-devel@lists.sourceforge.net">Phpmyadmin-devel@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel" target="_blank">https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel</a><br>
</font></span></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr">Edward Cheng<div><br></div></div>
</div></div>