Package 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

public class SqlExtractorService
extends ServiceConfig

Sql Extractor Engine service

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method	Description
ServiceData	checkFile(String fileName)	Check file exists
ServiceData	deleteColumns()	Delete columns from grid
ServiceData	extractData(String select, String type)	Extract data
ServiceData	getSelectFile()	Get existing select files
ServiceData	loadSelectSentence(String fileName)	Save select file
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, getProperty, getProperty, getRequest, getSession, setApplicationContext

Methods inherited from class java.lang.Object

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

Constructor Details

SqlExtractorService

public SqlExtractorService(DataListBuilder builder,
 DataSource dataSource)

Autowired constructor

Parameters:

builder -

dataSource -

Method Details

extractData

public ServiceData extractData(String select,
 String type)
                        throws AWException

Extract data

Parameters:

select - Select

type - Data type

Returns:

Extracted data

Throws:

AWException - Error in extraction

getSelectFile

public ServiceData getSelectFile()
                          throws AWException

Get existing select files

Returns:

Selected file

Throws:

AWException - Error retrieving file

loadSelectSentence

public ServiceData loadSelectSentence(String fileName)
                               throws AWException,
IOException

Save select file

Parameters:

fileName - File name

Returns:

Selected sentence

Throws:

AWException - Error loading sentence

IOException - Error retrieving file

saveSelectFile

public ServiceData saveSelectFile(String fileName,
 String selects)
                           throws AWException

Save select file

Parameters:

fileName - File name

selects - Select

Returns:

Selected file

Throws:

AWException - Error storing file

checkFile

public ServiceData checkFile(String fileName)

Check file exists

Parameters:

fileName - File name

Returns:

Check

deleteColumns

public ServiceData deleteColumns()

Delete columns from grid

Returns:

clientActionList