2025-03-07 21:05:03 +01:00
|
|
|
|
using System.Collections.Generic;
|
|
|
|
|
|
|
|
|
|
namespace ProgrammList.sql {
|
2025-03-03 22:16:47 +01:00
|
|
|
|
|
2025-03-05 23:12:50 +01:00
|
|
|
|
interface SqlBase {
|
2025-03-03 22:16:47 +01:00
|
|
|
|
|
|
|
|
|
|
2025-03-07 21:05:03 +01:00
|
|
|
|
bool GetSingleLine(string pcid, string program, string version);
|
|
|
|
|
|
|
|
|
|
void CheckTableExists();
|
|
|
|
|
|
2025-03-03 22:16:47 +01:00
|
|
|
|
|
|
|
|
|
|
2025-03-07 21:05:03 +01:00
|
|
|
|
void InsertData(Dictionary<string, string> valuesqlCommand);
|
2025-03-03 22:16:47 +01:00
|
|
|
|
|
|
|
|
|
|
2025-03-07 21:05:03 +01:00
|
|
|
|
void InsertOrUpdateData(Dictionary<string, string> value);
|
2025-03-03 22:16:47 +01:00
|
|
|
|
|
2025-03-07 21:05:03 +01:00
|
|
|
|
void DeleteOldData(string hostname);
|
|
|
|
|
void UpdateData(Dictionary<string, string> value);
|
2025-03-03 22:16:47 +01:00
|
|
|
|
|
|
|
|
|
|
|
|
|
|
}
|
2025-03-05 23:12:50 +01:00
|
|
|
|
|
2025-03-03 22:16:47 +01:00
|
|
|
|
}
|