### Question:
Parser { public Database parse( File file ) throws IOException { String ddl = readFile(file); DdlParsers parsers = new DdlParsers(); AstNode node = parsers.parse(ddl, file.getName()); System.out.println(node.toString()); return processStatements(node); }  static void main( String[] argv ); Database parse( File file );  }### Answer:
@Test public void shouldParseSql92CreateSchema() throws Exception { database = parser.parse(testFile("create_schema.ddl")); assertThat(database.getName(), is("POSTGRES")); Schema schema = database.getSchema("hollywood", false); assertThat(schema.getName(), is("hollywood")); Table table = schema.getTable("films", false); assertThat(table.getName(), is("films")); Iterator<Column> columns = table.getColumns().values().iterator(); assertColumn(columns.next(), "title", "VARCHAR", null, 255, 0, 0); assertColumn(columns.next(), "release", "DATE", null, 0, 0, 0); assertColumn(columns.next(), "producerName", "VARCHAR", null, 255, 0, 0); assertThat(columns.hasNext(), is(false)); View view = schema.getView("winners", false); assertThat(view.getName(), is("winners")); assertThat(view.expression, is("CREATE VIEW winners AS SELECT title, release FROM films WHERE producerName IS NOT NULL;")); }