Is it possible to read just the DDL stataments from a database backup in sql format?

[tmoreira2020]

hi there, I would like to "extract" only the CREATE TABLE and CREATE INDEX from a database dump that has 3.3 gb size. Is it possible to ignore all the INSERT statements?

[manticore-projects]

Greetings.

Yes, you can:

1. parse the statements (1 statement takes est. 8 ms)
2. test the parsed statement for instanceof Create...

Good luck and cheers.

[tmoreira2020]

Thanks @manticore-projects. I already applied your suggestion but I would like to improve more the parsing process. Let me rephrase my question. Is it possible to ignore all the INSERT during the parser process?

My code is

	    CCJSqlParser parser = new CCJSqlParser(new StreamProvider(reader));

	    while (reader.ready()) {
		    try {
		        Statement stmt = parser.withErrorRecovery(true).withBackslashEscapeCharacter(true).Statement(); // parse next statement
		        
		        if (stmt instanceof CreateTable || stmt instanceof CreateIndex) {
			        // process stmt here
					_parseOneStatement(stmt, tables, indexes);
		        }
			} catch (ParseException e) {
				e.printStackTrace();
			}
	    }

[manticore-projects]

Your code looks good although _parseOneStatement() may be misleading: We have parsed the statement at that point already. Do you mean processStatement(stmt) instead?

ignore all the INSERT is not possible: we know only after parsing what kind of statement it is.

Best and cheers.

[tmoreira2020]

Ok, thanks. I will rename the _parseOneStatement method to _processStatement.