Examples with DBType com.varsql.core.db.DBType used on opensource projects

Example 1 with DBType

use of com.varsql.core.db.DBType in project varsql by varsqlinfo.

the class SQLServiceImpl method sqlFormat.

/**
 * @Method Name  : sqlFormat
 * @Method 설명 : sql 포멧 맞추기
 * @작성자   : ytkim
 * @작성일   : 2015. 4. 6.
 * @변경이력  :
 * @param sqlExecuteInfo
 * @return
 * @throws Exception
 */
public ResponseResult sqlFormat(SqlExecuteDTO sqlExecuteInfo) throws Exception {
    ResponseResult result = new ResponseResult();
    DBType dbType = DBType.getDBType(sqlExecuteInfo.getDbType());
    if ("varsql".equals(sqlExecuteInfo.getCustom().get("formatType"))) {
        result.setItemOne(VarsqlFormatterUtil.format(sqlExecuteInfo.getSql(), dbType, VarsqlFormatterUtil.FORMAT_TYPE.VARSQL));
    } else {
        result.setItemOne(VarsqlFormatterUtil.format(sqlExecuteInfo.getSql(), dbType));
    }
    return result;
}

Example 2 with DBType

use of com.varsql.core.db.DBType in project varsql by varsqlinfo.

the class SqlSourceBuilderTest method testDruid.

@Test
void testDruid() {
    String sql;
    DBType dbType = DBType.ORACLE;
    ;
    try {
        sql = getResourceContent("/query/query.txt");
        HashMap param = new HashMap();
        List<SQLStatement> statements = SQLUtils.toStatementList(sql, SQLParserUtils.getDbParser(dbType));
        for (SQLStatement statement : statements) {
            System.out.println("main sysout " + SQLUtils.toSQLString(statement, SQLParserUtils.getDbParser(dbType), null));
        }
    } catch (Exception e) {
        e.printStackTrace();
    }
}

Example 3 with DBType

use of com.varsql.core.db.DBType in project varsql by varsqlinfo.

the class JPAConfigurer method querydslConfiguration.

@Bean
public com.querydsl.sql.Configuration querydslConfiguration() {
    SQLTemplates templates = H2Templates.builder().build();
    DBType dbType = DBType.getDBType(Configuration.getInstance().getDbType());
    if (DBType.MYSQL.equals(dbType)) {
        templates = MySQLTemplates.builder().build();
    } else if (DBType.MSSQL.equals(dbType)) {
        templates = SQLServerTemplates.builder().build();
    } else if (DBType.ORACLE.equals(dbType)) {
        templates = OracleTemplates.builder().build();
    } else if (DBType.POSTGRESQL.equals(dbType)) {
        templates = com.querydsl.sql.PostgreSQLTemplates.builder().build();
    } else if (DBType.CUBRID.equals(dbType)) {
        templates = com.querydsl.sql.CUBRIDTemplates.builder().build();
    } else if (DBType.DB2.equals(dbType)) {
        templates = com.querydsl.sql.DB2Templates.builder().build();
    } else if (DBType.MARIADB.equals(dbType)) {
        templates = com.querydsl.sql.MySQLTemplates.builder().build();
    } else if (DBType.TIBERO.equals(dbType)) {
        templates = com.querydsl.sql.OracleTemplates.builder().build();
    } else if (DBType.H2.equals(dbType)) {
        templates = com.querydsl.sql.H2Templates.builder().build();
    } else {
        templates = com.querydsl.sql.H2Templates.builder().build();
    }
    com.querydsl.sql.Configuration configuration = new com.querydsl.sql.Configuration(templates);
    configuration.setExceptionTranslator(new SpringExceptionTranslator());
    configuration.register(new DateTimeType());
    configuration.register(new LocalDateType());
    return configuration;
}

Example 4 with DBType

use of com.varsql.core.db.DBType in project varsql by varsqlinfo.

the class ExportServiceImpl method downloadTableData2.

public ResponseResult downloadTableData2(PreferencesRequestDTO preferencesInfo, HttpServletRequest req, HttpServletResponse res) throws Exception {
    DataDownloadInfo ddi = VartechUtils.jsonStringToObject(preferencesInfo.getPrefVal(), DataDownloadInfo.class, true);
    DatabaseInfo databaseInfo = SecurityUtil.loginInfo().getDatabaseInfo().get(ddi.getConuid());
    logger.debug("downloadTableData : {}", preferencesInfo.getPrefVal());
    String prefixSchema = StringUtils.isBlank(ddi.getSchema()) ? "" : ddi.getSchema() + ".";
    String charset = StringUtils.isBlank(ddi.getCharset()) ? VarsqlConstants.CHAR_SET : ddi.getCharset();
    String exportFileName = ValidateUtils.getValidFileName(ddi.getFileName());
    String fileId = VartechUtils.generateUUID();
    Path fileExportPath = FileServiceUtils.getSavePath(UploadFileType.EXPORT);
    File zipFile = new File(FileUtils.pathConcat(fileExportPath.toAbsolutePath().toString(), VarsqlFileType.ZIP.concatExtension(fileId)));
    int bufferSize = 2048;
    final VarsqlFileType exportType = ddi.getExportType();
    DBType dbType = DBType.getDBType(databaseInfo.getType());
    String requid = ddi.getRequid();
    ProgressInfo progressInfo = new ProgressInfo();
    progressInfo.setTotalItemSize(ddi.getItems().size());
    String sessAttrKey = HttpSessionConstants.progressKey(requid);
    System.out.println("downloadTableData2 sessAttrKey : " + sessAttrKey);
    HttpSession session = req.getSession();
    session.setAttribute(sessAttrKey, progressInfo);
    try (ZipOutputStream zos = new ZipOutputStream(new FileOutputStream(zipFile), Charset.forName(charset))) {
        int idx = 0;
        for (DownloadItemInfo item : ddi.getItems()) {
            ++idx;
            SqlExecuteDTO seDto = new SqlExecuteDTO();
            seDto.setLimit(ddi.getLimit());
            seDto.setConuid(ddi.getConuid(), exportFileName, databaseInfo);
            String objectName = prefixSchema + item.getName();
            seDto.setSqlParam("{}");
            seDto.setSql(SQLUtils.generateSelectQuery(objectName, item.getCondition(), dbType));
            String downloadFilePath = FileUtils.pathConcat(fileExportPath.toAbsolutePath().toString(), exportType.concatExtension(VartechUtils.generateUUID()));
            progressInfo.setName(item.getName());
            progressInfo.setItemIdx(idx);
            AbstractWriter writer = null;
            try (OutputStream outstream = new FileOutputStream(downloadFilePath)) {
                if (VarsqlFileType.CSV.equals(exportType)) {
                    writer = new CSVWriter(outstream, ',', charset);
                } else if (VarsqlFileType.JSON.equals(exportType)) {
                    writer = new JSONWriter(outstream, "row", charset);
                } else if (VarsqlFileType.XML.equals(exportType)) {
                    writer = new XMLWriter(outstream, "row", charset);
                } else if (VarsqlFileType.EXCEL.equals(exportType)) {
                    writer = new ExcelWriter(outstream);
                } else {
                    writer = new SQLWriter(outstream, dbType, objectName, charset);
                }
                logger.debug("data export downloadFilePath :{} , query : {}", downloadFilePath, seDto.getSql());
                final String tableName = item.getName();
                SQLExecuteResult ser = (new SelectExecutor()).execute(seDto, new AbstractSQLExecutorHandler(writer) {

                    private boolean firstFlag = true;

                    private int rowIdx = 0;

                    public boolean handle(SQLHandlerParameter handleParam) {
                        if (this.firstFlag) {
                            WriteMetadataInfo whi = new WriteMetadataInfo("exportInfo");
                            List<ExportColumnInfo> columns = new LinkedList<>();
                            handleParam.getColumnInfoList().forEach(item -> {
                                ExportColumnInfo gci = new ExportColumnInfo();
                                gci.setName(item.getLabel());
                                // 추가 할것.
                                gci.setAlias(item.getKey());
                                gci.setType(item.getDbType());
                                gci.setNumber(item.isNumber());
                                gci.setLob(item.isLob());
                                columns.add(gci);
                            });
                            whi.addMetedata("tableName", tableName);
                            whi.addMetedata("columns", columns);
                            getWriter().setMetadata(new WriteMetadataInfo[] { whi });
                            if (VarsqlFileType.SQL.equals(exportType)) {
                                ((SQLWriter) getWriter()).setColumnInfos(handleParam.getColumnInfoList());
                            }
                            this.firstFlag = false;
                        }
                        progressInfo.setProgressContentLength(++rowIdx);
                        try {
                            getWriter().addRow(handleParam.getRowObject());
                        } catch (IOException e) {
                            logger.error(e.getMessage(), e);
                            return false;
                        }
                        return true;
                    }
                });
                writer.writeAndClose();
                String zipFileName = exportType.concatExtension(item.getName());
                if (ser.getResultCode() != null) {
                    VarsqlUtils.textDownload(new FileOutputStream(downloadFilePath), ser.getMessage());
                    zipFileName = item.getName() + "-export-error.txt";
                }
                try (BufferedInputStream bis = new BufferedInputStream(new FileInputStream(downloadFilePath))) {
                    ZipEntry zentry = new ZipEntry(zipFileName);
                    zentry.setSize(new File(downloadFilePath).length());
                    zos.putNextEntry(zentry);
                    byte[] buffer = new byte[bufferSize];
                    int cnt = 0;
                    while ((cnt = bis.read(buffer, 0, bufferSize)) != -1) {
                        zos.write(buffer, 0, cnt);
                    }
                    zos.closeEntry();
                }
                new File(downloadFilePath).delete();
            } catch (Exception e) {
                throw e;
            } finally {
                IOUtils.close(writer);
            }
        }
        IOUtils.close(zos);
    }
    FileInfoEntity fie = FileInfoEntity.builder().fileId(fileId).fileContId(fileId).contGroupId(databaseInfo.getVconnid()).fileDiv(UploadFileType.EXPORT.getDiv()).fileFieldName("downloadZipFile").fileName(VarsqlFileType.ZIP.concatExtension(exportFileName)).fileSize(zipFile.length()).fileExt(VarsqlFileType.ZIP.getExtension()).filePath(FileUtils.pathConcat(FileServiceUtils.getSaveRelativePath(UploadFileType.EXPORT), zipFile.getName())).build();
    fileInfoEntityRepository.save(fie);
    session.setAttribute(sessAttrKey, "complete");
    return VarsqlUtils.getResponseResultItemOne(fie);
}

Example 5 with DBType

use of com.varsql.core.db.DBType in project varsql by varsqlinfo.

the class SqlSourceBuilderTest method testOracle.

@Test
void testOracle() {
    String sql;
    DBType dbType = DBType.ORACLE;
    ;
    try {
        sql = getResourceContent("/query/query.txt");
        HashMap param = new HashMap();
        List<SqlSource> statements = SqlSourceBuilder.parse(sql, param, dbType);
        for (SqlSource statement : statements) {
            System.out.println("main sysout " + statement.getQuery());
        }
    } catch (Exception e) {
        e.printStackTrace();
    }
}