ca.spatial.parser.SqlToBeanShell

public class SqlToBeanShell extends Object

Convert a PL/pgSQL function to an equivalent BeanShell function. This class is experimental and has not been programmed to contain all of the syntax and data types possible in PL/pgSQL. Consequently it may not be able to properly convert all cases. Please report any issues to SPS so that this script may be improved.

Field Summary

Fields

Modifier and Type

Field

Description

static int

ALTER

RegularExpression Id.

static int

AND

RegularExpression Id.

static int

AS

RegularExpression Id.

static int

ASSIGN

RegularExpression Id.

static int

BEGIN

RegularExpression Id.

static int

BODY

RegularExpression Id.

static int

CASE

RegularExpression Id.

static int

CAST

RegularExpression Id.

static int

CHARACTER

RegularExpression Id.

static int

COMMA

RegularExpression Id.

static int

COMMENT

RegularExpression Id.

static int

CONCAT

RegularExpression Id.

static int

DECLARE

RegularExpression Id.

static int

DEFAULT

Lexical state.

static int

ELSE

RegularExpression Id.

static int

END

RegularExpression Id.

static int

EOF

End of File.

static int

EQ

RegularExpression Id.

static int

GE

RegularExpression Id.

static int

GT

RegularExpression Id.

static int

ID

RegularExpression Id.

static int

IGNORE

Lexical state.

static int

INT

RegularExpression Id.

static int

INTEGER

RegularExpression Id.

static int

INTO

RegularExpression Id.

static int

IS

RegularExpression Id.

ca.spatial.parser.Token

jj_nt

Next token.

static int

LANGUAGE

RegularExpression Id.

static int

LE

RegularExpression Id.

static int

LPAREN

RegularExpression Id.

static int

LT

RegularExpression Id.

static int

NE

RegularExpression Id.

static int

NULL

RegularExpression Id.

static int

NUM

RegularExpression Id.

static int

NUMBER

RegularExpression Id.

static int

OR

RegularExpression Id.

static int

OTHERS

RegularExpression Id.

static int

RETURN

RegularExpression Id.

static int

RETURNS

RegularExpression Id.

static int

RPAREN

RegularExpression Id.

static int

SELECT

RegularExpression Id.

static int

SEMI

RegularExpression Id.

static int

SEMI2

RegularExpression Id.

static int

STRING_LITERAL

RegularExpression Id.

static int

TEXT

RegularExpression Id.

static int

THEN

RegularExpression Id.

ca.spatial.parser.Token

token

Current token.

ca.spatial.parser.SqlToBeanShellTokenManager

token_source

Generated Token Manager.

static String[]

tokenImage

Literal token values.

static int

VARYING

RegularExpression Id.

static int

WHEN

RegularExpression Id.
Constructor Summary

Constructors

Constructor

Description

SqlToBeanShell(ca.spatial.parser.SqlToBeanShellTokenManager tm)

Constructor with generated Token Manager.

SqlToBeanShell(InputStream stream)

Constructor with InputStream.

SqlToBeanShell(InputStream stream, String encoding)

Constructor with InputStream and supplied encoding

SqlToBeanShell(Reader stream)

Constructor.
Method Summary

Modifier and Type

Method

Description

static void

convertMethod(String filename, Window parent, boolean modal)

static String

convertMethod(String sql, String filename)

void

disable_tracing()

Disable tracing.

void

enable_tracing()

Enable tracing.

ParseException

generateParseException()

Generate ParseException.

ca.spatial.parser.Token

getNextToken()

Get the next Token.

ca.spatial.parser.Token

getToken(int index)

Get the specific Token.

static void

main(String[] args)

void

ReInit(ca.spatial.parser.SqlToBeanShellTokenManager tm)

Reinitialise.

void

ReInit(InputStream stream)

Reinitialise.

void

ReInit(InputStream stream, String encoding)

Reinitialise.

void

ReInit(Reader stream)

Reinitialise.

Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details
- token_source
  
  public ca.spatial.parser.SqlToBeanShellTokenManager token_source
  
  Generated Token Manager.
- token
  
  public ca.spatial.parser.Token token
  
  Current token.
- jj_nt
  
  public ca.spatial.parser.Token jj_nt
  
  Next token.
- EOF
  
  static final int EOF
  
  End of File.
  
  See Also:
  
  Constant Field Values
- COMMENT
  
  static final int COMMENT
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- LANGUAGE
  
  static final int LANGUAGE
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- ALTER
  
  static final int ALTER
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- SEMI2
  
  static final int SEMI2
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- INT
  
  static final int INT
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- INTEGER
  
  static final int INTEGER
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- TEXT
  
  static final int TEXT
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- CHARACTER
  
  static final int CHARACTER
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- VARYING
  
  static final int VARYING
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- AS
  
  static final int AS
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- CASE
  
  static final int CASE
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- END
  
  static final int END
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- WHEN
  
  static final int WHEN
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- THEN
  
  static final int THEN
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- ELSE
  
  static final int ELSE
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- DECLARE
  
  static final int DECLARE
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- BEGIN
  
  static final int BEGIN
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- CONCAT
  
  static final int CONCAT
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- CAST
  
  static final int CAST
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- COMMA
  
  static final int COMMA
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- SEMI
  
  static final int SEMI
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- LPAREN
  
  static final int LPAREN
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- RPAREN
  
  static final int RPAREN
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- RETURNS
  
  static final int RETURNS
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- RETURN
  
  static final int RETURN
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- BODY
  
  static final int BODY
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- SELECT
  
  static final int SELECT
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- INTO
  
  static final int INTO
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- EQ
  
  static final int EQ
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- NE
  
  static final int NE
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- LT
  
  static final int LT
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- LE
  
  static final int LE
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- GT
  
  static final int GT
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- GE
  
  static final int GE
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- AND
  
  static final int AND
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- OR
  
  static final int OR
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- ASSIGN
  
  static final int ASSIGN
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- IS
  
  static final int IS
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- NULL
  
  static final int NULL
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- NUM
  
  static final int NUM
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- OTHERS
  
  static final int OTHERS
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- ID
  
  static final int ID
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- NUMBER
  
  static final int NUMBER
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- STRING_LITERAL
  
  static final int STRING_LITERAL
  
  RegularExpression Id.
  
  See Also:
  
  Constant Field Values
- DEFAULT
  
  static final int DEFAULT
  
  Lexical state.
  
  See Also:
  
  Constant Field Values
- IGNORE
  
  static final int IGNORE
  
  Lexical state.
  
  See Also:
  
  Constant Field Values
- tokenImage
  
  static final String[] tokenImage
  
  Literal token values.
Constructor Details
- SqlToBeanShell
  
  public SqlToBeanShell(InputStream stream)
  
  Constructor with InputStream.
- SqlToBeanShell
  
  public SqlToBeanShell(InputStream stream, String encoding)
  
  Constructor with InputStream and supplied encoding
- SqlToBeanShell
  
  public SqlToBeanShell(Reader stream)
  
  Constructor.
- SqlToBeanShell
  
  public SqlToBeanShell(ca.spatial.parser.SqlToBeanShellTokenManager tm)
  
  Constructor with generated Token Manager.
Method Details
- main
  
  public static void main(String[] args)
- convertMethod
  
  public static String convertMethod(String sql, String filename)
- convertMethod
  
  public static void convertMethod(String filename, Window parent, boolean modal)
- ReInit
  
  public void ReInit(InputStream stream)
  
  Reinitialise.
- ReInit
  
  public void ReInit(InputStream stream, String encoding)
  
  Reinitialise.
- ReInit
  
  public void ReInit(Reader stream)
  
  Reinitialise.
- ReInit
  
  public void ReInit(ca.spatial.parser.SqlToBeanShellTokenManager tm)
  
  Reinitialise.
- getNextToken
  
  public final ca.spatial.parser.Token getNextToken()
  
  Get the next Token.
- getToken
  
  public final ca.spatial.parser.Token getToken(int index)
  
  Get the specific Token.
- generateParseException
  
  public ParseException generateParseException()
  
  Generate ParseException.
- enable_tracing
  
  public final void enable_tracing()
  
  Enable tracing.
- disable_tracing
  
  public final void disable_tracing()
  
  Disable tracing.

Class SqlToBeanShell

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Details

token_source

token

jj_nt

EOF

COMMENT

LANGUAGE

ALTER

SEMI2

INT

INTEGER

TEXT

CHARACTER

VARYING

AS

CASE

END

WHEN

THEN

ELSE

DECLARE

BEGIN

CONCAT

CAST

COMMA

SEMI

LPAREN

RPAREN

RETURNS

RETURN

BODY

SELECT

INTO

EQ

NE

LT

LE

GT

GE

AND

OR

ASSIGN

IS

NULL

NUM

OTHERS

ID

NUMBER

STRING_LITERAL

DEFAULT

IGNORE

tokenImage

Constructor Details

SqlToBeanShell

SqlToBeanShell

SqlToBeanShell

SqlToBeanShell

Method Details

main

convertMethod

convertMethod

ReInit

ReInit

ReInit

ReInit

getNextToken

getToken

generateParseException

enable_tracing

disable_tracing