io.vulpine.lib:sql-import

SQL resource loading

License	Apache License, Version 2.0
GroupId	io.vulpine.lib
ArtifactId	sql-import
Last Version	0.2.1
Release Date	Jun 18, 2018
Type	jar
Description	io.vulpine.lib:sql-import SQL resource loading
Project URL	https://github.com/foxcapades/java-sql-import
Project Organization	Foxcapades
Source Code Management	https://github.com/foxcapades/java-sql-import

Download sql-import

Filename	Size
sql-import-0.2.1.pom
sql-import-0.2.1.jar	3 KB
sql-import-0.2.1-sources.jar	3 KB
sql-import-0.2.1-javadoc.jar	365 KB

How to add to project

Apache Maven

<!-- https://jarcasting.com/artifacts/io.vulpine.lib/sql-import/ -->
<dependency>
    <groupId>io.vulpine.lib</groupId>
    <artifactId>sql-import</artifactId>
    <version>0.2.1</version>
</dependency>

Gradle Groovy

// https://jarcasting.com/artifacts/io.vulpine.lib/sql-import/
implementation 'io.vulpine.lib:sql-import:0.2.1'

Gradle Kotlin

// https://jarcasting.com/artifacts/io.vulpine.lib/sql-import/
implementation ("io.vulpine.lib:sql-import:0.2.1")

Apache Buildr

'io.vulpine.lib:sql-import:jar:0.2.1'

Apache Ivy

<dependency org="io.vulpine.lib" name="sql-import" rev="0.2.1">
  <artifact name="sql-import" type="jar" />
</dependency>

Groovy Grape

@Grapes(
@Grab(group='io.vulpine.lib', module='sql-import', version='0.2.1')
)

Scala SBT

libraryDependencies += "io.vulpine.lib" % "sql-import" % "0.2.1"

Leiningen

[io.vulpine.lib/sql-import "0.2.1"]

Dependencies

There are no dependencies for this project. It is a standalone project that does not depend on any other jars.

Project Modules

There are no modules declared in this project.

sql-import

SQL resource loading & caching.

Reads from a configurable standardized directory layout organized by query type.

Queries are cached per SqlLoader instance so repeated loads of the same query will only incur the filesystem I/O cost once.

Import functions utilize the java.util.Optional type. In the event that a query does not exist or cannot be loaded, an empty Optional will be returned, otherwise the Optional will contain the SQL text loaded from the specified file.

Examples

Resource directory using default settings

/resource-dir (src/main/resources for Gradle projects)
  └─ /sql
      ├─ /delete
      │   ├─ /comments
      │   │   ├─ by-id.sql
      │   │   └─ by-user.sql
      │   └─ /users
      │       └─ by-id.sql
      ├─ /insert
      │   ├─ /comment.sql
      │   └─ /user.sql
      ├─ /select
      (etc...)

Using the example above loading queries could be accomplished by the following:

Example.java

public void example() {
  var loader      = new SqlLoader(); // (1)
  var delComments = loader.delete("comments.by-user"); // (2)
  var delUsers    = loader.delete("users/by-id"); // (3)
  var insUser     = loader.insert("user");
}

1. Defaulted SqlLoader instance

2. Import using dot notation

3. Import using path notation

Versions

Version
0.2.1 Jun 18, 2018
0.2.0 Jun 18, 2018