it.unibz.inf.ontop.dbschema.impl

Class MySQLAbstractQuotedIDFactory

java.lang.Object

it.unibz.inf.ontop.dbschema.impl.SQLStandardQuotedIDFactory

it.unibz.inf.ontop.dbschema.impl.MySQLAbstractQuotedIDFactory

All Implemented Interfaces:

it.unibz.inf.ontop.dbschema.QuotedIDFactory

Direct Known Subclasses:

MySQLCaseNotSensitiveTableNamesQuotedIDFactory, MySQLCaseSensitiveTableNamesQuotedIDFactory

public abstract class MySQLAbstractQuotedIDFactory
extends it.unibz.inf.ontop.dbschema.impl.SQLStandardQuotedIDFactory

Creates QuotedIdentifiers following the rules of MySQL:
- unquoted table identifiers are preserved
- unquoted column identifiers are not case-sensitive
- quoted identifiers are preserved https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html How table and database names are stored on disk and used in MySQL is affected by the lower_case_table_names system variable, which you can set when starting mysqld. Column, index, and stored routine names are not case sensitive on any platform, nor are column aliases. https://dev.mysql.com/doc/refman/8.0/en/identifiers.html The identifier quote character is the backtick (`): If the ANSI_QUOTES SQL mode is enabled, it is also permissible to quote identifiers within double quotation marks. The ANSI_QUOTES mode causes the server to interpret double-quoted strings as identifiers. Consequently, when this mode is enabled, string literals must be enclosed within single quotation marks.

Author:

Roman Kontchakov

Field Summary

Fields inherited from class it.unibz.inf.ontop.dbschema.impl.SQLStandardQuotedIDFactory

NO_QUOTATION, QUOTATION_STRING

Constructor Summary

Constructors

Constructor and Description
MySQLAbstractQuotedIDFactory()

Method Summary

Modifier and Type	Method and Description
protected it.unibz.inf.ontop.dbschema.QuotedID	createFromString(String s, boolean caseSensitive)
String	getIDQuotationString()

Methods inherited from class it.unibz.inf.ontop.dbschema.impl.SQLStandardQuotedIDFactory

createAttributeID, createFromString, createRelationID, createRelationID

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

MySQLAbstractQuotedIDFactory

public MySQLAbstractQuotedIDFactory()

Method Detail

createFromString

protected it.unibz.inf.ontop.dbschema.QuotedID createFromString(@Nonnull
                                                                String s,
                                                                boolean caseSensitive)

getIDQuotationString

public String getIDQuotationString()

Specified by:

getIDQuotationString in interface it.unibz.inf.ontop.dbschema.QuotedIDFactory

Overrides:

getIDQuotationString in class it.unibz.inf.ontop.dbschema.impl.SQLStandardQuotedIDFactory