Skip to content

Instantly share code, notes, and snippets.

View Brutt's full-sized avatar

Ukraїner Brutt

View GitHub Profile
@Brutt
Brutt / Unpivot3.sql
Created April 17, 2019 13:41
unpivot3
WITH calendar as (
SELECT 1 as shop_id, 0 as mon, 0 as tue, 1 as wed, 1 as thur, 1 as fri, 0 as sat, 0 as sun FROM dual
UNION ALL
SELECT 2 as shop_id, 1 as mon, 1 as tue, 1 as wed, 1 as thur, 0 as fri, 0 as sat, 0 as sun FROM dual
)
, seq as (SELECT level as lvl FROM dual CONNECT BY level <= 7)
SELECT shop_id,
case when lvl = 1 then 'mon'
when lvl = 2 then 'tue'
@Brutt
Brutt / unpivot2.sql
Created April 17, 2019 13:36
unpivot2
WITH calendar as (
SELECT 1 as shop_id, 0 as mon, 0 as tue, 1 as wed, 1 as thur, 1 as fri, 0 as sat, 0 as sun FROM dual
UNION ALL
SELECT 2 as shop_id, 1 as mon, 1 as tue, 1 as wed, 1 as thur, 0 as fri, 0 as sat, 0 as sun FROM dual
)
SELECT * FROM (
SELECT shop_id, 'MON' as dayOfWeek, mon as isWorkDay
FROM calendar
UNION ALL
SELECT shop_id, 'TUE' as dayOfWeek, tue as isWorkDay
@Brutt
Brutt / Unpivot1.sql
Last active April 17, 2019 13:21
Unpivot
WITH calendar as (
SELECT 1 as shop_id, 0 as mon, 0 as tue, 1 as wed, 1 as thur, 1 as fri, 0 as sat, 0 as sun FROM dual
UNION ALL
SELECT 2 as shop_id, 1 as mon, 1 as tue, 1 as wed, 1 as thur, 0 as fri, 0 as sat, 0 as sun FROM dual
)
SELECT shop_id, dayOfWeek, isWorkDay
FROM calendar
UNPIVOT (
isWorkDay
FOR dayOfWeek IN (mon, tue, wed, thur, fri, sat, sun)
@Brutt
Brutt / ArrayStack
Created September 11, 2018 08:18
ArrayStack
public class ArrayStack implements Stack {
private Object[] array;
private int size;
private static final double koeff = 1.5d;
public ArrayStack() {
int initialCapacity = 2;
array = new Object[initialCapacity];
}
class Part1 {
public int max(int a, int b, boolean showParams){
if (showParams){
System.out.print("(" + a + ", " + b + "): ");
}
return a > b ? a : b;
}
public int max(int a, int b, int c, boolean showParams){
@Brutt
Brutt / Client
Created March 26, 2018 20:16
chat
package Chat;
import java.io.*;
import java.net.Socket;
public class Client implements Runnable {
BufferedReader consoleBufferedReader;
BufferedWriter socketBufferedWriter;
BufferedReader socketBufferedReader;
<!doctype html>
<html lang="en">
<head>
<title>404</title>
</head>
<body>
<h1>404 - Page not found!!!</h1>
</body>
</html>
import java.util.ArrayList;
import java.util.Scanner;
public class KeyboardReader implements Runnable {
private ArrayList<String> arrayList = new ArrayList<>();
@Override
public void run() {
try {
Timer timer = new Timer("timer1", 5);
import java.io.Serializable;
import java.util.Date;
public class Message implements Serializable {
private int id;
private Date date;
private String content;
public Message(int id, Date date, String content) {
this.id = id;
import java.lang.annotation.ElementType;
import java.lang.annotation.Retention;
import java.lang.annotation.RetentionPolicy;
import java.lang.annotation.Target;
@Retention(RetentionPolicy.RUNTIME)
@Target(ElementType.FIELD)
public @interface Column {
String name();
int primary() default 0;