Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Operations on more than one connection? #2

Closed
aadrian opened this issue Jul 20, 2018 · 9 comments
Closed

Operations on more than one connection? #2

aadrian opened this issue Jul 20, 2018 · 9 comments

Comments

@aadrian
Copy link

aadrian commented Jul 20, 2018

Any plans allowing operations on more than one connection?

It seems that quite allot of cases involves work on more than one DB (and sometimes those are not even the same DB type, or support DB Link like Oracle to be able to work with a single connection).

Thank you.
@krpors
Copy link
Owner

krpors commented Jul 21, 2018

Interesting use-case I suppose. It wasn't my initial target solution but I'll have to think about it (in terms of UI and quite possibly the impact of refactoring).

@krpors
Copy link
Owner

krpors commented Aug 1, 2018

Been thinking about it. I guess your original problem is that you want to make drill-down, except the target is not the same database, right?

In that case, I could make an additional context sub-menu to select a different active connection, and make it execute on that.

@aadrian
Copy link
Author

aadrian commented Aug 1, 2018

Been thinking about it. I guess your original problem is that you want to make drill-down, except the target is not the same database, right?

Yes.
Sometimes there are different DBs (even different DB types), other times are just different users that are not allowed to see every schema and table, so more than one connection (with different user) is required to analyze a certain problem.

In other cases would be nice to be able execute the same steps, the same way (like a replay) on a different connection - e.g. 7 drilldown steps on the Test DB, to be performed on the Production DB too, in order to be able to compare them side by side :) .

In that case, I could make an additional context sub-menu to select a different active connection, and make it execute on that.

This would probably solve most use cases.

If a "short name" for the connection would be also displayed in the drill down tree, e.g. "Get product item - (db=oracle)" instead of the actual in https://camo.githubusercontent.com/00812d5635e93a434361565e02567adbed3f1aa8/68747470733a2f2f692e696d6775722e636f6d2f494934546863592e706e67 , than it would be easy to use even for complex drill downs and it would no confusion.

Thank you!

@krpors
Copy link
Owner

krpors commented Aug 10, 2018

I've been playing around a bit. This is the thing I came up with:

In the screenshot, I am currently in the "In memory HSQL database as SA" connection. Depending on how many connections are open, an extra submenu will be displayed per connection (in this case it's "HSQL file as SA"). Using that submenu, you can execute the same subqueries, except on a different connection.

I'm not sure if it covers your use-case. If you want, you can try it out via the interconn branch. Ideas or comments are welcome!

@aadrian
Copy link
Author

aadrian commented Aug 10, 2018 •
edited
Loading

This is the thing I came up with: ...
Using that submenu, you can execute the same subqueries, except on a different connection.

@krpors wow, this looks great!

.. you can try it out via the interconn branch ...

Building with mvn clean package assembly:single as described in the https://github.com/krpors/gimlet#compiling-and-packaging section, seems to fail. Had to run it with -DskipTests

Ideas or comments are welcome!

So far looks very very good :) .
For the various smaller improvement comments I'll make separate tickets.

@krpors
Copy link
Owner

krpors commented Aug 12, 2018

Building with mvn clean package assembly:single as described in the https://github.com/krpors/gimlet#compiling-and-packaging section, seems to fail

What error did you get? I'm not getting any errors on my end.

@aadrian
Copy link
Author

aadrian commented Aug 12, 2018 

C:\work_2018\gimlet>mvn clean package assembly:single
[INFO] Scanning for projects...
[INFO]
[INFO] ----------------------< cruft.wtf.gimlet:gimlet >-----------------------
[INFO] Building Gimlet 1.3-SNAPSHOT
[INFO] --------------------------------[ jar ]---------------------------------
[INFO]
[INFO] --- maven-clean-plugin:2.5:clean (default-clean) @ gimlet ---
[INFO] Deleting C:\work_2018\gimlet\target
[INFO]
[INFO] --- maven-resources-plugin:2.6:resources (default-resources) @ gimlet ---
[INFO] Using 'UTF-8' encoding to copy filtered resources.
[INFO] Copying 33 resources
[INFO]
[INFO] --- maven-compiler-plugin:3.3:compile (default-compile) @ gimlet ---
[INFO] Changes detected - recompiling the module!
[INFO] Compiling 86 source files to C:\work_2018\gimlet\target\classes
[INFO]
[INFO] --- maven-resources-plugin:2.6:testResources (default-testResources) @ gimlet ---
[INFO] Using 'UTF-8' encoding to copy filtered resources.
[INFO] Copying 8 resources
[INFO]
[INFO] --- maven-compiler-plugin:3.3:testCompile (default-testCompile) @ gimlet ---
[INFO] Changes detected - recompiling the module!
[INFO] Compiling 12 source files to C:\work_2018\gimlet\target\test-classes
[INFO]
[INFO] --- maven-surefire-plugin:2.12.4:test (default-test) @ gimlet ---
[INFO] Surefire report directory: C:\work_2018\gimlet\target\surefire-reports

-------------------------------------------------------
 T E S T S
-------------------------------------------------------
Running cruft.wtf.gimlet.conf.AliasTest
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<alias>
    <color>#c0c0c0</color>
    <colorDisabled>true</colorDisabled>
    <askForPassword>false</askForPassword>
    <readOnly>true</readOnly>
    <jdbcProperties>
        <entry>
            <key>k1</key>
            <value>v1</value>
        </entry>
    </jdbcProperties>
</alias>
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.134 sec
Running cruft.wtf.gimlet.conf.GimletProjectTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.031 sec
Running cruft.wtf.gimlet.conf.QueryTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running cruft.wtf.gimlet.DataConverterTest
LARGE_FIRST_COLUMN_NAME |Two                                    |
=================================================================
Kevin                   |Pors                                   |
Derpy                   |Derpington                             |
Cruft and all           |Jazzy newsflash                        |
Ozzy                    |Bozzy <b>something</b>                 |
This col                |The other column, contains a newline!! |

LARGE_FIRST_COLUMN_NAME|Two|
**
Kevin|Pors|
Derpy|Derpington|
Cruft and all|Jazzy newsflash|
Ozzy|Bozzy <b>something</b>|
This col|The other column, contains a newline!!|

Kevin;Pors;
Derpy;Derpington;
Cruft and all;Jazzy newsflash;
Ozzy;Bozzy <b>something</b>;
This col;The other column, contains a newline!!;

<table><thead><tr><th>LARGE_FIRST_COLUMN_NAME</th><th>Two</th></tr></thead><tbody><tr><td>Kevin</td><td>Pors</td></tr><t
r><td>Derpy</td><td>Derpington</td></tr><tr><td>Cruft and all</td><td>Jazzy newsflash</td></tr><tr><td>Ozzy</td><td>Bozz
y &lt;b&gt;something&lt;/b&gt;</td></tr><tr><td>This col</td><td>The other column, contains
a newline!!</td></tr></tbody></table>
Tests run: 4, Failures: 3, Errors: 0, Skipped: 0, Time elapsed: 0.047 sec <<< FAILURE!
case01(cruft.wtf.gimlet.DataConverterTest)  Time elapsed: 0.015 sec  <<< FAILURE!
org.junit.ComparisonFailure: expected:<...                   |[
=================================================================
Kevin                   |Pors                                   |
Derpy                   |Derpington                             |
Cruft and all           |Jazzy newsflash                        |
Ozzy                    |Bozzy <b>something</b>                 |
This col                |The other column, contains a newline!! |]
> but was:<...                   |[
=================================================================
Kevin                   |Pors                                   |
Derpy                   |Derpington                             |
Cruft and all           |Jazzy newsflash                        |
Ozzy                    |Bozzy <b>something</b>                 |
]his col                |The other column, contains a newline!! |
>
        at org.junit.Assert.assertEquals(Assert.java:115)
        at org.junit.Assert.assertEquals(Assert.java:144)
        at cruft.wtf.gimlet.DataConverterTest.case01(DataConverterTest.java:47)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
        at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
        at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
        at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
        at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
        at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
        at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
        at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
        at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
        at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
        at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
        at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
        at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
        at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
        at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:252)
        at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:141)
        at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:112)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.apache.maven.surefire.util.ReflectionUtils.invokeMethodWithArray(ReflectionUtils.java:189)
        at org.apache.maven.surefire.booter.ProviderFactory$ProviderProxy.invoke(ProviderFactory.java:165)
        at org.apache.maven.surefire.booter.ProviderFactory.invokeProvider(ProviderFactory.java:85)
        at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:115)
        at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:75)

case02(cruft.wtf.gimlet.DataConverterTest)  Time elapsed: 0.023 sec  <<< FAILURE!
org.junit.ComparisonFailure: expected:<...RST_COLUMN_NAME|Two|[
**
Kevin|Pors|
Derpy|Derpington|
Cruft and all|Jazzy newsflash|
Ozzy|Bozzy <b>something</b>|
This col|The other column, contains a newline!!|]
> but was:<...RST_COLUMN_NAME|Two|[
**
Kevin|Pors|
Derpy|Derpington|
Cruft and all|Jazzy newsflash|
Ozzy|Bozzy <b>something</b>|
]his col|The other column, contains a newline!!|
>
        at org.junit.Assert.assertEquals(Assert.java:115)
        at org.junit.Assert.assertEquals(Assert.java:144)
        at cruft.wtf.gimlet.DataConverterTest.case02(DataConverterTest.java:62)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
        at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
        at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
        at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
        at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
        at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
        at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
        at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
        at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
        at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
        at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
        at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
        at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
        at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
        at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:252)
        at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:141)
        at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:112)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.apache.maven.surefire.util.ReflectionUtils.invokeMethodWithArray(ReflectionUtils.java:189)
        at org.apache.maven.surefire.booter.ProviderFactory$ProviderProxy.invoke(ProviderFactory.java:165)
        at org.apache.maven.surefire.booter.ProviderFactory.invokeProvider(ProviderFactory.java:85)
        at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:115)
        at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:75)

case03(cruft.wtf.gimlet.DataConverterTest)  Time elapsed: 0.005 sec  <<< FAILURE!
org.junit.ComparisonFailure: expected:<Kevin;Pors;[
Derpy;Derpington;
Cruft and all;Jazzy newsflash;
Ozzy;Bozzy <b>something</b>;
This col;The other column, contains a newline!!;]
> but was:<Kevin;Pors;[
Derpy;Derpington;
Cruft and all;Jazzy newsflash;
Ozzy;Bozzy <b>something</b>;
]his col;The other column, contains a newline!!;
>
        at org.junit.Assert.assertEquals(Assert.java:115)
        at org.junit.Assert.assertEquals(Assert.java:144)
        at cruft.wtf.gimlet.DataConverterTest.case03(DataConverterTest.java:76)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
        at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
        at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
        at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
        at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
        at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
        at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
        at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
        at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
        at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
        at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
        at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
        at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
        at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
        at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:252)
        at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:141)
        at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:112)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.apache.maven.surefire.util.ReflectionUtils.invokeMethodWithArray(ReflectionUtils.java:189)
        at org.apache.maven.surefire.booter.ProviderFactory$ProviderProxy.invoke(ProviderFactory.java:165)
        at org.apache.maven.surefire.booter.ProviderFactory.invokeProvider(ProviderFactory.java:85)
        at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:115)
        at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:75)

Running cruft.wtf.gimlet.jdbc.ParseResultTest
[Param{name='clazz', dataType=NUMBER}, Param{name='id', dataType=DATE}]
Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec
Running cruft.wtf.gimlet.jdbc.task.QueryTaskTest
Executed query: drop table customer if exists
Executed query: drop table invoice if exists
Executed query: create table customer(     id int,     name varchar(32) )
Executed query: insert into customer values (0, 'Kevin')
Executed query: create table invoice(     id int,     customer_id int, )
22:19:59.469 [main] DEBUG c.w.gimlet.jdbc.task.QueryTaskTest$1 - Running task
22:19:59.516 [main] DEBUG c.w.gimlet.jdbc.task.QueryTaskTest$1 - Preparing statement. Setting max rows to 0
22:19:59.525 [main] DEBUG c.w.gimlet.jdbc.task.QueryTaskTest$1 - Task finished in 9 ms, resulting in 1 rows in 2 columns

22:19:59.525 [main] DEBUG c.w.gimlet.jdbc.task.QueryTaskTest$1 - Closed statement
22:19:59.525 [main] DEBUG c.w.gimlet.jdbc.task.QueryTaskTest$1 - Closed result set
Kevin
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.185 sec
Running cruft.wtf.gimlet.jdbc.task.SimpleQueryTaskTest
Created connection
Executed query drop table customer if exists
Executed query drop table invoice if exists
Executed query create table customer(     id int,     name varchar(32) )
Executed query insert into customer values (0, 'Kevin')
Executed query create table invoice(     id int,     customer_id int, )
Kevin
Closed connection
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.025 sec
Running cruft.wtf.gimlet.ScriptLoaderTest
Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 0 sec <<< FAILURE!
loadScripts(cruft.wtf.gimlet.ScriptLoaderTest)  Time elapsed: 0 sec  <<< ERROR!
java.nio.file.InvalidPathException: Illegal char <:> at index 2: /C:/work_2018/gimlet/target/test-classes/scripts/
        at sun.nio.fs.WindowsPathParser.normalize(WindowsPathParser.java:182)
        at sun.nio.fs.WindowsPathParser.parse(WindowsPathParser.java:153)
        at sun.nio.fs.WindowsPathParser.parse(WindowsPathParser.java:77)
        at sun.nio.fs.WindowsPath.parse(WindowsPath.java:94)
        at sun.nio.fs.WindowsFileSystem.getPath(WindowsFileSystem.java:255)
        at java.nio.file.Paths.get(Paths.java:84)
        at cruft.wtf.gimlet.ScriptLoaderTest.loadScripts(ScriptLoaderTest.java:20)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
        at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
        at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
        at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
        at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
        at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
        at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
        at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
        at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
        at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
        at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
        at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
        at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
        at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:252)
        at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:141)
        at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:112)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.apache.maven.surefire.util.ReflectionUtils.invokeMethodWithArray(ReflectionUtils.java:189)
        at org.apache.maven.surefire.booter.ProviderFactory$ProviderProxy.invoke(ProviderFactory.java:165)
        at org.apache.maven.surefire.booter.ProviderFactory.invokeProvider(ProviderFactory.java:85)
        at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:115)
        at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:75)

Running cruft.wtf.gimlet.ScriptTest
This is the execution of an example script
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.028 sec
Running cruft.wtf.gimlet.TestTask
Executed query: drop table customer if exists
Executed query: drop table invoice if exists
Executed query: create table customer(     id int,     name varchar(32) )
Executed query: insert into customer values (0, 'Kevin')
Executed query: create table invoice(     id int,     customer_id int, )
Kevin
Kevin
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.061 sec

Results :

Failed tests:   case01(cruft.wtf.gimlet.DataConverterTest): expected:<...                   |[(..)
  case02(cruft.wtf.gimlet.DataConverterTest): expected:<...RST_COLUMN_NAME|Two|[(..)
  case03(cruft.wtf.gimlet.DataConverterTest): expected:<Kevin;Pors;[(..)

Tests in error:
  loadScripts(cruft.wtf.gimlet.ScriptLoaderTest): Illegal char <:> at index 2: /C:/work_2018/gimlet/target/test-classes/
scripts/

Tests run: 22, Failures: 3, Errors: 1, Skipped: 0

[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 3.985 s
[INFO] Finished at: 2018-08-12T22:19:59+02:00
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.12.4:test (default-test) on project giml
et: There are test failures.
[ERROR]
[ERROR] Please refer to C:\work_2018\gimlet\target\surefire-reports for the individual test results.
[ERROR] -> [Help 1]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoFailureException

@krpors
Copy link
Owner

krpors commented Aug 12, 2018

OK, thanks! I guess that's because of Windows. TBH I haven't tested the build on Windows before (only the execution of the application). My work laptop has Windows (all my others computers don't :)) so I can check it out, probably tomorrow.

@krpors
Copy link
Owner

krpors commented Aug 13, 2018

As I suspected it was a Windows thing (EOL issue and CRLF stuff). I pushed to master and to interconn branched and it seems to compile ok.

@krpors krpors closed this as completed in 9394a77 Aug 13, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@aadrian @krpors