search

kg-construct / rml-test-cases

RML conformance test suite
http://rml.io/test-cases/
Creative Commons Attribution 4.0 International
4 stars 12 forks source link

Config file for MySQL #31

Open Gautamshahi opened 4 years ago

Gautamshahi commented 4 years ago

Hi,

In the test case, there are multiple files for MySQL. which should I use for the beginners?

pheyvaer commented 4 years ago

Hi @Gautamshahi

To which test case are you referring?

Gautamshahi commented 4 years ago

Thanks for your reply. First of all, there are many test cases for MYSQL at https://github.com/RMLio/rml-test-cases/tree/master/test-cases what is the use of each test case?

Second, I started with test case https://github.com/RMLio/rml-test-cases/tree/master/test-cases/RMLTC0001b-MySQL

Why do we need resource..sql? What kind of query should it contain?

Again in the mapping.ttl file, rml:source <#DB_source>; is it referring to the DB_source as connection properties? Then in the connection properties, where should I put jdbc jar file and d2rq:Database, what I replace here?

It will great if you can provide an example or instruction file.

Thank you for your time.

Gautamshahi commented 4 years ago

@pheyvaer can you please provide a hint to resolve the issue?

pheyvaer commented 4 years ago

The resource.sql needs to be loaded in your MySQL database that should be running locally. Then in <#DB_source> you fill in the parameters so that they match your local MySQL instance. The JDBC jar should be used by the RML processor. For example in the case of the RMLMapper it is include by default.

What tool are you using the execute the test cases?