Skip to content

Instantly share code, notes, and snippets.

View CorneAussems's full-sized avatar
🎯
Focusing

Corné Aussems CorneAussems

🎯
Focusing
2 followers · 0 following
View GitHub Profile
@CorneAussems
CorneAussems / DLVerifyFiles.groovy
Last active November 1, 2018 09:53
Verify Liferay Document Library files exist on disk
import com.liferay.document.library.kernel.store.*;
import com.liferay.portal.kernel.util.*;
import com.liferay.portal.kernel.service.*;
import com.liferay.portal.kernel.dao.orm.*;
import com.liferay.portal.kernel.util.HtmlUtil;
import com.liferay.document.library.kernel.util.*;
import com.liferay.document.library.kernel.lar.*;
import com.liferay.document.library.kernel.service.*;
import com.liferay.document.library.kernel.model.*;
import com.liferay.document.library.kernel.service.*;
@CorneAussems
CorneAussems / tunneling.servlet.shared.secret.groovy
Last active July 19, 2018 17:41
Create Liferay Tunnel tunneling.servlet.shared.secret Hex
/**
https://dev.liferay.com/en/discover/portal/-/knowledge_base/7-0/enabling-remote-live-staging
tunneling.servlet.shared.secret=6162636465666768696a6b6c6d6e6f70
tunneling.servlet.shared.secret.hex=true
**/
import com.liferay.portal.kernel.security.pwd.*
import com.liferay.portal.util.*
try {
@CorneAussems
CorneAussems / TUnnel
Created July 19, 2018 12:07
Get Liferay Tunnel
import com.liferay.portal.kernel.security.pwd.*
try{
String algorithm = PasswordEncryptorUtil.getDefaultPasswordAlgorithmType();
out.println("Algorithm"+algorithm);
String pwdEnc = PasswordEncryptorUtil.encrypt("TEXTTEXTTEXT");
out.println("Password encrypted:"+pwdEnc);
String hexPwd = org.apache.commons.codec.binary.Hex.encodeHexString(pwdEnc.getBytes());
@CorneAussems
CorneAussems / TUnnel
Created July 19, 2018 12:07
Get Liferay Tunnel
import com.liferay.portal.kernel.security.pwd.*
try{
String algorithm = PasswordEncryptorUtil.getDefaultPasswordAlgorithmType();
out.println("Algorithm"+algorithm);
String pwdEnc = PasswordEncryptorUtil.encrypt("TEXTTEXTTEXT");
out.println("Password encrypted:"+pwdEnc);
String hexPwd = org.apache.commons.codec.binary.Hex.encodeHexString(pwdEnc.getBytes());
@CorneAussems
CorneAussems / skype-query.sql
Last active June 27, 2018 06:52
Skype SqlLite Database Queries
cd /Users/corne/Library/Application\ Support/Skype/corne.aussems/
cp main.db main-bak.db
sqlite3 main-bak.db
/** pretty print **/
sqlite3 -separator $'\t' -header -cmd '.mode columns' main-bak.db ;
/** You want to know what you wrote in each Conversation last 2 days **/
SELECT displayname,from_dispname, datetime(Messages.timestamp, 'unixepoch') AS date, body_xml
FROM Messages LEFT JOIN Conversations on Messages.chatname = Conversations.identity
WHERE Messages.timestamp BETWEEN strftime('%s','now', '-2 days') AND strftime('%s','now')
@CorneAussems
CorneAussems / Liferay Groovy output file
Last active May 15, 2018 19:44
Liferay Groovy output Web Content Folder Tree
#############
import com.liferay.portal.kernel.service.*;
import com.liferay.portal.kernel.dao.orm.*;
final def SCRIPT_ID = "MYSCRIPT"
outputFile = new File("""${System.getProperty("liferay.home")}/logs/out-${SCRIPT_ID}.txt""")
out.println(outputFile.text)
@CorneAussems
CorneAussems / JournalFolderTree.groovy
Created March 21, 2018 16:46
Liferay DXP JournalFolderTree with file download groovy
import com.liferay.portal.kernel.util.PortalUtil;
import com.liferay.portal.kernel.service.ServiceContext;
import com.liferay.portlet.journal.service.*;
import com.liferay.journal.service.impl.*;
import com.liferay.journal.service.*;
import com.liferay.portal.kernel.service.*;
import com.liferay.portal.kernel.dao.orm.*;
final def SCRIPT_ID = "MYSCRIPT1"
outputFile = new File("""${System.getProperty("liferay.home")}/scripting/out-${SCRIPT_ID}.txt""")
@CorneAussems
CorneAussems / .groovy
Created November 22, 2017 23:34
Groovy Document and Media File: remove Guest and set SiteMember permission on all documents
import java.util.ArrayList
import java.util.Iterator
import java.util.List
import java.util.ListIterator
import com.liferay.portal.service.ResourcePermissionLocalServiceUtil
import com.liferay.portal.service.RoleLocalServiceUtil
import com.liferay.portal.model.ResourceConstants
import com.liferay.portal.model.ResourcePermission
import com.liferay.portal.model.Role
@CorneAussems
CorneAussems / Liferay Groovy update Agreed To Terms Of Use
Last active November 20, 2017 22:05
//import com.liferay.portal.service.ServiceContext;
//import com.liferay.portal.util.*;
//import com.liferay.portal.service.*;
//import com.liferay.portal.service.impl.*;
import com.liferay.portal.kernel.service.ServiceContext;
import com.liferay.portal.kernel.util.*;
import com.liferay.portal.kernel.service.*;
import com.liferay.portal.kernel.service.impl.*;
@CorneAussems
CorneAussems / regex
Created October 18, 2017 08:38
Anonymize BE employee import
<INTERN_NUMMER>(.*)</INTERN_NUMMER>\n^(.*)<ACHTERNAAM>Diwali</ACHTERNAAM>\n^(.*)<VOORNAAM>Sunder</VOORNAAM>\n^(.*)<GESLACHT>V</GESLACHT>\n^(.*)<TAAL>NL</TAAL>\n^(.*)<EMAIL>(.*)</EMAIL>
<INTERN_NUMMER>\1</INTERN_NUMMER>\n\2<ACHTERNAAM>Diwali</ACHTERNAAM>\n\3<VOORNAAM>Sunder</VOORNAAM>\n\4<GESLACHT>V</GESLACHT>\n\5<TAAL>NL</TAAL>\n\6<EMAIL>\1@hema.whatever</EMAIL>