diff options
author | vnugent <public@vaughnnugent.com> | 2023-01-09 15:09:13 -0500 |
---|---|---|
committer | vnugent <public@vaughnnugent.com> | 2023-01-09 15:09:13 -0500 |
commit | a46c3bf452d287b50b2e7dd5a24f5995c9fd26f6 (patch) | |
tree | 3a978b2dd2887b5c0e25f595516594a647d8e880 /lib/VNLib.Plugins.Extensions.Data/src/SQL/TableManager.cs | |
parent | 189c6714057bf45553847eaeb9ce97eb7272eb8c (diff) |
Restructure
Diffstat (limited to 'lib/VNLib.Plugins.Extensions.Data/src/SQL/TableManager.cs')
-rw-r--r-- | lib/VNLib.Plugins.Extensions.Data/src/SQL/TableManager.cs | 66 |
1 files changed, 66 insertions, 0 deletions
diff --git a/lib/VNLib.Plugins.Extensions.Data/src/SQL/TableManager.cs b/lib/VNLib.Plugins.Extensions.Data/src/SQL/TableManager.cs new file mode 100644 index 0000000..a7f7873 --- /dev/null +++ b/lib/VNLib.Plugins.Extensions.Data/src/SQL/TableManager.cs @@ -0,0 +1,66 @@ +/* +* Copyright (c) 2022 Vaughn Nugent +* +* Library: VNLib +* Package: VNLib.Plugins.Extensions.Data +* File: TableManager.cs +* +* TableManager.cs is part of VNLib.Plugins.Extensions.Data which is part of the larger +* VNLib collection of libraries and utilities. +* +* VNLib.Plugins.Extensions.Data is free software: you can redistribute it and/or modify +* it under the terms of the GNU General Public License as published +* by the Free Software Foundation, either version 2 of the License, +* or (at your option) any later version. +* +* VNLib.Plugins.Extensions.Data is distributed in the hope that it will be useful, +* but WITHOUT ANY WARRANTY; without even the implied warranty of +* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU +* General Public License for more details. +* +* You should have received a copy of the GNU General Public License +* along with VNLib.Plugins.Extensions.Data. If not, see http://www.gnu.org/licenses/. +*/ + +using System; +using System.Data.Common; + +namespace VNLib.Plugins.Extensions.Data.SQL +{ + /// <summary> + /// A class that contains basic structures for interacting with an SQL driven database + /// </summary> + public abstract class TableManager + { + private readonly Func<DbConnection> Factory; + protected string Insert { get; set; } + protected string Select { get; set; } + protected string Update { get; set; } + protected string Delete { get; set; } + + /// <summary> + /// The name of the table specified during initialized + /// </summary> + protected string TableName { get; } + + protected TableManager(Func<DbConnection> factory, string tableName) + { + this.Factory = factory ?? throw new ArgumentNullException(nameof(factory)); + this.TableName = !string.IsNullOrWhiteSpace(tableName) ? tableName : throw new ArgumentNullException(nameof(tableName)); + } + + protected TableManager(Func<DbConnection> factory) + { + this.Factory = factory ?? throw new ArgumentNullException(nameof(factory)); + this.TableName = ""; + } + /// <summary> + /// Opens a new <see cref="DbConnection"/> by invoking the factory callback method + /// </summary> + /// <returns>The open connection</returns> + protected DbConnection GetConnection() + { + return Factory(); + } + } +} |