Examples of SqlFile

com.dci.intellij.dbn.language.sql.SQLFile
org.hsqldb.cmdline.SqlFile
Encapsulation of SQL text and the environment under which it will executed with a JDBC Connection. 'SqlInputStream' would be a more precise name, but the content we are talking about here is what is colloqially known as the contents of "SQL file"s.
The file src/org/hsqldb/sample/SqlFileEmbedder.java in the HSQLDB distribution provides an example for using SqlFile to execute SQL files directly from your own Java classes.
The complexities of passing userVars and macros maps are to facilitate strong scoping (among blocks and nested scripts).
Some implementation comments and variable names use keywords based on the following definitions.
- COMMAND = Statement || SpecialCommand || BufferCommand
- Statement = SQL statement like "SQL Statement;"
- SpecialCommand = Special Command like "\x arg..."
- BufferCommand = Editing/buffer command like ":s/this/that/"
When entering SQL statements, you are always "appending" to the "immediate" command (not the "buffer", which is a different thing). All you can do to the immediate command is append new lines to it, execute it, or save it to buffer. When you are entering a buffer edit command like ":s/this/that/", your immediate command is the buffer-edit-command. The buffer is the command string that you are editing. The buffer usually contains either an exact copy of the last command executed or sent to buffer by entering a blank line, but BUFFER commands can change the contents of the buffer.
In general, the special commands mirror those of Postgresql's psql, but SqlFile handles command editing very differently than Postgresql does, in part because of Java's lack of support for raw tty I/O. The \p special command, in particular, is very different from psql's.
Buffer commands are unique to SQLFile. The ":" commands allow you to edit the buffer and to execute the buffer.
\d commands are very poorly supported for Mysql because (a) Mysql lacks most of the most basic JDBC support elements, and the most basic role and schema features, and (b) to access the Mysql data dictionary, one must change the database instance (to do that would require work to restore the original state and could have disastrous effects upon transactions).
The process*() methods, other than processBuffHist() ALWAYS execute on "buffer", and expect it to contain the method specific prefix (if any).
The input/output Reader/Stream are generally managed by the caller. An exception is that the input reader may be closed automatically or on demand by the user, since in some cases this class builds the Reader. There is no corresponding functionality for output since the user always has control over that object (which may be null or System.out).
@see The SqlTool chapter of the HyperSQL Utilities Guide @see org.hsqldb.sample.SqlFileEmbedder @version $Revision: 3628 $, $Date: 2010-06-05 20:44:08 -0400 (Sat, 05 Jun 2010) $ @author Blaine Simpson (blaine dot simpson at admc dot com)
org.hsqldb.util.SqlFile
Encapsulation of a sql text file like 'myscript.sql'. The ultimate goal is to run the execute() method to feed the SQL commands within the file to a jdbc connection. Some implementation comments and variable names use keywords based on the following definitions.
- COMMAND = Statement || SpecialCommand || BufferCommand Statement = SQL statement like "SQL Statement;" SpecialCommand = Special Command like "\x arg..." BufferCommand = Editing/buffer command like ":s/this/that/" When entering SQL statements, you are always "appending" to the "immediate" command (not the "buffer", which is a different thing). All you can do to the immediate command is append new lines to it, execute it, or save it to buffer. When you are entering a buffer edit command like ":s/this/that/", your immediate command is the buffer-edit-command. The buffer is the command string that you are editing. The buffer usually contains either an exact copy of the last command executed or sent to buffer by entering a blank line, but BUFFER commands can change the contents of the buffer. In general, the special commands mirror those of Postgresql's psql, but SqlFile handles command editing much different from Postgresql because of Java's lack of support for raw tty I/O. The \p special command, in particular, is very different from psql's. Buffer commands are unique to SQLFile. The ":" commands allow you to edit the buffer and to execute the buffer. \d commands are very poorly supported for Mysql because (a) Mysql lacks most of the most basic JDBC support elements, and the most basic role and schema features, and (b) to access the Mysql data dictionay, one must change the database instance (to do that would require work to restore the original state and could have disastrous effects upon transactions). To make changes to this class less destructive to external callers, the input parameters should be moved to setters (probably JavaBean setters would be best) instead of constructor args and System Properties. The process*() methods, other than processBuffHist() ALWAYS execute on "buffer", and expect it to contain the method specific prefix (if any). @version $Revision: 1.169 $ @author Blaine Simpson unsaved@users

Examples of com.dci.intellij.dbn.language.sql.SQLFile

        String condition = filter.getCondition();
        boolean isValidCondition = StringUtil.isNotEmptyOrSpaces(condition);
        selectStatement.append(isValidCondition ? condition : COMMENT);


        PsiFileFactory psiFileFactory = PsiFileFactory.getInstance(project);
        SQLFile selectStatementFile = (SQLFile)
                psiFileFactory.createFileFromText(
                    "filter.sql",
                    dataset.getLanguageDialect(SQLLanguage.INSTANCE),
                    selectStatement.toString());
        selectStatementFile.setParseRootId("subquery");


        selectStatementFile.setActiveConnection(dataset.getConnectionHandler());
        selectStatementFile.setCurrentSchema(dataset.getSchema());




        document = DocumentUtil.getDocument(selectStatementFile);
        document.createGuardedBlock(0, conditionStartOffset);
        editor = (EditorEx) EditorFactory.getInstance().createEditor(document, project);

View Full Code Here

Examples of com.dci.intellij.dbn.language.sql.SQLFile

        }


        if (previewDocument == null) {
            PsiFileFactory psiFileFactory = PsiFileFactory.getInstance(project);


            SQLFile selectStatementFile = (SQLFile)
                psiFileFactory.createFileFromText(
                    "filter.sql",
                    connectionHandler.getLanguageDialect(SQLLanguage.INSTANCE),
                    previewText);


            selectStatementFile.setActiveConnection(connectionHandler);
            selectStatementFile.setCurrentSchema(variablesBundle.getCurrentSchema());
            previewDocument = DocumentUtil.getDocument(selectStatementFile);


            viewer = (EditorEx) EditorFactory.getInstance().createViewer(previewDocument, project);
            viewer.setEmbeddedIntoDialogWrapper(true);
            JScrollPane viewerScrollPane = viewer.getScrollPane();

View Full Code Here

Examples of com.dci.intellij.dbn.language.sql.SQLFile

            }


            if (previewDocument == null) {
                PsiFileFactory psiFileFactory = PsiFileFactory.getInstance(dataset.getProject());


                SQLFile selectStatementFile = (SQLFile)
                        psiFileFactory.createFileFromText(
                                "filter.sql",
                                dataset.getLanguageDialect(SQLLanguage.INSTANCE),
                                selectStatement.toString());


                selectStatementFile.setActiveConnection(dataset.getConnectionHandler());
                selectStatementFile.setCurrentSchema(dataset.getSchema());
                previewDocument = DocumentUtil.getDocument(selectStatementFile);


                viewer = (EditorEx) EditorFactory.getInstance().createViewer(previewDocument, dataset.getProject());
                viewer.setEmbeddedIntoDialogWrapper(true);
                JScrollPane viewerScrollPane = viewer.getScrollPane();

View Full Code Here

Examples of org.hsqldb.cmdline.SqlFile

        sqlVarMap.put("invoker", getClass().getName());
        // This variable is pretty useless, but this should show you how to
        // set variables which you can access inside of scripts like *{this}.


        File file;
        SqlFile sqlFile;
        for (String fileString : fileStrings) {
            file = new File(fileString);
            if (!file.isFile())
                throw new IOException("SQL file not present: "
                        + file.getAbsolutePath());
            sqlFile = new SqlFile(file);
            sqlFile.setConnection(conn);
            sqlFile.addUserVars(sqlVarMap);
            sqlFile.execute();


            // The only reason for the following two statements is so that
            // changes made by one .sql file will effect the future SQL files.
            // Has no effect if you only execute one SQL file.
            conn = sqlFile.getConnection();
            sqlVarMap = sqlFile.getUserVars();
        }
    }

View Full Code Here

Examples of org.hsqldb.cmdline.SqlFile

    {
        Connection conn = null;
        try
        {
            conn = getConnection();
            SqlFile userDbSetup = new SqlFile( new File( file ) );
            userDbSetup.setConnection(conn);
            userDbSetup.execute();
        }
        catch( Exception e ) 
        {
            LOG.error( e.getMessage(), e );
        }

View Full Code Here

Examples of org.hsqldb.cmdline.SqlFile

        sqlVarMap.put("invoker", getClass().getName());
        // This variable is pretty useless, but this should show you how to
        // set variables which you can access inside of scripts like *{this}.


        File file;
        SqlFile sqlFile;
        for (String fileString : fileStrings) {
            file = new File(fileString);
            if (!file.isFile())
                throw new IOException("SQL file not present: "
                        + file.getAbsolutePath());
            sqlFile = new SqlFile(file);
            sqlFile.setConnection(conn);
            sqlFile.addUserVars(sqlVarMap);
            sqlFile.execute();


            // The only reason for the following two statements is so that
            // changes made by one .sql file will effect the future SQL files.
            // Has no effect if you only execute one SQL file.
            conn = sqlFile.getConnection();
            sqlVarMap = sqlFile.getUserVars();
        }
    }

View Full Code Here

Examples of org.hsqldb.cmdline.SqlFile

     */
    public void load(final Logger logger,
                     final Database database,
                     final Source source) {
        try {
            final SqlFile sqlFile = new SqlFile(
                    getReader(source),
                    source.getSourceFile(),
                    System.out,
                    null,
                    false,
                    null);
            final DataSource dataSource = ((SQLDatabase)database).getDataSource();
            final Connection connection = dataSource.getConnection();
            try {
                sqlFile.setConnection(connection);
                sqlFile.execute();
            } finally {
                connection.close();
            }
        } catch (final IOException exception) {
            final String message = MessageUtil.getMessage(CANNOT_READ_SOURCE_FILE, source.getSourceFile());

View Full Code Here

Examples of org.hsqldb.cmdline.SqlFile

        assert database != null;
        assert logger != null;
        assert source != null;


        try {
            final SqlFile sqlFile = new SqlFile(source);
            final DataSource dataSource = database.getDataSource();
            final Connection connection = dataSource.getConnection();
            try {
                sqlFile.setConnection(connection);
                sqlFile.execute();
                connection.commit();
            } finally {
                connection.close();
            }
        } catch (final IOException exception) {

View Full Code Here

Examples of org.hsqldb.cmdline.SqlFile

    assert database != null;
    assert logger != null;
    assert source != null;


    try {
      final SqlFile sqlFile = new SqlFile(source);
      final DataSource dataSource = database.getDataSource();
      final Connection connection = dataSource.getConnection();
      try {
        sqlFile.setConnection(connection);
        sqlFile.execute();
        connection.commit();
      } finally {
        connection.close();
      }
    } catch (final IOException exception) {

View Full Code Here

Examples of org.hsqldb.cmdline.SqlFile

     */
    public void load(final Logger logger,
                     final Database database,
                     final Source source) {
        try {
            final SqlFile sqlFile = new SqlFile(
                    getReader(source),
                    source.getSourceFile(),
                    System.out,
                    null,
                    false,
                    null);
            final DataSource dataSource = ((SQLDatabase)database).getDataSource();
            final Connection connection = dataSource.getConnection();
            try {
                sqlFile.setConnection(connection);
                sqlFile.execute();
            } finally {
                connection.close();
            }
        } catch (final IOException exception) {
            final String message = MessageUtil.getMessage(CANNOT_READ_SOURCE_FILE, source.getSourceFile());

View Full Code Here

0 1

TOP

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.