Quick Tips: Doctrine 2 useful commands

Standard

Hi there! Using Zend Framework 2 With doctrine have been nice! But commands for update and validate schema are hard to keep it in mind! So on Root Dir:

Validate Schema: 

./vendor/bin/doctrine-module orm:validate-schema

Create Schema:

./vendor/bin/doctrine-module orm:schema-tool:create

Validate an Update:

./vendor/bin/doctrine-module orm:schema-tool:update –dump-sql

Apply an Update:

./vendor/bin/doctrine-module orm:schema-tool:update –force

Hope It helps some one!

Don’t forget to leave a comment!

MySQL select to file

Standard

So, the idea is to execute a query in MySQL but export the result to a CSV file.
MySQL gives you the statement INTO OUTFILE
Example:

Select * from table_name into outfile ‘/path/to/file.csv

Hope it helps.

select … for update (mysql)

Standard

Hi there!

Using mysql, I saw a awesome feature for concurrency in web applications. The reality is, big information systems needs to sharing data so, database can be a problem sometimes.

Here’s the deal:
I want to read a database record or update him too, without the risk of another database call modify him. Here we can use for update statement.

Simple Example:

You have a table that has for a primary key a int value (like a counter) and later update him:

– Start a Transaction
Start Transaction;

– build your select for the record
select * from table where key_value = ‘value_string’ for update;

–here you can include updare statement
update table ….. etc, etc etc

–just commit transaction to take effect and release table
— consider that other table calls will wait until you call commit statement
commit;

 

the concept is simple and is available on most of PHP frameworks (Zend Framework too)

Hope it helps.
leave a comment…