deleteChildren.m

function success = deleteChildren( sort_id, conn) %ftp_conn
%deleteChildren of a sort when it's updated, clusters and psth's
global directory;
[~,~,~,~,~,servrep,mapddataf]=SetUserDir;

results = fetch(conn, ['SELECT cluster_id, average_wvfrm, isi FROM clusters c WHERE c.sort_id_fk =' num2str(sort_id)]);
psths = {};

% for a = 1:size(results,1)
%     end

% cd(ftp_conn,'/myapp/figures/'); not using ftp now
figdir = [directory, 'figures\'];

for a = 1:size(results,1)
    psths =  [psths fetch(conn, ['SELECT psth_id, image_url FROM psth p WHERE p.cluster_id_fk =' num2str(results{a})])];
    sqlquery = ['DELETE FROM psth WHERE psth.cluster_id_fk = ' num2str(results{a})];
    curs = exec(conn, sqlquery);
    
    try
        % to delete file
        system(['C:\cygwin64\bin\bash --login -c -l "cd ',regexprep(figdir,'\','/'),'; rm ', results{a,2},' ',servrep,'/',mapddataf,'/figures/"']);
        system(['C:\cygwin64\bin\bash --login -c -l "cd ',regexprep(figdir,'\','/'),'; rm ', results{a,3},' ',servrep,'/',mapddataf,'/figures/"']);
%         delete(ftp_conn,results{a,2});
%         delete(ftp_conn,results{a,3});
    catch
        disp('Nothing to delete!');
    end
end

for a = 1:size(psths,1)
    try
        system(['C:\cygwin64\bin\bash --login -c -l "cd ',regexprep(figdir,'\','/'),'; rm ', psths{a,2},' ',servrep,'/',mapddataf,'/figures/"']);
%         delete(ftp_conn,psths{a,2});
    catch
        disp('Nothing to delete!');
    end
end

sqlquery = ['DELETE FROM clusters WHERE sort_id_fk = ' num2str(sort_id)];
curs = exec(conn, sqlquery);
success = 1;
end