Mercurial Hosting > nabble
diff src/fschmidt/db/postgres/DbDatabaseImpl.java @ 68:00520880ad02
add fschmidt source
author | Franklin Schmidt <fschmidt@gmail.com> |
---|---|
date | Sun, 05 Oct 2025 17:24:15 -0600 |
parents | |
children |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/src/fschmidt/db/postgres/DbDatabaseImpl.java Sun Oct 05 17:24:15 2025 -0600 @@ -0,0 +1,76 @@ +/* +Copyright (c) 2008 Franklin Schmidt <fschmidt@gmail.com> + +Permission is hereby granted, free of charge, to any person obtaining a copy +of this software and associated documentation files (the "Software"), to deal +in the Software without restriction, including without limitation the rights +to use, copy, modify, merge, publish, distribute, sublicense, and/or sell +copies of the Software, and to permit persons to whom the Software is +furnished to do so, subject to the following conditions: + +The above copyright notice and this permission notice shall be included in +all copies or substantial portions of the Software. + +THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR +IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, +FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE +AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER +LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, +OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN +THE SOFTWARE. +*/ + +package fschmidt.db.postgres; + +import java.sql.Connection; +import java.sql.PreparedStatement; +import java.sql.Savepoint; +import java.sql.SQLException; +import fschmidt.db.DbArcana; + + +public final class DbDatabaseImpl extends fschmidt.db.base.DbDatabaseImpl implements DbArcana { + + public DbDatabaseImpl(String url,String user,String password) { + super(url,user,password); + try { + Class.forName("org.postgresql.Driver"); + } catch(ClassNotFoundException e) { + throw new RuntimeException(e); + } + } + + public DbArcana arcana() { + return this; + } + + public String quoteIdentifier(String identifier) { + return "\"" + identifier + "\""; + } + + public String getLastSeqValFn() { + return "lastval()"; + } + + public String dateSub(String date,int n,String units) { + return "(" + date + " - interval '" + n + " " + units + "')"; + } + + public static int executeUpdateIgnoringDuplicateKeys(PreparedStatement stmt) + throws SQLException + { + PostgresExceptionHandler peh = new PostgresExceptionHandler(stmt); + try { + return stmt.executeUpdate(); + } catch(SQLException e) { + if( e.getMessage().startsWith("ERROR: duplicate key value violates unique constraint ") ) { + peh.handleException(); + return 0; + } + throw e; + } finally { + peh.close(); + } + } + +}