Ntp.Data.Provider.MySqlFactory Class Reference

Inheritance diagram for Ntp.Data.Provider.MySqlFactory:

Collaboration diagram for Ntp.Data.Provider.MySqlFactory:

Public Member Functions
override IDbCommand	CreateCommand ()
override IDbConnection	CreateConnection ()
override void	CreateDatabase ()
override IDbConnection	CreateGenericConnection ()
override IDbDataParameter	CreateParameter (string name, object value)
override string	DateAddMinutes (string dateColumn, string minuteColumn)
override string	PrepareCheckTableSql (string table)
override string	PrepareCreateTableSql (string sql)
override string	PrepareInsertSql (string sql)
override string	PrepareSql (string sql)

Package Functions
	MySqlFactory ()

Static Private Member Functions
static string	BuildConnectionString (bool includeName=true)

Private Attributes
const string	CheckTableSql
const string	CreateDatabaseSql

Additional Inherited Members
Static Public Member Functions inherited from Ntp.Data.Provider.SqlDatabaseFactory
static void	Initialize (IDatabaseConfiguration factoryConfiguration)
Static Protected Attributes inherited from Ntp.Data.Provider.SqlDatabaseFactory
static IDatabaseConfiguration	Config
Properties inherited from Ntp.Data.Provider.SqlDatabaseFactory
static SqlDatabaseFactory	Instance [get]

Detailed Description

Definition at line 29 of file MySqlFactory.cs.

Constructor & Destructor Documentation

Ntp.Data.Provider.MySqlFactory.MySqlFactory ( )

inlinepackage

Definition at line 31 of file MySqlFactory.cs.

        {
        }

Member Function Documentation

static string Ntp.Data.Provider.MySqlFactory.BuildConnectionString ( bool  includeName = true )

inlinestaticprivate

Definition at line 101 of file MySqlFactory.cs.

References b.

        {
            if (Config.ConnectionString != null)
                return Config.ConnectionString;

            var b = new StringBuilder();
            b.Append($"Server={Config.Host};");

            if (Config.Port != null)
                b.Append($"Port={Config.Port};");

            if (includeName)
                b.Append($"Database={Config.Name};");

            b.Append($"Uid={Config.User};");
            b.Append($"Pwd={Config.Pass};");

            if (Config.EnableSsl)
                b.Append(@"SSL Mode=Required;");

            if (Config.CertificateFile != null)
                b.Append($"CertificateFile={Config.CertificateFile};");

            if (Config.CertificatePassword != null)
                b.Append($"CertificatePassword={Config.CertificatePassword};");

            if (Config.ConnectionTimeout.HasValue)
                b.Append($"Connection Timeout={Config.ConnectionTimeout.Value};");

            return b.ToString();
        }

override IDbCommand Ntp.Data.Provider.MySqlFactory.CreateCommand ( )

inlinevirtual

Implements Ntp.Data.Provider.SqlDatabaseFactory.

Definition at line 44 of file MySqlFactory.cs.

        {
            return new MySqlCommand();
        }

override IDbConnection Ntp.Data.Provider.MySqlFactory.CreateConnection ( )

inlinevirtual

Implements Ntp.Data.Provider.SqlDatabaseFactory.

Definition at line 49 of file MySqlFactory.cs.

        {
            return new MySqlConnection(BuildConnectionString());
        }

override void Ntp.Data.Provider.MySqlFactory.CreateDatabase ( )

inlinevirtual

Implements Ntp.Data.Provider.SqlDatabaseFactory.

Definition at line 55 of file MySqlFactory.cs.

        {
            var connection = CreateGenericConnection();
            connection.Open();
            var command = Instance.CreateCommand();
            command.Connection = connection;
            command.CommandText = string.Format(CreateDatabaseSql, Config.Name);
            command.Prepare();
            connection.Close();
        }

override IDbConnection Ntp.Data.Provider.MySqlFactory.CreateGenericConnection ( )

inlinevirtual

Implements Ntp.Data.Provider.SqlDatabaseFactory.

Definition at line 66 of file MySqlFactory.cs.

        {
            return new MySqlConnection(BuildConnectionString(false));
        }

override IDbDataParameter Ntp.Data.Provider.MySqlFactory.CreateParameter ( string  name, object  value  )

inlinevirtual

Implements Ntp.Data.Provider.SqlDatabaseFactory.

Definition at line 71 of file MySqlFactory.cs.

        {
            return new MySqlParameter(name, value);
        }

override string Ntp.Data.Provider.MySqlFactory.DateAddMinutes ( string  dateColumn, string  minuteColumn  )

inlinevirtual

Implements Ntp.Data.Provider.SqlDatabaseFactory.

Definition at line 76 of file MySqlFactory.cs.

        {
            return $"{dateColumn} - interval {minuteColumn} minute";
        }

override string Ntp.Data.Provider.MySqlFactory.PrepareCheckTableSql ( string  table )

inlinevirtual

Implements Ntp.Data.Provider.SqlDatabaseFactory.

Definition at line 81 of file MySqlFactory.cs.

        {
            return PrepareSql(string.Format(CheckTableSql, Config.Name, table));
        }

override string Ntp.Data.Provider.MySqlFactory.PrepareCreateTableSql ( string  sql )

inlinevirtual

Implements Ntp.Data.Provider.SqlDatabaseFactory.

Definition at line 86 of file MySqlFactory.cs.

        {
            return PrepareSql(string.Format(sql, "INT NOT NULL AUTO_INCREMENT", " ENGINE=INNODB"));
        }

override string Ntp.Data.Provider.MySqlFactory.PrepareInsertSql ( string  sql )

inlinevirtual

Implements Ntp.Data.Provider.SqlDatabaseFactory.

Definition at line 91 of file MySqlFactory.cs.

        {
            return PrepareSql(string.Format(sql, "SELECT LAST_INSERT_ID()"));
        }

override string Ntp.Data.Provider.MySqlFactory.PrepareSql ( string  sql )

inlinevirtual

Implements Ntp.Data.Provider.SqlDatabaseFactory.

Definition at line 96 of file MySqlFactory.cs.

        {
            return sql.Replace("[", string.Empty).Replace("]", string.Empty);
        }

Member Data Documentation

const string Ntp.Data.Provider.MySqlFactory.CheckTableSql

private

Initial value:

=
            "SELECT table_name " +
            "FROM information_schema.tables " +
            "WHERE table_schema = '{0}' " +
            "AND table_name = '{1}';"

Definition at line 38 of file MySqlFactory.cs.

const string Ntp.Data.Provider.MySqlFactory.CreateDatabaseSql

private

Initial value:

=
            "CREATE DATABASE IF NOT EXISTS {0};"

Definition at line 35 of file MySqlFactory.cs.

---

The documentation for this class was generated from the following file:

• Ntp.Data.Provider/MySqlFactory.cs