Created
March 9, 2015 00:28
-
-
Save jonasschneider/07657eadd996577cd784 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[main] INFO spark.servlet.SparkFilter - StaticResourceHandler configured with folder = /public | |
Running in servlet container -- configuring from servlet context (usually from web.xml) | |
null | |
DB: CREATE TABLE IF NOT EXISTS experiment(id TEXT PRIMARY KEY NOT NULL, description TEXT DEFAULT '', budget INT, preview_click_count INT, hit_mturkid TEXT, finished INT, softfinished INT, answer_payment INT, rating_payment INT , basic_payment INT, statsid TEXT, ratingviewclass TEXT, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, bonus_payment INT, tags INT, qualifications INT, hit_title INT, max_answers_per_assignment INT, max_ratings_per_assignment INT, hit_description INT); | |
DB: CREATE TABLE IF NOT EXISTS qualification(id TEXT PRIMARY KEY NOT NULL, text TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS tag(id TEXT PRIMARY KEY NOT NULL, text TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS creativetask(id TEXT PRIMARY KEY NOT NULL, description TEXT , picture_source_url TEXT, picture_url TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS strategyparam(id TEXT PRIMARY KEY NOT NULL, key TEXT , value TEXT, experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS assignment(id TEXT PRIMARY KEY NOT NULL, worker_mturkid TEXT , is_paid INT , mturkid TEXT, is_submitted INT, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS ratingtask(id TEXT PRIMARY KEY NOT NULL, experimentid TEXT NOT NULL, description TEXT ); | |
DB: CREATE TABLE IF NOT EXISTS stats(id TEXT PRIMARY KEY NOT NULL, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, num_cancellers INT,preview_clicks_count INT DEFAULT 0,accepted_hits_count INT DEFAULT 0, rating_count INT, submission_count INT ); | |
DB: CREATE TABLE IF NOT EXISTS paymentoutcome(id TEXT PRIMARY KEY NOT NULL, assignmentid TEXT NOT NULL, receives_base_payment INT , bonus_amount INT ); | |
DB: CREATE TABLE IF NOT EXISTS ratingoption(id TEXT PRIMARY KEY NOT NULL, value REAL, text TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS taskconstellation(id TEXT PRIMARY KEY NOT NULL, assignmentid TEXT NOT NULL, again INT, submit INT, next INT, current_pos INT); | |
DB: CREATE TABLE IF NOT EXISTS rating(id TEXT PRIMARY KEY NOT NULL, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, text TEXT, ratingoptionid TEXT, final_quality_index REAL, containsevaluativeid TEXT, answerid TEXT ); | |
DB: CREATE TABLE IF NOT EXISTS answer(id TEXT PRIMARY KEY NOT NULL, final_quality_index REAL , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, text TEXT, marked_as_rated INT, containscreativeid TEXT); | |
DB: CREATE TABLE IF NOT EXISTS containscreative(id TEXT PRIMARY KEY NOT NULL, taskconstellationid TEXT , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, creativetaskid TEXT, task_position INT); | |
DB: CREATE TABLE IF NOT EXISTS containsevaluative(id TEXT PRIMARY KEY NOT NULL, taskconstellationid TEXT , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, ratingtaskid TEXT, task_position INT); | |
DB: CREATE TABLE IF NOT EXISTS findratingsfor(id TEXT PRIMARY KEY NOT NULL, ratingtaskid TEXT , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, answerid TEXT, answer_position INT); | |
DB: SELECT * FROM experiment WHERE id = 'MonMar0901:28:24CET2015'; | |
requested Experiment does not exist | |
edu.kit.ipd.creativecrowd.persistentmodel.DatabaseException: requested Experiment does not exist | |
at edu.kit.ipd.creativecrowd.persistentmodel.PersistentExperimentRepo.loadExperiment(PersistentExperimentRepo.java:259) | |
at edu.kit.ipd.creativecrowd.connector.Connector.deleteExperiment(Connector.java:226) | |
at edu.kit.ipd.creativecrowd.controller.ExperimentController.deleteExperiment(ExperimentController.java:137) | |
at edu.kit.ipd.creativecrowd.router.Router.lambda$2(Router.java:39) | |
at edu.kit.ipd.creativecrowd.router.Router$$Lambda$3/2015781843.handle(Unknown Source) | |
at spark.SparkBase$1.handle(SparkBase.java:264) | |
at spark.webserver.MatcherFilter.doFilter(MatcherFilter.java:154) | |
at spark.servlet.SparkFilter.doFilter(SparkFilter.java:126) | |
at com.meterware.servletunit.InvocationContextImpl.service(InvocationContextImpl.java:74) | |
at com.meterware.servletunit.ServletUnitClient.newResponse(ServletUnitClient.java:140) | |
at com.meterware.httpunit.WebClient.createResponse(WebClient.java:667) | |
at com.meterware.httpunit.WebWindow.getResource(WebWindow.java:240) | |
at com.meterware.httpunit.WebWindow.getSubframeResponse(WebWindow.java:198) | |
at com.meterware.httpunit.WebWindow.getResponse(WebWindow.java:169) | |
at com.meterware.httpunit.WebClient.getResponse(WebClient.java:122) | |
at edu.kit.ipd.creativecrowd.router.RouterIntegrationTest.cleanDataSet(RouterIntegrationTest.java:69) | |
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:483) | |
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47) | |
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) | |
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44) | |
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:33) | |
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271) | |
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70) | |
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50) | |
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238) | |
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63) | |
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236) | |
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53) | |
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229) | |
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) | |
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) | |
at org.junit.runners.ParentRunner.run(ParentRunner.java:309) | |
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50) | |
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192) | |
requested Experiment does not exist | |
null | |
DB: CREATE TABLE IF NOT EXISTS experiment(id TEXT PRIMARY KEY NOT NULL, description TEXT DEFAULT '', budget INT, preview_click_count INT, hit_mturkid TEXT, finished INT, softfinished INT, answer_payment INT, rating_payment INT , basic_payment INT, statsid TEXT, ratingviewclass TEXT, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, bonus_payment INT, tags INT, qualifications INT, hit_title INT, max_answers_per_assignment INT, max_ratings_per_assignment INT, hit_description INT); | |
DB: CREATE TABLE IF NOT EXISTS qualification(id TEXT PRIMARY KEY NOT NULL, text TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS tag(id TEXT PRIMARY KEY NOT NULL, text TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS creativetask(id TEXT PRIMARY KEY NOT NULL, description TEXT , picture_source_url TEXT, picture_url TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS strategyparam(id TEXT PRIMARY KEY NOT NULL, key TEXT , value TEXT, experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS assignment(id TEXT PRIMARY KEY NOT NULL, worker_mturkid TEXT , is_paid INT , mturkid TEXT, is_submitted INT, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS ratingtask(id TEXT PRIMARY KEY NOT NULL, experimentid TEXT NOT NULL, description TEXT ); | |
DB: CREATE TABLE IF NOT EXISTS stats(id TEXT PRIMARY KEY NOT NULL, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, num_cancellers INT,preview_clicks_count INT DEFAULT 0,accepted_hits_count INT DEFAULT 0, rating_count INT, submission_count INT ); | |
DB: CREATE TABLE IF NOT EXISTS paymentoutcome(id TEXT PRIMARY KEY NOT NULL, assignmentid TEXT NOT NULL, receives_base_payment INT , bonus_amount INT ); | |
DB: CREATE TABLE IF NOT EXISTS ratingoption(id TEXT PRIMARY KEY NOT NULL, value REAL, text TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS taskconstellation(id TEXT PRIMARY KEY NOT NULL, assignmentid TEXT NOT NULL, again INT, submit INT, next INT, current_pos INT); | |
DB: CREATE TABLE IF NOT EXISTS rating(id TEXT PRIMARY KEY NOT NULL, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, text TEXT, ratingoptionid TEXT, final_quality_index REAL, containsevaluativeid TEXT, answerid TEXT ); | |
DB: CREATE TABLE IF NOT EXISTS answer(id TEXT PRIMARY KEY NOT NULL, final_quality_index REAL , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, text TEXT, marked_as_rated INT, containscreativeid TEXT); | |
DB: CREATE TABLE IF NOT EXISTS containscreative(id TEXT PRIMARY KEY NOT NULL, taskconstellationid TEXT , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, creativetaskid TEXT, task_position INT); | |
DB: CREATE TABLE IF NOT EXISTS containsevaluative(id TEXT PRIMARY KEY NOT NULL, taskconstellationid TEXT , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, ratingtaskid TEXT, task_position INT); | |
DB: CREATE TABLE IF NOT EXISTS findratingsfor(id TEXT PRIMARY KEY NOT NULL, ratingtaskid TEXT , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, answerid TEXT, answer_position INT); | |
DB: SELECT * FROM experiment WHERE id = 'MonMar0901:28:24CET2015'; | |
requested Experiment does not exist | |
edu.kit.ipd.creativecrowd.persistentmodel.DatabaseException: requested Experiment does not exist | |
at edu.kit.ipd.creativecrowd.persistentmodel.PersistentExperimentRepo.loadExperiment(PersistentExperimentRepo.java:259) | |
at edu.kit.ipd.creativecrowd.connector.Connector.deleteExperiment(Connector.java:226) | |
at edu.kit.ipd.creativecrowd.controller.ExperimentController.deleteExperiment(ExperimentController.java:137) | |
at edu.kit.ipd.creativecrowd.router.Router.lambda$2(Router.java:39) | |
at edu.kit.ipd.creativecrowd.router.Router$$Lambda$3/2015781843.handle(Unknown Source) | |
at spark.SparkBase$1.handle(SparkBase.java:264) | |
at spark.webserver.MatcherFilter.doFilter(MatcherFilter.java:154) | |
at spark.servlet.SparkFilter.doFilter(SparkFilter.java:126) | |
at com.meterware.servletunit.InvocationContextImpl.service(InvocationContextImpl.java:74) | |
at com.meterware.servletunit.ServletUnitClient.newResponse(ServletUnitClient.java:140) | |
at com.meterware.httpunit.WebClient.createResponse(WebClient.java:667) | |
at com.meterware.httpunit.WebWindow.getResource(WebWindow.java:240) | |
at com.meterware.httpunit.WebWindow.getSubframeResponse(WebWindow.java:198) | |
at com.meterware.httpunit.WebWindow.getResponse(WebWindow.java:169) | |
at com.meterware.httpunit.WebClient.getResponse(WebClient.java:122) | |
at edu.kit.ipd.creativecrowd.router.RouterIntegrationTest.cleanDataSet(RouterIntegrationTest.java:69) | |
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:483) | |
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47) | |
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) | |
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44) | |
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:33) | |
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271) | |
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70) | |
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50) | |
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238) | |
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63) | |
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236) | |
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53) | |
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229) | |
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) | |
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) | |
at org.junit.runners.ParentRunner.run(ParentRunner.java:309) | |
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50) | |
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192) | |
requested Experiment does not exist | |
null | |
DB: CREATE TABLE IF NOT EXISTS experiment(id TEXT PRIMARY KEY NOT NULL, description TEXT DEFAULT '', budget INT, preview_click_count INT, hit_mturkid TEXT, finished INT, softfinished INT, answer_payment INT, rating_payment INT , basic_payment INT, statsid TEXT, ratingviewclass TEXT, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, bonus_payment INT, tags INT, qualifications INT, hit_title INT, max_answers_per_assignment INT, max_ratings_per_assignment INT, hit_description INT); | |
DB: CREATE TABLE IF NOT EXISTS qualification(id TEXT PRIMARY KEY NOT NULL, text TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS tag(id TEXT PRIMARY KEY NOT NULL, text TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS creativetask(id TEXT PRIMARY KEY NOT NULL, description TEXT , picture_source_url TEXT, picture_url TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS strategyparam(id TEXT PRIMARY KEY NOT NULL, key TEXT , value TEXT, experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS assignment(id TEXT PRIMARY KEY NOT NULL, worker_mturkid TEXT , is_paid INT , mturkid TEXT, is_submitted INT, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS ratingtask(id TEXT PRIMARY KEY NOT NULL, experimentid TEXT NOT NULL, description TEXT ); | |
DB: CREATE TABLE IF NOT EXISTS stats(id TEXT PRIMARY KEY NOT NULL, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, num_cancellers INT,preview_clicks_count INT DEFAULT 0,accepted_hits_count INT DEFAULT 0, rating_count INT, submission_count INT ); | |
DB: CREATE TABLE IF NOT EXISTS paymentoutcome(id TEXT PRIMARY KEY NOT NULL, assignmentid TEXT NOT NULL, receives_base_payment INT , bonus_amount INT ); | |
DB: CREATE TABLE IF NOT EXISTS ratingoption(id TEXT PRIMARY KEY NOT NULL, value REAL, text TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS taskconstellation(id TEXT PRIMARY KEY NOT NULL, assignmentid TEXT NOT NULL, again INT, submit INT, next INT, current_pos INT); | |
DB: CREATE TABLE IF NOT EXISTS rating(id TEXT PRIMARY KEY NOT NULL, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, text TEXT, ratingoptionid TEXT, final_quality_index REAL, containsevaluativeid TEXT, answerid TEXT ); | |
DB: CREATE TABLE IF NOT EXISTS answer(id TEXT PRIMARY KEY NOT NULL, final_quality_index REAL , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, text TEXT, marked_as_rated INT, containscreativeid TEXT); | |
DB: CREATE TABLE IF NOT EXISTS containscreative(id TEXT PRIMARY KEY NOT NULL, taskconstellationid TEXT , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, creativetaskid TEXT, task_position INT); | |
DB: CREATE TABLE IF NOT EXISTS containsevaluative(id TEXT PRIMARY KEY NOT NULL, taskconstellationid TEXT , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, ratingtaskid TEXT, task_position INT); | |
DB: CREATE TABLE IF NOT EXISTS findratingsfor(id TEXT PRIMARY KEY NOT NULL, ratingtaskid TEXT , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, answerid TEXT, answer_position INT); | |
DB: SELECT * FROM experiment WHERE id = 'MonMar0901:28:24CET2015'; | |
requested Experiment does not exist | |
edu.kit.ipd.creativecrowd.persistentmodel.DatabaseException: requested Experiment does not exist | |
at edu.kit.ipd.creativecrowd.persistentmodel.PersistentExperimentRepo.loadExperiment(PersistentExperimentRepo.java:259) | |
at edu.kit.ipd.creativecrowd.connector.Connector.deleteExperiment(Connector.java:226) | |
at edu.kit.ipd.creativecrowd.controller.ExperimentController.deleteExperiment(ExperimentController.java:137) | |
at edu.kit.ipd.creativecrowd.router.Router.lambda$2(Router.java:39) | |
at edu.kit.ipd.creativecrowd.router.Router$$Lambda$3/2015781843.handle(Unknown Source) | |
at spark.SparkBase$1.handle(SparkBase.java:264) | |
at spark.webserver.MatcherFilter.doFilter(MatcherFilter.java:154) | |
at spark.servlet.SparkFilter.doFilter(SparkFilter.java:126) | |
at com.meterware.servletunit.InvocationContextImpl.service(InvocationContextImpl.java:74) | |
at com.meterware.servletunit.ServletUnitClient.newResponse(ServletUnitClient.java:140) | |
at com.meterware.httpunit.WebClient.createResponse(WebClient.java:667) | |
at com.meterware.httpunit.WebWindow.getResource(WebWindow.java:240) | |
at com.meterware.httpunit.WebWindow.getSubframeResponse(WebWindow.java:198) | |
at com.meterware.httpunit.WebWindow.getResponse(WebWindow.java:169) | |
at com.meterware.httpunit.WebClient.getResponse(WebClient.java:122) | |
at edu.kit.ipd.creativecrowd.router.RouterIntegrationTest.cleanDataSet(RouterIntegrationTest.java:69) | |
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:483) | |
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47) | |
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) | |
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44) | |
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:33) | |
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271) | |
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70) | |
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50) | |
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238) | |
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63) | |
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236) | |
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53) | |
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229) | |
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) | |
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) | |
at org.junit.runners.ParentRunner.run(ParentRunner.java:309) | |
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50) | |
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192) | |
requested Experiment does not exist | |
null | |
DB: CREATE TABLE IF NOT EXISTS experiment(id TEXT PRIMARY KEY NOT NULL, description TEXT DEFAULT '', budget INT, preview_click_count INT, hit_mturkid TEXT, finished INT, softfinished INT, answer_payment INT, rating_payment INT , basic_payment INT, statsid TEXT, ratingviewclass TEXT, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, bonus_payment INT, tags INT, qualifications INT, hit_title INT, max_answers_per_assignment INT, max_ratings_per_assignment INT, hit_description INT); | |
DB: CREATE TABLE IF NOT EXISTS qualification(id TEXT PRIMARY KEY NOT NULL, text TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS tag(id TEXT PRIMARY KEY NOT NULL, text TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS creativetask(id TEXT PRIMARY KEY NOT NULL, description TEXT , picture_source_url TEXT, picture_url TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS strategyparam(id TEXT PRIMARY KEY NOT NULL, key TEXT , value TEXT, experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS assignment(id TEXT PRIMARY KEY NOT NULL, worker_mturkid TEXT , is_paid INT , mturkid TEXT, is_submitted INT, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS ratingtask(id TEXT PRIMARY KEY NOT NULL, experimentid TEXT NOT NULL, description TEXT ); | |
DB: CREATE TABLE IF NOT EXISTS stats(id TEXT PRIMARY KEY NOT NULL, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, num_cancellers INT,preview_clicks_count INT DEFAULT 0,accepted_hits_count INT DEFAULT 0, rating_count INT, submission_count INT ); | |
DB: CREATE TABLE IF NOT EXISTS paymentoutcome(id TEXT PRIMARY KEY NOT NULL, assignmentid TEXT NOT NULL, receives_base_payment INT , bonus_amount INT ); | |
DB: CREATE TABLE IF NOT EXISTS ratingoption(id TEXT PRIMARY KEY NOT NULL, value REAL, text TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS taskconstellation(id TEXT PRIMARY KEY NOT NULL, assignmentid TEXT NOT NULL, again INT, submit INT, next INT, current_pos INT); | |
DB: CREATE TABLE IF NOT EXISTS rating(id TEXT PRIMARY KEY NOT NULL, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, text TEXT, ratingoptionid TEXT, final_quality_index REAL, containsevaluativeid TEXT, answerid TEXT ); | |
DB: CREATE TABLE IF NOT EXISTS answer(id TEXT PRIMARY KEY NOT NULL, final_quality_index REAL , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, text TEXT, marked_as_rated INT, containscreativeid TEXT); | |
DB: CREATE TABLE IF NOT EXISTS containscreative(id TEXT PRIMARY KEY NOT NULL, taskconstellationid TEXT , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, creativetaskid TEXT, task_position INT); | |
DB: CREATE TABLE IF NOT EXISTS containsevaluative(id TEXT PRIMARY KEY NOT NULL, taskconstellationid TEXT , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, ratingtaskid TEXT, task_position INT); | |
DB: CREATE TABLE IF NOT EXISTS findratingsfor(id TEXT PRIMARY KEY NOT NULL, ratingtaskid TEXT , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, answerid TEXT, answer_position INT); | |
DB: SELECT * FROM experiment WHERE id = 'MonMar0901:28:24CET2015'; | |
requested Experiment does not exist | |
edu.kit.ipd.creativecrowd.persistentmodel.DatabaseException: requested Experiment does not exist | |
at edu.kit.ipd.creativecrowd.persistentmodel.PersistentExperimentRepo.loadExperiment(PersistentExperimentRepo.java:259) | |
at edu.kit.ipd.creativecrowd.connector.Connector.deleteExperiment(Connector.java:226) | |
at edu.kit.ipd.creativecrowd.controller.ExperimentController.deleteExperiment(ExperimentController.java:137) | |
at edu.kit.ipd.creativecrowd.router.Router.lambda$2(Router.java:39) | |
at edu.kit.ipd.creativecrowd.router.Router$$Lambda$3/2015781843.handle(Unknown Source) | |
at spark.SparkBase$1.handle(SparkBase.java:264) | |
at spark.webserver.MatcherFilter.doFilter(MatcherFilter.java:154) | |
at spark.servlet.SparkFilter.doFilter(SparkFilter.java:126) | |
at com.meterware.servletunit.InvocationContextImpl.service(InvocationContextImpl.java:74) | |
at com.meterware.servletunit.ServletUnitClient.newResponse(ServletUnitClient.java:140) | |
at com.meterware.httpunit.WebClient.createResponse(WebClient.java:667) | |
at com.meterware.httpunit.WebWindow.getResource(WebWindow.java:240) | |
at com.meterware.httpunit.WebWindow.getSubframeResponse(WebWindow.java:198) | |
at com.meterware.httpunit.WebWindow.getResponse(WebWindow.java:169) | |
at com.meterware.httpunit.WebClient.getResponse(WebClient.java:122) | |
at edu.kit.ipd.creativecrowd.router.RouterIntegrationTest.cleanDataSet(RouterIntegrationTest.java:69) | |
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:483) | |
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47) | |
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) | |
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44) | |
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:33) | |
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271) | |
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70) | |
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50) | |
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238) | |
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63) | |
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236) | |
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53) | |
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229) | |
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) | |
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) | |
at org.junit.runners.ParentRunner.run(ParentRunner.java:309) | |
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50) | |
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192) | |
requested Experiment does not exist | |
null | |
DB: CREATE TABLE IF NOT EXISTS experiment(id TEXT PRIMARY KEY NOT NULL, description TEXT DEFAULT '', budget INT, preview_click_count INT, hit_mturkid TEXT, finished INT, softfinished INT, answer_payment INT, rating_payment INT , basic_payment INT, statsid TEXT, ratingviewclass TEXT, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, bonus_payment INT, tags INT, qualifications INT, hit_title INT, max_answers_per_assignment INT, max_ratings_per_assignment INT, hit_description INT); | |
DB: CREATE TABLE IF NOT EXISTS qualification(id TEXT PRIMARY KEY NOT NULL, text TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS tag(id TEXT PRIMARY KEY NOT NULL, text TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS creativetask(id TEXT PRIMARY KEY NOT NULL, description TEXT , picture_source_url TEXT, picture_url TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS strategyparam(id TEXT PRIMARY KEY NOT NULL, key TEXT , value TEXT, experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS assignment(id TEXT PRIMARY KEY NOT NULL, worker_mturkid TEXT , is_paid INT , mturkid TEXT, is_submitted INT, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS ratingtask(id TEXT PRIMARY KEY NOT NULL, experimentid TEXT NOT NULL, description TEXT ); | |
DB: CREATE TABLE IF NOT EXISTS stats(id TEXT PRIMARY KEY NOT NULL, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, num_cancellers INT,preview_clicks_count INT DEFAULT 0,accepted_hits_count INT DEFAULT 0, rating_count INT, submission_count INT ); | |
DB: CREATE TABLE IF NOT EXISTS paymentoutcome(id TEXT PRIMARY KEY NOT NULL, assignmentid TEXT NOT NULL, receives_base_payment INT , bonus_amount INT ); | |
DB: CREATE TABLE IF NOT EXISTS ratingoption(id TEXT PRIMARY KEY NOT NULL, value REAL, text TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS taskconstellation(id TEXT PRIMARY KEY NOT NULL, assignmentid TEXT NOT NULL, again INT, submit INT, next INT, current_pos INT); | |
DB: CREATE TABLE IF NOT EXISTS rating(id TEXT PRIMARY KEY NOT NULL, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, text TEXT, ratingoptionid TEXT, final_quality_index REAL, containsevaluativeid TEXT, answerid TEXT ); | |
DB: CREATE TABLE IF NOT EXISTS answer(id TEXT PRIMARY KEY NOT NULL, final_quality_index REAL , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, text TEXT, marked_as_rated INT, containscreativeid TEXT); | |
DB: CREATE TABLE IF NOT EXISTS containscreative(id TEXT PRIMARY KEY NOT NULL, taskconstellationid TEXT , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, creativetaskid TEXT, task_position INT); | |
DB: CREATE TABLE IF NOT EXISTS containsevaluative(id TEXT PRIMARY KEY NOT NULL, taskconstellationid TEXT , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, ratingtaskid TEXT, task_position INT); | |
DB: CREATE TABLE IF NOT EXISTS findratingsfor(id TEXT PRIMARY KEY NOT NULL, ratingtaskid TEXT , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, answerid TEXT, answer_position INT); | |
DB: SELECT * FROM experiment WHERE id = 'MonMar0901:28:24CET2015'; | |
requested Experiment does not exist | |
edu.kit.ipd.creativecrowd.persistentmodel.DatabaseException: requested Experiment does not exist | |
at edu.kit.ipd.creativecrowd.persistentmodel.PersistentExperimentRepo.loadExperiment(PersistentExperimentRepo.java:259) | |
at edu.kit.ipd.creativecrowd.connector.Connector.deleteExperiment(Connector.java:226) | |
at edu.kit.ipd.creativecrowd.controller.ExperimentController.deleteExperiment(ExperimentController.java:137) | |
at edu.kit.ipd.creativecrowd.router.Router.lambda$2(Router.java:39) | |
at edu.kit.ipd.creativecrowd.router.Router$$Lambda$3/2015781843.handle(Unknown Source) | |
at spark.SparkBase$1.handle(SparkBase.java:264) | |
at spark.webserver.MatcherFilter.doFilter(MatcherFilter.java:154) | |
at spark.servlet.SparkFilter.doFilter(SparkFilter.java:126) | |
at com.meterware.servletunit.InvocationContextImpl.service(InvocationContextImpl.java:74) | |
at com.meterware.servletunit.ServletUnitClient.newResponse(ServletUnitClient.java:140) | |
at com.meterware.httpunit.WebClient.createResponse(WebClient.java:667) | |
at com.meterware.httpunit.WebWindow.getResource(WebWindow.java:240) | |
at com.meterware.httpunit.WebWindow.getSubframeResponse(WebWindow.java:198) | |
at com.meterware.httpunit.WebWindow.getResponse(WebWindow.java:169) | |
at com.meterware.httpunit.WebClient.getResponse(WebClient.java:122) | |
at edu.kit.ipd.creativecrowd.router.RouterIntegrationTest.cleanDataSet(RouterIntegrationTest.java:69) | |
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:483) | |
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47) | |
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) | |
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44) | |
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:33) | |
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271) | |
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70) | |
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50) | |
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238) | |
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63) | |
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236) | |
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53) | |
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229) | |
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) | |
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) | |
at org.junit.runners.ParentRunner.run(ParentRunner.java:309) | |
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50) | |
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192) | |
requested Experiment does not exist | |
null | |
DB: CREATE TABLE IF NOT EXISTS experiment(id TEXT PRIMARY KEY NOT NULL, description TEXT DEFAULT '', budget INT, preview_click_count INT, hit_mturkid TEXT, finished INT, softfinished INT, answer_payment INT, rating_payment INT , basic_payment INT, statsid TEXT, ratingviewclass TEXT, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, bonus_payment INT, tags INT, qualifications INT, hit_title INT, max_answers_per_assignment INT, max_ratings_per_assignment INT, hit_description INT); | |
DB: CREATE TABLE IF NOT EXISTS qualification(id TEXT PRIMARY KEY NOT NULL, text TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS tag(id TEXT PRIMARY KEY NOT NULL, text TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS creativetask(id TEXT PRIMARY KEY NOT NULL, description TEXT , picture_source_url TEXT, picture_url TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS strategyparam(id TEXT PRIMARY KEY NOT NULL, key TEXT , value TEXT, experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS assignment(id TEXT PRIMARY KEY NOT NULL, worker_mturkid TEXT , is_paid INT , mturkid TEXT, is_submitted INT, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS ratingtask(id TEXT PRIMARY KEY NOT NULL, experimentid TEXT NOT NULL, description TEXT ); | |
DB: CREATE TABLE IF NOT EXISTS stats(id TEXT PRIMARY KEY NOT NULL, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, num_cancellers INT,preview_clicks_count INT DEFAULT 0,accepted_hits_count INT DEFAULT 0, rating_count INT, submission_count INT ); | |
DB: CREATE TABLE IF NOT EXISTS paymentoutcome(id TEXT PRIMARY KEY NOT NULL, assignmentid TEXT NOT NULL, receives_base_payment INT , bonus_amount INT ); | |
DB: CREATE TABLE IF NOT EXISTS ratingoption(id TEXT PRIMARY KEY NOT NULL, value REAL, text TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS taskconstellation(id TEXT PRIMARY KEY NOT NULL, assignmentid TEXT NOT NULL, again INT, submit INT, next INT, current_pos INT); | |
DB: CREATE TABLE IF NOT EXISTS rating(id TEXT PRIMARY KEY NOT NULL, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, text TEXT, ratingoptionid TEXT, final_quality_index REAL, containsevaluativeid TEXT, answerid TEXT ); | |
DB: CREATE TABLE IF NOT EXISTS answer(id TEXT PRIMARY KEY NOT NULL, final_quality_index REAL , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, text TEXT, marked_as_rated INT, containscreativeid TEXT); | |
DB: CREATE TABLE IF NOT EXISTS containscreative(id TEXT PRIMARY KEY NOT NULL, taskconstellationid TEXT , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, creativetaskid TEXT, task_position INT); | |
DB: CREATE TABLE IF NOT EXISTS containsevaluative(id TEXT PRIMARY KEY NOT NULL, taskconstellationid TEXT , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, ratingtaskid TEXT, task_position INT); | |
DB: CREATE TABLE IF NOT EXISTS findratingsfor(id TEXT PRIMARY KEY NOT NULL, ratingtaskid TEXT , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, answerid TEXT, answer_position INT); | |
DB: SELECT * FROM experiment WHERE id = 'MonMar0901:28:24CET2015'; | |
requested Experiment does not exist | |
edu.kit.ipd.creativecrowd.persistentmodel.DatabaseException: requested Experiment does not exist | |
at edu.kit.ipd.creativecrowd.persistentmodel.PersistentExperimentRepo.loadExperiment(PersistentExperimentRepo.java:259) | |
at edu.kit.ipd.creativecrowd.connector.Connector.deleteExperiment(Connector.java:226) | |
at edu.kit.ipd.creativecrowd.controller.ExperimentController.deleteExperiment(ExperimentController.java:137) | |
at edu.kit.ipd.creativecrowd.router.Router.lambda$2(Router.java:39) | |
at edu.kit.ipd.creativecrowd.router.Router$$Lambda$3/2015781843.handle(Unknown Source) | |
at spark.SparkBase$1.handle(SparkBase.java:264) | |
at spark.webserver.MatcherFilter.doFilter(MatcherFilter.java:154) | |
at spark.servlet.SparkFilter.doFilter(SparkFilter.java:126) | |
at com.meterware.servletunit.InvocationContextImpl.service(InvocationContextImpl.java:74) | |
at com.meterware.servletunit.ServletUnitClient.newResponse(ServletUnitClient.java:140) | |
at com.meterware.httpunit.WebClient.createResponse(WebClient.java:667) | |
at com.meterware.httpunit.WebWindow.getResource(WebWindow.java:240) | |
at com.meterware.httpunit.WebWindow.getSubframeResponse(WebWindow.java:198) | |
at com.meterware.httpunit.WebWindow.getResponse(WebWindow.java:169) | |
at com.meterware.httpunit.WebClient.getResponse(WebClient.java:122) | |
at edu.kit.ipd.creativecrowd.router.RouterIntegrationTest.cleanDataSet(RouterIntegrationTest.java:69) | |
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:483) | |
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47) | |
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) | |
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44) | |
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:33) | |
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271) | |
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70) | |
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50) | |
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238) | |
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63) | |
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236) | |
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53) | |
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229) | |
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) | |
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) | |
at org.junit.runners.ParentRunner.run(ParentRunner.java:309) | |
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50) | |
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192) | |
requested Experiment does not exist | |
null | |
DB: CREATE TABLE IF NOT EXISTS experiment(id TEXT PRIMARY KEY NOT NULL, description TEXT DEFAULT '', budget INT, preview_click_count INT, hit_mturkid TEXT, finished INT, softfinished INT, answer_payment INT, rating_payment INT , basic_payment INT, statsid TEXT, ratingviewclass TEXT, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, bonus_payment INT, tags INT, qualifications INT, hit_title INT, max_answers_per_assignment INT, max_ratings_per_assignment INT, hit_description INT); | |
DB: CREATE TABLE IF NOT EXISTS qualification(id TEXT PRIMARY KEY NOT NULL, text TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS tag(id TEXT PRIMARY KEY NOT NULL, text TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS creativetask(id TEXT PRIMARY KEY NOT NULL, description TEXT , picture_source_url TEXT, picture_url TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS strategyparam(id TEXT PRIMARY KEY NOT NULL, key TEXT , value TEXT, experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS assignment(id TEXT PRIMARY KEY NOT NULL, worker_mturkid TEXT , is_paid INT , mturkid TEXT, is_submitted INT, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS ratingtask(id TEXT PRIMARY KEY NOT NULL, experimentid TEXT NOT NULL, description TEXT ); | |
DB: CREATE TABLE IF NOT EXISTS stats(id TEXT PRIMARY KEY NOT NULL, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, num_cancellers INT,preview_clicks_count INT DEFAULT 0,accepted_hits_count INT DEFAULT 0, rating_count INT, submission_count INT ); | |
DB: CREATE TABLE IF NOT EXISTS paymentoutcome(id TEXT PRIMARY KEY NOT NULL, assignmentid TEXT NOT NULL, receives_base_payment INT , bonus_amount INT ); | |
DB: CREATE TABLE IF NOT EXISTS ratingoption(id TEXT PRIMARY KEY NOT NULL, value REAL, text TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS taskconstellation(id TEXT PRIMARY KEY NOT NULL, assignmentid TEXT NOT NULL, again INT, submit INT, next INT, current_pos INT); | |
DB: CREATE TABLE IF NOT EXISTS rating(id TEXT PRIMARY KEY NOT NULL, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, text TEXT, ratingoptionid TEXT, final_quality_index REAL, containsevaluativeid TEXT, answerid TEXT ); | |
DB: CREATE TABLE IF NOT EXISTS answer(id TEXT PRIMARY KEY NOT NULL, final_quality_index REAL , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, text TEXT, marked_as_rated INT, containscreativeid TEXT); | |
DB: CREATE TABLE IF NOT EXISTS containscreative(id TEXT PRIMARY KEY NOT NULL, taskconstellationid TEXT , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, creativetaskid TEXT, task_position INT); | |
DB: CREATE TABLE IF NOT EXISTS containsevaluative(id TEXT PRIMARY KEY NOT NULL, taskconstellationid TEXT , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, ratingtaskid TEXT, task_position INT); | |
DB: CREATE TABLE IF NOT EXISTS findratingsfor(id TEXT PRIMARY KEY NOT NULL, ratingtaskid TEXT , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, answerid TEXT, answer_position INT); | |
DB: SELECT * FROM experiment WHERE id = 'MonMar0901:28:24CET2015'; | |
requested Experiment does not exist | |
edu.kit.ipd.creativecrowd.persistentmodel.DatabaseException: requested Experiment does not exist | |
at edu.kit.ipd.creativecrowd.persistentmodel.PersistentExperimentRepo.loadExperiment(PersistentExperimentRepo.java:259) | |
at edu.kit.ipd.creativecrowd.connector.Connector.deleteExperiment(Connector.java:226) | |
at edu.kit.ipd.creativecrowd.controller.ExperimentController.deleteExperiment(ExperimentController.java:137) | |
at edu.kit.ipd.creativecrowd.router.Router.lambda$2(Router.java:39) | |
at edu.kit.ipd.creativecrowd.router.Router$$Lambda$3/2015781843.handle(Unknown Source) | |
at spark.SparkBase$1.handle(SparkBase.java:264) | |
at spark.webserver.MatcherFilter.doFilter(MatcherFilter.java:154) | |
at spark.servlet.SparkFilter.doFilter(SparkFilter.java:126) | |
at com.meterware.servletunit.InvocationContextImpl.service(InvocationContextImpl.java:74) | |
at com.meterware.servletunit.ServletUnitClient.newResponse(ServletUnitClient.java:140) | |
at com.meterware.httpunit.WebClient.createResponse(WebClient.java:667) | |
at com.meterware.httpunit.WebWindow.getResource(WebWindow.java:240) | |
at com.meterware.httpunit.WebWindow.getSubframeResponse(WebWindow.java:198) | |
at com.meterware.httpunit.WebWindow.getResponse(WebWindow.java:169) | |
at com.meterware.httpunit.WebClient.getResponse(WebClient.java:122) | |
at edu.kit.ipd.creativecrowd.router.RouterIntegrationTest.cleanDataSet(RouterIntegrationTest.java:69) | |
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:483) | |
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47) | |
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) | |
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44) | |
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:33) | |
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271) | |
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70) | |
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50) | |
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238) | |
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63) | |
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236) | |
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53) | |
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229) | |
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) | |
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) | |
at org.junit.runners.ParentRunner.run(ParentRunner.java:309) | |
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50) | |
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192) | |
requested Experiment does not exist | |
null | |
DB: CREATE TABLE IF NOT EXISTS experiment(id TEXT PRIMARY KEY NOT NULL, description TEXT DEFAULT '', budget INT, preview_click_count INT, hit_mturkid TEXT, finished INT, softfinished INT, answer_payment INT, rating_payment INT , basic_payment INT, statsid TEXT, ratingviewclass TEXT, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, bonus_payment INT, tags INT, qualifications INT, hit_title INT, max_answers_per_assignment INT, max_ratings_per_assignment INT, hit_description INT); | |
DB: CREATE TABLE IF NOT EXISTS qualification(id TEXT PRIMARY KEY NOT NULL, text TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS tag(id TEXT PRIMARY KEY NOT NULL, text TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS creativetask(id TEXT PRIMARY KEY NOT NULL, description TEXT , picture_source_url TEXT, picture_url TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS strategyparam(id TEXT PRIMARY KEY NOT NULL, key TEXT , value TEXT, experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS assignment(id TEXT PRIMARY KEY NOT NULL, worker_mturkid TEXT , is_paid INT , mturkid TEXT, is_submitted INT, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS ratingtask(id TEXT PRIMARY KEY NOT NULL, experimentid TEXT NOT NULL, description TEXT ); | |
DB: CREATE TABLE IF NOT EXISTS stats(id TEXT PRIMARY KEY NOT NULL, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, num_cancellers INT,preview_clicks_count INT DEFAULT 0,accepted_hits_count INT DEFAULT 0, rating_count INT, submission_count INT ); | |
DB: CREATE TABLE IF NOT EXISTS paymentoutcome(id TEXT PRIMARY KEY NOT NULL, assignmentid TEXT NOT NULL, receives_base_payment INT , bonus_amount INT ); | |
DB: CREATE TABLE IF NOT EXISTS ratingoption(id TEXT PRIMARY KEY NOT NULL, value REAL, text TEXT , experimentid TEXT NOT NULL); | |
DB: CREATE TABLE IF NOT EXISTS taskconstellation(id TEXT PRIMARY KEY NOT NULL, assignmentid TEXT NOT NULL, again INT, submit INT, next INT, current_pos INT); | |
DB: CREATE TABLE IF NOT EXISTS rating(id TEXT PRIMARY KEY NOT NULL, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, text TEXT, ratingoptionid TEXT, final_quality_index REAL, containsevaluativeid TEXT, answerid TEXT ); | |
DB: CREATE TABLE IF NOT EXISTS answer(id TEXT PRIMARY KEY NOT NULL, final_quality_index REAL , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, text TEXT, marked_as_rated INT, containscreativeid TEXT); | |
DB: CREATE TABLE IF NOT EXISTS containscreative(id TEXT PRIMARY KEY NOT NULL, taskconstellationid TEXT , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, creativetaskid TEXT, task_position INT); | |
DB: CREATE TABLE IF NOT EXISTS containsevaluative(id TEXT PRIMARY KEY NOT NULL, taskconstellationid TEXT , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, ratingtaskid TEXT, task_position INT); | |
DB: CREATE TABLE IF NOT EXISTS findratingsfor(id TEXT PRIMARY KEY NOT NULL, ratingtaskid TEXT , sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, answerid TEXT, answer_position INT); | |
DB: SELECT * FROM experiment WHERE id = 'MonMar0901:28:24CET2015'; | |
requested Experiment does not exist | |
edu.kit.ipd.creativecrowd.persistentmodel.DatabaseException: requested Experiment does not exist | |
at edu.kit.ipd.creativecrowd.persistentmodel.PersistentExperimentRepo.loadExperiment(PersistentExperimentRepo.java:259) | |
at edu.kit.ipd.creativecrowd.connector.Connector.deleteExperiment(Connector.java:226) | |
at edu.kit.ipd.creativecrowd.controller.ExperimentController.deleteExperiment(ExperimentController.java:137) | |
at edu.kit.ipd.creativecrowd.router.Router.lambda$2(Router.java:39) | |
at edu.kit.ipd.creativecrowd.router.Router$$Lambda$3/2015781843.handle(Unknown Source) | |
at spark.SparkBase$1.handle(SparkBase.java:264) | |
at spark.webserver.MatcherFilter.doFilter(MatcherFilter.java:154) | |
at spark.servlet.SparkFilter.doFilter(SparkFilter.java:126) | |
at com.meterware.servletunit.InvocationContextImpl.service(InvocationContextImpl.java:74) | |
at com.meterware.servletunit.ServletUnitClient.newResponse(ServletUnitClient.java:140) | |
at com.meterware.httpunit.WebClient.createResponse(WebClient.java:667) | |
at com.meterware.httpunit.WebWindow.getResource(WebWindow.java:240) | |
at com.meterware.httpunit.WebWindow.getSubframeResponse(WebWindow.java:198) | |
at com.meterware.httpunit.WebWindow.getResponse(WebWindow.java:169) | |
at com.meterware.httpunit.WebClient.getResponse(WebClient.java:122) | |
at edu.kit.ipd.creativecrowd.router.RouterIntegrationTest.cleanDataSet(RouterIntegrationTest.java:69) | |
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:483) | |
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47) | |
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) | |
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44) | |
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:33) | |
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271) | |
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70) | |
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50) | |
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238) | |
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63) | |
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236) | |
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53) | |
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229) | |
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) | |
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) | |
at org.junit.runners.ParentRunner.run(ParentRunner.java:309) | |
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50) | |
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382) | |
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192) | |
requested Experiment does not exist |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment