ipoddubny · April 3, 2024 06:48 · masscontrolx · May 25, 2021 · agent188 · Jul 18, 2021
diff --git a/getdata.sh b/getdata.sh
 #!/bin/bash

 function getCSV {
  echo "Downloading $1..."
  curl -s https://rossvyaz.ru/data/$1.csv |\
    iconv -f cp1251 -t utf8 |\
    sed -e 's/[[:space:]]*;[[:space:]]*/;/g' -e '/^$/d' |\
    awk '{ split($0,a,";"); print a[1] ";" a[2] ";" a[3] ";" a[4] ";" a[5] ";" a[6] ", " a[7] ", " a[8] ", " a[9] ", " a[10] }' |\
    sed -e 's/\(,[[:space:]]\)*$//' > $2.csv
 }

 getCSV DEF-9xx def
 getCSV ABC-3xx abc3
 getCSV ABC-4xx abc4
 getCSV ABC-8xx abc8

 echo "Creating database..."

 /bin/rm -f db.sqlite3

 sqlite3 db.sqlite3 <<SQL
 CREATE TABLE abcdef (
  code varchar(3),
  dstart varchar(7),
  dend varchar(7),
  capacity int,
  operator varchar,
  region varchar
 );

 .mode csv
 .separator ';'
 .import def.csv abcdef
 .import abc3.csv abcdef
 .import abc4.csv abcdef
 .import abc8.csv abcdef

 CREATE INDEX 'abcdef_code_start_end' ON abcdef ('code', 'dstart', 'dend');
 SQL
diff --git a/lookup.sh b/lookup.sh
 #!/bin/bash

 if [[ $# -ne 1 || ${#1} -ne 10 ]]; then
  echo "Usage: $0 9991112233"
  exit
 fi

 code=${1:0:3}
 num=${1:3:7}

 sqlite3 db <<SQL
 .mode line
 SELECT * FROM abcdef WHERE code = '${code}' AND '${num}' BETWEEN dstart AND dend;
 SQL
	#!/bin/bash

	function getCSV {
	echo "Downloading $1..."
	curl -s https://rossvyaz.ru/data/$1.csv \|\
	iconv -f cp1251 -t utf8 \|\
	sed -e 's/[[:space:]];[[:space:]]/;/g' -e '/^$/d' \|\
	awk '{ split($0,a,";"); print a[1] ";" a[2] ";" a[3] ";" a[4] ";" a[5] ";" a[6] ", " a[7] ", " a[8] ", " a[9] ", " a[10] }' \|\
	sed -e 's/\(,[[:space:]]\)*$//' > $2.csv
	}

	getCSV DEF-9xx def
	getCSV ABC-3xx abc3
	getCSV ABC-4xx abc4
	getCSV ABC-8xx abc8

	echo "Creating database..."

	/bin/rm -f db.sqlite3

	sqlite3 db.sqlite3 <<SQL
	CREATE TABLE abcdef (
	code varchar(3),
	dstart varchar(7),
	dend varchar(7),
	capacity int,
	operator varchar,
	region varchar
	);

	.mode csv
	.separator ';'
	.import def.csv abcdef
	.import abc3.csv abcdef
	.import abc4.csv abcdef
	.import abc8.csv abcdef

	CREATE INDEX 'abcdef_code_start_end' ON abcdef ('code', 'dstart', 'dend');
	SQL
	#!/bin/bash

	if [[ $# -ne 1 \|\| ${#1} -ne 10 ]]; then
	echo "Usage: $0 9991112233"
	exit
	fi

	code=${1:0:3}
	num=${1:3:7}

	sqlite3 db <<SQL
	.mode line
	SELECT * FROM abcdef WHERE code = '${code}' AND '${num}' BETWEEN dstart AND dend;
	SQL