�&ǐk�@'bJ�h�ۊL'}T�:��'2�Z#$��n�a����>a��`��_3d�Qpt�/�P
-��#5�,�M���
�pA:©�q�����NW��ډ�A�����9nʺج����
�TSM��{J6?7��r�@�\����D����׶���s�f�TJj?"��D��`?��̒�	b�#�%�C*v�$�{�$����5Ծ�F�s��y�e/8��h-�f�̰
&(����Gj�L:U�	2������v�_k����Y��gp,�k�WF�R����<Q%E�,��+׬��$�䑽�0����]q�%�ˮI�����5_�}}
�c�{8�.��&���o��Ӳ�ߢ�!�2M��@��GƲz�@�Z$�b�ցK���Q��m�C���6�i����V�j|�s�y����\1�����5'?�@3�$%vP�v >��_C�R��N@���R�@�ߔ?A�w9���F("iNa-S���Q�o�3tDMLh*�#4k�T/iQ��Y*�G��m����)��8�
hBm/�I�,g�ﯖ���Z��}�Cz�q@
´��d.����L�ŕ�,��1�Z�܌�:̪���F+J-'��c�tvJ8��]Q-��b��y�6;*J`r_�d	��'�G ~p��)'�C,�%F��E(��2�k�����lР�z�!�=t��_�0��f7�
��
;�p�|�U	�%<j
��I�#!/usr/local/cpanel/3rdparty/bin/perl

# cpanel - scripts/convert_whmxfer_to_sqlite       Copyright 2022 cPanel, L.L.C.
#                                                           All rights reserved.
# copyright@cpanel.net                                         http://cpanel.net
# This code is subject to the cPanel license. Unauthorized copying is prohibited

package scripts::convert_whmxfer_to_sqlite;

use strict;
use Whostmgr::Transfers::Session::Config ();
use Whostmgr::Transfers::SessionBase     ();
use Cpanel::MysqlUtils::Connect          ();

exit( __PACKAGE__->script() ) unless caller();

sub script {
    my $sessionbase = Whostmgr::Transfers::SessionBase->new();
    my $sqlite_dbh  = $sessionbase->get_master_dbh();
    my $mysql_dbh   = Cpanel::MysqlUtils::Connect::get_dbi_handle();

    my $has_db = $mysql_dbh->selectall_arrayref("SHOW DATABASES LIKE 'whmxfer';");

    return if !$has_db->[0];

    my $ref = $mysql_dbh->selectall_hashref( "select * from whmxfer.sessions;", 'sessionid' );

    foreach my $sessionid ( sort keys %$ref ) {
        next if !-d $Whostmgr::Transfers::Session::Config::SESSION_DIR . '/' . $sessionid;
        my $row    = $ref->{$sessionid};
        my $cols   = join( ',', map { $sqlite_dbh->quote($_) } keys %{$row} );
        my $values = join( ',', map { $sqlite_dbh->quote($_) } values %{$row} );
        $sqlite_dbh->do("INSERT INTO sessions ($cols) VALUES($values);");
    }

    $mysql_dbh->do("DROP DATABASE whmxfer;");

    return 0;
}