dozortsev

package taskB;

import org.apache.log4j.Logger;

import java.io.*;
import java.nio.file.Files;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.HashMap;
import java.util.Map;

dozortsev

DROP DATABASE IF EXISTS dbTaskC;

CREATE DATABASE IF NOT EXISTS dbTaskC;

USE dbTaskC;

CREATE TABLE Student (
  Id int(11) UNIQUE NOT NULL AUTO_INCREMENT,
  FirstName varchar(50),
  LastName varchar(50),

dozortsev

# Install RVM : https://rvm.io/

$ \curl -sSL https://get.rvm.io | bash -s stable --rails --autolibs=enabled --ruby=2.1.1

# Reboot terminal

$ ruby -v
# Use last version

# Set new version by default

dozortsev

DELIMITER //
CREATE PROCEDURE isDateRangeValid()
  foo : BEGIN
    
    SET @i = 0;
    SET @j = 1;
    
    DECLARE dates CURSOR FOR SELECT joined FROM user GROUP BY joined LIMIT 10;
    
    WHILE @i < 9 AND @j < 9 DO

dozortsev

SELECT
  IF((SELECT
  count(*)
      FROM
        PatientMedicalRecord
      WHERE
        PatientId = 30819
        AND Domain = 'encounter') >= 2
     AND duplicates = (SELECT
  count(*)

dozortsev

#!/bin/bash
for file in *server.log */server.log */server.log.*
do
	# echo "$file"
	grep -rwn "$file" -e "Unexpected error during registration."
    if [ $? = 0 ]
    then
        printf "\n\n\nfile: $file\n"
        grep -rwn "$file" -e "Unexpected error during registration."
    fi