dataexpress

DataExpress is a simple, Scala-based cross database ETL toolkit supporting Postgres, MySql, Oracle, SQLServer, and Sqlite.

License	BSD-style
Categories	Data Search Business Logic Libraries
GroupId	edu.chop.research.dbhi
ArtifactId	dataexpress_2.12
Last Version	0.9.3
Release Date	Jul 24, 2019
Type	jar
Description	dataexpress DataExpress is a simple, Scala-based cross database ETL toolkit supporting Postgres, MySql, Oracle, SQLServer, and Sqlite.
Project Organization	chop
Source Code Management	https://github.com/chop-dbhi/dataexpress

Download dataexpress_2.12

Filename	Size
dataexpress_2.12-0.9.3.pom
dataexpress_2.12-0.9.3.jar	559 KB
dataexpress_2.12-0.9.3-sources.jar	84 KB
dataexpress_2.12-0.9.3-javadoc.jar	1 MB

How to add to project

Apache Maven

<!-- https://jarcasting.com/artifacts/edu.chop.research.dbhi/dataexpress_2.12/ -->
<dependency>
    <groupId>edu.chop.research.dbhi</groupId>
    <artifactId>dataexpress_2.12</artifactId>
    <version>0.9.3</version>
</dependency>

Gradle Groovy

// https://jarcasting.com/artifacts/edu.chop.research.dbhi/dataexpress_2.12/
implementation 'edu.chop.research.dbhi:dataexpress_2.12:0.9.3'

Gradle Kotlin

// https://jarcasting.com/artifacts/edu.chop.research.dbhi/dataexpress_2.12/
implementation ("edu.chop.research.dbhi:dataexpress_2.12:0.9.3")

Apache Buildr

'edu.chop.research.dbhi:dataexpress_2.12:jar:0.9.3'

Apache Ivy

<dependency org="edu.chop.research.dbhi" name="dataexpress_2.12" rev="0.9.3">
  <artifact name="dataexpress_2.12" type="jar" />
</dependency>

Groovy Grape

@Grapes(
@Grab(group='edu.chop.research.dbhi', module='dataexpress_2.12', version='0.9.3')
)

Scala SBT

libraryDependencies += "edu.chop.research.dbhi" % "dataexpress_2.12" % "0.9.3"

Leiningen

[edu.chop.research.dbhi/dataexpress_2.12 "0.9.3"]

Dependencies

compile (3)

Group / Artifact	Type	Version
org.scala-lang : scala-library	jar	2.12.8
org.xerial : sqlite-jdbc	jar	3.28.0
mysql : mysql-connector-java	jar	8.0.16

test (2)

Group / Artifact	Type	Version
org.scalatest : scalatest_2.12	jar	3.0.8
junit : junit	jar	4.8.1

Project Modules

There are no modules declared in this project.

We now have a google group for DataExpress! Please come join the discussion and help us build a community

Getting Started

The official DataExpress website contains a tutorial and other basic information for new users

Downloading Binaries

The releases page contains the jars and tutorial starter files for DataExpress. You can use these if you're not familiar with Scala or the various JVM build processes

Using from SBT, Maven, etc...

DataExpress is published to the Sonatype OSS snapshot and release repositories. These repositories are pushed to Maven Central every 2 hours. This means that you can use releases without adding custom resolvers to your sbt build definition or custom repositories to your Maven POM. The group id (organization) is edu.chop.research and the artifact id (name) is dataexpress

To add a dependency to the latest release version of DataExpress to your sbt (0.12.x) build definition:

libraryDependencies += "edu.chop.research" %% "dataexpress" % "0.9.1.3"

If you would like to live on the (often bleeding-) edge, a snapshot version of DataExpress can go in your sbt (0.12.x) build definition:

resolvers += Opts.resolver.sonatypeSnapshots

libraryDependencies += "edu.chop.research" %% "dataexpress" % "0.9.1.4-SNAPSHOT"

Compiling from Source

The source code includes an SBT build.sbt configuration allowing for building.

All commands assume you are working in the dataexpress root directory, here ~/dataexpress)

1. Clone the source to a local project directory, here assume it is ~/dataexpress

2. Ensure both Scala SBT is installed see http://www.scala-sbt.org/

3. To compile current source code: $sbt compile

4. To test current source code: $sbt test

5. To package WITHOUT dependencies: $sbt package

6. To package a "fat jar" containing dependencies (e.g. database drivers) $sbt assembly Note: this excludes the Scala library; to include that as well, edit the line in build.sbt to read assembleArtifact in packageScala := true

7. To create scaladocs $sbt doc

8. To start a Scala console with DataExpress on the class path $sbt console

-Note this will also automatically perform the following imports: import edu.chop.cbmi.dataExpress.dsl.ETL._ import edu.chop.cbmi.dataExpress.dsl.ETL import edu.chop.cbmi.dataExpress.dsl.stores.SqlDb import edu.chop.cbmi.dataExpress.dataModels.RichOption._

Getting Involved and Contributing

See CONTRIBUTORS.md in the repo for all the details.

tl;dr: we would love your contributions!

DBHi

Department of Biomedical and Health Informatics

Versions

Version
0.9.3 Jul 24, 2019