sql-metadata-plugin

Execute SQL to return result set metadata easily.

License	The Apache Software License, Version 2.0
Categories	Data
GroupId	io.github.pleuvoir
ArtifactId	sql-metadata-plugin
Last Version	1.0.3
Release Date	Dec 1, 2018
Type	jar
Description	sql-metadata-plugin Execute SQL to return result set metadata easily.
Project URL	https://github.com/pleuvoir/sql-metadata-plugin
Source Code Management	https://github.com/pleuvoir/sql-metadata-plugin

Download sql-metadata-plugin

Filename	Size
sql-metadata-plugin-1.0.3.pom
sql-metadata-plugin-1.0.3.jar	24 KB
sql-metadata-plugin-1.0.3-sources.jar	14 KB
sql-metadata-plugin-1.0.3-javadoc.jar	138 KB

How to add to project

Apache Maven

<!-- https://jarcasting.com/artifacts/io.github.pleuvoir/sql-metadata-plugin/ -->
<dependency>
    <groupId>io.github.pleuvoir</groupId>
    <artifactId>sql-metadata-plugin</artifactId>
    <version>1.0.3</version>
</dependency>

Gradle Groovy

// https://jarcasting.com/artifacts/io.github.pleuvoir/sql-metadata-plugin/
implementation 'io.github.pleuvoir:sql-metadata-plugin:1.0.3'

Gradle Kotlin

// https://jarcasting.com/artifacts/io.github.pleuvoir/sql-metadata-plugin/
implementation ("io.github.pleuvoir:sql-metadata-plugin:1.0.3")

Apache Buildr

'io.github.pleuvoir:sql-metadata-plugin:jar:1.0.3'

Apache Ivy

<dependency org="io.github.pleuvoir" name="sql-metadata-plugin" rev="1.0.3">
  <artifact name="sql-metadata-plugin" type="jar" />
</dependency>

Groovy Grape

@Grapes(
@Grab(group='io.github.pleuvoir', module='sql-metadata-plugin', version='1.0.3')
)

Scala SBT

libraryDependencies += "io.github.pleuvoir" % "sql-metadata-plugin" % "1.0.3"

Leiningen

[io.github.pleuvoir/sql-metadata-plugin "1.0.3"]

Dependencies

compile (4)

Group / Artifact	Type	Version
io.github.pleuvoir : plugin-base	jar	1.0.0
org.freemarker : freemarker	jar	2.3.23
com.alibaba : druid	jar	1.1.10
org.springframework : spring-context Optional	jar	5.0.6.RELEASE

test (2)

Group / Artifact	Type	Version
org.springframework : spring-test	jar	5.0.6.RELEASE
junit : junit	jar	4.12

Project Modules

There are no modules declared in this project.

sql-metadata-plugin

Execute SQL to return result-set metadata easily. It also provide template engine support for code-generator.

Usage

import dependency

<dependency>
	<groupId>io.github.pleuvoir</groupId>
	<artifactId>sql-metadata-plugin</artifactId>
	<version>${latest.version}</version>
</dependency>

register in spring container

<bean class="io.github.pleuvoir.sql.MetaDataConfiguration">
	<property name="ftlLocation" value="classpath:ftl" />

	<!-- if you use dataSourceConfig, Be careful of database driver -->
	<property name="dataSourceConfig">
		<bean class="io.github.pleuvoir.sql.bean.DataSourceConfig">
			<property name="driverClass" value="oracle.jdbc.OracleDriver" />
			<property name="url" value="jdbc:oracle:thin:@192.168.100.8:1521:cacplat" />
			<property name="username" value="auction_test" />
			<property name="password" value="auction_test" />
		</bean>
	</property>
</bean>

junit test

@Autowired
private DBScriptRunner dBScriptRunner;

@Test
public void contextTest() throws FileNotFoundException, IOException, TemplateException {

	// 1. get metaData
	MetaData metaData = dBScriptRunner.excute("select * from pub_param");

	String entityName = "pubParamPO";
	
	// 2. convert to dataModel
	DataModel dataModel = metaData.asDataModel().addData("entityName", entityName);

	System.out.println(dataModel.toJSON());
	
	// 3. write file ..
	dataModel.write("po.ftl", "D:\\" + entityName + ".java");
}

you can realize your TypeHandlerFactory to support more database type. look like this:

dBScriptRunner.setTypeHandlerFactory(new MyTypeHandlerFactory());
dBScriptRunner.excute("select * from pub_param", "org.h2.Driver");

LICENSE

Apache License

Versions

Version
1.0.3 Dec 1, 2018
1.0.2 Nov 16, 2018
1.0.1 Nov 16, 2018
1.0.0 Nov 13, 2018