com.almis.awe.tools.service

Class SqlExtractorService

java.lang.Object

com.almis.awe.config.ServiceConfig

com.almis.awe.tools.service.SqlExtractorService

All Implemented Interfaces:

org.springframework.beans.factory.Aware, org.springframework.context.ApplicationContextAware

@Service
public class SqlExtractorService
extends com.almis.awe.config.ServiceConfig

Sql Extractor Engine service

Constructor Summary

Constructors

Constructor and Description
SqlExtractorService(DataListBuilder builder, DataSource dataSource) Autowired constructor

Method Summary

Modifier and Type	Method and Description
com.almis.awe.model.dto.ServiceData	checkFile(String fileName) Check file exists
com.almis.awe.model.dto.ServiceData	deleteColumns() Delete columns from grid
com.almis.awe.model.dto.ServiceData	extractData(String select, String type) Extract data
com.almis.awe.model.dto.ServiceData	getSelectFile() Get existing select files
com.almis.awe.model.dto.ServiceData	loadSelectSentence(String fileName) Save select file
com.almis.awe.model.dto.ServiceData	saveSelectFile(String fileName, String selects) Save select file

Methods inherited from class com.almis.awe.config.ServiceConfig

containsBean, getApplicationContext, getBean, getBean, getElements, getLocale, getLocale, getLogger, getProperty, getProperty, getRequest, getSession, setApplicationContext

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SqlExtractorService

@Autowired
public SqlExtractorService(DataListBuilder builder,
                                      DataSource dataSource)

Autowired constructor

Parameters:

builder -

dataSource -

Method Detail

extractData

public com.almis.awe.model.dto.ServiceData extractData(String select,
                                                       String type)
                                                throws com.almis.awe.exception.AWException

Extract data

Parameters:

select - Select

type - Data type

Returns:

Extracted data

Throws:

com.almis.awe.exception.AWException - Error in extraction

getSelectFile

public com.almis.awe.model.dto.ServiceData getSelectFile()
                                                  throws com.almis.awe.exception.AWException

Get existing select files

Returns:

Selected file

Throws:

com.almis.awe.exception.AWException - Error retrieving file

loadSelectSentence

public com.almis.awe.model.dto.ServiceData loadSelectSentence(String fileName)
                                                       throws com.almis.awe.exception.AWException,
                                                              IOException

Save select file

Parameters:

fileName - File name

Returns:

Selected sentence

Throws:

com.almis.awe.exception.AWException - Error loading sentence

IOException - Error retrieving file

saveSelectFile

public com.almis.awe.model.dto.ServiceData saveSelectFile(String fileName,
                                                          String selects)
                                                   throws com.almis.awe.exception.AWException

Save select file

Parameters:

fileName - File name

selects - Select

Returns:

Selected file

Throws:

com.almis.awe.exception.AWException - Error storing file

checkFile

public com.almis.awe.model.dto.ServiceData checkFile(String fileName)

Check file exists

Parameters:

fileName - File name

Returns:

Check

deleteColumns

public com.almis.awe.model.dto.ServiceData deleteColumns()

Delete columns from grid

Returns:

clientActionList