Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll

Build a REST API in Spark

Well done!

You have completed Build a REST API in Spark!

Sign up for Treehouse Back to Library

Testing Our Implementations

13:38 with Craig Dennis

Let's get our database implementation in place and write a test to an in-memory version of it.

SQL DDL (Data Definition Language)

CREATE TABLE IF NOT EXISTS courses (
   id int PRIMARY KEY auto_increment,
   name VARCHAR,
   url VARCHAR
);

CREATE TABLE IF NOT EXISTS reviews (
   id INTEGER PRIMARY KEY auto_increment,
   course_id INTEGER,
   rating INTEGER,
   comment VARCHAR,
   FOREIGN KEY(course_id) REFERENCES public.courses(id)
);

Gradle Dependencies

compile 'com.h2database:h2:1.4.190'

Read more

Related Discussions

Have questions about this video? Start a discussion with the community and Treehouse staff.

Sign up

    Related Discussions

    Have questions about this video? Start a discussion with the community and Treehouse staff.

    Sign up

    This approach is constructor dependency injection, and 0:00
    we are about to get to see it in action. 0:01
    Since SQL is a common language for databases, and 0:04
    JDBC is the abstraction that allows Java to talk to any database, 0:07
    what we've written so far should work with any database that's supported by JDBC. 0:11
    That's pretty cool, right? 0:15
    We haven't even chosen a database yet and hypothetically it should just work. 0:17
    I'd like for us to use a complete Java database implementation named H2. 0:22
    It allows us to have a file base version, as well as a complete in-memory version. 0:27

    You need to sign up for Treehouse in order to download course files.

    Sign up

      You need to sign up for Treehouse in order to set up Workspace

      Sign up