Skip to content

Instantly share code, notes, and snippets.

@sanaulla123
sanaulla123 / data.sql
Created January 31, 2022 12:52
Sample data for app_user
INSERT INTO app_user(username, first_name, last_name, password)
VALUES('user1', 'First 1', 'Last 1', '12345-1');
INSERT INTO app_user(username, first_name, last_name, password)
VALUES('user2', 'First 2', 'Last 2', '12345-2');
INSERT INTO app_user(username, first_name, last_name, password)
VALUES('user3', 'First 3', 'Last 3', '12345-3');
INSERT INTO app_user(username, first_name, last_name, password)
select
co.Code 'code',
co.name 'name',
co.Continent 'continent',
co.region 'region',
co.SurfaceArea 'surface_area',
co.IndepYear 'year_of_independence',
co.Population 'population',
co.LifeExpectancy 'life_expectancy',
co.GovernmentForm 'government_form',
@sanaulla123
sanaulla123 / world-index.json
Last active November 2, 2017 14:32
Index mapping structure for world index
{
"aliases":{},
"warmers":{},
"mappings": {
"world": {
"properties": {
"capital": {
"properties": {
"district": {
"type": "string"
#!/bin/sh
DIR="$( cd "$( dirname "${BASH_SOURCE[0]}" )" && pwd )"
bin=${DIR}/../bin
lib=${DIR}/../lib
java \
-cp "${lib}/*" \
-Dlog4j.configurationFile=${bin}/log4j2.xml \
org.xbib.tools.Runner \
@echo off
set DIR=%~dp0
set LIB=%DIR%..\lib\*
set BIN=%DIR%..\bin
REM ???
"%JAVA8_HOME%\bin\java" -cp "%LIB%" -Dlog4j.configurationFile="%BIN%\log4j2.xml" "org.xbib.tools.Runner" "org.xbib.tools.JDBCImporter" world-importer-config.json
{
"type" : "jdbc",
"jdbc" : {
"password" : "******",
"user" : "root",
"url" : "jdbc:mysql://localhost:3306/world",
"sql" : [ {
"statement" : "world.sql"
} ],
select
co.Code '_id',
co.Code 'code',
co.name 'name',
co.Continent 'continent',
co.region 'region',
co.SurfaceArea 'surface_area',
co.IndepYear 'year_of_independence',
co.Population 'population',
co.LifeExpectancy 'life_expectancy',
import java.util.List;
import java.util.ArrayList;
public class ChainOfResponsibilityDemo {
/**
* @param args
*/
public static void main(String[] args) {
public class XmlParser extends Parser {
@Override
public void parse(String fileName) {
if ( canHandleFile(fileName, ".xml")){
System.out.println("A XML parser is handling the file: "+fileName);
}
else{
super.parse(fileName);
}
public class CsvParser extends Parser {
public CsvParser(Parser successor){
this.setSuccessor(successor);
}
@Override
public void parse(String fileName) {
if ( canHandleFile(fileName, ".csv")){
System.out.println("A CSV parser is handling the file: "+fileName);