Examples of org.hsqldb.scriptio.ScriptWriterText

org.hsqldb.scriptio.ScriptWriterText
Handles all scripting and logging operations. A script consists of two blocks:
DDL: SQL statements for table and user definitions DATA: INSERT statements for memory tables This happens as part of the CHECKPOINT and SHUTDOWN COMPACT process. In this case, the DATA block contains the CACHED table data as well.
A related use for this class is for saving a current snapshot of the database data to a user-defined file with the SCRIPT command A log consists of SQL statements of different types. Each statement is encoded as ASCII and saved. @author Fred Toussi (fredt@users dot sourceforge.net) @version 1.9.0 @since 1.7.2


        Crypto crypto = database.logger.getCrypto();


        try {
            if (crypto == null) {
                dbLogWriter = new ScriptWriterText(database, logFileName,
                                                   false, false, false);
            } else {
                dbLogWriter = new ScriptWriterEncode(database, logFileName,
                                                     crypto);
            }

View Full Code Here


        ScriptWriterBase scw;
        Crypto           crypto = database.logger.getCrypto();


        if (crypto == null) {
            scw = new ScriptWriterText(database, scriptFileName + ".new",
                                       full, true, false);
        } else {
            scw = new ScriptWriterEncode(database, scriptFileName + ".new",
                                         full, crypto);
        }

View Full Code Here

                } catch (HsqlException e) {
                    return Result.newErrorResult(e, sql);
                }
            }
            case StatementTypes.DATABASE_SCRIPT : {
                ScriptWriterText dsw  = null;
                String           name = (String) parameters[0];


                if (name == null) {
                    return session.database.getScript(false);
                } else {
                    try {
                        dsw = new ScriptWriterText(session.database, name,
                                                   true, true, true);


                        dsw.writeAll();
                        dsw.close();
                    } catch (HsqlException e) {
                        return Result.newErrorResult(e, sql);
                    }


                    return Result.updateZeroResult;

View Full Code Here

     * @throws HsqlException
     */
    private Result processScript() throws IOException, HsqlException {


        String           token = tokenizer.getString();
        ScriptWriterText dsw   = null;


        session.checkAdmin();


        try {
            if (tokenizer.wasValue()) {
                if (tokenizer.getType() != Types.VARCHAR) {
                    throw Trace.error(Trace.INVALID_IDENTIFIER);
                }


                dsw = new ScriptWriterText(database, token, true, true, true);


                dsw.writeAll();


                return new Result(ResultConstants.UPDATECOUNT);
            } else {
                tokenizer.back();


                return DatabaseScript.getScript(database, false);
            }
        } finally {
            if (dsw != null) {
                dsw.close();
            }
        }
    }

View Full Code Here

                } catch (HsqlException e) {
                    return Result.newErrorResult(e, sql);
                }
            }
            case StatementTypes.DATABASE_SCRIPT : {
                ScriptWriterText dsw  = null;
                String           name = (String) parameters[0];


                try {
                    session.checkAdmin();


                    if (name == null) {
                        return session.database.getScript(false);
                    } else {
                        dsw = new ScriptWriterText(session.database, name,
                                                   true, true, true);


                        dsw.writeAll();
                        dsw.close();


                        return Result.updateZeroResult;
                    }
                } catch (HsqlException e) {
                    return Result.newErrorResult(e, sql);

View Full Code Here

                }


                path = path + "/" + new File(database.getPath()).getName();
                scriptName = path + scriptFileExtension;


                ScriptWriterText dsw = new ScriptWriterText(database,
                    scriptName, true, true, true);


                dsw.writeAll();
                dsw.close();


                backup = new DbBackup(archiveFile, path, true);


                backup.write();
            } else {

View Full Code Here


        Crypto crypto = database.logger.getCrypto();


        try {
            if (crypto == null) {
                dbLogWriter = new ScriptWriterText(database, logFileName,
                                                   false, false, false);
            } else {
                dbLogWriter = new ScriptWriterEncode(database, logFileName,
                                                     crypto);
            }

View Full Code Here

        Crypto           crypto = database.logger.getCrypto();


        if (crypto == null) {
            boolean compressed = database.logger.propScriptFormat == 3;


            scw = new ScriptWriterText(database,
                                       scriptFileName
                                       + Logger.newFileExtension, full,
                                           compressed);
        } else {
            scw = new ScriptWriterEncode(database,

View Full Code Here

                } catch (HsqlException e) {
                    return Result.newErrorResult(e, sql);
                }
            }
            case StatementTypes.DATABASE_SCRIPT : {
                ScriptWriterText dsw  = null;
                String           name = (String) parameters[0];


                try {
                    session.checkAdmin();


                    if (name == null) {
                        return session.database.getScript(false);
                    } else {
                        dsw = new ScriptWriterText(session.database, name,
                                                   true, true, true);


                        dsw.writeAll();
                        dsw.close();


                        return Result.updateZeroResult;
                    }
                } catch (HsqlException e) {
                    return Result.newErrorResult(e, sql);

View Full Code Here

                }


                path = path + "/" + new File(database.getPath()).getName();
                scriptName = path + scriptFileExtension;


                ScriptWriterText dsw = new ScriptWriterText(database,
                    scriptName, true, true, true);


                dsw.writeAll();
                dsw.close();


                backup = new DbBackup(archiveFile, path, true);


                backup.write();
            } else {

View Full Code Here

0 1

TOP

Related Classes of org.hsqldb.scriptio.ScriptWriterText

org.hsqldb.DatabaseCommandInterpreter

org.hsqldb.persist.Log

org.hsqldb.persist.Logger

org.hsqldb.rowio.RowOutputTextLog

org.hsqldb.StatementCommand

java.util.zip.GZIPOutputStream

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.