#!/usr/bin/env bash

upgradedatabase_1_2() {
	local	data		\
		datas		\
		id		\
		rename_pattern	\
		pattern		\
		fat32
	echo "Upgrading database to version 2... (backup is $database.bak_v1)"
	cp "$database" "$database.bak_v1"
	echo 'ALTER TABLE destination_files ADD COLUMN fat32compat INTEGER;' >&3
	echo 'ALTER TABLE destination_files ADD COLUMN ascii INTEGER;' >&3
	echo '
SELECT		id,
		rename_pattern
FROM		destination_files;

SELECT	"AtOM::NoMoreData";' >&3

	read -u4 -r -d $'\0' data
	while [[ $data != AtOM::NoMoreData ]]
	do
		datas+=( "$data" )
		read -u4 -r -d $'\0' data
	done
	echo 'BEGIN TRANSACTION;' >&3
	for data in "${datas[@]}"
	do
		id="${data%%::AtOM:SQL:Sep::*}"
		rename_pattern="${data#*::AtOM:SQL:Sep::}"
		IFS=':'
		read pattern fat32 <<<"$rename_pattern"
		IFS="$oldIFS"
		Update destination_files		\
			rename_pattern	"$pattern"	\
			fat32compat	"$fat32"	\
			ascii		0		\
		<<<"id = $id"
	done
	echo 'COMMIT;' >&3
	Update atom version 2 <<<"1 = 1"
}
