Tech Stuff Blog

So, I haven't use PowerMock too much, but I've found how to test private methods, I know it's not rocket science but I drop this note in this blog to remember stuff, so there it is how I've done it and a link from where I learned it:

    @Test
    public void buildHeaderTest() {
        try {
            String[] headerReturn = Whitebox.invokeMethod(paymentsReceivedReport, "buildHeader");
            assertThat(headerReturn).isEqualTo(csvHeaderValues);
        } catch (Exception e) {
            System.out.println("Error testing PaymentsReceivedReport:buildHeaderTest");
            e.printStackTrace();
        }
    }

https://automationrhapsody.com/call-private-method-powermock/

So I'm trying to increase the time out on requests on the DB, as we implemente Hikari connection pool i increased the property idle-timeout, not pretty sure if i get what i want increasing this property but i found a good article from may of 2018 that i would like to read closely later...

https://www.baeldung.com/hikaricp

But this is the official documentation

https://github.com/brettwooldridge/HikariCP#initialization

To generate CSV Files I'm using OpenCSV this is a guide on how to use it:

http://www.baeldung.com/opencsv

Haven't read this guide btw, but I've just found it and it's pretty recent (version 4) from april 2018 just to have it in the future if i need it for reference ;)
Below is an example of how I'm using it for download csv files from and endpoint:

@PostMapping( value = "/download", produces = "text/csv" )
@ApiImplicitParams( @ApiImplicitParam( name = Constant.App.ACCESS_TOKEN, value = Constant.App.ACCESS_TOKEN_VALUE, required = true, dataType = Constant.App.STRING_VALUE, paramType = Constant.App.HEADER_VALUE ) )
public void getPaymentsReceivedDownload( HttpServletResponse response, @Valid @RequestBody DatesReportRequestVo vo ) throws IOException
{

            LOGGER.info( Constant.LogMessages.STARTING_PAYMENTS_RECEIVED_DOWNLOAD, vo.getStartDate(), vo.getEndDate() );
            CsvFileUtil.setHeaderToCsv( response, CSV_NAME );
            paymentsReceivedReport.generateReport( response.getWriter(), vo );
}

    @SuppressWarnings("unchecked")
    @LogExecutionTime
    public void generateReport( PrintWriter writer, DatesReportRequestVo vo )
    {
        PageResponse report = runReport( vo );

        String[] values = buildHeader( );

        CSVWriter csvWriter = new CSVWriter( writer, ',' );
        csvWriter.writeNext( values );

        voToStringArray( writer, ( List<PaymentsReceivedVo> ) report.getContent(), csvWriter );

        writer.flush();
        writer.close();
    }    
    
    private void voToStringArray( PrintWriter writer, List<PaymentsReceivedVo> trans, CSVWriter csvWriter )
    {
        int count = 0;
        for ( PaymentsReceivedVo vo : trans )
        {
            String[] values = new String[8];
            values[0] = vo.getApplicationId();
            values[1] = vo.getCustomerName();
            values[2] = vo.getMerchantDbaName();
            values[3] = vo.getEffectiveDate();
            values[4] = vo.getPaymentMethod();
            values[5] = vo.getBatchId().toString();
            values[6] = vo.getCreditCardVerification();
            values[7] = vo.getAmount().toString();

            csvWriter.writeNext( values );

            count++;

            if ( count % 10 == 0 )
            {
                writer.flush();
            }

        }
    }
    
    private String[] buildHeader()
    {
        String[] pValues = new String[22];
        pValues[0] = "Application Id";
        pValues[1] = "Name";
        pValues[2] = "DBA Name";
        pValues[3] = "Effective Date";
        pValues[4] = "Type";
        pValues[5] = "Batch Id";
        pValues[6] = "Ver Code";
        pValues[7] = "Payment Amount";

        return pValues;
    }    

Taken from Angular: Getting Started from Deborah Kurata

import { Component } from '@angular/core';

/*Decorator*/
@Component({
        selector: 'pm-root',
        /*Template*/
        template: ˜`</span><br /><span style="font-family: courier new, courier, monospace;">        <div><h1>{{pageTitle}}</h1></span><br /><span style="font-family: courier new, courier, monospace;">                <div>My First Component</div></span><br /><span style="font-family: courier new, courier, monospace;">        </div></span><br /><span style="font-family: courier new, courier, monospace;">        `
})

/*Class*/
export class AppComponent {
        pageTtitle: string = 'Acme Product Management';
}

I needed to implement a way to transfer files via sftp, so I've done it using JSCh which is a is a pure Java implementation of SSH2.
JSch allows you to connect to an sshd server and use port forwarding, X11 forwarding, file transfer, etc., and you can integrate its functionality into your own Java programs. JSch is licensed under BSD style license. you can read details here

And the code below is a sample of how it was done

JSch jsch = new JSch();
session = jsch.getSession( ftpUser, ftpHost, 22 );
session.setPassword( ftpPassword );
java.util.Properties config = new java.util.Properties();
config.put( "StrictHostKeyChecking", "no" );
session.setConfig( config );
session.connect();
System.out.println( "Host connected." );
channel = session.openChannel( "sftp" );
channel.connect();
batchSchedulerLog.log( Level.INFO, "sftp channel opened and connected." );
System.out.println("sftp channel opened and connected.");
channelSftp = ( ChannelSftp ) channel;
channelSftp.cd( ftpDir );
channelSftp = ( ChannelSftp ) channel;
channelSftp.put( new ByteArrayInputStream( data ), "pruebaRicardo.csv" );
batchSchedulerLog.log( Level.INFO, "File transferred successfully to host." );
System.out.println("File transferred successfully to host.");