Hi all,
KEY ACCOMPLISHMENTS LAST WEEK
=============================
- I added a separate filter functionality to the tracking report.
Now it is possible to list data definition, data manipulation
or both kinds of statements. Date ranges are supported.
- Secondly I added an user filter. PMA_Tracker tracks the
logged in username. The tracking report page supports
to list all tracked usernames (*), one username or a list
of usernames with ',' as delimiter.
- The export form uses the described filter settings.
- I added a new export option: "SQL dump as file download".
Users can directly download the statements.
- I did some work on the SQL dump page. It shows the SQL query
form now. The lines
CREATE database IF NOT EXISTS pma_temp_db;
USE pma_temp_db;
will automatically added to the dump. The user can copy the whole
dump to the clipboard or execute it by clicking on the submit button.
If he submits it he gets a "temporary" table and can do fine things
with it (use PMA export functionality for example).
- I decided to cut off `dbname` . prefixes from tracked statements.
I used a Perl regular expression for that. Only without these prefixes
the dump export to other databases is possible.
- I merged my Subversion branch with trunk/phpMyAdmin and committed the
changes. Not a big job, but good to see that it worked.
- German translation added.
KEY TASKS THAT STALLED
======================
I tried to use libraries/sqlparser.lib.php within my PMA_Tracker
but it produces a lot of notices.
In addition PMA_SQP_analyze() works only for SELECT queries.
Did not see an easy (time-efficient) way to enable it for my PMA_Tracker
so I reduced the queue priority for this job.
KEY CONCERNS
============
Tracking for whole databases is still open.
TASKS IN THE UPCOMING WEEK
==========================
- Create first prototype of tracking page for databases / set of tables.
- Add handlers for CREATE/DROP INDEX, CREATE/ALTER/DROP VIEW.
- Inform users about deactivated tracking versions (use an icon or
notice message).
Finally I want to call attention to
http://demo.phpmyadmin.net/gsoc-alex/
Its a copy of my svn branch (thanks to Michal).
Best regards and have a nice WE
Alexander
Hi all,
I am using the following piece of code in my java script file to
retrieve the ids of checked check boxes from a div named "list".
I am appending the arrays of ids in the url using the "location.href =
location.href+"?array=true&0="+course;" etc. I can see the array in the
address bar but using $REQUEST or $GET does not help me fetch the values.
Please have a look at my code and help me as soon as possible. This problem
has already taken a lot of my time.
Thanx in advance.
function ApplySelectedChanges()
{
var Checked_tables_ids = new Array();
var div = document.getElementById("list");
var input_fields = div.getElementsByTagName('input');
var x = input_fields.length;
var i;
var append_string;
for (i=0; i<x; i++) {
if (input_fields[i].type == 'checkbox') {
if (i == 0) {
append_string = "?abc="+1234+"&";
} else {
append_string += "&";
}
Checked_tables_ids[i] = input_fields[i].id;
append_string += i+"="+input_fields[i].id;
}
}
location.href += append_string;
}
Hi,
I was doing work, and all the sudden I got this error message when I tried
to log in:
Error
>
> SQL query:
>
> SET CHARACTER SET 'utf8';
>
> MySQL said:
>
> #1064 - You have an error in your SQL syntax near ''utf8';' at line 1
>
I tried restarting MySQL server, but it did not help. I am supposing it
should not be a big problem. Hope someone can help me out!
Thanks!
--------------------------------------------------
Best regards,
Zeeshan Mughal
Email: zeeshanmughal(a)ieee.org
Web: http://www.zixan.info
Hi all,
does anybody know if there exist a config var in PMA that define the
style of generated tablenames ? Is there a rule for programmers ?
When I edit the structure of a field, PMA produces only "tablename"
as table name. When I insert data it produces "dbname" . "tablename".
Example:
ALTER TABLE `table1` CHANGE `field3` `field3` INT( 14 ) NOT NULL ;
INSERT INTO `test`.`table1` (
`field1` ,
`field2` ,
`field3`
)
VALUES (
'1', '2', '3'
);
Thank you
Alex
Hi all,
here is my report:
KEY ACCOMPLISHMENTS LAST WEEK
=============================
- I got my own SVN branch phpmyadmin/branches/gsoc/alex/phpMyAdmin
(thanks to Marc for the permissions).
- SVN copy from trunk/phpMyAdmin was unexpected not easy for me, because
I made the mistake to use http instead of https and so I got the error
message "502 BAD GATEWAY". First I thought it was a problem with my
subclipse plugin but then I found the hint about the protocol and then
the copy process worked fine.
- Switched from Eclipse 3.2 to NetBeans IDE 6.7. PHP eclipse nerved
me because it was sometimes unstable and did not open some files.
NetBeans seems to be more optimized for PHP development.
- Did some work on my code too :)
Here is a summary of my committed changes to SVN branch:
+ First tracking mechanism patch applied.
+ Problems causing PHP notices solved.
+ Some useless PMA_DBI_select_db() calls removed.
+ Bug: after renaming a table the list of tracking versions is broken
(Fixed)
+ Using PMA_query_as_controluser where it is possible.
+ New tab "Tracking" for the table view added.
+ A little bit PMA_Tracker code refactoring.
+ SQL dump of pma_tracking to scripts/create_tables.sql added.
+ Localization introduced, using string vars in english-utf-8.inc.php
for outputs.
+ Short php tags and short print instruction removed how it is
recommended in PEAR coding standards.
(Thanks to Michal for the helpful hints).
KEY TASKS THAT STALLED
======================
Parsing for additional commands like ALTER VIEW etc.
First I want to read and tryout PMA SQL parse functions.
It makes more sense to optimize the parser of PMA_Tracker before
adding new types of SQL statements.
KEY CONCERNS
============
Tracking functionality for whole databases. At current status a user has
to select every single table that he wants to track.
Is it possible to forward prepared SQL dump code to the export script of
PMA ? When yes I could use it to deliver more export types than SQL dump
and SQL execution.
TASKS IN THE UPCOMING WEEK
==========================
- Make me familiar with the PMA SQL parser library / functions.
- Try to use PMA SQL parser library.
- I think it would be a good idea to track the usernames too. I will add
this attribute to the tracker log and build a filter to the tracking report.
Best regards and have a nice WE
Alexander
Hi all,
I tried to make a column in the table 'student_course' foreign key using
the query
"ALTER TABLE student_course ADD FOREIGN KEY (Course_Id) REFERENCES
course(Id)";
I also got the success message that the query has been executed
successfully.
But when I tried the query "SHOW TABLE STATUS FROM db_name LIKE
'student_course' ;"
to get foreign key information from the comments, the comments were empty.
I also used the function in libraries/relation.lib.php PMA_getForeigners()
but the result is empty.
I think the foreign key is not being created properly so tell me the correct
syntax for creating the foreign key.
I need help ASAP.
Regard,
Zahra.
Hi,
I am creating a configuration file to allow sysadmins to enable/disable
permanently stored settings, or simply the entire permanent storage feature
itself. Would it be a good idea to include these options in an already
existing file? If so, which file?
Or, I should create a new file (which is according to plan)? The file is
currently in the root dir, and will be included in *
libraries/header.inc.php.
*Thanks!
--------------------------------------------------
Best regards,
Zeeshan Mughal
Email: zeeshanmughal(a)ieee.org
Web: http://www.zixan.info
Hi all,
I finished my part for Googles mid term evaluation.
Please feel free to try out my code, you will find it as attachment.
KEY ACCOMPLISHMENTS LAST WEEKS
==============================
Finished following functionalities:
- Tables can be tracked by mechanism now
- System logs data definition and data manipulation statements:
INSERT, UDATE, DELETE, TRUNCATE, ALTER TABLE, RENAME TABLE
- Tracking can be activated for a subset of these commands
- Tables with active tracking are marked with an "eye" icon.
- Simple versioning system. User can create new tracking versions.
- Deactivation and Reactivation of tracking jobs is possible.
- Simple schema (structure) snapshot, uses SHOW FULL COLUMNS FROM and
SHOW INDEX FROM
- When user is selecting a tracked table, a notice will printed out
- Switching between tables within a database is possible
- Tracking report is available. Contains dates and statements.
- Simple export form added, it can be used for undo action.
(structure only|data only|both) -> (SQL dump|SQL execution)
- Date_from - Date_to range selection for exports added.
KEY CONCERNS
============
I want to teach the tracker more SQL statements:
ALTER VIEW, CREATE INDEX, DROP INDEX
Tracker should handle whole databases.
TASKS IN THE UPCOMING WEEK(S)
=============================
- Evaluate your feedback to my PMA_Tracker
- Localize english-only strings
- Add more export possibilities
- Snapshot comparison would be fine
- Prettify some layout elements
I hope you are happy about the new Tracker, please send me your
feedback. I need it for a successful progress.
Thank you very much and my best regards
Alexander Rutkowski