Package com.killcoding.jsplus
Class ScriptConsole
java.lang.Object
com.killcoding.jsplus.ScriptConsole
- All Implemented Interfaces:
ConsoleImpl
- Direct Known Subclasses:
CmdConsole,JdbcConsole
-
Field Summary
FieldsModifier and TypeFieldDescriptionprotected static ConfigPropertiesprivate CacheDriverExecutorprotected Runnableprotected CmdConsoleprotected static final Map<Integer,ScriptConsole> protected ConfigPropertiesprivate static DriverDataSourceprotected ConfigPropertiesprotected Stringprivate static ExecutorServiceprivate booleanprotected booleanprotected CacheArrayprivate Stringprotected JsPlusContextprivate Stringprotected Loggerprivate longprivate static final longprotected booleanprivate static Pathprivate booleanprivate booleanprivate booleanFields inherited from interface com.killcoding.jsplus.ConsoleImpl
CALL_REGEX, CONSOLE_FUN_REGEX, CONSOLE_VAR_REGEX, DEFAULT_AesKey, DEFAULT_AutoCommit, DEFAULT_BatchSize, DEFAULT_CallStoredProcedureFun, DEFAULT_ColumnCut, DEFAULT_ColumnWidth, DEFAULT_CommandCancel, DEFAULT_CommandEnd, DEFAULT_CommandHistory, DEFAULT_DateFormat, DEFAULT_DateTimeFormat, DEFAULT_ExportCursorStart, DEFAULT_ExportMaxFileSize, DEFAULT_ExportMaxRows, DEFAULT_ExportOrderBy, DEFAULT_ExportSplit, DEFAULT_ExportTimer, DEFAULT_ExportUpperOrLowerCase, DEFAULT_ImportSplit, DEFAULT_Name, DEFAULT_QueryCursorStart, DEFAULT_QueryMaxRows, DEFAULT_Quote, DEFAULT_ScriptEngine, DEFAULT_ShowResultBody, DEFAULT_ShowResultFooter, DEFAULT_ShowResultHeader, DEFAULT_ShowTaskLog, DEFAULT_Task, DEFAULT_TaskTimer, DEFAULT_TimeFormat, DEFAULT_WriteHistory, SELECT_REGEX, VERSION -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionvoidabort()private voidvoidaddExitRunnable(Runnable exitRun) voidaddHistory(String command) voidvoidvoidclear()private voidvoidclearLastSelectCommand(List<String> params) voidclose()private voidvoidvoidcommit()private voidvoidconnect(int consoleHashCode) converToSqlFromMap(String schema, String tableName, List<String> columns) protected CacheArrayFiltercreateCacheArrayFilter(long filterTimer, long filterLoopTimer) private static booleanstatic StringvoidevalScript(String script) booleanexecuteBatch(String batchFile) protected StringexecuteCmdBatch(String batchFile) booleanexecuteForCmd(boolean enableSystemOut, String commands) booleanexecuteForCmd(String commands) booleanexecuteForJdbc(Boolean enableSystemOut, String commands) booleanexecuteForJdbc(String commands) booleanexecuteForScript(String commands) protected StringexecuteJdbcBatch(String batchFile) static Stringexit()exportTables(String schema, String exportToFolder) exportTables(List<String> params) voidvoidvoidvoidformatCommand(String command) formatForExport(Object objValue) formatForExport(String tableObjectFolder, Object objValue) formatObjectValue(boolean useEncrypt, boolean single, Object objValue, String tableObjectFolder) genCreateTable(String schema, String tableName) genCreateTable(List<String> params) genCreateTables(String schema, String sqlFilePath) genCreateTables(List<String> params) static ConfigPropertiesgetCacheArrayFilter(Boolean enableSystemOut) getCacheArrayFilterForExport(boolean showTaskLog, String file) getCacheDriverExecutor(boolean refreshConnection) protected ScriptConsolegetDataType(boolean isId, String javaType, int precision) protected StringgetGlobalCacheArray(long filterTimer, int filterLoopTimer) static Stringhelp()hostname()importFrom(String schema, String tableName, String csv) importFrom(List<String> params) importTables(String schema, String folder) importTables(List<String> params) voidinitGlobalCacheArray(long filterTimer, long filterLoopTimer) static voidinitPool()voidvoidvoidbooleanisCommandCancel(String command) booleanisCommandEnd(String command) booleanbooleanbooleanvoiddoubledoublememoryUsage(long using) longnewBuilder(String engineName) newBuilder(String engineName, String libHomePath) booleanopen()private booleanvoidreset()voidrollback()private voidsetAutoCommit(Boolean autoCommit) setAutoCommit(List<String> params) static voidsetCacheApi(String apiClass) setCacheApi(List<String> params) static voidsetDataSource(DriverDataSource datasource) voidsetIntoValue(Object value) voidsetLastSelectCommand(String lastSelectCommand) voidvoidvoidvoidvoidshowAll()showColumnClasses(String tableName) showColumnClasses(List<String> params) showColumnTypes(String tableName) showColumnTypes(List<String> params) voidshowHistory(String hiscmd) showTables(String schema) showTables(List<String> params) voidvoidvoidstopTask()protected voidtask()protected voidvoidbyte[]toByteArray(Blob blobValue) byte[]toByteArray(Clob clobValue) toResultList(List<Map<String, Object>> list) version()
-
Field Details
-
log
-
CONNECT_CONSOLES
-
datasource
-
datasourceVariables
-
consoleVariables
-
appenvCp
-
taskExecuted
-
firstOpen
-
useScriptEnv
-
useJdbcEnv
-
useCmdEnv
-
preExecuteTime
-
cacheDriverExecutor
-
lastSelectCommand
-
intoValue
-
exportedCompleted
-
cmdConsole
-
jsPlusContext
-
displayEngineName
-
exitRuns
-
startedTimeMs
-
tmpPath
-
exitExecute
-
globalCacheArray
-
callback
-
-
Constructor Details
-
ScriptConsole
public ScriptConsole()
-
-
Method Details
-
loadAppenv
-
getAppenv
-
detectSystemExit
- Throws:
IOException
-
initPool
-
setDataSource
-
getDataSource
- Throws:
IOException
-
getIntoValue
-
getLastSelectCommand
-
getCacheDriverExecutor
-
getCacheDriverExecutor
-
getConsoleVariables
-
setLastSelectCommand
-
clearLastSelectCommand
-
into
-
sleep
- Throws:
Exception
-
hostname
- Throws:
Exception
-
startTask
-
stopTask
-
callback
- Throws:
Exception
-
getGlobalCacheArray
-
getGlobalCacheArray
-
createCacheArrayFilter
-
initGlobalCacheArray
-
initScriptEngineManager
- Throws:
Exception
-
initScriptEngineManager
- Throws:
Exception
-
getContext
-
eval
- Throws:
Exception
-
eval
- Throws:
Exception
-
eval
- Throws:
Exception
-
closeContext
- Throws:
Exception
-
newBuilder
- Throws:
Exception
-
newBuilder
- Throws:
Exception
-
newBuilder
- Throws:
Exception
-
desc
- Throws:
Exception
-
showTables
- Throws:
Exception
-
showTables
- Throws:
Exception
-
showColumnTypes
- Throws:
Exception
-
showColumnClasses
- Throws:
Exception
-
set
-
show
-
showAll
-
setAutoCommit
- Throws:
Exception
-
genCreateTables
-
genCreateTable
- Throws:
Exception
-
getDataType
-
setCacheApi
- Throws:
Exception
-
reset
-
converToSqlFromMap
-
conver
public Object conver(String tableObjectFolder, String javaType, String encryptCell) throws Exception - Throws:
Exception
-
getJarPath
-
exportTo
- Throws:
Exception
-
exportTo
- Throws:
Exception
-
exportTo
- Throws:
Exception
-
exportTo
- Throws:
Exception
-
getCacheArrayFilterForExport
-
format
-
formatForExport
-
formatForExport
-
formatObjectValue
public String formatObjectValue(boolean useEncrypt, boolean single, Object objValue, String tableObjectFolder) -
toByteArray
-
toByteArray
-
columnCut
-
toSingle
-
clear
-
clear
-
open
-
close
-
commit
-
rollback
-
abort
-
abort
- Throws:
SQLException
-
rollback
- Throws:
SQLException
-
commit
- Throws:
SQLException
-
close
- Throws:
SQLException
-
open
-
executeBatch
- Throws:
Exception
-
executeCmdBatch
- Throws:
Exception
-
executeJdbcBatch
- Throws:
Exception
-
evalScript
- Throws:
Exception
-
executeForCmd
-
executeForScript
-
execute
-
executeForJdbc
-
executeForCmd
-
executeForJdbc
-
getCacheArrayFilter
-
checkHistory
-
addHistory
-
showHistory
-
toResultList
-
isCommandEnd
-
isCommandCancel
-
parseArgs
-
task
- Throws:
Exception
-
task
- Throws:
Exception
-
setTask
-
setTask
-
taskExecute
-
importFrom
- Throws:
Exception
-
importTables
-
exportTables
-
quote
-
setIntoValue
-
formatCommand
-
exportUpperOrLowerCase
-
getCmdConsole
-
error
-
exit
-
memoryUsing
-
memoryUsage
-
memoryUsage
-
addExitRunnable
-
version
-
setUseJdbcEnv
-
setUseScriptEnv
-
setUseCmdEnv
-
isUseJdbcEnv
-
isUseScriptEnv
-
isUseCmdEnv
-
help
-
connect
-
getConsole
-
getDisplayEngineName
-
version
-
help
-
exit
-
reset
-
setCacheApi
-
when
-
into
-
batch
-
sleep
-
hostname
-
startTask
-
stopTask
-
set
-
show
-
showAll
-
importTables
-
clearLastSelectCommand
-
exportTables
-
desc
-
showTables
-
showColumnTypes
-
showColumnClasses
-
exportTo
-
importFrom
-
setAutoCommit
-
genCreateTables
-
genCreateTable
-