-- DROP TABLE IF EXISTS `customer1`;
CREATE TABLE `customer1` (
  `pk`                    BIGINT        NOT NULL AUTO_INCREMENT,
  `id`                    BIGINT        NOT NULL,
  `name`                  VARCHAR(256)  NOT NULL,
  `email`                 VARCHAR(64)   NOT NULL,
  `password`              VARCHAR(64)   NOT NULL,
  PRIMARY KEY(`pk`),
  UNIQUE(`id`)
);

include "silhouette.conf"

db {

   default.driver="org.mariadb.jdbc.Driver"
   default.url="jdbc:mariadb://127.0.0.1:3306/spetstore?characterEncoding=utf8"
   default.username= admin
   default.password= admin

   default.poolInitialSize = 10
   default.poolMaxSize = 10
   default.poolValidationQuery = "select 1 as one"

 }


 scalikejdbc {
   global {
     loggingSQLAndTime.enabled = true
     loggingSQLAndTime.singleLineMode = true
     loggingSQLAndTime.logLevel = DEBUG
     loggingSQLAndTime.warningEnabled = true
     loggingSQLAndTime.warningThresholdMillis = 5
     loggingSQLAndTime.warningLogLevel = warn
   }
 }

package forms

import play.api.data.Form
import play.api.data.Forms._

/**
 * The form which handles the sign up process.
 */
object SignUpForm {

  /**
   * A play framework form.
   */
   val form = Form(
     mapping(
       "firstName" -> nonEmptyText,
       "lastName" -> nonEmptyText,
       "email" -> email,
       "password" -> nonEmptyText
     )(Data.apply)(Data.unapply)
   )


   /**
    * The form data.
    *
    * @param firstName The first name of a user.
    * @param lastName The last name of a user.
    * @param email The email of the user.
    * @param password The password of the user.
    */
  case class Data(
    firstName: String,
    lastName: String,
    email: String,
    password: String)

def insert(data: Data): Unit = SignUpFormSupport.insert(data)
}

package forms

import java.util.UUID
import javax.inject.Inject

import com.mohiva.play.silhouette.api._
import com.mohiva.play.silhouette.api.repositories.AuthInfoRepository
import com.mohiva.play.silhouette.api.services.AvatarService
import com.mohiva.play.silhouette.api.util.PasswordHasherRegistry
import com.mohiva.play.silhouette.impl.providers._
import models.User
import models.services.{ AuthTokenService, UserService }
import org.webjars.play.WebJarsUtil
import play.api.i18n.{ I18nSupport, Messages }
import play.api.libs.mailer.{ Email, MailerClient }

import play.api.mvc._
import utils.auth.DefaultEnv

import scala.concurrent.{ ExecutionContext, Future }

import com.typesafe.config.ConfigFactory

import java.sql.Connection
import scalikejdbc._
import scalikejdbc.SQLInterpolation._

object SignUpFormSupport {

   import forms.SignUpForm.Data

  /** 登録 */
   def insert(data: Data): Unit = {

    try {

       DB localTx { implicit session =>

       import data._

        val id = System.currentTimeMillis()

         sql"""insert into customer1 (id, `name`, email, `password`)
              |values ($id,  ${firstName + lastName}, $email, $password)"""
          .stripMargin
          .update
          .apply()

      }

    } catch {
      case e: Exception => e.printStackTrace()

    }

   }

}