Kostromin Igor elw00d

## RusEnKeyboardLayoutFilter.java
package ru.dz;

import org.apache.lucene.analysis.TokenFilter;
import org.apache.lucene.analysis.TokenStream;
import org.apache.lucene.analysis.tokenattributes.CharTermAttribute;
import org.apache.lucene.analysis.tokenattributes.PositionIncrementAttribute;

import java.io.IOException;
import java.util.HashMap;
import java.util.Map;

## recursive.sql
with cte as (
	select id, parentId, name from Category where id = 17
	union all
	select c.id, c.parentId, c.name from Category c
		join cte on c.id = cte.parentId
) select * from cte

## start.sh
export LC_ALL=en_US.UTF-8
nohup java -DSTOP.PORT=7575 -DSTOP.KEY=stop_jetty -Djetty.host=localhost -Djetty.port=8080 -jar start.jar &

## vk-image-subst.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                elw00d
                / vk-image-subst.md
            
            
              Created
              July 17, 2014 09:30
                — forked from bedefaced/vk-image-subst.md
            
          
    По мотивам https://vk.com/id232967147 / https://vk.com/mgnoveniag

Создаём пост с любой картинкой.
Ждём полгода/год. Открываем газету, выбираем важные события современности.
Редактируем у себя на комплюктере исходную картинку, описывая важные события современности.
Открываем ту старую фотографию из поста ВКонтакте, нажимаем "Редактировать".
Открываем инструменты разработчика в своём браузере и узнаём значение переменной cur.filterSaveOptions.upload_url.
Пишем программу на HTML. Создаём файлик upload.html:


## group_concat
Tables:
a (id, name)
b (id, name)
a_to_b (a_id, b_id)

Outputs:
a_id a_name b_ids_over_comma

select *, STUFF(
    (SELECT ',' + LTRIM(RTRIM(b.name))

## import.sh
#!/bin/bash

for FILE in ./*.sql; do
    echo "Importing $FILE"
	/cygdrive/c/Program\ Files/MySQL/MySQL\ Server\ 5.6/bin/mysql.exe -u root -padmin --database mydb < $FILE
done

## example.jsp
<%@ taglib tagdir="/WEB-INF/tags/util" prefix="util" %>

<%-- tag should be placed to Web-inf/tags/util/toJson.tag --%>

<script id="scheduleData" type="json-data"><util:toJson source="${schedule}"/></script>

## JsDataInjectionInterceptor.java
package su.elwood;

import com.fasterxml.jackson.databind.ObjectMapper;
import com.fasterxml.jackson.databind.SerializationFeature;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.handler.HandlerInterceptorAdapter;

import javax.servlet.http.HttpServletRequest;

## HibernateListener.java
package com.playground.myapp.web;

import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
import org.hibernate.service.ServiceRegistryBuilder;

import javax.servlet.ServletContext;
import javax.servlet.ServletContextEvent;
import javax.servlet.ServletContextListener;

## index.html
<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
  </head>
  <body onload="onLoad()">
    <script type="text/javascript">
      var jsilConfig = {
        printStackTrace: false,
        xna: 4,
	package ru.dz;

	import org.apache.lucene.analysis.TokenFilter;
	import org.apache.lucene.analysis.TokenStream;
	import org.apache.lucene.analysis.tokenattributes.CharTermAttribute;
	import org.apache.lucene.analysis.tokenattributes.PositionIncrementAttribute;

	import java.io.IOException;
	import java.util.HashMap;
	import java.util.Map;
	with cte as (
	select id, parentId, name from Category where id = 17
	union all
	select c.id, c.parentId, c.name from Category c
	join cte on c.id = cte.parentId
	) select * from cte
	export LC_ALL=en_US.UTF-8
	nohup java -DSTOP.PORT=7575 -DSTOP.KEY=stop_jetty -Djetty.host=localhost -Djetty.port=8080 -jar start.jar &
	Tables:
	a (id, name)
	b (id, name)
	a_to_b (a_id, b_id)

	Outputs:
	a_id a_name b_ids_over_comma

	select *, STUFF(
	(SELECT ',' + LTRIM(RTRIM(b.name))
	#!/bin/bash

	for FILE in ./*.sql; do
	echo "Importing $FILE"
	/cygdrive/c/Program\ Files/MySQL/MySQL\ Server\ 5.6/bin/mysql.exe -u root -padmin --database mydb < $FILE
	done
	<%@ taglib tagdir="/WEB-INF/tags/util" prefix="util" %>

	<%-- tag should be placed to Web-inf/tags/util/toJson.tag --%>

	<script id="scheduleData" type="json-data"><util:toJson source="${schedule}"/></script>
	package su.elwood;

	import com.fasterxml.jackson.databind.ObjectMapper;
	import com.fasterxml.jackson.databind.SerializationFeature;
	import org.apache.commons.logging.Log;
	import org.apache.commons.logging.LogFactory;
	import org.springframework.web.servlet.ModelAndView;
	import org.springframework.web.servlet.handler.HandlerInterceptorAdapter;

	import javax.servlet.http.HttpServletRequest;
	package com.playground.myapp.web;

	import org.hibernate.SessionFactory;
	import org.hibernate.cfg.Configuration;
	import org.hibernate.service.ServiceRegistry;
	import org.hibernate.service.ServiceRegistryBuilder;

	import javax.servlet.ServletContext;
	import javax.servlet.ServletContextEvent;
	import javax.servlet.ServletContextListener;
	<!DOCTYPE html>
	<html>
	<head>
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	</head>
	<body onload="onLoad()">
	<script type="text/javascript">
	var jsilConfig = {
	printStackTrace: false,
	xna: 4,