paulrohrbeck’s gists

## delete-translation-projects.groovy
import com.adobe.cq.projects.api.*;
import org.apache.jackrabbit.api.security.user.*;

ProjectFilter pf = new ProjectFilter();
Boolean dryRun = true;

List<String> templates = Arrays.asList("/libs/cq/core/content/projects/templates/create-translation-project");
pf.setProjectTemplates(templates);

ProjectManager pm = resourceResolver.adaptTo(ProjectManager.class);

## aem_find_i18n_strings.txt
# Run in parent Maven project to find all:
grep -riohE '\$\{(.)* ?@ ?i18n\}' .

# Example result: ${'Filter' @ i18n}

## aem_querybuilder_snippets
Find pages with CUG on it:

path=/content
type=cq:PageContent
property=cq:cugEnabled
property.value=true

## mysql_find_duplicates
# Delete directly:
# -------------------------------------

DELETE
n1
FROM
`tableName` n1, `tableName` n2
WHERE
n1.id = n2.id AND
n1.lastmodifieddate = n2.lastmodifieddate AND

## adobecq_find_modified_nodes
path=/content
group.p.or=true

group.1_relativedaterange.property=jcr:lastModified
group.1_relativedaterange.lowerBound=-14d
group.1_relativedaterange.lowerOperation=>=
group.1_relativedaterange.upperBound=0

group.2_relativedaterange.property=jcr:created
group.2_relativedaterange.lowerBound=-14d

## download_images.py
#!/usr/bin/python

"""
Download Images
"""

import optparse
from bs4 import BeautifulSoup
import requests
from urlparse import urlsplit

## typo3_list_headlines
### Sitebar ###
marks.sitebar = COA
marks.sitebar {
    10 = CONTENT
    10 {
        table = tt_content
        select.where = colPos = 0
        select.languageField = sys_language_uid
        renderObj = COA
        renderObj {

## typo3_optional_select
'feld' => array(
    'exclude' => 0,
    'label' => 'Feld Name',
    'config' => array(
        'type' => 'select',
        'items' => Array (
                Array("",0),
            ),
        'foreign_table' => 'tx_deinetabelle',
        'size' => 1,

## aem_filter_tag
<tab4
    jcr:primaryType="nt:unstructured"
    title="Filter"
    xtype="panel">
    <items jcr:primaryType="cq:WidgetCollection">
      <tagFilter
      	jcr:primaryType="cq:Widget"
      	name="./tagFilter"
        fieldDescription="Add tags to filter the result set."
        fieldLabel="Filter by tags"

## aem_style_selector
        <basepage jcr:primaryType="nt:unstructured">
            <mainParagraph
                jcr:lastModified="{Date}2014-01-17T17:44:04.712-08:00"
                jcr:lastModifiedBy="admin"
                jcr:primaryType="nt:unstructured"
                components="[group:General,group:Columns,group:Form]">
                <section jcr:primaryType="nt:unstructured"/>
                <text jcr:primaryType="nt:unstructured">
                	<cq:styles jcr:primaryType="nt:unstructured">
                		<columns