Ntp.Analyzer.Data.Sql.HostDatabaseMapper Class Reference

OR/M mapper for table host. More...

Inheritance diagram for Ntp.Analyzer.Data.Sql.HostDatabaseMapper:

Collaboration diagram for Ntp.Analyzer.Data.Sql.HostDatabaseMapper:

Protected Member Functions
override void	Insert (Host item)
override void	ReadContent ()
override void	Update (Host item)
Protected Member Functions inherited from Ntp.Analyzer.Data.Sql.SqlDatabaseMapper< Host >
	SqlDatabaseMapper (LogBase log)
void	AddItem (T item)
void	Close ()
IDbDataParameter	CreateParameter (string name, object value)
virtual T	FetchExternal (int id)
abstract void	Insert (T item)
void	Open ()
string	PrepareInsertSql (string sql)
virtual string	PrepareSql (string sql)
void	RemoveItem (T item)
abstract void	Update (T item)

Protected Attributes
override string	CreateSql
override string	TableName => "host"
override bool	UseCache => true
Protected Attributes inherited from Ntp.Analyzer.Data.Sql.SqlDatabaseMapper< Host >
IEnumerable< T >	Content
readonly object	MapperLocker
IDataReader	Reader

Package Functions
	HostDatabaseMapper (LogBase log)

Private Attributes
const string	InsertSql
const string	SelectSql
const string	UpdateSql

Additional Inherited Members
Public Member Functions inherited from Ntp.Analyzer.Data.Sql.SqlDatabaseMapper< Host >
void	CheckTable ()
override IEnumerator< T >	GetEnumerator ()
	Read all data from table in a sequential manner. More...
void	Save (T item)
Properties inherited from Ntp.Analyzer.Data.Sql.SqlDatabaseMapper< Host >
IDbCommand	Command [get, private set]
abstract string	CreateSql [get]
abstract string	TableName [get]
T	this[int id] [get]
abstract bool	UseCache [get]

Detailed Description

OR/M mapper for table host.

Definition at line 34 of file HostDatabaseMapper.cs.

Constructor & Destructor Documentation

Ntp.Analyzer.Data.Sql.HostDatabaseMapper.HostDatabaseMapper ( LogBase  log )

inlinepackage

Definition at line 36 of file HostDatabaseMapper.cs.

            : base(log)
        {
        }

Member Function Documentation

override void Ntp.Analyzer.Data.Sql.HostDatabaseMapper.Insert ( Host  item )

inlineprotected

Definition at line 62 of file HostDatabaseMapper.cs.

References e, Ntp.Analyzer.Objects.PersistentObject.Id, Ntp.Analyzer.Objects.Host.Ip, Ntp.Analyzer.Objects.NamedObject.Name, and Ntp.Analyzer.Objects.Host.OrgId.

        {
            lock (MapperLocker)
            {
                try
                {
                    Open();
                    Command.CommandText = PrepareInsertSql(InsertSql);
                    Command.Parameters.Add(CreateParameter("@id", item.Id));
                    Command.Parameters.Add(CreateParameter("@name", item.Name));
                    Command.Parameters.Add(CreateParameter("@ip", item.Ip));
                    Command.Parameters.Add(CreateParameter("@orgId", item.OrgId));
                    Command.Prepare();
                    Log.SqlExecute(Command.CommandText, Command.Parameters);
                    Command.ExecuteNonQuery();
                }
                catch (Exception e)
                {
                    Log.InsertError(TableName, e);
                }
                finally
                {
                    Close();
                }
            }
        }

override void Ntp.Analyzer.Data.Sql.HostDatabaseMapper.ReadContent ( )

inlineprotectedvirtual

Implements Ntp.Analyzer.Data.Sql.SqlDatabaseMapper< Host >.

Definition at line 90 of file HostDatabaseMapper.cs.

References e.

        {
            try
            {
                Open();
                Command.CommandText = PrepareSql(SelectSql);
                Log.SqlExecute(Command.CommandText);
                Reader = Command.ExecuteReader();

                while (Reader.Read())
                {
                    int id = Convert.ToInt32(Reader["id"]);
                    string name = Reader["name"].ToString();
                    string ip = Reader["ip"].ToString();
                    var orgId = Reader["orgId"] != DBNull.Value
                        ? Convert.ToInt32(Reader["orgId"])
                        : (int?) null;
                    var host = new Host(id, name, ip, orgId, false);
                    AddItem(host);
                }
            }
            catch (Exception e)
            {
                Log.ReadError(TableName, e);
            }
            finally
            {
                Close();
            }
        }

override void Ntp.Analyzer.Data.Sql.HostDatabaseMapper.Update ( Host  item )

inlineprotected

Definition at line 122 of file HostDatabaseMapper.cs.

References e, Ntp.Analyzer.Objects.PersistentObject.Id, Ntp.Analyzer.Objects.Host.Ip, Ntp.Analyzer.Objects.NamedObject.Name, and Ntp.Analyzer.Objects.Host.OrgId.

        {
            lock (MapperLocker)
            {
                try
                {
                    Open();
                    Command.CommandText = PrepareSql(UpdateSql);
                    Command.Parameters.Add(CreateParameter("@name", item.Name));
                    Command.Parameters.Add(CreateParameter("@ip", item.Ip));
                    Command.Parameters.Add(CreateParameter("@orgId", item.OrgId));
                    Command.Parameters.Add(CreateParameter("@id", item.Id));
                    Command.Prepare();
                    Log.SqlExecute(Command.CommandText, Command.Parameters);
                    Command.ExecuteScalar();
                }
                catch (Exception e)
                {
                    Log.UpdateError(TableName, e);
                }
                finally
                {
                    Close();
                }
            }
        }

Member Data Documentation

override string Ntp.Analyzer.Data.Sql.HostDatabaseMapper.CreateSql

protected

Initial value:

=> "CREATE TABLE host ( " +
                                               "    id INT NOT NULL PRIMARY KEY, " +
                                               "    name VARCHAR(255) NOT NULL, " +
                                               "    ip VARCHAR(45) NOT NULL, " +
                                               "    orgId INT " +
                                               "){1};"

Definition at line 54 of file HostDatabaseMapper.cs.

const string Ntp.Analyzer.Data.Sql.HostDatabaseMapper.InsertSql

private

Initial value:

=
            "INSERT INTO host( id, name, ip, orgId ) VALUES( @id, @name, @ip, @orgId );"

Definition at line 44 of file HostDatabaseMapper.cs.

const string Ntp.Analyzer.Data.Sql.HostDatabaseMapper.SelectSql

private

Initial value:

=
            "SELECT id, name, ip, orgId FROM host;"

Definition at line 41 of file HostDatabaseMapper.cs.

override string Ntp.Analyzer.Data.Sql.HostDatabaseMapper.TableName => "host"

protected

Definition at line 52 of file HostDatabaseMapper.cs.

const string Ntp.Analyzer.Data.Sql.HostDatabaseMapper.UpdateSql

private

Initial value:

=
            "UPDATE host SET name = @name, ip = @ip, orgId = @orgId WHERE id = @id"

Definition at line 47 of file HostDatabaseMapper.cs.

override bool Ntp.Analyzer.Data.Sql.HostDatabaseMapper.UseCache => true

protected

Definition at line 50 of file HostDatabaseMapper.cs.

---

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

• Ntp.Analyzer.Data/Sql/HostDatabaseMapper.cs