Mercurial Hosting > nabble
diff src/fschmidt/db/h2/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/h2/DbDatabaseImpl.java Sun Oct 05 17:24:15 2025 -0600 @@ -0,0 +1,55 @@ +/* +Copyright (c) 2009 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.h2; + +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.h2.Driver"); + } catch(ClassNotFoundException e) { + throw new RuntimeException(e); + } + } + + public DbArcana arcana() { + return this; + } + + public String quoteIdentifier(String identifier) { + return "`" + identifier + "`"; + } + + public String getLastSeqValFn() { + return "IDENTITY()"; + } + + public String dateSub(String date,int n,String units) { + return "dateadd('" + units + "'," + (-n) + "," + date + ")"; + } + +}