com.squareup.sqldelight.validation.SqlDelightValidator.kt Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of compiler Show documentation
Common code shared between the Gradle and IntelliJ plugin
There is a newer version: 0.9.0
/*
 * Copyright (C) 2016 Square, Inc.
 *
 * 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 com.squareup.sqldelight.validation

import com.squareup.sqldelight.SqliteParser
import com.squareup.sqldelight.Status
import com.squareup.sqldelight.model.columnName
import com.squareup.sqldelight.resolution.ResolutionError
import com.squareup.sqldelight.resolution.Resolver
import com.squareup.sqldelight.resolution.resolve
import com.squareup.sqldelight.types.SymbolTable
import java.util.ArrayList

class SqlDelightValidator {
  fun validate(
      relativePath: String,
      parse: SqliteParser.ParseContext,
      symbolTable: SymbolTable
  ): Status.ValidationStatus {
    val resolver = Resolver(symbolTable)
    val errors = ArrayList()
    val queries = ArrayList()

    val columnNames = linkedSetOf()
    val sqlStatementNames = linkedSetOf()

    parse.sql_stmt_list().create_table_stmt()?.let { createTable ->
      errors.addAll(CreateTableValidator(resolver).validate(createTable))

      createTable.column_def().forEach { column ->
        if (!columnNames.add(column.columnName())) {
          errors.add(ResolutionError.CreateTableError(
              column.column_name(), "Duplicate column name"
          ))
        }
      }
    }

    parse.sql_stmt_list().sql_stmt().forEach { sqlStmt ->
      if (columnNames.contains(sqlStmt.sql_stmt_name().text)) {
        errors.add(ResolutionError.CollisionError(
            sqlStmt.sql_stmt_name(), "SQL identifier collides with column name"
        ))
      }
      if (!sqlStatementNames.add(sqlStmt.sql_stmt_name().text)) {
        errors.add(ResolutionError.CollisionError(
            sqlStmt.sql_stmt_name(), "Duplicate SQL identifier"
        ))
      }
      if (sqlStmt.select_stmt() != null) {
        val resolution = resolver.resolve(sqlStmt.select_stmt())
        errors.addAll(resolution.errors)
        if (resolution.errors.isEmpty()) {
          val queryResults = QueryResults.create(relativePath,
              resolution, symbolTable, sqlStmt.sql_stmt_name().text)
          if (queryResults.isEmpty()) {
            errors.add(ResolutionError.ExpressionError(sqlStmt.select_stmt(),
                "No result column found"))
          } else {
            queries.add(queryResults)
          }
        }
      } else {
        errors.addAll(validate(sqlStmt, resolver))
      }
    }

    val importTypes = linkedSetOf()
    parse.sql_stmt_list().import_stmt().forEach { import ->
      if (!importTypes.add(import.java_type_name().text.substringAfterLast('.'))) {
        errors.add(ResolutionError.CollisionError(
            import.java_type_name(),
            "Multiple imports for type ${import.java_type_name().text.substringAfterLast('.')}"
        ))
      }
    }

    return if (errors.isEmpty())
      Status.ValidationStatus.Validated(parse, resolver.dependencies, queries)
    else
      Status.ValidationStatus.Invalid(errors
          .distinctBy {
            it.originatingElement.start.startIndex to it.originatingElement.stop.stopIndex to it.errorMessage
          }, resolver.dependencies)
  }

  fun validate(sqlStmt: SqliteParser.Sql_stmtContext, resolver: Resolver): List =
      sqlStmt.run {
        select_stmt()?.apply { return resolver.resolve(this).errors }
        insert_stmt()?.apply { return InsertValidator(resolver).validate(this) }
        update_stmt()?.apply { return UpdateValidator(resolver).validate(this) }
        update_stmt_limited()?.apply { return UpdateValidator(resolver).validate(this) }
        delete_stmt()?.apply { return DeleteValidator(resolver).validate(this) }
        delete_stmt_limited()?.apply { return DeleteValidator(resolver).validate(this) }
        create_index_stmt()?.apply { return CreateIndexValidator(resolver).validate(this) }
        create_trigger_stmt()?.apply { return CreateTriggerValidator(resolver).validate(this) }
        create_view_stmt()?.apply { return resolver.resolve(select_stmt()).errors }
        return emptyList()
      }

  companion object {
    const val ALL_FILE_DEPENDENCY = "all_file_dependency"
  }
}