Hi,
RFE #701 proposes that we should replace the 'Print View' and 'Print View
(with Full Texts)' with a 'Print View' Option which should print out the
CSS of the page only (i.e. whatever exactly is currently displayed on the
page itself).
*I had something in mind about the implementation, but am not able to
figure some details. Any help in this regard would be appreciated. *
*Details of implementation:*
On clicking the 'Print View' link, it will call a click-handler JQuery
function which will get the HTML for the table from the current page,
traverse through the HTML.
Then, make a JSON of relevant information such as SQL Query, No. of Rows,
Column Heads and then arrays of values in each row *for SQL results* and
information such as Table Name, Rows, Type, Collation, Size, Overhead,
Comment for *db_structure.php and tbl_structure.php*.
Now, send a POST Request to a PHP file and get the $response (PMA_Response)
after making a output with good-looking table and other details and the
'Print' Button.
The main problem I am facing here is that, how should I output the
$response ?
I thought of a very-unlike-PMA way:
Open a new tab with JS and add HTML to it as
var w = window.open();
$(w.document.body).html($html);
​But here I guess there will be difficulty to use PMA_Response with its
headers(and do I actually need to use PMA_Response or can I just print the
$html_output recieved from PHP file).
​
or Can I somehow use 'target="print_view" ' and get the $response to be
shown onto it ?
Also, please suggest any flaws/ possible problems that I may have missed or
if you would suggest a different way.
Thanks.
--
*Regards,Deven G. Bansod*
* <f2012316(a)pilani.bits-pilani.ac.in>*
See <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/9672/>
------------------------------------------
Started by GitHub push by madhuracj
[EnvInject] - Loading node environment variables.
Building in workspace <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/>
> git rev-parse --is-inside-work-tree # timeout=10
Fetching changes from the remote Git repository
> git config remote.origin.url git://github.com/phpmyadmin/phpmyadmin.git # timeout=10
Fetching upstream changes from git://github.com/phpmyadmin/phpmyadmin.git
> git --version # timeout=10
> git -c core.askpass=true fetch --tags --progress git://github.com/phpmyadmin/phpmyadmin.git +refs/heads/*:refs/remotes/origin/*
ERROR: Error fetching remote repo 'origin'
hudson.plugins.git.GitException: Failed to fetch from git://github.com/phpmyadmin/phpmyadmin.git
at hudson.plugins.git.GitSCM.fetchFrom(GitSCM.java:735)
at hudson.plugins.git.GitSCM.retrieveChanges(GitSCM.java:983)
at hudson.plugins.git.GitSCM.checkout(GitSCM.java:1016)
at hudson.scm.SCM.checkout(SCM.java:485)
at hudson.model.AbstractProject.checkout(AbstractProject.java:1276)
at hudson.model.AbstractBuild$AbstractBuildExecution.defaultCheckout(AbstractBuild.java:610)
at jenkins.scm.SCMCheckoutStrategy.checkout(SCMCheckoutStrategy.java:86)
at hudson.model.AbstractBuild$AbstractBuildExecution.run(AbstractBuild.java:532)
at hudson.model.Run.execute(Run.java:1744)
at hudson.model.FreeStyleBuild.run(FreeStyleBuild.java:43)
at hudson.model.ResourceController.execute(ResourceController.java:98)
at hudson.model.Executor.run(Executor.java:374)
Caused by: hudson.plugins.git.GitException: Command "git -c core.askpass=true fetch --tags --progress git://github.com/phpmyadmin/phpmyadmin.git +refs/heads/*:refs/remotes/origin/*" returned status code 128:
stdout:
stderr: fatal: Could not read from remote repository.
Please make sure you have the correct access rights
and the repository exists.
at org.jenkinsci.plugins.gitclient.CliGitAPIImpl.launchCommandIn(CliGitAPIImpl.java:1572)
at org.jenkinsci.plugins.gitclient.CliGitAPIImpl.launchCommandWithCredentials(CliGitAPIImpl.java:1360)
at org.jenkinsci.plugins.gitclient.CliGitAPIImpl.access$300(CliGitAPIImpl.java:62)
at org.jenkinsci.plugins.gitclient.CliGitAPIImpl$1.execute(CliGitAPIImpl.java:300)
at hudson.plugins.git.GitSCM.fetchFrom(GitSCM.java:733)
... 11 more
ERROR: Error fetching remote repo 'origin'
[CHECKSTYLE] Skipping publisher since build result is FAILURE
[JSLINT] Skipping publisher since build result is FAILURE
[DRY] Collecting duplicate code analysis files...
[DRY] Finding all files that match the pattern build/logs/pmd-cpd.xml
[DRY] Parsing 1 file in <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/>
[DRY] Successfully parsed file <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build/logs/pmd-cpd.x…> with 20 unique warnings and 0 duplicates.
[DRY] Computing warning deltas based on reference build #9671
[TASKS] Skipping publisher since build result is FAILURE
[ANALYSIS-COLLECTOR] Computing warning deltas based on reference build #9671
Recording plot data
[xUnit] [INFO] - Starting to record.
[xUnit] [INFO] - Processing PHPUnit-3.x (default)
[xUnit] [INFO] - [PHPUnit-3.x (default)] - 1 test report file(s) were found with the pattern 'build/logs/junit.xml' relative to '<https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/'> for the testing framework 'PHPUnit-3.x (default)'.
[xUnit] [ERROR] - Test reports were found but not all of them are new. Did all the tests run?
* <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build/logs/junit.xml> is 44 min old
[xUnit] [INFO] - Failing BUILD.
[xUnit] [INFO] - There are errors when processing test results.
[xUnit] [INFO] - Skipping tests recording.
[xUnit] [INFO] - Stop build.
Hi Dan,
I had a look at
https://github.com/udan11/sql-parser/tree/master/src/Statements
I know that this is work in progress but hope that you will handle also
other statements (specifically, DML statements).
As an example, the current parser handles the CREATE TABLE statement.
--
Marc Delisle (phpMyAdmin)
Hello phpmyadmin,
I had included this feature request
http://sourceforge.net/p/phpmyadmin/feature-requests/1624/
in my GSOC proposal for this year. And I have started its implementation
partly at that point of time only, just to check the feasibility of my
ideas.
Is it ok, if I try and implement this feature now? Or is it being
implemented by someone selected in GSoC?
Thanks,
Tapan