Search in sources :

Example 6 with Command

use of st.photonbur.Discord.Bot.lightbotv3.command.Command in project h2database by h2database.

the class DatabaseInfo method listSessions.

@Override
public String listSessions() {
    StringBuilder buff = new StringBuilder();
    for (Session session : database.getSessions(false)) {
        buff.append("session id: ").append(session.getId());
        buff.append(" user: ").append(session.getUser().getName()).append('\n');
        buff.append("connected: ").append(new Timestamp(session.getSessionStart())).append('\n');
        Command command = session.getCurrentCommand();
        if (command != null) {
            buff.append("statement: ").append(session.getCurrentCommand()).append('\n');
            long commandStart = session.getCurrentCommandStart();
            if (commandStart != 0) {
                buff.append("started: ").append(new Timestamp(commandStart)).append('\n');
            }
        }
        Table[] t = session.getLocks();
        if (t.length > 0) {
            for (Table table : session.getLocks()) {
                if (table.isLockedExclusivelyBy(session)) {
                    buff.append("write lock on ");
                } else {
                    buff.append("read lock on ");
                }
                buff.append(table.getSchema().getName()).append('.').append(table.getName()).append('\n');
            }
        }
        buff.append('\n');
    }
    return buff.toString();
}
Also used : Table(org.h2.table.Table) Command(org.h2.command.Command) Timestamp(java.sql.Timestamp) Session(org.h2.engine.Session)

Aggregations

Command (org.h2.command.Command)6 Session (org.h2.engine.Session)3 IOException (java.io.IOException)2 Timestamp (java.sql.Timestamp)2 JdbcSQLException (org.h2.jdbc.JdbcSQLException)2 DbException (org.h2.message.DbException)2 ByteArrayInputStream (java.io.ByteArrayInputStream)1 InputStreamReader (java.io.InputStreamReader)1 Reader (java.io.Reader)1 ResultSet (java.sql.ResultSet)1 SQLException (java.sql.SQLException)1 ArrayList (java.util.ArrayList)1 HashMap (java.util.HashMap)1 Locale (java.util.Locale)1 Parser (org.h2.command.Parser)1 Constraint (org.h2.constraint.Constraint)1 ConstraintActionType (org.h2.constraint.ConstraintActionType)1 ConstraintReferential (org.h2.constraint.ConstraintReferential)1 ConstraintUnique (org.h2.constraint.ConstraintUnique)1 DbObject (org.h2.engine.DbObject)1