D-Net

{"type_source": "SVN", "goal": "package -U -T 4C source:jar", "url": "http://svn-public.driver.research-infrastructures.eu/driver/dnet40/modules/dnet-modular-database-ui/trunk/", "deploy_repository": "dnet4-snapshots", "version": "4", "mail": "sandro.labruzzo@isti.cnr.it,michele.artini@isti.cnr.it, claudio.atzori@isti.cnr.it, alessia.bardi@isti.cnr.it", "deploy_repository_url": "http://maven.research-infrastructures.eu/nexus/content/repositories/dnet4-snapshots", "name": "dnet-modular-database-ui"}

package eu.dnetlib.functionality.modular.ui.db;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.springframework.ui.ModelMap;

import eu.dnetlib.functionality.modular.ui.ModuleEntryPoint;

public class DbManagerEntryPointController extends ModuleEntryPoint {

	@Override

	protected void initialize(final ModelMap map, final HttpServletRequest request, final HttpServletResponse response) throws Exception {

	}

}

package eu.dnetlib.functionality.modular.ui.db;

import java.io.IOException;

import java.io.StringReader;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import javax.annotation.Resource;

import javax.servlet.ServletOutputStream;

import javax.servlet.ServletResponse;

import javax.servlet.http.HttpServletResponse;

import org.apache.commons.io.IOUtils;

import org.springframework.jdbc.support.rowset.SqlRowSet;

import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RequestParam;

import org.springframework.web.bind.annotation.ResponseBody;

import com.google.common.collect.Iterables;

import com.google.common.collect.Lists;

import eu.dnetlib.enabling.database.DatabaseServiceCore;

import eu.dnetlib.enabling.database.objects.DnetDatabase;

import eu.dnetlib.enabling.database.resultset.IterableRowSet;

import eu.dnetlib.enabling.resultset.client.utils.EPRUtils;

@Controller

public class DbManagerInternalController {

	public static final String CTYPE_CSS = "text/css";

	public static final String CTYPE_JS = "text/javascript";

	public static final String CTYPE_XML = "text/xml";

	public static final String CTYPE_TEXT = "text/plain";

	public static final String CTYPE_HTML = "text/html";

	@Resource

	private DatabaseServiceCore core;

	@RequestMapping("/ui/listDBs.do")

	public @ResponseBody List<DnetDatabase> listDatabases() throws Exception {

		return core.listDatabases();

	}

	@RequestMapping("/ui/listTables.do")

	public @ResponseBody List<Map<String, Object>> listTables(@RequestParam(value = "db", required = true) String db) throws Exception {

		final List<Map<String, Object>> tables = new ArrayList<Map<String, Object>>();

		final Map<String, String> logSize = new HashMap<String, String>();

		final String sql = IOUtils.toString(getClass().getResourceAsStream("tables_info.sql"));

		final SqlRowSet rows = core.getDbUtils().executeSql(db, sql, SqlRowSet.class);

		while (rows.next()) {

			final String tname = rows.getString("name");

			if (tname.endsWith("_log")) {

				logSize.put(tname.substring(0, tname.length() - 4), rows.getString("total"));

			} else {

				final Map<String, Object> t = new HashMap<String, Object>();

				t.put("name", rows.getString("name"));

				t.put("view", rows.getString("kind").equalsIgnoreCase("v"));

				t.put("data", rows.getString("data"));

				t.put("indices", rows.getString("indices"));

				t.put("total", rows.getString("total"));

				t.put("managed", core.getDbUtils().isManagedTable(db, tname));

				t.put("logged", core.getDbUtils().isLoggedTable(db, tname));

				t.put("dnetIdentifier", core.getDbUtils().getDefaultDnetIdentifier(db, tname));

				tables.add(t);

			}

		}

		for (Map<String, Object> t : tables) {

			if (logSize.containsKey(t.get("name"))) {

				t.put("logdata", logSize.get(t.get("name")));

			} else {

				t.put("logdata", "-");

			}

		}

		return tables;

	}

	@RequestMapping("/ui/manageDB.do")

	public @ResponseBody boolean manageDB(@RequestParam(value = "db", required = true) String db,

			@RequestParam(value = "manage", required = true) boolean b) throws Exception {

		core.changeDatabaseStatus(db, b);

		return true;

	}

	@RequestMapping("/ui/importEPR.do")

	public @ResponseBody boolean importEPR(@RequestParam(value = "db", required = true) String db,

			@RequestParam(value = "epr", required = true) String epr) throws Exception {

		core.importFromResultset(db, (new EPRUtils()).getEpr(epr));

		return true;

	}

	@RequestMapping("/ui/query.do")

	public @ResponseBody List<String> query(@RequestParam(value = "query", required = true) final String query,

			@RequestParam(value = "db", required = true) final String db,

			@RequestParam(value = "limit", required = true) int limit) throws Exception {

		return Lists.newArrayList(Iterables.limit(new IterableRowSet(db, query, null, core.getDbUtils()), limit));

	}

	@RequestMapping("/ui/changeTableManagement.do")

	public @ResponseBody boolean changeTableManagement(@RequestParam(value = "db", required = true) final String db,

			@RequestParam(value = "t", required = true) final String t) throws Exception {

		if (core.getDbUtils().isManagedTable(db, t)) {

			core.getDbUtils().removeManagementOfTable(db, t);

		} else {

			core.getDbUtils().prepareManagementOfTable(db, t);			

		}

		return true;

	} 

	@RequestMapping("/ui/changeIdentifiers.do")

	public @ResponseBody boolean changeId(HttpServletResponse res, 

			@RequestParam(value = "db", required = true) final String db,

			@RequestParam(value = "t", required = false) final String t) throws Exception {

		if (t == null || t.isEmpty()) {

			core.getDbUtils().reassignDefaultDnetIdentifiers(db);

		} else {

			core.getDbUtils().reassignDefaultDnetIdentifiers(db, t);

		}

		return true;

	} 

	@RequestMapping("/ui/changeTableLog.do")

	public @ResponseBody boolean changeTableLog(@RequestParam(value = "db", required = true) final String db,

			@RequestParam(value = "t", required = true) final String t) throws Exception {

		if (core.getDbUtils().isManagedTable(db, t)) {

			if (core.getDbUtils().isLoggedTable(db, t)) {

				core.getDbUtils().removeLogTable(db, t);

			} else {

				core.getDbUtils().addLogTable(db, t);			

			}

		}

		return true;

	} 

	@RequestMapping("/ui/describeTable.do")

	public @ResponseBody List<Map<?, ?>> describeTable(@RequestParam(value = "db", required = true) final String db,

			@RequestParam(value = "t", required = true) final String t) throws Exception {

		return core.getDbUtils().describeTable(db, t);

	} 

	@RequestMapping("/ui/dumpTable.do")

	public void dumpTable(final ServletResponse response, @RequestParam(value = "db", required = true) final String db,

			@RequestParam(value = "t", required = true) final String t) throws Exception {

		sendXML(response, core.getDbUtils().dumpTableAsXML(db,t));

	}

	@RequestMapping("/ui/dumpTableEPR.do")

	public void dumpTableEPR(final ServletResponse response, 

			@RequestParam(value = "db", required = true) final String db,

			@RequestParam(value = "t", required = true) final String t) throws Exception {

		sendXML(response, core.generateResultSet(db, t, null).toString());

	}

	public void sendXML(final ServletResponse response, final String xml) throws IOException {

		response.setContentType("text/xml");

		final ServletOutputStream out = response.getOutputStream();

		IOUtils.copy(new StringReader(xml), out);

		out.flush();

		out.close();

	}

}

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:jaxws="http://cxf.apache.org/jaxws"

	xmlns:sec="http://cxf.apache.org/configuration/security" xmlns:wsa="http://cxf.apache.org/ws/addressing"

	xmlns:p="http://www.springframework.org/schema/p" xmlns:http="http://cxf.apache.org/transports/http/configuration"

	xmlns:t="http://dnetlib.eu/springbeans/t" xmlns:template="http://dnetlib.eu/springbeans/template"

	xmlns:util="http://www.springframework.org/schema/util" xmlns:context="http://www.springframework.org/schema/context"

	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd

						http://cxf.apache.org/ws/addressing http://cxf.apache.org/schemas/ws-addr-conf.xsd

						http://cxf.apache.org/configuration/security http://cxf.apache.org/schemas/configuration/security.xsd

						http://cxf.apache.org/transports/http/configuration http://cxf.apache.org/schemas/configuration/http-conf.xsd

						http://cxf.apache.org/jaxws http://cxf.apache.org/schemas/jaxws.xsd

						http://dnetlib.eu/springbeans/template http://dnetlib.eu/springbeans/template.xsd

						http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util.xsd

						http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">

	<bean name="/ui/dbManager.do"

		class="eu.dnetlib.functionality.modular.ui.db.DbManagerEntryPointController"

		p:menu="Database Manager" 

		p:title="Database Manager"

		p:description="Manager for the Database Service" 

		p:group="Tools">

		<property name="permissionLevels">

			<set>

				<value>IS_ADMIN</value>

			</set>

		</property>

	</bean>

</beans>

SELECT c.relname AS name, 

		c.relkind as kind,

		pg_size_pretty(pg_relation_size(c.relname::text)) AS data,

		pg_size_pretty(pg_total_relation_size(c.relname::text)-pg_relation_size(c.relname::text)) AS indices,

		pg_size_pretty(pg_total_relation_size(c.relname::text)) AS total

FROM pg_class c

LEFT JOIN pg_namespace n ON n.oid = c.relnamespace

WHERE c.relkind IN ('r','v','')

	AND n.nspname NOT IN ('pg_catalog', 'pg_toast')

	AND pg_table_is_visible(c.oid)

ORDER BY c.relname;

$common/master( header={

	<script type="text/javascript" src="../resources/js/angular.min.js" ></script>

	<script type="text/javascript" src="../resources/js/angular-route.min.js"></script>

	<script type="text/javascript" src="../resources/js/db_manager.js"></script>

	<script type="text/javascript" src="../resources/js/db_manager_controllers.js"></script>

}, body={

	<div ng-app="dbManager">

		<div ng-view></div>

	</div>

} )$

<div class="well">

	<fieldset>

		<legend>

			<b>Database: </b><i>{{db}}</i> - <b>table: </b><i>{{table}}</i>  

		</legend>

		<div class="panel panel-info" ng-repeat="field in details">

			<div class="panel-heading"><b>Field: </b><i>{{field.column_name}}</i></div>

			<table class="table table-condensed">

				<tr ng-repeat="(k, v) in field" ng-show="v">

					<th class="col-xs-3">{{k}}</th>

					<td class="col-xs-9">{{v}}</td>

				</tr>

			</table>

		</div>

	</fieldset>

</div>

<table class="table table-hover">

	<thead>

		<tr>

			<th>Database</th>

			<th class="text-center">is Managed</th>

			<th class="text-right">Operations</th>

		</tr>

	</thead>

	<tbody>

		<tr ng-repeat="db in databases">

			<td><a href="javascript:void(0)" ng-click="go('/db/'+db.dbName)">{{db.dbName}}</a></td>

			<td class="text-center">

				<span ng-show="db.managed">

					<span class="label label-success">YES</span> / <a href="javascript:void(0)" ng-click="manageDB(db.dbName, false)">NO</a>

				</span>

				<span ng-show="!db.managed">

					<a href="javascript:void(0)" ng-click="manageDB(db.dbName, true)">YES</a> / <span class="label label-danger">NO</span>

				</span>

	  		</td>

			<td class="text-right">

				<button class="btn btn-sm btn-primary" ng-click="go('/q/' + db.dbName)">

					SQL Query

				</button>

				<button class="btn btn-sm btn-warning" ng-click="changeIdentifiers(db.dbName)">

					Fix D-Net Identifiers				

				</button>

			</td>

		</tr>

	</tbody>

</table>

<table class="table table-hover">

	<thead>

		<tr>

			<th>Table</th>

			<th>Database</th>

			<th class="text-center">Data</th>

			<th class="text-center">Indices</th>

			<th class="text-center">Total</th>

			<th class="text-center">Log data</th>

			<th class="text-center">Type</th>

			<th class="text-center">is Managed</th>

			<th class="text-center">is Logged</th>

			<th class="text-center">Default value for Dnet-ID</th>

			<th class="text-right">Dump</th>

		</tr>

	</thead>

	<tbody>

		<tr ng-repeat="t in dbtables">

			<td><a href="javascript:void(0)" ng-click="go('/t/' + db + '/' + t.name)">{{t.name}}</a></td>

			<td>{{db}}</td>

			<td class="text-center">{{t.data}}</td>

			<td class="text-center">{{t.indices}}</td>

			<td class="text-center">{{t.total}}</td>

			<td class="text-center">{{t.logdata}}</td>

			<td class="text-center">

				<span ng-show="t.view" class="label label-default">VIEW</span>

				<span ng-show="!t.view" class="label label-primary">TABLE</span>

			</td>

			<td class="text-center">

				<span ng-show="!t.view">

					<span ng-show="t.managed">

						<span class="label label-success">YES</span> / <a href="javascript:void(0)" ng-click="changeTableManagement(db, t.name)">NO</a>

					</span>

					<span ng-show="!t.managed">

						<a href="javascript:void(0)" ng-click="changeTableManagement(db, t.name)">YES</a> / <span class="label label-danger">NO</span>

					</span>

				</span>

			</td>

			<td class="text-center">

				<span ng-show="!t.view && t.managed">

					<span ng-show="t.logged">

						<span class="label label-success">YES</span> / <a href="javascript:void(0)" ng-click="changeTableLog(db, t.name)">NO</a>

					</span>

					<span ng-show="!t.logged">

						<a href="javascript:void(0)" ng-click="changeTableLog(db, t.name)">YES</a> / <span class="label label-danger">NO</span>

					</span>

				</span>

			</td>

			<td class="text-center">

				<form class="form-inline" ng-show="!t.view && t.managed">

					<input class="form-control input-sm" type="text" readonly="readonly"  ng-model="t.dnetIdentifier" />

					<button class="btn btn-sm btn-primary" ng-click="changeIdentifiers(db, t.name)">fix</button>

				</form>

			</td>

			<td class="text-right">

				<a href="dumpTable.do?db={{db}}&t={{t.name}}" class="btn btn-sm btn-primary">as XML</a>

				<a href="dumpTableEPR.do?db={{db}}&t={{t.name}}" class="btn btn-sm btn-primary">as EPR</a>

			</td>

		</tr>

	</tbody>

</table>

<form class="form-horizontal" role="form">

	<div class="form-group">

		<label for="dbInput" class="col-sm-2 control-label">Database</label>

		<div class="col-sm-4">

			<input class="form-control" id="dbInput" ng-model="db" readonly="readonly" />

		</div>

	</div>

	<div class="form-group">

		<label for="sqlInput" class="col-sm-2 control-label">SQL Query</label>

		<div class="col-sm-4">

			<textarea class="form-control" id="sqlInput" ng-model="sql"></textarea>

		</div>

	</div>

	<div class="form-group">

		<label for="limitInput" class="col-sm-2 control-label">Limit</label>

		<div class="col-sm-1">

			<input class="form-control" id="limitInput" ng-model="limit" />

		</div>

	</div>

	<div class="form-group">

		<div class="col-sm-offset-2 col-sm-4">

			<button class="btn btn-default" ng-click="searchSQL()">Search</button>

		</div>

	</div>

</form>

<div class="panel panel-primary" ng-repeat="r in results">

	<div class="panel-heading"><b>Result: </b><i>{{$index + 1}}</i></div>

	<div class="panel-body">

		{{r}}

	</div>

</div>

var dbManagerControllers = angular.module('dbManagerControllers', []);

function common_init($scope, $http, $sce, $location) {

	initSpinner();

	$scope.showError        = function(error)   { show_notification("error", error); }

	$scope.showNotification = function(message) { show_notification("info", message); }

	$scope.showSpinner      = function()        { showSpinner(); }

	$scope.hideSpinner      = function()        { hideSpinner(); }

	$scope.to_trusted       = function(html)    { return $sce.trustAsHtml(html); }

	$scope.go               = function(path)    { $location.path(path); }

	$scope.encodeValue      = function(val)     { return val; }

}

dbManagerControllers.controller('databasesCtrl', [

	'$scope', '$http', '$sce', '$location', 

	function ($scope, $http, $sce, $location) {

		common_init($scope, $http, $sce, $location);

		$scope.databases = [];

		$scope.listDatabases = function() {

			$scope.databases = [];

			$scope.showSpinner();

			$http.get('listDBs.do').success(function(data) {

				$scope.hideSpinner();

				$scope.databases = data;

		    }).error(function() {

	            $scope.showError('Something really bad must have happened to our fellow hamster..');

	            $scope.hideSpinner();

		    });

		}

		$scope.manageDB = function(db, b) {

			$scope.showSpinner();

			$http.get('manageDB.do?db=' + db + "&manage=" + b).success(function(data) {

				$scope.hideSpinner();

				$scope.showNotification("Management Mode Updated !");

				$scope.listDatabases();

		    }).error(function() {

	            $scope.showError('Something really bad must have happened to our fellow hamster..');

	            $scope.hideSpinner();

		    });

		}

		$scope.changeIdentifiers = function(db) {

			if (confirm("Are you sure ?")) {

				$scope.showSpinner();

				$http.get('changeIdentifiers.do?db=' + db).success(function(data) {

					$scope.hideSpinner();

					$scope.showNotification("Identifiers changed !");

					$scope.listDatabases();

			    }).error(function() {

		            $scope.showError('Something really bad must have happened to our fellow hamster..');

		            $scope.hideSpinner();

			    });

			}

		}

		$scope.listDatabases();

	}

]);

dbManagerControllers.controller('tablesCtrl', [

	'$scope', '$http', '$sce', '$location', '$routeParams',  

    function ($scope, $http, $sce, $location, $routeParams) {

		common_init($scope, $http, $sce, $location);

		$scope.db       = $routeParams.db;

		$scope.dbtables = [];

		$scope.listTables = function() {

			$scope.dbtables = [];

			$scope.showSpinner();

			$http.get('listTables.do?db=' + $scope.db).success(function(data) {

				$scope.hideSpinner();

				$scope.dbtables = data;

		    }).error(function() {

	            $scope.showError('Something really bad must have happened to our fellow hamster..');

	            $scope.hideSpinner();

		    });

		}

		$scope.changeTableManagement = function(db, t) {

			$scope.showSpinner();

			$http.get('changeTableManagement.do?db=' + db + "&t=" + t).success(function(data) {

				$scope.hideSpinner();

				$scope.showNotification("Management Mode Updated !");

				$scope.listTables();

		    }).error(function() {

	            $scope.showError('Something really bad must have happened to our fellow hamster..');

	            $scope.hideSpinner();

		    });

		}

		$scope.changeTableLog = function(db, t) {

			$scope.showSpinner();

			$http.get('changeTableLog.do?db=' + db + "&t=" + t).success(function(data) {

				$scope.hideSpinner();

				$scope.showNotification("Log Mode Updated !");

				$scope.listTables();

		    }).error(function() {

	            $scope.showError('Something really bad must have happened to our fellow hamster..');

	            $scope.hideSpinner();

		    });

		}

		$scope.changeIdentifiers = function(db, t) {

			if (confirm("Are you sure ?")) {

				$scope.showSpinner();

				$http.get('changeIdentifiers.do?db=' + db + '&t=' + t).success(function(data) {

					$scope.hideSpinner();

					$scope.showNotification("Identifiers changed !");

					$scope.listDatabases();

			    }).error(function() {

		            $scope.showError('Something really bad must have happened to our fellow hamster..');

		            $scope.hideSpinner();

			    });

			}

		}

		$scope.listTables();

	}

]);

dbManagerControllers.controller('tableDescCtrl', [

	'$scope', '$http', '$sce', '$location', '$routeParams',  

	function ($scope, $http, $sce, $location, $routeParams) {

		common_init($scope, $http, $sce, $location);

		$scope.db       = $routeParams.db;

		$scope.table    = $routeParams.t;

		$scope.details  = [];

		$scope.getTableDetails = function() {

			$scope.details = [];

			$scope.showSpinner();

			$http.get('describeTable.do?db=' + $scope.db + "&t=" + $scope.table).success(function(data) {

				$scope.hideSpinner();

				$scope.details = data;

		    }).error(function() {

	            $scope.showError('Something really bad must have happened to our fellow hamster..');

	            $scope.hideSpinner();

		    });

		}

		$scope.getTableDetails();

	}

]);

dbManagerControllers.controller('dbQueryCtrl', [

	'$scope', '$http', '$sce', '$location', '$routeParams',  

	function ($scope, $http, $sce, $location, $routeParams) {

		common_init($scope, $http, $sce, $location);

        $scope.db = $routeParams.db;

        $scope.sql = 'SELECT 1';

        $scope.limit = 100;

        $scope.results = [];

        $scope.searchSQL = function() {

			$scope.results = [];

			$scope.showSpinner();

			$http.defaults.headers.post["Content-Type"] = "application/x-www-form-urlencoded; charset=UTF-8";

            $http.post('query.do', $.param({

                    'db'    : $scope.db,

                    'limit' : $scope.limit,

                    'query' : $scope.sql

            })).success(function(data) {

				$scope.hideSpinner();

				$scope.results = data;

		    }).error(function() {

	            $scope.showError('Something really bad must have happened to our fellow hamster..');

	            $scope.hideSpinner();

		    });

		}

	}

]);

var module = angular.module('dbManager', ['ngRoute', 'dbManagerControllers']);

module.config([

	'$routeProvider',

	function($routeProvider) {

		$routeProvider

			.when('/dbs',      { templateUrl: '../resources/html/databases.html', controller: 'databasesCtrl' })

			.when('/db/:db',   { templateUrl: '../resources/html/tables.html',    controller: 'tablesCtrl'    })

			.when('/t/:db/:t', { templateUrl: '../resources/html/tableDesc.html', controller: 'tableDescCtrl' })

			.when('/q/:db',    { templateUrl: '../resources/html/dbQuery.html',   controller: 'dbQueryCtrl'   })

			.otherwise({ redirectTo: '/dbs' });

	}

]);

<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">

	<parent>

		<groupId>eu.dnetlib</groupId>

		<artifactId>dnet-parent</artifactId>

		<version>1.0.0</version>

	</parent>

	<modelVersion>4.0.0</modelVersion>

	<groupId>eu.dnetlib</groupId>

	<artifactId>dnet-modular-database-ui</artifactId>

	<packaging>jar</packaging>

	<version>2.1.1-SNAPSHOT</version>

	<scm>

	  <developerConnection>scm:svn:https://svn.driver.research-infrastructures.eu/driver/dnet40/modules/dnet-modular-database-ui/trunk</developerConnection>

	</scm>

	<dependencies>

		<dependency>

			<groupId>commons-fileupload</groupId>

			<artifactId>commons-fileupload</artifactId>

			<version>1.3.1</version>

		</dependency>

		<dependency>

			<groupId>eu.dnetlib</groupId>

			<artifactId>dnet-modular-ui</artifactId>

			<version>[3.0.0,4.0.0)</version>

		</dependency>

		<dependency>

			<groupId>junit</groupId>

			<artifactId>junit</artifactId>

			<version>${junit.version}</version>

			<scope>test</scope>

		</dependency>

		<dependency>

			<groupId>eu.dnetlib</groupId>

			<artifactId>cnr-enabling-database-service</artifactId>

			<version>[3.0.0,4.0.0)</version>

		</dependency>

		<dependency>

			<groupId>javax.servlet</groupId>

			<artifactId>javax.servlet-api</artifactId>

			<version>${javax.servlet.version}</version>

			<scope>provided</scope>

		</dependency>

	</dependencies>

</project>

{"type_source": "SVN", "goal": "package -U -T 4C source:jar", "url": "http://svn-public.driver.research-infrastructures.eu/driver/dnet40/modules/dnet-modular-database-ui/trunk/", "deploy_repository": "dnet4-snapshots", "version": "4", "mail": "sandro.labruzzo@isti.cnr.it,michele.artini@isti.cnr.it, claudio.atzori@isti.cnr.it, alessia.bardi@isti.cnr.it", "deploy_repository_url": "http://maven.research-infrastructures.eu/nexus/content/repositories/dnet4-snapshots", "name": "dnet-modular-database-ui"}

package eu.dnetlib.functionality.modular.ui.db;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.springframework.ui.ModelMap;

import eu.dnetlib.functionality.modular.ui.ModuleEntryPoint;

public class DbManagerEntryPointController extends ModuleEntryPoint {

	@Override

	protected void initialize(final ModelMap map, final HttpServletRequest request, final HttpServletResponse response) throws Exception {

	}

}

package eu.dnetlib.functionality.modular.ui.db;

import java.io.IOException;

import java.io.StringReader;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import javax.annotation.Resource;

import javax.servlet.ServletOutputStream;

import javax.servlet.ServletResponse;

import javax.servlet.http.HttpServletResponse;

import org.apache.commons.io.IOUtils;

import org.springframework.jdbc.support.rowset.SqlRowSet;

import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RequestParam;

import org.springframework.web.bind.annotation.ResponseBody;

import com.google.common.collect.Iterables;

import com.google.common.collect.Lists;

import eu.dnetlib.enabling.database.DatabaseServiceCore;

import eu.dnetlib.enabling.database.objects.DnetDatabase;

import eu.dnetlib.enabling.database.resultset.IterableRowSet;

import eu.dnetlib.enabling.resultset.client.utils.EPRUtils;

@Controller

public class DbManagerInternalController {

	public static final String CTYPE_CSS = "text/css";

	public static final String CTYPE_JS = "text/javascript";

	public static final String CTYPE_XML = "text/xml";

	public static final String CTYPE_TEXT = "text/plain";

	public static final String CTYPE_HTML = "text/html";

	@Resource

	private DatabaseServiceCore core;

	@RequestMapping("/ui/listDBs.do")

	public @ResponseBody List<DnetDatabase> listDatabases() throws Exception {

		return core.listDatabases();

	}

	@RequestMapping("/ui/listTables.do")

	public @ResponseBody List<Map<String, Object>> listTables(@RequestParam(value = "db", required = true) String db) throws Exception {

		final List<Map<String, Object>> tables = new ArrayList<Map<String, Object>>();

		final Map<String, String> logSize = new HashMap<String, String>();

		final String sql = IOUtils.toString(getClass().getResourceAsStream("tables_info.sql"));

		final SqlRowSet rows = core.getDbUtils().executeSql(db, sql, SqlRowSet.class);

		while (rows.next()) {

			final String tname = rows.getString("name");

			if (tname.endsWith("_log")) {

				logSize.put(tname.substring(0, tname.length() - 4), rows.getString("total"));

			} else {

				final Map<String, Object> t = new HashMap<String, Object>();

				t.put("name", rows.getString("name"));

				t.put("view", rows.getString("kind").equalsIgnoreCase("v"));

				t.put("data", rows.getString("data"));

				t.put("indices", rows.getString("indices"));

				t.put("total", rows.getString("total"));

				t.put("managed", core.getDbUtils().isManagedTable(db, tname));

				t.put("logged", core.getDbUtils().isLoggedTable(db, tname));

				t.put("dnetIdentifier", core.getDbUtils().getDefaultDnetIdentifier(db, tname));

				tables.add(t);

			}

		}

		for (Map<String, Object> t : tables) {

			if (logSize.containsKey(t.get("name"))) {

				t.put("logdata", logSize.get(t.get("name")));

			} else {

				t.put("logdata", "-");

			}

		}

		return tables;

	}

	@RequestMapping("/ui/manageDB.do")

	public @ResponseBody boolean manageDB(@RequestParam(value = "db", required = true) String db,

			@RequestParam(value = "manage", required = true) boolean b) throws Exception {

		core.changeDatabaseStatus(db, b);

		return true;

	}

	@RequestMapping("/ui/importEPR.do")

	public @ResponseBody boolean importEPR(@RequestParam(value = "db", required = true) String db,

			@RequestParam(value = "epr", required = true) String epr) throws Exception {

		core.importFromResultset(db, (new EPRUtils()).getEpr(epr));

		return true;

	}

	@RequestMapping("/ui/query.do")

	public @ResponseBody List<String> query(@RequestParam(value = "query", required = true) final String query,

			@RequestParam(value = "db", required = true) final String db,

			@RequestParam(value = "limit", required = true) int limit) throws Exception {

		return Lists.newArrayList(Iterables.limit(new IterableRowSet(db, query, null, core.getDbUtils()), limit));

	}

	@RequestMapping("/ui/changeTableManagement.do")

	public @ResponseBody boolean changeTableManagement(@RequestParam(value = "db", required = true) final String db,

			@RequestParam(value = "t", required = true) final String t) throws Exception {

		if (core.getDbUtils().isManagedTable(db, t)) {

			core.getDbUtils().removeManagementOfTable(db, t);

		} else {

			core.getDbUtils().prepareManagementOfTable(db, t);			

		}

		return true;

	} 

	@RequestMapping("/ui/changeIdentifiers.do")

	public @ResponseBody boolean changeId(HttpServletResponse res, 

			@RequestParam(value = "db", required = true) final String db,

			@RequestParam(value = "t", required = false) final String t) throws Exception {

		if (t == null || t.isEmpty()) {

			core.getDbUtils().reassignDefaultDnetIdentifiers(db);

		} else {

			core.getDbUtils().reassignDefaultDnetIdentifiers(db, t);

		}

		return true;

	} 

	@RequestMapping("/ui/changeTableLog.do")

	public @ResponseBody boolean changeTableLog(@RequestParam(value = "db", required = true) final String db,

			@RequestParam(value = "t", required = true) final String t) throws Exception {

		if (core.getDbUtils().isManagedTable(db, t)) {

			if (core.getDbUtils().isLoggedTable(db, t)) {

				core.getDbUtils().removeLogTable(db, t);

			} else {

				core.getDbUtils().addLogTable(db, t);			

			}

		}

		return true;

	} 

	@RequestMapping("/ui/describeTable.do")

	public @ResponseBody List<Map<?, ?>> describeTable(@RequestParam(value = "db", required = true) final String db,

			@RequestParam(value = "t", required = true) final String t) throws Exception {

		return core.getDbUtils().describeTable(db, t);

	} 

	@RequestMapping("/ui/dumpTable.do")

	public void dumpTable(final ServletResponse response, @RequestParam(value = "db", required = true) final String db,

			@RequestParam(value = "t", required = true) final String t) throws Exception {

		sendXML(response, core.getDbUtils().dumpTableAsXML(db,t));

	}

	@RequestMapping("/ui/dumpTableEPR.do")

	public void dumpTableEPR(final ServletResponse response, 

			@RequestParam(value = "db", required = true) final String db,

			@RequestParam(value = "t", required = true) final String t) throws Exception {

		sendXML(response, core.generateResultSet(db, t, null).toString());

	}

	public void sendXML(final ServletResponse response, final String xml) throws IOException {

		response.setContentType("text/xml");

		final ServletOutputStream out = response.getOutputStream();

		IOUtils.copy(new StringReader(xml), out);

		out.flush();

		out.close();

	}

}

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:jaxws="http://cxf.apache.org/jaxws"

	xmlns:sec="http://cxf.apache.org/configuration/security" xmlns:wsa="http://cxf.apache.org/ws/addressing"

	xmlns:p="http://www.springframework.org/schema/p" xmlns:http="http://cxf.apache.org/transports/http/configuration"

	xmlns:t="http://dnetlib.eu/springbeans/t" xmlns:template="http://dnetlib.eu/springbeans/template"

	xmlns:util="http://www.springframework.org/schema/util" xmlns:context="http://www.springframework.org/schema/context"

	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd

						http://cxf.apache.org/ws/addressing http://cxf.apache.org/schemas/ws-addr-conf.xsd

						http://cxf.apache.org/configuration/security http://cxf.apache.org/schemas/configuration/security.xsd

						http://cxf.apache.org/transports/http/configuration http://cxf.apache.org/schemas/configuration/http-conf.xsd

						http://cxf.apache.org/jaxws http://cxf.apache.org/schemas/jaxws.xsd

						http://dnetlib.eu/springbeans/template http://dnetlib.eu/springbeans/template.xsd

						http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util.xsd

						http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">

	<bean name="/ui/dbManager.do"

		class="eu.dnetlib.functionality.modular.ui.db.DbManagerEntryPointController"

		p:menu="Database Manager" 

		p:title="Database Manager"

		p:description="Manager for the Database Service" 

		p:group="Tools">

		<property name="permissionLevels">

			<set>

				<value>IS_ADMIN</value>

			</set>

		</property>

	</bean>

</beans>

SELECT c.relname AS name, 

		c.relkind as kind,

		pg_size_pretty(pg_relation_size(c.relname::text)) AS data,

		pg_size_pretty(pg_total_relation_size(c.relname::text)-pg_relation_size(c.relname::text)) AS indices,

		pg_size_pretty(pg_total_relation_size(c.relname::text)) AS total

FROM pg_class c

LEFT JOIN pg_namespace n ON n.oid = c.relnamespace

WHERE c.relkind IN ('r','v','')

	AND n.nspname NOT IN ('pg_catalog', 'pg_toast')

	AND pg_table_is_visible(c.oid)

ORDER BY c.relname;

$common/master( header={

	<script type="text/javascript" src="../resources/js/angular.min.js" ></script>

	<script type="text/javascript" src="../resources/js/angular-route.min.js"></script>

	<script type="text/javascript" src="../resources/js/db_manager.js"></script>

	<script type="text/javascript" src="../resources/js/db_manager_controllers.js"></script>

}, body={

	<div ng-app="dbManager">

		<div ng-view></div>

	</div>

} )$

<div class="well">

	<fieldset>

		<legend>

			<b>Database: </b><i>{{db}}</i> - <b>table: </b><i>{{table}}</i>  

		</legend>

		<div class="panel panel-info" ng-repeat="field in details">

			<div class="panel-heading"><b>Field: </b><i>{{field.column_name}}</i></div>

			<table class="table table-condensed">

				<tr ng-repeat="(k, v) in field" ng-show="v">

					<th class="col-xs-3">{{k}}</th>

					<td class="col-xs-9">{{v}}</td>

				</tr>

			</table>

		</div>

	</fieldset>

</div>

<table class="table table-hover">

	<thead>

		<tr>

			<th>Database</th>

			<th class="text-center">is Managed</th>

			<th class="text-right">Operations</th>

		</tr>

	</thead>

	<tbody>

		<tr ng-repeat="db in databases">

			<td><a href="javascript:void(0)" ng-click="go('/db/'+db.dbName)">{{db.dbName}}</a></td>

			<td class="text-center">

				<span ng-show="db.managed">

					<span class="label label-success">YES</span> / <a href="javascript:void(0)" ng-click="manageDB(db.dbName, false)">NO</a>

				</span>

				<span ng-show="!db.managed">

					<a href="javascript:void(0)" ng-click="manageDB(db.dbName, true)">YES</a> / <span class="label label-danger">NO</span>

				</span>

	  		</td>

			<td class="text-right">

				<button class="btn btn-sm btn-primary" ng-click="go('/q/' + db.dbName)">

					SQL Query

				</button>

				<button class="btn btn-sm btn-warning" ng-click="changeIdentifiers(db.dbName)">

					Fix D-Net Identifiers				

				</button>

			</td>

		</tr>

	</tbody>

</table>

<table class="table table-hover">

	<thead>

		<tr>

			<th>Table</th>

			<th>Database</th>

			<th class="text-center">Data</th>

			<th class="text-center">Indices</th>

			<th class="text-center">Total</th>

			<th class="text-center">Log data</th>

			<th class="text-center">Type</th>

			<th class="text-center">is Managed</th>

			<th class="text-center">is Logged</th>

			<th class="text-center">Default value for Dnet-ID</th>

			<th class="text-right">Dump</th>

		</tr>

	</thead>

	<tbody>

		<tr ng-repeat="t in dbtables">

			<td><a href="javascript:void(0)" ng-click="go('/t/' + db + '/' + t.name)">{{t.name}}</a></td>

			<td>{{db}}</td>

			<td class="text-center">{{t.data}}</td>

			<td class="text-center">{{t.indices}}</td>

			<td class="text-center">{{t.total}}</td>

			<td class="text-center">{{t.logdata}}</td>

			<td class="text-center">

				<span ng-show="t.view" class="label label-default">VIEW</span>

				<span ng-show="!t.view" class="label label-primary">TABLE</span>

			</td>

			<td class="text-center">

				<span ng-show="!t.view">

					<span ng-show="t.managed">

						<span class="label label-success">YES</span> / <a href="javascript:void(0)" ng-click="changeTableManagement(db, t.name)">NO</a>

					</span>

					<span ng-show="!t.managed">

						<a href="javascript:void(0)" ng-click="changeTableManagement(db, t.name)">YES</a> / <span class="label label-danger">NO</span>

					</span>

				</span>

			</td>

			<td class="text-center">

				<span ng-show="!t.view && t.managed">

					<span ng-show="t.logged">

						<span class="label label-success">YES</span> / <a href="javascript:void(0)" ng-click="changeTableLog(db, t.name)">NO</a>

					</span>

					<span ng-show="!t.logged">

						<a href="javascript:void(0)" ng-click="changeTableLog(db, t.name)">YES</a> / <span class="label label-danger">NO</span>

					</span>

				</span>

			</td>

			<td class="text-center">

				<form class="form-inline" ng-show="!t.view && t.managed">

					<input class="form-control input-sm" type="text" readonly="readonly"  ng-model="t.dnetIdentifier" />

					<button class="btn btn-sm btn-primary" ng-click="changeIdentifiers(db, t.name)">fix</button>

				</form>

			</td>

			<td class="text-right">

				<a href="dumpTable.do?db={{db}}&t={{t.name}}" class="btn btn-sm btn-primary">as XML</a>

				<a href="dumpTableEPR.do?db={{db}}&t={{t.name}}" class="btn btn-sm btn-primary">as EPR</a>

			</td>

		</tr>

	</tbody>

</table>

<form class="form-horizontal" role="form">

	<div class="form-group">

		<label for="dbInput" class="col-sm-2 control-label">Database</label>

		<div class="col-sm-4">

			<input class="form-control" id="dbInput" ng-model="db" readonly="readonly" />

		</div>

	</div>

	<div class="form-group">

		<label for="sqlInput" class="col-sm-2 control-label">SQL Query</label>

		<div class="col-sm-4">

			<textarea class="form-control" id="sqlInput" ng-model="sql"></textarea>

		</div>

	</div>

	<div class="form-group">

		<label for="limitInput" class="col-sm-2 control-label">Limit</label>

		<div class="col-sm-1">

			<input class="form-control" id="limitInput" ng-model="limit" />

		</div>

	</div>

	<div class="form-group">

		<div class="col-sm-offset-2 col-sm-4">

			<button class="btn btn-default" ng-click="searchSQL()">Search</button>

		</div>

	</div>

</form>

<div class="panel panel-primary" ng-repeat="r in results">

	<div class="panel-heading"><b>Result: </b><i>{{$index + 1}}</i></div>

	<div class="panel-body">

		{{r}}

	</div>

</div>

var dbManagerControllers = angular.module('dbManagerControllers', []);

function common_init($scope, $http, $sce, $location) {

	initSpinner();

	$scope.showError        = function(error)   { show_notification("error", error); }

	$scope.showNotification = function(message) { show_notification("info", message); }

	$scope.showSpinner      = function()        { showSpinner(); }

	$scope.hideSpinner      = function()        { hideSpinner(); }

	$scope.to_trusted       = function(html)    { return $sce.trustAsHtml(html); }

	$scope.go               = function(path)    { $location.path(path); }

	$scope.encodeValue      = function(val)     { return val; }

}

dbManagerControllers.controller('databasesCtrl', [

	'$scope', '$http', '$sce', '$location', 

	function ($scope, $http, $sce, $location) {

		common_init($scope, $http, $sce, $location);

		$scope.databases = [];

		$scope.listDatabases = function() {

			$scope.databases = [];

			$scope.showSpinner();

			$http.get('listDBs.do').success(function(data) {

				$scope.hideSpinner();

				$scope.databases = data;

		    }).error(function() {

	            $scope.showError('Something really bad must have happened to our fellow hamster..');

	            $scope.hideSpinner();

		    });

		}

		$scope.manageDB = function(db, b) {

			$scope.showSpinner();

			$http.get('manageDB.do?db=' + db + "&manage=" + b).success(function(data) {

				$scope.hideSpinner();

				$scope.showNotification("Management Mode Updated !");

				$scope.listDatabases();

		    }).error(function() {

	            $scope.showError('Something really bad must have happened to our fellow hamster..');

	            $scope.hideSpinner();

		    });

		}

		$scope.changeIdentifiers = function(db) {

			if (confirm("Are you sure ?")) {

				$scope.showSpinner();

				$http.get('changeIdentifiers.do?db=' + db).success(function(data) {

					$scope.hideSpinner();

					$scope.showNotification("Identifiers changed !");

					$scope.listDatabases();

			    }).error(function() {

		            $scope.showError('Something really bad must have happened to our fellow hamster..');

		            $scope.hideSpinner();

			    });

			}

		}

		$scope.listDatabases();

	}

]);

dbManagerControllers.controller('tablesCtrl', [

	'$scope', '$http', '$sce', '$location', '$routeParams',  

    function ($scope, $http, $sce, $location, $routeParams) {

		common_init($scope, $http, $sce, $location);

		$scope.db       = $routeParams.db;

		$scope.dbtables = [];

		$scope.listTables = function() {

			$scope.dbtables = [];

			$scope.showSpinner();

			$http.get('listTables.do?db=' + $scope.db).success(function(data) {

				$scope.hideSpinner();

				$scope.dbtables = data;

		    }).error(function() {

	            $scope.showError('Something really bad must have happened to our fellow hamster..');

	            $scope.hideSpinner();

		    });

		}

		$scope.changeTableManagement = function(db, t) {

			$scope.showSpinner();

			$http.get('changeTableManagement.do?db=' + db + "&t=" + t).success(function(data) {

				$scope.hideSpinner();

				$scope.showNotification("Management Mode Updated !");

				$scope.listTables();

		    }).error(function() {

	            $scope.showError('Something really bad must have happened to our fellow hamster..');

	            $scope.hideSpinner();

		    });

		}

		$scope.changeTableLog = function(db, t) {

			$scope.showSpinner();

			$http.get('changeTableLog.do?db=' + db + "&t=" + t).success(function(data) {

				$scope.hideSpinner();

				$scope.showNotification("Log Mode Updated !");

				$scope.listTables();

		    }).error(function() {

	            $scope.showError('Something really bad must have happened to our fellow hamster..');

	            $scope.hideSpinner();

		    });

		}

		$scope.changeIdentifiers = function(db, t) {

			if (confirm("Are you sure ?")) {

				$scope.showSpinner();

				$http.get('changeIdentifiers.do?db=' + db + '&t=' + t).success(function(data) {

					$scope.hideSpinner();

					$scope.showNotification("Identifiers changed !");

					$scope.listDatabases();

			    }).error(function() {

		            $scope.showError('Something really bad must have happened to our fellow hamster..');

		            $scope.hideSpinner();

			    });

			}

		}

		$scope.listTables();

	}

]);

dbManagerControllers.controller('tableDescCtrl', [

	'$scope', '$http', '$sce', '$location', '$routeParams',  

	function ($scope, $http, $sce, $location, $routeParams) {

		common_init($scope, $http, $sce, $location);

		$scope.db       = $routeParams.db;

		$scope.table    = $routeParams.t;

		$scope.details  = [];

		$scope.getTableDetails = function() {

			$scope.details = [];

			$scope.showSpinner();

			$http.get('describeTable.do?db=' + $scope.db + "&t=" + $scope.table).success(function(data) {

				$scope.hideSpinner();

				$scope.details = data;

		    }).error(function() {

	            $scope.showError('Something really bad must have happened to our fellow hamster..');

	            $scope.hideSpinner();

		    });

		}

		$scope.getTableDetails();

	}

]);

dbManagerControllers.controller('dbQueryCtrl', [

	'$scope', '$http', '$sce', '$location', '$routeParams',  

	function ($scope, $http, $sce, $location, $routeParams) {

		common_init($scope, $http, $sce, $location);

        $scope.db = $routeParams.db;

        $scope.sql = 'SELECT 1';

        $scope.limit = 100;

        $scope.results = [];

        $scope.searchSQL = function() {

			$scope.results = [];

			$scope.showSpinner();

			$http.defaults.headers.post["Content-Type"] = "application/x-www-form-urlencoded; charset=UTF-8";

            $http.post('query.do', $.param({

                    'db'    : $scope.db,

                    'limit' : $scope.limit,

                    'query' : $scope.sql

            })).success(function(data) {

				$scope.hideSpinner();

				$scope.results = data;

		    }).error(function() {

	            $scope.showError('Something really bad must have happened to our fellow hamster..');

	            $scope.hideSpinner();

		    });

		}

	}

]);

var module = angular.module('dbManager', ['ngRoute', 'dbManagerControllers']);

module.config([

	'$routeProvider',

	function($routeProvider) {

		$routeProvider

			.when('/dbs',      { templateUrl: '../resources/html/databases.html', controller: 'databasesCtrl' })

			.when('/db/:db',   { templateUrl: '../resources/html/tables.html',    controller: 'tablesCtrl'    })

			.when('/t/:db/:t', { templateUrl: '../resources/html/tableDesc.html', controller: 'tableDescCtrl' })

			.when('/q/:db',    { templateUrl: '../resources/html/dbQuery.html',   controller: 'dbQueryCtrl'   })

			.otherwise({ redirectTo: '/dbs' });

	}

]);

<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">

	<parent>

		<groupId>eu.dnetlib</groupId>

		<artifactId>dnet-parent</artifactId>

		<version>1.0.0</version>

	</parent>

	<modelVersion>4.0.0</modelVersion>

	<groupId>eu.dnetlib</groupId>

	<artifactId>dnet-modular-database-ui</artifactId>

	<packaging>jar</packaging>

	<version>1.0.0</version>

	<scm>

	  <developerConnection>scm:svn:https://svn.driver.research-infrastructures.eu/driver/dnet40/modules/dnet-modular-database-ui/tags/dnet-modular-database-ui-1.0.0</developerConnection>

	</scm>

	<dependencies>

		<dependency>

			<groupId>commons-fileupload</groupId>

			<artifactId>commons-fileupload</artifactId>

			<version>1.3.1</version>

		</dependency>

		<dependency>

			<groupId>eu.dnetlib</groupId>

			<artifactId>dnet-modular-ui</artifactId>

			<version>[2.0.0,3.0.0)</version>

		</dependency>

		<dependency>

			<groupId>junit</groupId>

			<artifactId>junit</artifactId>

			<version>${junit.version}</version>

			<scope>test</scope>

		</dependency>

		<dependency>

			<groupId>eu.dnetlib</groupId>

			<artifactId>cnr-enabling-database-service</artifactId>

			<version>[1.0.0,)</version>

		</dependency>

		<dependency>

			<groupId>javax.servlet</groupId>

			<artifactId>javax.servlet-api</artifactId>

			<version>${javax.servlet.version}</version>

			<scope>provided</scope>

		</dependency>

	</dependencies>

</project>

{"type_source": "SVN", "goal": "package -U -T 4C source:jar", "url": "http://svn-public.driver.research-infrastructures.eu/driver/dnet40/modules/dnet-modular-database-ui/trunk/", "deploy_repository": "dnet4-snapshots", "version": "4", "mail": "sandro.labruzzo@isti.cnr.it,michele.artini@isti.cnr.it, claudio.atzori@isti.cnr.it, alessia.bardi@isti.cnr.it", "deploy_repository_url": "http://maven.research-infrastructures.eu/nexus/content/repositories/dnet4-snapshots", "name": "dnet-modular-database-ui"}

package eu.dnetlib.functionality.modular.ui.db;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.springframework.ui.ModelMap;

import eu.dnetlib.functionality.modular.ui.ModuleEntryPoint;

public class DbManagerEntryPointController extends ModuleEntryPoint {

	@Override

	protected void initialize(final ModelMap map, final HttpServletRequest request, final HttpServletResponse response) throws Exception {

	}

}

package eu.dnetlib.functionality.modular.ui.db;

import java.io.IOException;

import java.io.StringReader;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import javax.annotation.Resource;

import javax.servlet.ServletOutputStream;

import javax.servlet.ServletResponse;

import javax.servlet.http.HttpServletResponse;

import org.apache.commons.io.IOUtils;

import org.springframework.jdbc.support.rowset.SqlRowSet;

import org.springframework.stereotype.Controller;