package gudusoft.gsqlparser.dlineage.metadata;

import java.util.List;

import gudusoft.gsqlparser.dlineage.dataflow.model.ModelBindingManager;
import gudusoft.gsqlparser.sqlenv.TSQLEnv;
import gudusoft.gsqlparser.util.json.JSONField;

public class Table extends TreeNode {

        private String dbLink;
        private String name;
        private String displayName;
        private String type;
        private String alias;
        private String subType;
        private List<Column> columns;
        private Coordinate[] coordinates;
        private String fromDDL;
        private String databaseName;
        private String schemaName;

        public String getName() {
                return name;
        }

        public void setName(String name) {
                this.name = name;
        }

        public List<Column> getColumns() {
                return columns;
        }

        public void setColumns(List<Column> columns) {
                this.columns = columns;
        }

        public String getType() {
                return type;
        }

        public void setType(String type) {
                this.type = type;
        }
        
        public String getDbLink() {
                return dbLink;
        }

        public void setDbLink(String dbLink) {
                this.dbLink = dbLink;
        }

        public String getDisplayName() {
                return displayName;
        }

        public void setDisplayName(String displayName) {
                this.displayName = displayName;
        }

        public String getSubType() {
                return subType;
        }

        public void setSubType(String subType) {
                this.subType = subType;
        }

        public String getAlias() {
                return alias;
        }

        public void setAlias(String alias) {
                this.alias = alias;
        }

        @JSONField(serialize = false)
        public Database getDatabase() {
                TreeNode parent = getParent();
                Server server = getServer();
                if (parent == null || server == null) {
                        return null;
                }
                if (server.isSupportsCatalogs() && server.isSupportsSchemas()) {
                        return (Database) parent.getParent();
                } else if (server.isSupportsCatalogs()) {
                        return (Database) parent;
                }
                return null;
        }

        @JSONField(serialize = false)
        public Schema getSchema() {
                TreeNode parent = getParent();
                Server server = getServer();
                if (parent == null || server == null) {
                        return null;
                }
                if (server.isSupportsSchemas()) {
                        return (Schema) parent;
                }
                return null;
        }

        @JSONField(serialize = false)
        public String fullName() {
                TreeNode parent = getParent();
                Server server = getServer();
                if (parent == null || server == null) {
                        return name;
                } else {
                        StringBuilder builder = new StringBuilder();
                        if (server.isSupportsCatalogs() && server.isSupportsSchemas()) {
                                if (!TSQLEnv.DEFAULT_DB_NAME.equalsIgnoreCase(getDatabase().getName())) {
                                        builder.append(getDatabase().getName()).append(".");
                                }
                                if (builder.length() > 0 || !TSQLEnv.DEFAULT_SCHEMA_NAME.equalsIgnoreCase(getSchema().getName())) {
                                        builder.append(getSchema().getName()).append(".");
                                }
                                builder.append(getName());
                        } else if (server.isSupportsSchemas()) {
                                if (!TSQLEnv.DEFAULT_SCHEMA_NAME.equalsIgnoreCase(getSchema().getName())) {
                                        builder.append(getSchema().getName()).append(".");
                                }
                                builder.append(getName());
                        } else if (server.isSupportsCatalogs()) {
                                if (!TSQLEnv.DEFAULT_DB_NAME.equalsIgnoreCase(getDatabase().getName())) {
                                        builder.append(getDatabase().getName()).append(".");
                                }
                                builder.append(getName());
                        } else {
                                builder.append(getName());
                        }
                        return builder.toString();
                }
        }

        public Coordinate[] getCoordinates() {
                if (ModelBindingManager.getGlobalOption() != null
                                && ModelBindingManager.getGlobalOption().isIgnoreCoordinate()) {
                        return null;
                }
                return coordinates;
        }

        public void setCoordinates(Coordinate[] coordinates) {
                if (ModelBindingManager.getGlobalOption() != null
                                && ModelBindingManager.getGlobalOption().isIgnoreCoordinate()) {
                        return;
                }
                this.coordinates = coordinates;
        }

        public String getFromDDL() {
                return fromDDL;
        }

        public void setFromDDL(String fromDDL) {
                this.fromDDL = fromDDL;
        }

        public String getDatabaseName() {
                return databaseName;
        }

        public void setDatabaseName(String databaseName) {
                this.databaseName = databaseName;
        }

        public String getSchemaName() {
                return schemaName;
        }

        public void setSchemaName(String schemaName) {
                this.schemaName = schemaName;
        }
}