src.main.java.org.kawanfw.sql.servlet.ServerLogout Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of aceql-http Show documentation

AceQL HTTP is a framework of REST like http APIs that allow to access to remote SQL databases over http from any device that supports http. AceQL HTTP is provided with three client SDK: - The AceQL C# Client SDK allows to wrap the HTTP APIs using Microsoft SQL Server like calls in their code, just like they would for a local database. - The AceQL Java Client JDBC Driver allows to wrap the HTTP APIs using JDBC calls in their code, just like they would for a local database. - The AceQL Python Client SDK allows SQL calls to be encoded with standard unmodified DB-API 2.0 syntax

There is a newer version: 12.2

Show newest version

/*
 * This file is part of AceQL HTTP.
 * AceQL HTTP: SQL Over HTTP
 * Copyright (C) 2020,  KawanSoft SAS
 * (http://www.kawansoft.com). All rights reserved.
 *
 * AceQL HTTP is free software; you can redistribute it and/or
 * modify it under the terms of the GNU Lesser General Public
 * License as published by the Free Software Foundation; either
 * version 2.1 of the License, or (at your option) any later version.
 *
 * AceQL HTTP is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 * Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public
 * License along with this library; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
 * 02110-1301  USA
 *
 * Any modifications to this file must keep this entire header
 * intact.
 */
package org.kawanfw.sql.servlet;

import java.io.File;
import java.io.IOException;
import java.io.OutputStream;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Objects;
import java.util.Set;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.commons.lang3.exception.ExceptionUtils;
import org.kawanfw.sql.api.server.DatabaseConfigurator;
import org.kawanfw.sql.api.server.session.SessionConfigurator;
import org.kawanfw.sql.servlet.connection.ConnectionStore;
import org.kawanfw.sql.servlet.sql.json_return.JsonErrorReturn;
import org.kawanfw.sql.servlet.sql.json_return.JsonOkReturn;
import org.kawanfw.sql.util.FrameworkDebug;

/**
 * @author Nicolas de Pomereu
 *
 */
public class ServerLogout {

    private static boolean DEBUG = FrameworkDebug.isSet(ServerLogout.class);;

    // A space
    public static final String SPACE = " ";

    private static final long TWENTY_MINUTES_IN_MILLISECONDS = 1000 * 60 * 20;


    public static void logout(HttpServletRequest request, HttpServletResponse response,
	    OutputStream out, DatabaseConfigurator databaseConfigurator) throws IOException {

	try {
	    response.setContentType("text/html");

	    String username = request.getParameter(HttpParameter.USERNAME);
	    String sessionId = request.getParameter(HttpParameter.SESSION_ID);

	    SessionConfigurator sessionConfigurator = ServerSqlManager.getSessionManagerConfigurator();
	    sessionConfigurator.remove(sessionId);

	    Set connections = ConnectionStore.getAllConnections(username, sessionId);

	    for (Connection connection : connections) {
		// ConnectionCloser.freeConnection(connection, databaseConfigurator);
		databaseConfigurator.close(connection);
	    }

	    ConnectionStore.removeAll(username, sessionId);

	    deleteOldBlobFiles(databaseConfigurator, username);

	    String jSonReturn = JsonOkReturn.build();

	    if (DEBUG) {
		System.err.println("jSonReturn: " + jSonReturn);
		System.err.println(sessionId);
	    }

	    ServerSqlManager.writeLine(out, jSonReturn);

	} catch (Exception e) {

	    JsonErrorReturn errorReturn = new JsonErrorReturn(response, HttpServletResponse.SC_INTERNAL_SERVER_ERROR,
		    JsonErrorReturn.ERROR_ACEQL_FAILURE, e.getMessage(), ExceptionUtils.getStackTrace(e));
	    ServerSqlManager.writeLine(out, errorReturn.build());

	}
    }

    /**
     * Delete all files, but do throw error if problem, except development control
     * null pointer exception
     *
     * @param databaseConfigurator
     * @param username
     */
    private static void deleteOldBlobFiles(DatabaseConfigurator databaseConfigurator, String username)
	    throws IOException, SQLException {

	Objects.requireNonNull(databaseConfigurator, "databaseConfigurator cannot be null!");
	Objects.requireNonNull(username, "username cannot be null!");

	// Delete all files
	File blobDirectory = databaseConfigurator.getBlobsDirectory(username);
	if (blobDirectory == null || !blobDirectory.exists()) {
	    return;
	}

	File[] files = blobDirectory.listFiles();

	if (files == null) {
	    return;
	}

	for (File file : files) {
	    if (file.lastModified() < System.currentTimeMillis() - TWENTY_MINUTES_IN_MILLISECONDS) {
		file.delete();
	    }
	}

    }

}