How to Run Integration Tests on Grails

Problem
How do I run integration tests on Grails?

Solution
Run the following command on the console:

grails test-app integration:integration

How to Drop All User Tables in Oracle

Problem
You want to remove/drop all user tables from on Oracle Database.

Solution
1. Run the following SQL query

select 'drop table '||table_name||' cascade constraints;' from user_tables;

2. Run the SQL query generated after the 1st step above.

How to Show Hibernate SQL Statements in Grails

Problem
You want to see all Hibernate SQL statements when using grails.

Solution
You must have these line of codes inside your conf/Config.groovy configuration file.

log4j = { debug 'org.hibernate.SQL' trace 'org.hibernate.type' }

The SQL statements will appear on the standard output console.

Update MySQL User Password

SET PASSWORD FOR 'root'@'localhost' = '';

The SQL script above sets the password for the user root to blank.
The script will run successfully if the current user has UPDATE privilege on the MySQL database.

How to Import Existing GIT Project to BitBucket

Here are the steps to import your existing GIT project to BitBucket. This tutorial focuses on local GIT project. If you plan to import project from your hosting site, checkout this Atlassian article instead.

1. Login to to your BitBucket account.

2. Create a new repo.

Click Create button.

Click Create repository button to save the new repo.

3. Open your Terminal application to the project's path.

cd /path/to/my/repo

3.1. Remove any existing remote (in this case the remote name is origin). Skip this if your project has no remote yet.

git remote rm origin

4. Point your project to the new BitBucket repo.

git remote add origin https://mybitbucketusername@bitbucket.org/mybitbucketusername/myexistingproject.git

5. Push the project and all its refs.

git push -u origin --all

6. Push tags in the project.

git push -u origin --tags

Done. :)

Maximize an ImageView on Android

Problem
How to maximize an ImageView on Android while keeping the aspect ratio? There's a lot of combinations available on the Internet but the following code alone was able to solve my problem.

Solution

<ImageView android:layout_width="0dp" android:layout_height="fill_parent" android:layout_weight="1" android:scaleType="fitCenter" />

Important Note
Make sure the ImageView is inside a LinearLayout for the android:layout_weight to work.

Source
Comment of Mohsen Afshin on stackoverflow.com

phpMyAdmin Installation on Ubuntu using Terminal

Had to install phpmyadmin on Ubuntu 12.04

Just used the following command:

sudo apt-get install libapache2-mod-auth-mysql phpmyadmin

When asked to choose a Web server, I chose

[*] apache2

Clicked Enter when asked to create the database called dbconfig-common

Entered password for MySQL root, phpMyAdmin.

The installation completed but I was not able to open the link:
http://127.0.0.1/phpmyadmin/

Had to edit /etc/apache2/apache2.conf and added the following to the end of the file:

Include /etc/phpmyadmin/apache.conf

Restarted apache using

sudo /etc/init.d/apache2 restart

Finally, opened http://127.0.0.1/phpmyadmin/ again and it worked at last.