Tuple的元素太多：27，允许：22

问题描述：

我是新来的Slick并使用Slick 3.1.1。我的表看起来像Tuple的元素太多：27，允许：22

import java.sql.{Blob, Timestamp} 

import slick.collection.heterogeneous.HNil 

import slick.driver.MySQLDriver.api._ 


case class AnomalyC(id: Int, serviceName: String, serviceId: String, timeUpdated: Timestamp, timestamp: Timestamp, anomalyCategoryId: Int, 
        userGroup:Int, riskValue: Float, activityTypeId: Int, destinationHost: String, userName: String, tenantId: Int, information:Blob, timeCreated: Timestamp, userId: Int, anomalyType:Int, anomalyValue:String, measure:Int, 
        userAction:Int, uniqueIdentifier:Int, similarCount:Int, trainingValue:String, state: Int, riskLevel:Int, userRiskLevel:Int, 
        userRiskScore: Float, response:Int) 
class Anomaly(tag:Tag) extends Table[AnomalyC](tag, "Anomaly") { 
    def id = column[Int]("id") 
    def serviceName = column[String]("ServiceName") 
    def serviceId = column[Int]("ServiceId") 
    def timeUpdated = column[Timestamp]("TimeUpdated") 
    def timestamp = column[Timestamp]("Timestamp") 
    def anomalyCategoryId = column[Int]("AnomalyCategoryId") 
    def userGroup = column[Int]("UserGroup") 
    def riskValue = column[Float]("RiskValue") 
    def activityTypeId = column[Int]("ActivityTypeId") 
    def destinationHost = column[String]("DestinationHost") 
    def userName = column[String]("UserName") 
    def tenantId = column[Int]("TenantId") 
    def information = column[Blob]("Information") 
    def timeCreated = column[Timestamp]("TimeCreated") 
    def userId = column[Int]("UserId") 
    def anomalyType = column[Int]("AnomalyType") 
    def anomalyValue = column[String]("AnomalyValue") 
    def measure = column[Int]("Measure") 
    def userAction = column[Int]("UserAction") 
    def uniqueIdentifier = column[String]("UniqueIdentifier") 
    def similarCount = column[Int]("SimilarCount") 
    def trainingValue = column[String]("TrainingValue") 
    def state = column[Int]("State") 
    def riskLevel = column[Int]("RiskLevel") 
    def userRiskLevel = column[Int]("UserRiskLevel") 
    def userRiskScore = column[Float]("UserRiskScore") 
    def response = column[Int]("Response") 

    def * = (id, serviceName, serviceId, timeUpdated, timestamp, anomalyCategoryId, userGroup, 
    riskValue, activityTypeId, destinationHost, userName, tenantId, information, timeCreated, userId, anomalyType, anomalyValue, 
    measure, userAction, uniqueIdentifier, similarCount, trainingValue, state, riskLevel, userRiskLevel, userRiskScore, response) 

}

当我跑，我得到错误的

Error:(57, 11) too many elements for tuple: 27, allowed: 22 
    def * = (id, serviceName, serviceId, timeUpdated, timestamp, anomalyCategoryId, userGroup, 
     ^

我该怎么办？

答

根据来自@ insan-e的回答，我重新编写了这个文件，这也适用。我更喜欢这种方法，但我不明白整个代码

import java.sql.{Blob, Timestamp} 

import slick.driver.MySQLDriver.api._ 

case class Anomaly1(id:Int, serviceName:String, serviceId: Int, timeUpdated: Timestamp, timeStamp: Timestamp, 
        anomalyCategoryId: Int, userGroup: Int, riskValue: Float, activityTypeId: Int, destinationHost: String, userName: String) 

case class Anomaly2(tenantId: Int, information:Blob, timeCreated: Timestamp, userId: Int, anomalyType:Int, anomalyValue: String, measure: Int, userAction: Int, 
        uniqueIdentifier: String, similarCount: Int, trainingValue: String, state: Int, riskLevel: Int, 
        userRiskLevel: Int, userRiskScore: Float, response: Int) 

case class AnomalyRow(anomaly1: Anomaly1, anomaly2: Anomaly2) 

class Anomaly(tag:Tag) extends Table[AnomalyRow](tag, "Anomaly") { 

    def id = column[Int]("id") 
    def serviceName = column[String]("ServiceName") 
    def serviceId = column[Int]("ServiceId") 
    def timeUpdated = column[Timestamp]("TimeUpdated") 
    def timestamp = column[Timestamp]("Timestamp") 
    def anomalyCategoryId = column[Int]("AnomalyCategoryId") 
    def userGroup = column[Int]("UserGroup") 
    def riskValue = column[Float]("RiskValue") 
    def activityTypeId = column[Int]("ActivityTypeId") 
    def destinationHost = column[String]("DestinationHost") 
    def userName = column[String]("UserName") 
    def tenantId = column[Int]("TenantId") 
    def information = column[Blob]("Information") 
    def timeCreated = column[Timestamp]("TimeCreated") 
    def userId = column[Int]("UserId") 
    def anomalyType = column[Int]("AnomalyType") 
    def anomalyValue = column[String]("AnomalyValue") 
    def measure = column[Int]("Measure") 
    def userAction = column[Int]("UserAction") 
    def uniqueIdentifier = column[String]("UniqueIdentifier") 
    def similarCount = column[Int]("SimilarCount") 
    def trainingValue = column[String]("TrainingValue") 
    def state = column[Int]("State") 
    def riskLevel = column[Int]("RiskLevel") 
    def userRiskLevel = column[Int]("UserRiskLevel") 
    def userRiskScore = column[Float]("UserRiskScore") 
    def response = column[Int]("Response") 

    private type Anomaly1TupleType = (Int, String, Int, Timestamp, Timestamp, Int, Int, Float, Int, String, String) 
    private type Anomaly2TupleType = (Int, Blob, Timestamp, Int, Int, String, Int, Int, String, Int, String, Int, Int, Int, Float, Int) 
    private type AnomalyRowTupleType = (Anomaly1TupleType, Anomaly2TupleType) 

    private val anomalyShapedValue = (
    (id, serviceName, serviceId, timeUpdated, timestamp, anomalyCategoryId, userGroup, riskValue, activityTypeId, destinationHost, userName), 
    (tenantId, information, timeCreated, userId, anomalyType, anomalyValue, measure, userAction, uniqueIdentifier, similarCount, trainingValue, state, riskLevel, userRiskLevel, userRiskScore, response) 
    ).shaped[AnomalyRowTupleType] 

    private val toAnomalyRow: (AnomalyRowTupleType => AnomalyRow) = { anomalyTuple => 
    AnomalyRow(anomaly1 = Anomaly1.tupled.apply(anomalyTuple._1), anomaly2 = Anomaly2.tupled.apply(anomalyTuple._2)) 
    } 

    private val toAnomalyTuple: (AnomalyRow => Option[AnomalyRowTupleType]) = { anomalyRow => 
    Some(Anomaly1.unapply(anomalyRow.anomaly1).get, Anomaly2.unapply(anomalyRow.anomaly2).get) 
    } 

    def * = anomalyShapedValue <> (toAnomalyRow, toAnomalyTuple) 
}

答

您可以使用HList。 Slick有它自己的实现，或者可能使用无形的更好的互操作性。这里有一篇文章解释它：http://underscore.io/blog/posts/2015/08/08/slickless.html

或者，你可以使用一个case类而不是一个元组。

哪个没形？我正在使用'Maven'，这是你正在使用的？ http://mvnrepository.com/search?q=shapeless – daydreamer

这一个：https：//github.com/milessabin/shapeless。看起来这是最新的com.chuusai：无形：2.3.1 – cvogt

http://mvnrepository.com/artifact/com.chuusai/shapeless_2.11/2.3.0 – daydreamer

答

下面的工作基于@cvogt提供的方向。

import java.sql.{Blob, Timestamp} 

import slick.collection.heterogeneous.HNil 
import slick.collection.heterogeneous.syntax._ 
import slick.driver.MySQLDriver.api._ 

class Anomaly(tag:Tag) extends Table[Int :: String :: Int :: Timestamp :: Timestamp :: Int :: Int :: Float :: Int :: String 
    :: String :: Int ::Blob :: Timestamp :: Int ::Int ::String ::Int ::Int ::String ::Int ::String :: Int ::Int ::Int :: 
    Float :: Int :: HNil ](tag, "Anomaly") { 

    def id = column[Int]("id") 
    def serviceName = column[String]("ServiceName") 
    def serviceId = column[Int]("ServiceId") 
    def timeUpdated = column[Timestamp]("TimeUpdated") 
    def timestamp = column[Timestamp]("Timestamp") 
    def anomalyCategoryId = column[Int]("AnomalyCategoryId") 
    def userGroup = column[Int]("UserGroup") 
    def riskValue = column[Float]("RiskValue") 
    def activityTypeId = column[Int]("ActivityTypeId") 
    def destinationHost = column[String]("DestinationHost") 
    def userName = column[String]("UserName") 
    def tenantId = column[Int]("TenantId") 
    def information = column[Blob]("Information") 
    def timeCreated = column[Timestamp]("TimeCreated") 
    def userId = column[Int]("UserId") 
    def anomalyType = column[Int]("AnomalyType") 
    def anomalyValue = column[String]("AnomalyValue") 
    def measure = column[Int]("Measure") 
    def userAction = column[Int]("UserAction") 
    def uniqueIdentifier = column[String]("UniqueIdentifier") 
    def similarCount = column[Int]("SimilarCount") 
    def trainingValue = column[String]("TrainingValue") 
    def state = column[Int]("State") 
    def riskLevel = column[Int]("RiskLevel") 
    def userRiskLevel = column[Int]("UserRiskLevel") 
    def userRiskScore = column[Float]("UserRiskScore") 
    def response = column[Int]("Response") 

    def * = id :: serviceName :: serviceId :: timeUpdated :: timestamp :: anomalyCategoryId :: userGroup :: 
    riskValue :: activityTypeId :: destinationHost :: userName :: tenantId :: information :: timeCreated :: userId :: anomalyType :: anomalyValue :: 
    measure :: userAction :: uniqueIdentifier :: similarCount :: trainingValue :: state :: riskLevel :: userRiskLevel :: userRiskScore :: response :: HNil 
}

构建运行和测试通不过，但是，我仍然看到的IntelliJ抱怨，出现以下错误

答

正如cvogt已经说了，你可以使用嵌套case类，他们更容易与之合作，见here。我知道HLists是强大的，但恕我直言，人们迫使他们太多......案例类有什么问题？ xD

您应该从包含< = 22个字段的2个或更多个案例类组成AnomalyC类。

Tuple的元素太多：27，允许：22

相关推荐