jp.ne.opt.redshiftfake.parse

AlterTableHandler

class AlterTableHandler extends BaseParser

Created by frankfarrell on 01/03/2018.

Converts redshift alter table to postgres equivalents

https://docs.aws.amazon.com/redshift/latest/dg/r_ALTER_TABLE.html#r_ALTER_TABLE-synopsis

> https://www.postgresql.org/docs/9.1/static/sql-altertable.html

Cases 1) Add column => No difference if NOT NULL and/or DEFAULT are not present 2) Add column with default and/or not null => multiple postgresql statements, drop encoding. i) If NOT NULL and no default -> throw ii) If default is function with params => throw 3) Rename table => jsql? No difference 4) Rename column => jsql? No difference 5) Drop column => jsql? No difference 6) Add Contrainst => No difference 7) Drop Constraint => No difference 8) Alter column add foreign key -> need to ADD CONSTRAINT somethingfk : But this does not work in a transaction. Dropping as it is not enforced by Redshift

Linear Supertypes
BaseParser, RegexParsers, Parsers, AnyRef, Any
Ordering
  1. Alphabetic
  2. By inheritance
Inherited
  1. AlterTableHandler
  2. BaseParser
  3. RegexParsers
  4. Parsers
  5. AnyRef
  6. Any
  1. Hide All
  2. Show all
Learn more about member selection
Visibility
  1. Public
  2. All

Instance Constructors

  1. new AlterTableHandler()

Type Members

  1. type Elem = Char

    Definition Classes
    RegexParsers → Parsers

  2. case class Error extends NoSuccess with Product with Serializable

    Definition Classes
    Parsers

  3. case class Failure extends NoSuccess with Product with Serializable

    Definition Classes
    Parsers

  4. type Input = Reader[Elem]

    Definition Classes
    Parsers

  5. sealed abstract class NoSuccess extends ParseResult[Nothing]

    Definition Classes
    Parsers

  6. trait OnceParser[+T] extends Parser[T]

    Definition Classes
    Parsers

  7. sealed abstract class ParseResult[+T] extends AnyRef

    Definition Classes
    Parsers

  8. abstract class Parser[+T] extends (Input) ⇒ ParseResult[T]

    Definition Classes
    Parsers

  9. case class Success[+T] extends ParseResult[T] with Product with Serializable

    Definition Classes
    Parsers

  10. case class ~[+a, +b] extends Product with Serializable

    Definition Classes
    Parsers

Value Members

  1. final def !=(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef

  2. final def !=(arg0: Any): Boolean

    Definition Classes
    Any

  3. final def ##(): Int

    Definition Classes
    AnyRef → Any

  4. final def ==(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef

  5. final def ==(arg0: Any): Boolean

    Definition Classes
    Any

  6. def OnceParser[T](f: (Input) ⇒ ParseResult[T]): Parser[T] with OnceParser[T]

    Definition Classes
    Parsers

  7. def Parser[T](f: (Input) ⇒ ParseResult[T]): Parser[T]

    Definition Classes
    Parsers

  8. def accept[U](expected: String, f: PartialFunction[Elem, U]): Parser[U]

    Definition Classes
    Parsers

  9. def accept[ES](es: ES)(implicit arg0: (ES) ⇒ List[Elem]): Parser[List[Elem]]

    Definition Classes
    Parsers

  10. implicit def accept(e: Elem): Parser[Elem]

    Definition Classes
    Parsers

  11. def acceptIf(p: (Elem) ⇒ Boolean)(err: (Elem) ⇒ String): Parser[Elem]

    Definition Classes
    Parsers

  12. def acceptMatch[U](expected: String, f: PartialFunction[Elem, U]): Parser[U]

    Definition Classes
    Parsers

  13. def acceptSeq[ES](es: ES)(implicit arg0: (ES) ⇒ Iterable[Elem]): Parser[List[Elem]]

    Definition Classes
    Parsers

  14. val addColumn: Regex

  15. val addColumnNotNull: Regex

  16. val addForeignKey: Regex

  17. val alterTableRegex: Regex

  18. val any: String

    Definition Classes
    BaseParser

  19. final def asInstanceOf[T0]: T0

    Definition Classes
    Any

  20. val awsAuthArgsParser: Parser[Product with Serializable with Credentials]

    Definition Classes
    BaseParser

  21. val awsAuthTemporaryParser: Parser[WithTemporaryToken]

    Definition Classes
    BaseParser

  22. def chainl1[T, U](first: ⇒ Parser[T], p: ⇒ Parser[U], q: ⇒ Parser[(T, U) ⇒ T]): Parser[T]

    Definition Classes
    Parsers

  23. def chainl1[T](p: ⇒ Parser[T], q: ⇒ Parser[(T, T) ⇒ T]): Parser[T]

    Definition Classes
    Parsers

  24. def chainr1[T, U](p: ⇒ Parser[T], q: ⇒ Parser[(T, U) ⇒ U], combine: (T, U) ⇒ U, first: U): Parser[U]

    Definition Classes
    Parsers

  25. def clone(): AnyRef

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  26. val columnName: Parser[String]

  27. def commit[T](p: ⇒ Parser[T]): Parser[T]

    Definition Classes
    Parsers

  28. val dataTypeIdentifier: String

    Definition Classes
    BaseParser

  29. val delimiterParser: Parser[Char]

    Definition Classes
    BaseParser

  30. def elem(e: Elem): Parser[Elem]

    Definition Classes
    Parsers

  31. def elem(kind: String, p: (Elem) ⇒ Boolean): Parser[Elem]

    Definition Classes
    Parsers

  32. final def eq(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef

  33. def equals(arg0: Any): Boolean

    Definition Classes
    AnyRef → Any

  34. def err(msg: String): Parser[Nothing]

    Definition Classes
    Parsers

  35. def failure(msg: String): Parser[Nothing]

    Definition Classes
    Parsers

  36. def finalize(): Unit

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )

  37. final def getClass(): Class[_]

    Definition Classes
    AnyRef → Any

  38. def guard[T](p: ⇒ Parser[T]): Parser[T]

    Definition Classes
    Parsers

  39. def handle(sql: String): String

  40. def handleWhiteSpace(source: CharSequence, offset: Int): Int

    Attributes
    protected
    Definition Classes
    RegexParsers

  41. def hashCode(): Int

    Definition Classes
    AnyRef → Any

  42. val identifier: String

    Definition Classes
    BaseParser

  43. final def isInstanceOf[T0]: Boolean

    Definition Classes
    Any

  44. implicit def literal(s: String): Parser[String]

    Definition Classes
    RegexParsers

  45. def log[T](p: ⇒ Parser[T])(name: String): Parser[T]

    Definition Classes
    Parsers

  46. def matches(sql: String): Boolean

  47. def mkList[T]: (~[T, List[T]]) ⇒ List[T]

    Definition Classes
    Parsers

  48. final def ne(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef

  49. def not[T](p: ⇒ Parser[T]): Parser[Unit]

    Definition Classes
    Parsers

  50. final def notify(): Unit

    Definition Classes
    AnyRef

  51. final def notifyAll(): Unit

    Definition Classes
    AnyRef

  52. def opt[T](p: ⇒ Parser[T]): Parser[Option[T]]

    Definition Classes
    Parsers

  53. def parse[T](p: Parser[T], in: Reader): ParseResult[T]

    Definition Classes
    RegexParsers

  54. def parse[T](p: Parser[T], in: CharSequence): ParseResult[T]

    Definition Classes
    RegexParsers

  55. def parse[T](p: Parser[T], in: Reader[Char]): ParseResult[T]

    Definition Classes
    RegexParsers

  56. def parseAll[T](p: Parser[T], in: CharSequence): ParseResult[T]

    Definition Classes
    RegexParsers

  57. def parseAll[T](p: Parser[T], in: Reader): ParseResult[T]

    Definition Classes
    RegexParsers

  58. def parseAll[T](p: Parser[T], in: Reader[Char]): ParseResult[T]

    Definition Classes
    RegexParsers

  59. def phrase[T](p: Parser[T]): Parser[T]

    Definition Classes
    RegexParsers → Parsers

  60. def positioned[T <: Positional](p: ⇒ Parser[T]): Parser[T]

    Definition Classes
    RegexParsers → Parsers

  61. val quotedIdentifier: String

    Definition Classes
    BaseParser

  62. val quotedIdentifierParser: Parser[String]

    Definition Classes
    BaseParser

  63. implicit def regex(r: Regex): Parser[String]

    Definition Classes
    RegexParsers

  64. def rep[T](p: ⇒ Parser[T]): Parser[List[T]]

    Definition Classes
    Parsers

  65. def rep1[T](first: ⇒ Parser[T], p0: ⇒ Parser[T]): Parser[List[T]]

    Definition Classes
    Parsers
    Annotations
    @migration
    Migration

    (Changed in version 2.9.0) The p0 call-by-name arguments is evaluated at most once per constructed Parser object, instead of on every need that arises during parsing.

  66. def rep1[T](p: ⇒ Parser[T]): Parser[List[T]]

    Definition Classes
    Parsers

  67. def rep1sep[T](p: ⇒ Parser[T], q: ⇒ Parser[Any]): Parser[List[T]]

    Definition Classes
    Parsers

  68. def repN[T](num: Int, p: ⇒ Parser[T]): Parser[List[T]]

    Definition Classes
    Parsers

  69. def repsep[T](p: ⇒ Parser[T], q: ⇒ Parser[Any]): Parser[List[T]]

    Definition Classes
    Parsers

  70. val s3LocationParser: Parser[S3Location]

    Definition Classes
    BaseParser

  71. def skipWhitespace: Boolean

    Definition Classes
    RegexParsers

  72. val space: String

    Definition Classes
    BaseParser

  73. def success[T](v: T): Parser[T]

    Definition Classes
    Parsers

  74. final def synchronized[T0](arg0: ⇒ T0): T0

    Definition Classes
    AnyRef

  75. def toString(): String

    Definition Classes
    AnyRef → Any

  76. final def wait(): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  77. final def wait(arg0: Long, arg1: Int): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  78. final def wait(arg0: Long): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  79. val whiteSpace: Regex

    Attributes
    protected
    Definition Classes
    RegexParsers

Deprecated Value Members

  1. def lastNoSuccess: NoSuccess

    Definition Classes
    Parsers
    Annotations
    @deprecated
    Deprecated

    (Since version 2.10.0) lastNoSuccess was not thread-safe and will be removed in 2.11.0

  2. def lastNoSuccess_=(x: NoSuccess): Unit

    Definition Classes
    Parsers
    Annotations
    @deprecated
    Deprecated

    (Since version 2.10.0) lastNoSuccess was not thread-safe and will be removed in 2.11.0

Inherited from BaseParser

Inherited from RegexParsers

Inherited from Parsers

Inherited from AnyRef

Inherited from Any

Ungrouped