All Downloads are FREE. Search and download functionalities are using the official Maven repository.

net.moznion.mysql.diff.SchemaParser Maven / Gradle / Ivy

Go to download

Detect and extract diff between two table declarations from schema of MySQL

There is a newer version: 1.1.0
Show newest version
package net.moznion.mysql.diff;

import net.moznion.mysql.diff.model.Column;
import net.moznion.mysql.diff.model.OrdinaryKey;
import net.moznion.mysql.diff.model.Table;
import net.moznion.mysql.diff.model.UniqueKey;

import java.util.ArrayList;
import java.util.List;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

/**
 * Dumper for SQL table definition.
 * 
 * @author moznion
 *
 */
public class SchemaParser {
  private static final Pattern TABLA_BLOCK_PATTERN = Pattern.compile(
      "CREATE TABLE .*? ENGINE[^;]*", Pattern.MULTILINE | Pattern.DOTALL);

  private static final Pattern TABLE_NAME_PATTERN = Pattern.compile("`(.*?)`");

  private static final Pattern PRIMARY_KEY_PATTERN = Pattern.compile(
      "^\\s*PRIMARY KEY\\s+\\((.*)\\)");

  private static final Pattern UNIQUE_KEY_PATTERN = Pattern.compile(
      "^\\s*UNIQUE KEY\\s+`(.*)`\\s+\\((.*)\\)");

  private static final Pattern ORDINARY_KEY_PATTERN = Pattern.compile(
      "^\\s*KEY\\s+`(.*)`\\s+\\((.*)\\)");

  private static final Pattern COLUMN_PATTERN = Pattern.compile(
      "^\\s*`(.*?)`\\s+(.+?)[\n,]?$");

  /**
   * Parse and output table definition of given schema.
   * 
   * @param schema Schema which is generated by SchemaDumper.
   * @return Table definition of given schema.
   */
  public static List parse(String schema) {
    Matcher blockMatcher = TABLA_BLOCK_PATTERN.matcher(schema);

    List
 tables = new ArrayList<>();

    while (blockMatcher.find()) {
      String content = blockMatcher.group();

      Matcher tableNameMatcher = TABLE_NAME_PATTERN.matcher(content);
      if (!tableNameMatcher.find()) {
        continue;
      }
      String tableName = tableNameMatcher.group(1);

      List primaryKeys = new ArrayList<>();
      List uniqueKeys = new ArrayList<>();
      List keys = new ArrayList<>();
      List columns = new ArrayList<>();

      for (String line : content.split("\r?\n")) {
        if (line.matches("^CREATE") || line.matches("^\\)")) {
          continue;
        }

        Matcher primaryKeyMatcher = PRIMARY_KEY_PATTERN.matcher(line);
        if (primaryKeyMatcher.find()) {
          primaryKeys.add(primaryKeyMatcher.group(1));
          continue;
        }

        Matcher uniqueKeyMatcher = UNIQUE_KEY_PATTERN.matcher(line);
        if (uniqueKeyMatcher.find()) {
          uniqueKeys.add(new UniqueKey(uniqueKeyMatcher.group(1), uniqueKeyMatcher.group(2)));
          continue;
        }

        Matcher ordinaryKeyMatcher = ORDINARY_KEY_PATTERN.matcher(line);
        if (ordinaryKeyMatcher.find()) {
          keys.add(new OrdinaryKey(ordinaryKeyMatcher.group(1), ordinaryKeyMatcher.group(2)));
          continue;
        }

        Matcher columnMatcher = COLUMN_PATTERN.matcher(line);
        if (columnMatcher.find()) {
          columns.add(new Column(columnMatcher.group(1), columnMatcher.group(2)));
          continue;
        }

        // Match nothing if reach here
      }

      tables.add(Table.builder()
          .tableName(tableName)
          .primaryKeys(primaryKeys)
          .keys(keys)
          .uniqueKeys(uniqueKeys)
          .columns(columns)
          .content(content)
          .build());
    }

    return tables;
  }
}
    

    

    

            

    

            



    
    






    
© 2015 - 2024 Weber Informatics LLC | Privacy Policy