X-Git-Url: https://git.argeo.org/?a=blobdiff_plain;f=org.argeo.cms.pgsql%2Fsrc%2Forg%2Fargeo%2Fcms%2Fpgsql%2Futil%2FCheckPg.java;fp=org.argeo.cms.pgsql%2Fsrc%2Forg%2Fargeo%2Fcms%2Fpgsql%2Futil%2FCheckPg.java;h=9db43df25b75fff20701c8d61461d9fd66cad1dc;hb=6a094c2da64df3cd7d6515b035034a9bc671bcba;hp=0000000000000000000000000000000000000000;hpb=6e9508a68a3f907ff6bbdc622bbff522b28fe4b4;p=lgpl%2Fargeo-commons.git

diff --git a/org.argeo.cms.pgsql/src/org/argeo/cms/pgsql/util/CheckPg.java b/org.argeo.cms.pgsql/src/org/argeo/cms/pgsql/util/CheckPg.java
new file mode 100644
index 000000000..9db43df25
--- /dev/null
+++ b/org.argeo.cms.pgsql/src/org/argeo/cms/pgsql/util/CheckPg.java
@@ -0,0 +1,42 @@
+package org.argeo.cms.pgsql.util;
+
+import java.sql.Connection;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.sql.Statement;
+import java.util.ArrayList;
+import java.util.List;
+import java.util.Properties;
+
+import org.postgresql.Driver;
+
+/** Simple PostgreSQL check. */
+public class CheckPg {
+
+	public List<String> listTables() {
+		String osUser = System.getProperty("user.name");
+
+		String url = "jdbc:postgresql://localhost/" + osUser;
+		Properties props = new Properties();
+		props.setProperty("user", osUser);
+		props.setProperty("password", "changeit");
+		List<String> result = new ArrayList<>();
+
+		Driver driver = new Driver();
+		try (Connection conn = driver.connect(url, props); Statement s = conn.createStatement();) {
+			s.execute("SELECT * FROM pg_catalog.pg_tables");
+			ResultSet rs = s.getResultSet();
+			while (rs.next()) {
+				result.add(rs.getString("tablename"));
+			}
+			return result;
+		} catch (SQLException e) {
+			throw new IllegalStateException(e);
+		}
+	}
+
+	public static void main(String[] args) {
+		new CheckPg().listTables().forEach(System.out::println);
+	}
+
+}