public FFTblSettings(ISQLiteDataManager dataManager, string tableName)
: base(dataManager, tableName)
{
_ddlScript = "CREATE TABLE [" + tableName + "] (" +
" SettingName VARCHAR( 255 ), SettingValue VARCHAR( 255 )" +
");";
QUERY_INSERT_RECORD = "INSERT INTO " + _name + "(SettingName, SettingValue) " +
"SELECT @SettingName, @SettingValue " +
"WHERE NOT EXISTS (SELECT 1 FROM " + tableName +
" WHERE SettingName = @SettingName)";
QUERY_GET_ALLRECORDS = "SELECT * FROM VW_" + tableName + "_GetAllRecords";
QUERY_UPDATE_VALUE = "UPDATE " + tableName + " SET SettingValue = @SettingValue WHERE ROWID = @ROWID";
QUERY_UPDATE_RECORD = "UPDATE " + tableName + " SET SettingName = @SettingName, " +
"SettingValue = @SettingValue " +
" WHERE ROWID = @ROWID";
QUERY_DELETE_RECORD = "DELETE FROM " + tableName + " WHERE ROWID = @ROWID";
this.Indexes.Add(
new SQLiteDbIndex(this.DataManager, "IDX_" + tableName + "_SettingName",
"CREATE INDEX [IDX_" + tableName + "_SettingName] ON [" + tableName + "] ([SettingName] ASC)")
);
this.Views.Add(
new SQLiteDbView(this.DataManager, "VW_" + tableName + "_GetAllRecords",
"CREATE VIEW [VW_" + tableName + "_GetAllRecords] AS" +
" SELECT A.RowId, " +
" A.SettingName, " +
" A.SettingValue " +
" FROM " + tableName + " A " +
" ORDER BY " +
" A.RowId")
);
}
public FFTblSettings(ISQLiteDataManager dataManager, string tableName)
: base(dataManager, tableName)
{
_ddlScript = "CREATE TABLE [" + tableName + "] (" +
" SettingName VARCHAR( 255 ), SettingValue VARCHAR( 255 )" +
");";
QUERY_INSERT_RECORD = "INSERT INTO " + _name + "(SettingName, SettingValue) " +
"SELECT @SettingName, @SettingValue " +
"WHERE NOT EXISTS (SELECT 1 FROM " + tableName +
" WHERE SettingName = @SettingName)";
QUERY_GET_ALLRECORDS = "SELECT * FROM VW_" + tableName + "_GetAllRecords";
QUERY_UPDATE_VALUE = "UPDATE " + tableName + " SET SettingValue = @SettingValue WHERE ROWID = @ROWID";
QUERY_UPDATE_RECORD = "UPDATE " + tableName + " SET SettingName = @SettingName, " +
"SettingValue = @SettingValue " +
" WHERE ROWID = @ROWID";
QUERY_DELETE_RECORD = "DELETE FROM " + tableName + " WHERE ROWID = @ROWID";
this.Indexes.Add(
new SQLiteDbIndex(this.DataManager, "IDX_" + tableName + "_SettingName",
"CREATE INDEX [IDX_" + tableName + "_SettingName] ON [" + tableName + "] ([SettingName] ASC)")
);
this.Views.Add(
new SQLiteDbView(this.DataManager, "VW_" + tableName + "_GetAllRecords",
"CREATE VIEW [VW_" + tableName + "_GetAllRecords] AS" +
" SELECT A.RowId, " +
" A.SettingName, " +
" A.SettingValue " +
" FROM " + tableName + " A " +
" ORDER BY " +
" A.RowId")
);
}
public FFTblGIMInformation(ISQLiteDataManager dataManager, string tableName)
: base(dataManager, tableName)
{
_ddlScript = "CREATE TABLE [" + tableName + "] (" +
" HashCode INT NOT NULL, " +
" IPAddress VARCHAR( 20 ), AssetNo VARCHAR( 50 )," +
" GmuNo VARCHAR( 50 ), SerialNo VARCHAR( 50 )," +
" ManufacturerID VARCHAR( 50 ), MACAddress VARCHAR( 50 )," +
" GmuVersion VARCHAR( 100 ), SASVersion VARCHAR( 50 ) " +
");";
QUERY_INSERT_RECORD = "INSERT INTO " + _name + "(HashCode, IPAddress, AssetNo, GmuNo, SerialNo, ManufacturerID, MACAddress, GmuVersion, SASVersion) " +
"VALUES(@HashCode, @IPAddress, @AssetNo, @GmuNo, @SerialNo, @ManufacturerID, @MACAddress, @GmuVersion, @SASVersion)";
QUERY_GET_ALLRECORDS = "SELECT * FROM VW_" + tableName + "_GetAllRecords";
QUERY_UPDATE_IPADDR = "UPDATE " + tableName + " SET IPAddress = @IPAddress WHERE ROWID = @ROWID";
QUERY_UPDATE_RECORD = "UPDATE " + tableName + " SET IPAddress = @IPAddress, " +
"AssetNo = @AssetNo, " +
"GmuNo = @GmuNo, " +
"SerialNo = @SerialNo, " +
"ManufacturerID = @ManufacturerID, " +
"MACAddress = @MACAddress, " +
"GmuVersion = @GmuVersion, " +
"SASVersion = @SASVersion " +
" WHERE ROWID = @ROWID";
QUERY_DELETE_RECORD = "DELETE FROM " + tableName + " WHERE ROWID = @ROWID";
this.Indexes.Add(
new SQLiteDbIndex(this.DataManager, "IDX_" + tableName + "_HashCode",
"CREATE INDEX [IDX_" + tableName + "_HashCode] ON [" + tableName + "] ([HashCode] ASC)")
);
this.Indexes.Add(
new SQLiteDbIndex(this.DataManager, "IDX_" + tableName + "_IPAddress",
"CREATE INDEX [IDX_" + tableName + "_IPAddress] ON [" + tableName + "] ([IPAddress] ASC)")
);
this.Views.Add(
new SQLiteDbView(this.DataManager, "VW_" + tableName + "_GetAllRecords",
"CREATE VIEW [VW_" + tableName + "_GetAllRecords] AS" +
" SELECT A.RowId, " +
" A.HashCode, " +
" A.IPAddress, " +
" A.AssetNo, " +
" A.GmuNo, " +
" A.SerialNo, " +
" A.ManufacturerID, " +
" A.MACAddress, " +
" A.GmuVersion, " +
" A.SASVersion" +
" FROM " + tableName + " A " +
" ORDER BY " +
" A.RowId")
);
}
public FFTblGIMInformation(ISQLiteDataManager dataManager, string tableName)
: base(dataManager, tableName)
{
_ddlScript = "CREATE TABLE [" + tableName + "] (" +
" HashCode INT NOT NULL, " +
" IPAddress VARCHAR( 20 ), AssetNo VARCHAR( 50 )," +
" GmuNo VARCHAR( 50 ), SerialNo VARCHAR( 50 )," +
" ManufacturerID VARCHAR( 50 ), MACAddress VARCHAR( 50 )," +
" GmuVersion VARCHAR( 100 ), SASVersion VARCHAR( 50 ) " +
");";
QUERY_INSERT_RECORD = "INSERT INTO " + _name + "(HashCode, IPAddress, AssetNo, GmuNo, SerialNo, ManufacturerID, MACAddress, GmuVersion, SASVersion) " +
"VALUES(@HashCode, @IPAddress, @AssetNo, @GmuNo, @SerialNo, @ManufacturerID, @MACAddress, @GmuVersion, @SASVersion)";
QUERY_GET_ALLRECORDS = "SELECT * FROM VW_" + tableName + "_GetAllRecords";
QUERY_UPDATE_IPADDR = "UPDATE " + tableName + " SET IPAddress = @IPAddress WHERE ROWID = @ROWID";
QUERY_UPDATE_RECORD = "UPDATE " + tableName + " SET IPAddress = @IPAddress, " +
"AssetNo = @AssetNo, " +
"GmuNo = @GmuNo, " +
"SerialNo = @SerialNo, " +
"ManufacturerID = @ManufacturerID, " +
"MACAddress = @MACAddress, " +
"GmuVersion = @GmuVersion, " +
"SASVersion = @SASVersion " +
" WHERE ROWID = @ROWID";
QUERY_DELETE_RECORD = "DELETE FROM " + tableName + " WHERE ROWID = @ROWID";
this.Indexes.Add(
new SQLiteDbIndex(this.DataManager, "IDX_" + tableName + "_HashCode",
"CREATE INDEX [IDX_" + tableName + "_HashCode] ON [" + tableName + "] ([HashCode] ASC)")
);
this.Indexes.Add(
new SQLiteDbIndex(this.DataManager, "IDX_" + tableName + "_IPAddress",
"CREATE INDEX [IDX_" + tableName + "_IPAddress] ON [" + tableName + "] ([IPAddress] ASC)")
);
this.Views.Add(
new SQLiteDbView(this.DataManager, "VW_" + tableName + "_GetAllRecords",
"CREATE VIEW [VW_" + tableName + "_GetAllRecords] AS" +
" SELECT A.RowId, " +
" A.HashCode, " +
" A.IPAddress, " +
" A.AssetNo, " +
" A.GmuNo, " +
" A.SerialNo, " +
" A.ManufacturerID, " +
" A.MACAddress, " +
" A.GmuVersion, " +
" A.SASVersion" +
" FROM " + tableName + " A " +
" ORDER BY " +
" A.RowId")
);
}
public FFTblCardInformation(ISQLiteDataManager dataManager, string tableName)
: base(dataManager, tableName)
{
_ddlScript = "CREATE TABLE [" + tableName + "] (" +
" HashCode INT NOT NULL, " +
" CardNo VARCHAR( 50 ), " +
" CardType INTEGER, " +
" GmuRowID INTEGER" +
");";
QUERY_INSERT_RECORD = "INSERT INTO " + _name + "(HashCode, CardNo, CardType, GmuRowID) " +
"VALUES(@HashCode, @CardNo, @CardType, @GmuRowID)";
QUERY_GET_ALLRECORDS = "SELECT * FROM VW_" + tableName + "_GetAllRecords";
QUERY_GET_PLAYERCARDRECORDS = "SELECT * FROM VW_" + tableName + "_GetPlayerRecords";
QUERY_GET_EMPLOYEECARDRECORDS = "SELECT * FROM VW_" + tableName + "_GetEmployeeRecords";
QUERY_UPDATE_IPADDR = "UPDATE " + tableName + " SET CardNo = @CardNo WHERE ROWID = @ROWID";
QUERY_UPDATE_RECORD = "UPDATE " + tableName + " SET CardNo = @CardNo, " +
"CardType = @CardType, " +
"GmuRowID = @GmuRowID, " +
" WHERE ROWID = @ROWID";
QUERY_DELETE_RECORD = "DELETE FROM " + tableName + " WHERE ROWID = @ROWID";
this.Indexes.Add(
new SQLiteDbIndex(this.DataManager, "IDX_" + tableName + "_HashCode",
"CREATE INDEX [IDX_" + tableName + "_HashCode] ON [" + tableName + "] ([HashCode] ASC)")
);
this.Indexes.Add(
new SQLiteDbIndex(this.DataManager, "IDX_" + tableName + "_CardNo",
"CREATE INDEX [IDX_" + tableName + "_CardNo] ON [" + tableName + "] ([CardNo] ASC)")
);
this.Views.Add(
new SQLiteDbView(this.DataManager, "VW_" + tableName + "_GetAllRecords",
this.PrepareSelectQuery("_GetAllRecords", string.Empty))
);
this.Views.Add(
new SQLiteDbView(this.DataManager, "VW_" + tableName + "_GetPlayerRecords",
this.PrepareSelectQuery("_GetPlayerRecords", " WHERE A.CardType = 0"))
);
this.Views.Add(
new SQLiteDbView(this.DataManager, "VW_" + tableName + "_GetEmployeeRecords",
this.PrepareSelectQuery("_GetEmployeeRecords", " WHERE A.CardType = 1"))
);
}
public FFTblCardInformation(ISQLiteDataManager dataManager, string tableName)
: base(dataManager, tableName)
{
_ddlScript = "CREATE TABLE [" + tableName + "] (" +
" HashCode INT NOT NULL, " +
" CardNo VARCHAR( 50 ), " +
" CardType INTEGER, " +
" GmuRowID INTEGER" +
");";
QUERY_INSERT_RECORD = "INSERT INTO " + _name + "(HashCode, CardNo, CardType, GmuRowID) " +
"VALUES(@HashCode, @CardNo, @CardType, @GmuRowID)";
QUERY_GET_ALLRECORDS = "SELECT * FROM VW_" + tableName + "_GetAllRecords";
QUERY_GET_PLAYERCARDRECORDS = "SELECT * FROM VW_" + tableName + "_GetPlayerRecords";
QUERY_GET_EMPLOYEECARDRECORDS = "SELECT * FROM VW_" + tableName + "_GetEmployeeRecords";
QUERY_UPDATE_IPADDR = "UPDATE " + tableName + " SET CardNo = @CardNo WHERE ROWID = @ROWID";
QUERY_UPDATE_RECORD = "UPDATE " + tableName + " SET CardNo = @CardNo, " +
"CardType = @CardType, " +
"GmuRowID = @GmuRowID, " +
" WHERE ROWID = @ROWID";
QUERY_DELETE_RECORD = "DELETE FROM " + tableName + " WHERE ROWID = @ROWID";
this.Indexes.Add(
new SQLiteDbIndex(this.DataManager, "IDX_" + tableName + "_HashCode",
"CREATE INDEX [IDX_" + tableName + "_HashCode] ON [" + tableName + "] ([HashCode] ASC)")
);
this.Indexes.Add(
new SQLiteDbIndex(this.DataManager, "IDX_" + tableName + "_CardNo",
"CREATE INDEX [IDX_" + tableName + "_CardNo] ON [" + tableName + "] ([CardNo] ASC)")
);
this.Views.Add(
new SQLiteDbView(this.DataManager, "VW_" + tableName + "_GetAllRecords",
this.PrepareSelectQuery("_GetAllRecords", string.Empty))
);
this.Views.Add(
new SQLiteDbView(this.DataManager, "VW_" + tableName + "_GetPlayerRecords",
this.PrepareSelectQuery("_GetPlayerRecords", " WHERE A.CardType = 0"))
);
this.Views.Add(
new SQLiteDbView(this.DataManager, "VW_" + tableName + "_GetEmployeeRecords",
this.PrepareSelectQuery("_GetEmployeeRecords", " WHERE A.CardType = 1"))
);
}
/// <summary>
/// Initializes a new instance of the <see cref="SQLiteDbView"/> class.
/// </summary>
/// <param name="dataManager">The data manager.</param>
/// <param name="name">The name.</param>
public SQLiteDbView(ISQLiteDataManager dataManager, string name)
: base(dataManager, name) { }
/// <summary>
/// Initializes a new instance of the <see cref="SQLiteDbView"/> class.
/// </summary>
/// <param name="dataManager">The data manager.</param>
public SQLiteDbView(ISQLiteDataManager dataManager)
: base(dataManager) { }
/// <summary>
/// Initializes a new instance of the <see cref="SQLiteDbIndex"/> class.
/// </summary>
/// <param name="dataManager">The data manager.</param>
/// <param name="name">The name.</param>
public SQLiteDbIndex(ISQLiteDataManager dataManager, string name)
: base(dataManager, name) { }
/// <summary>
/// Initializes a new instance of the <see cref="SQLiteDbIndex"/> class.
/// </summary>
/// <param name="dataManager">The data manager.</param>
public SQLiteDbIndex(ISQLiteDataManager dataManager)
: base(dataManager) { }
/// <summary>
/// Initializes a new instance of the <see cref="SQLiteDbTable"/> class.
/// </summary>
/// <param name="dataManager">The data manager.</param>
/// <param name="name">The name.</param>
/// <param name="ddlScript">The DDL script.</param>
public SQLiteDbTable(ISQLiteDataManager dataManager, string name, string ddlScript)
: base(dataManager, name, ddlScript) { this.Initialize(); }
/// <summary>
/// Initializes a new instance of the <see cref="SQLiteDbTable"/> class.
/// </summary>
/// <param name="dataManager">The data manager.</param>
/// <param name="name">The name.</param>
/// <param name="ddlScript">The DDL script.</param>
public SQLiteDbTable(ISQLiteDataManager dataManager, string name, string ddlScript)
: base(dataManager, name, ddlScript)
{
this.Initialize();
}
/// <summary>
/// Initializes a new instance of the <see cref="SQLiteDbObjectBase"/> class.
/// </summary>
/// <param name="dataManager">The data manager.</param>
/// <param name="name">The name.</param>
public SQLiteDbObjectBase(ISQLiteDataManager dataManager, string name)
: this(dataManager)
{
_name = name;
}
/// <summary>
/// Initializes a new instance of the <see cref="SQLiteDbObjectBase"/> class.
/// </summary>
/// <param name="dataManager">The data manager.</param>
public SQLiteDbObjectBase(ISQLiteDataManager dataManager)
{
this.DataManager = dataManager;
}
/// <summary>
/// Initializes a new instance of the <see cref="SQLiteDbView"/> class.
/// </summary>
/// <param name="dataManager">The data manager.</param>
/// <param name="name">The name.</param>
/// <param name="ddlScript">The DDL script.</param>
public SQLiteDbView(ISQLiteDataManager dataManager, string name, string ddlScript)
: base(dataManager, name, ddlScript) { }
/// <summary>
/// Initializes a new instance of the <see cref="SQLiteDbView"/> class.
/// </summary>
/// <param name="dataManager">The data manager.</param>
/// <param name="name">The name.</param>
/// <param name="ddlScript">The DDL script.</param>
public SQLiteDbView(ISQLiteDataManager dataManager, string name, string ddlScript)
: base(dataManager, name, ddlScript)
{
}
/// <summary>
/// Initializes a new instance of the <see cref="SQLiteDbView"/> class.
/// </summary>
/// <param name="dataManager">The data manager.</param>
/// <param name="name">The name.</param>
public SQLiteDbView(ISQLiteDataManager dataManager, string name)
: base(dataManager, name)
{
}
/// <summary>
/// Initializes a new instance of the <see cref="SQLiteDbView"/> class.
/// </summary>
/// <param name="dataManager">The data manager.</param>
public SQLiteDbView(ISQLiteDataManager dataManager)
: base(dataManager)
{
}
/// <summary>
/// Initializes a new instance of the <see cref="SQLiteDbIndex"/> class.
/// </summary>
/// <param name="dataManager">The data manager.</param>
/// <param name="name">The name.</param>
public SQLiteDbIndex(ISQLiteDataManager dataManager, string name)
: base(dataManager, name)
{
}
/// <summary>
/// Initializes a new instance of the <see cref="SQLiteDbIndex"/> class.
/// </summary>
/// <param name="dataManager">The data manager.</param>
public SQLiteDbIndex(ISQLiteDataManager dataManager)
: base(dataManager)
{
}
/// <summary>
/// Initializes a new instance of the <see cref="SQLiteDbObjectBase"/> class.
/// </summary>
/// <param name="dataManager">The data manager.</param>
public SQLiteDbObjectBase(ISQLiteDataManager dataManager)
{
this.DataManager = dataManager;
}
/// <summary>
/// Initializes a new instance of the <see cref="SQLiteDbObjectBase"/> class.
/// </summary>
/// <param name="dataManager">The data manager.</param>
/// <param name="name">The name.</param>
/// <param name="ddlScript">The DDL script.</param>
public SQLiteDbObjectBase(ISQLiteDataManager dataManager, string name, string ddlScript)
: this(dataManager)
{
_name = name;
_ddlScript = ddlScript;
}
/// <summary>
/// Initializes a new instance of the <see cref="SQLiteDbTable"/> class.
/// </summary>
/// <param name="dataManager">The data manager.</param>
public SQLiteDbTable(ISQLiteDataManager dataManager)
: base(dataManager)
{
this.Initialize();
}
/// <summary>
/// Initializes a new instance of the <see cref="SQLiteDbObjectBase"/> class.
/// </summary>
/// <param name="dataManager">The data manager.</param>
/// <param name="name">The name.</param>
/// <param name="ddlScript">The DDL script.</param>
public SQLiteDbObjectBase(ISQLiteDataManager dataManager, string name, string ddlScript)
: this(dataManager)
{
_name = name;
_ddlScript = ddlScript;
}
/// <summary>
/// Initializes a new instance of the <see cref="SQLiteDbTable"/> class.
/// </summary>
/// <param name="dataManager">The data manager.</param>
public SQLiteDbTable(ISQLiteDataManager dataManager)
: base(dataManager) { this.Initialize(); }
/// <summary>
/// Initializes a new instance of the <see cref="SQLiteDbTable"/> class.
/// </summary>
/// <param name="dataManager">The data manager.</param>
/// <param name="name">The name.</param>
public SQLiteDbTable(ISQLiteDataManager dataManager, string name)
: base(dataManager, name)
{
this.Initialize();
}
/// <summary>
/// Initializes a new instance of the <see cref="SQLiteDbTable"/> class.
/// </summary>
/// <param name="dataManager">The data manager.</param>
/// <param name="name">The name.</param>
public SQLiteDbTable(ISQLiteDataManager dataManager, string name)
: base(dataManager, name) { this.Initialize(); }
/// <summary>
/// Initializes a new instance of the <see cref="SQLiteDbObjectBase"/> class.
/// </summary>
/// <param name="dataManager">The data manager.</param>
/// <param name="name">The name.</param>
public SQLiteDbObjectBase(ISQLiteDataManager dataManager, string name)
: this(dataManager)
{
_name = name;
}
