Agile - Linux, Web & Open Source

Using the LIKE keyword with mysql CREATE TABLE you can easily copy the structure of a table.

mysql> CREATE TABLE new_table LIKE my_table;

This will create a table the "new_table" which will have exactly the same structure of "my_table".

When importing a large table, the table is locked and it is not possible to use a "SELECT COUNT(*) FROM Table;", to follow the import progress use:

mysql> use information_schema
mysql> SELECT TABLE_NAME, TABLE_ROWS FROM `information_schema`.`tables` WHERE `table_schema` = 'YOUR_DB_NAME';

To find out when the last insert happened use:

mysql> use information_schema
mysql> SELECT table_schema,table_name,max_time FROM information_schema.tables t1 JOIN   (select MAX(t2.create_time) AS max_time FROM    information_schema.tables t2 WHERE table_schema ='YOUR_DB_NAME') AS t3   ON t1.create_time = t3.max_time;

First estimations are estimations, and will always be just an estimation.

Using hours to estimate a work to do is very complicated and very subjective from person to person.

I instead use Relative Points, this is comparing the effort for finishing a feature based on past similar feature and give them Effort points that represent the effort to achieve them till done.

How to start:

To find out the difference between two files from two remote servers using SSH, e.g use:

diff <(ssh -A root@server_ip_1 'cat /etc/php5/cli/php.ini') <(ssh -A root@server_ip_2 'cat /etc/php5/cli/php.ini')

Note, you need to add your keys using ssh-add

The Page Model Pattern

The Page model is a pattern that maps a UI page to a class, where for example a page could be a HTML page. The functionality to interact or make assertions about that that page is captured within the Page class. Then these methods may be called by a test. So ultimately we are introducing a gatekeeper to the GUI of a page.

Why using the Page Object Pattern?

A Page Object simply models these as objects within the test code. This reduces the amount of duplicated code and means that if the UI changes, the fix need only be applied in one place.

References:

• http://blog.josephwilk.net/cucumber/page-object-pattern.html
• http://code.google.com/p/selenium/wiki/PageObjects