Re: [2.1-RC3 Scala] Noob question sorry - How to set a default Seq[Seo] if there is no result from databases?

[Sarvesh Kumar Singh]

def getSeoForSor(page: String): Seq[Seo] = {

    getSeo match {

        case Nil => Seq( Seo("my default seo") )

        case a :: _ => getSeo

    }

}

[Julien L.]

Sarvesh Kumar Singh, you make 2 DB call here, no?

I would have written something like that: 

getSeo match { 

  case Nil => Seq(/* your default seo*/) 

  case result => result 

[Sarvesh Kumar Singh]

In that case.. I think answer by Jullen is better

def getSeoForSor(page: String): Seq[Seo] = {

    getSeo(page) match {

        case Nil => Seq(/* your default seo*/)

        case result => result

    }

}  

On Monday, 4 February 2013 18:39:13 UTC+5:30, Alex wrote:

Hi Sarvesh

I get this when I add that def to my code

missing arguments for method getSeo in object Seo; follow this method with `_' if you want to treat it as a partially applied function

[Julien L.]

scala> Seq() match { 

  case Nil => Seq("default")

  case r => r 

}

res1: Seq[String] = List(default) // works

On Monday, February 4, 2013 2:17:01 PM UTC+1, Alex wrote:

Hi

Does not work

[IndexOutOfBoundsException: 0]

The Seq[Seo] is not getting fill with default values :(

On Monday, February 4, 2013 12:57:10 PM UTC, Sarvesh Kumar Singh wrote:

[Julien L.]

When it works in the Scala console but not in Play, you can be sure you have a Pebkac somewhere ;)

On Monday, February 4, 2013 2:36:14 PM UTC+1, Alex wrote:

THANKS Julien

I COULD CRY this works - thanks :) - I spent so many hours searching for this, I NEED to get better at Scala :)

THANKS


def getSeo(page : String) : Seq[Seo] = {
    DB.withConnection { implicit connection =>
      SQL("select * from seo where page = {page}").on('page -> page).as(Seo.pageseo *)
    }
    match {
      case Nil => Seq( Seo("London", "hello", "o"))
      case result => result