public ZNxtUserRDBService(IRDBService rdBService, IUserNotifierService userNotifierService, ILogger logger, IApiGatewayService apiGatewayService, ITenantSetterService tenantSetterService, IInMemoryCacheService inMemoryCacheService) : base(
userNotifierService, logger, apiGatewayService, tenantSetterService
)
{
_rdBService = rdBService;
_inMemoryCacheService = inMemoryCacheService;
}
public static string GetInsertSQLWithParam(this IRDBService dbService, JObject data, string table)
{
StringBuilder sb = new StringBuilder();
sb.Append($"INSERT INTO {table}");
var columns = new List <string>();
var values = new List <string>();
foreach (var item in data)
{
columns.Add(item.Key);
if (item.Value.Type == JTokenType.Integer || item.Value.Type == JTokenType.Boolean)
{
values.Add(item.Value.ToString().ToLower());
}
else
{
values.Add($"'{item.Value.ToString()}'");
}
}
sb.Append($"([{string.Join("],[", columns) }])");
sb.Append($" values ({string.Join(",", values) })");
return(sb.ToString());
}
public ZNxtUserServiceBaseUnitTest()
{
Environment.SetEnvironmentVariable("NPGSQLConnectionString", "Host=103.212.120.XXX;Username=root;Password=root;Database=identity;");
_rDBService = new SqlRDBService(new HttpProxyMock());
_zNxtUserService = new ZNxtUserRDBService(_rDBService, new MockUserNotifierService(), new MockLogger(), new MockApiGatewayService(), new MockTenantSetterService(), new MockinMemoryCacheService());
}
public PingController(IHttpContextProxy httpContextProxy,
IDBService dBService,
IRDBService rDBService,
ILogger logger, IResponseBuilder responseBuilder)
: base(httpContextProxy, dBService, logger, responseBuilder)
{
_logger = logger;
_responseBuilder = responseBuilder;
}
public ClientController(IResponseBuilder responseBuilder, ILogger logger, IHttpContextProxy httpContextProxy, IDBService dBService, IRDBService rDBService, IZNxtUserService zNxtUserService)
: base(httpContextProxy, dBService, logger, responseBuilder)
{
_responseBuilder = responseBuilder;
_httpContextProxy = httpContextProxy;
_logger = logger;
_rDBService = rDBService;
_zNxtUserService = zNxtUserService;
}
public IdentityCURD()
{
Environment.SetEnvironmentVariable("NPGSQLConnectionString", "Host=103.212.120.XXX;Username=root;Password=root;Database=identity;");
_rDBService = new SqlRDBService(new HttpProxyMock());
}
public GetDataUnitTest()
{
Environment.SetEnvironmentVariable("MSSQLConnectionString", "Server=.\\SQLEXPRESS;Database=TEST;Trusted_Connection=True;");
_rDBService = new SqlRDBService(new HttpProxyMock());
}
public InsertDataPGDBUnitTest()
{
Environment.SetEnvironmentVariable("NPGSQLConnectionString", "Host=103.212.120.XXX;Username=root;Password=root;Database=mvp_tenant_mgt");
_rDBService = new SqlRDBService(new HttpProxyMock());
}
