tarnagas

SELECT *, (
    case when sku = 'W556B' then 1 else 0 end +
    case when product_type = 'Tapis' then 1 else 0 end
) as cnt from  etl_raw_import_art
WHERE (sku = 'W556B' or product_type = 'Tapis')
order by
    case when sku = 'W556B' then 1 else 0 end +
    case when product_type = 'Tapis' then 1 else 0 end
DESC

tarnagas

#!/usr/bin/env ruby

require 'liquid'

template = <<-HEREDOC
data:
  {%- for item in plops %}
  - {{ item }}
  {%- endfor %}
host: "sample.local"

tarnagas

<?php
$locale = 'nl_NL';
Mage::app()->getLocale()->setLocaleCode($locale);
Mage::getSingleton('core/translate')->setLocale($locale)->init('frontend', true);

//http://www.kennydeckers.com/programatically-set-locale-language-magento/
?>

tarnagas

SELECT * FROM events 
LEFT JOIN events as e2 ON e2.tag_id = events.tag_id 
AND e2.change_dt > events.change_dt
WHERE e2.change_dt IS NULL

tarnagas

/**
 * kotlinc/bin/kotlinc hello.kt -include-runtime -d hello.jar
 * java -jar hello.jar
 *
 * https://github.com/Zenika/docker-kotlin/blob/master/1.3/jdk12/Dockerfile
 */
fun main(args: Array<String>) {
    println("Hello, %s!".format(args[0]))
}

tarnagas

# Global configration
# --------------------------------------------------------------------
startup_message off
autodetach on
nonblock on
altscreen on
# define a bigger scrollback, default is 100 lines
defscrollback 1000

term  screen-256color

tarnagas

#!/usr/bin/env sh

# Sample of use:
#
# ```sh
# sh import.sh backuped_database.sql
# ```
#
# @see https://hub.docker.com/r/mysql/mysql-server/
# @see https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html

tarnagas

'use strict'

/**
 * Sample of use
 *
 * ```js
 * import { path as MediasPath } from './vue/medias/forms'
 * import { content_type as WorksContentType } from './vue/works/forms'
 * appify({
 *   components: {

tarnagas

#!/usr/bin/env sh

# Sample of use:
#
# rasp-backup /dev/sdc

set -eu
IMG_FILE=rasp.$(date +%Y%m%d.%s).img.gz
GZIP_BIN="$(which pigz)" # tries for multithread gzip
test -z "${GZIP_BIN}" && {

tarnagas

git branch --merged master | grep -Ev "^\s+(release/.*|master)$" | while read line; do git branch -d "$line" && git push origin --delete "$line"; done