Databases
StackOverflow2013
Postsdbo
POUsing specs2 and FakeApplication() to test database fails evolution inserts
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUsing specs2 and FakeApplication() to test database fails evolution inserts
    primarykey
    data
    text
    <p>This is for Play! Framework 2.0.</p> <p>I'm trying to write a simple test case to ensure my user model is functioning properly and persisting data in my database. I'd like to run it in memory if possible so I can get a fresh start with every new run.</p> <p>The issue I have is that my evolutions run(tables are created, data is inserted, but I can't query it as being there). First, my code.</p> <pre><code>CREATE TABLE user_data ( id SERIAL PRIMARY KEY, user_name varchar(256) UNIQUE NOT NULL, email varchar(256) NOT NULL, password varchar(256) NOT NULL, edits int NOT NULL, reports int NOT NULL, active BOOLEAN NOT NULL); INSERT INTO user_data(user_name, email, password, edits, reports, active) VALUES ('user1', 'user1@email.com', '12345678', 0, 0, true); </code></pre> <p>In application.conf</p> <pre><code>db.default.driver=org.postgresql.Driver db.default.url="postgres://user:password@localhost:5432/ME" </code></pre> <p>In build.scala</p> <pre><code>val appDependencies = Seq( // Add your project dependencies here, "postgresql" % "postgresql" % "9.1-901-1.jdbc4" ) </code></pre> <p>The test code</p> <pre><code>class User_dataSpec extends Specification { "The Database" should { "persist data properly" in { running(FakeApplication(additionalConfiguration = inMemoryDatabase())) { //User_data.findAll().length must beEqualTo(1) //Create users User_data.create("user1", "password1", "email@test1.com") must beEqualTo(1) User_data.create("user2", "password2", "email@test2.com") must beEqualTo(2) User_data.create("user1", "password3", "email@test3.com") must beEqualTo(0) //Count users User_data.findAll().length must beEqualTo(2) //Verify users exist User_data.exists("user1") must beTrue User_data.exists("user2") must beTrue //Verify user doesn't exist User_data.exists("user3") must beFalse //Find users by ID User_data.findUser(1).get.user_name must beEqualTo("user1") User_data.findUser(2).get.user_name must beEqualTo("user2") //Fail to find users by ID User_data.findUser(3) must beNone //Find users by user_name User_data.findUser("user1").get.user_name must beEqualTo("user1") User_data.findUser("user2").get.user_name must beEqualTo("user2") //Fail to find users by user_name User_data.findUser("user3") must beNone //Authenticate users User_data.authenticate("user1", "password1") must beTrue User_data.authenticate("user2", "password2") must beTrue //Fail to authenticate users User_data.authenticate("user1", "password2") must beFalse User_data.authenticate("user3", "passwordX") must beFalse //Confirm the user was inserted properly val user = User_data.findUser("user1") user.get.user_name must beEqualTo("user1") user.get.email must beEqualTo("email@test1.com") user.get.password must beEqualTo("password1") user.get.edits must beEqualTo(0) user.get.reports must beEqualTo(0) user.get.active must beTrue } } } } </code></pre> <p>This code will pass as written, however it shouldn't. If I uncomment the first test case inside the running block to test that my findAll() function should be a length of 1 it will fail immediately. However, if I change this to use a persisted PostgreSQL DB on my machine, it will still fail immediately, but when I look at the PostgreSQL DB, my user_data table has the single evolution applied insert in it, and the play_evolutions table has the entry for my evolution and is marked as state = "applied" and last problem = "".</p> <p>Any help would be appreciated, thanks.</p> <p>(P.S., I am a first time poster, but will do my best to accept an answer as soon as possible for those willing to lend their help)</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USjazmit
    1. USWilliam Thurston
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POUsing specs2 and FakeApplication() to test database fails evolution inserts
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POUsing specs2 and FakeApplication() to test database fails evolution inserts
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POUsing specs2 and FakeApplication() to test database fails evolution inserts
      1. USTodd Flanders
      1. VTBountyStart
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload