/*

 * Copyright 2011-2012 Tomas Zeman <tzeman@volny.cz>

 *

 * Licensed under the Apache License, Version 2.0 (the "License");

 * you may not use this file except in compliance with the License.

 * You may obtain a copy of the License at

 *

 *     http://www.apache.org/licenses/LICENSE-2.0

 *

 * Unless required by applicable law or agreed to in writing, software

 * distributed under the License is distributed on an "AS IS" BASIS,

 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

 * See the License for the specific language governing permissions and

 * limitations under the License.

 */

package fis.aaa.model

import fis.base.model.BaseSchema

import net.liftweb.squerylrecord.RecordTypeMode._

/**

 * Database schema for users, ...

 */

trait AaaSchema extends BaseSchema {

  val userT = tableWithSeq[User]

  on(userT)(t => declare(

    t.login   defineAs(indexed("user_login_idx")),

    columns(t.deleted, t.active) are(indexed("user_deleted_active_idx"))

  ))

  /** All existing (undeleted) users. */

  val usersF = () => from(userT)(u =>

    where(u.deleted === false) select(u) orderBy(u.name asc))

  /** Active users. */

  val activeUsersF = () => from(userT)(u =>

    where(u.deleted === false and u.active === true) select(u)

    orderBy(u.name asc))

}

object AaaSchema extends AaaSchema

// vim: set ts=2 sw=2 et: