Aritz Galdos aritzg
milendyankov
/ DXP70-runSQL.groovy
Last active
May 12, 2023 11:20
Running SQL queries from liferay's groovy console
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import java.sql.Connection; | |
| import java.sql.ResultSet; | |
| import java.sql.ResultSetMetaData; | |
| import java.sql.SQLException; | |
| import java.sql.Statement; | |
| import com.liferay.portal.kernel.dao.jdbc.DataAccess; | |
| Connection con = null; | |
| Statement st = null; |
slemarchand
/ exec.groovy
Created
October 10, 2011 00:26
Execute a shell command from Liferay control panel ("Server Administration -> Script") and get ouptut
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| def exec = { cmd -> def p = cmd.execute(); out.leftShift(new SequenceInputStream(p.getErr(), p.getIn())) } | |
| exec('df -h -a -i -T') |