<?php
$db_name = $argv[1];
$db_user = $argv[2];
$db_pass = '';

echo 'POSTGRESQL PASSWORD: ';
fscanf(STDIN, '%s\n', $db_pass);

$pdo = new PDO('pgsql:host=localhost; dbname=' . $db_name . '; user=' . $db_user . '; password=' . $db_pass);

try {
	$pdo->beginTransaction()

	$statement = $pdo->prepare('
		ALTER TABLE user_account
		ALTER COLUMN password
		TYPE varchar(250);
	');

	$statement->execute();


	$statement = $pdo->prepare('
		ALTER TABLE user_account
		ADD COLUMN hash varchar(250);
	');

	$statement->execute();


	$statement = $pdo->prepare('
		SELECT username, password
		FROM user_account;
	');

	$statement->execute();

	$users = $statement->fetchAll();

	$statement = $pdo->prepare('
		UPDATE user_account
		SET hash = :hash
		WHERE username = :username;
	')

	foreach($users as $user) {
		$params = array (
			'hash' => password_hash($user['password'], PASSWORD_DEFAULT),
			'username' => $user['username']
		);

		$statement->execute($params);
	}

	$pdo->commit();
} catch (Exception e){
	$pdo->rollback();
}
?>