SQL Parsing

[aidan-bailey]

SQL Parsing

For the initial milestone, we're just taking in SQL as input (i.e., the source create tables & the target create tables, constraints and mappings). It follows then that we'll have manipulate this information in some way. In order to do this in the sophisticated manner required, we'll have to properly parse them.

JSqlParser looks to be a good candidate to accommodate this.

[aidan-bailey]

Create Tables of the form:

CREATE TABLE ssqlt_test._person(ssn VARCHAR (100) NOT NULL,phone VARCHAR (100) NOT NULL,manager VARCHAR (100),title VARCHAR (100),city VARCHAR (100) NOT NULL,country VARCHAR (100) NOT NULL,mayor VARCHAR (100) NOT NULL,PRIMARY KEY (ssn,phone))

have been successfully parsed