public SQLHandlerBase()
{
if (_connectionString == null || _connectionString.Length == 0)
{
_connectionString = CommandlineParameters.Value("database", "");
if (_connectionString?.Length < 1)
{
var conxStrings = System.Configuration.ConfigurationManager.ConnectionStrings;
_connectionString = conxStrings["database"].ConnectionString;
}
}
if (_schema == null || _schema.Length == 0 ||
_tableprefix == null || _tableprefix.Length == 0)
{
_schema = CommandlineParameters.Value("schema", "dbo").Trim();
_tableprefix = CommandlineParameters.Value("TablePrefix", "CIM_").Trim();
if (_schema?.Length < 1)
{
var settings = System.Configuration.ConfigurationManager.AppSettings;
//_connectionString = settings["database"].Trim();
_schema = settings["schema"].Trim();
}
if (_tableprefix?.Length < 1)
{
var settings = System.Configuration.ConfigurationManager.AppSettings;
_tableprefix = settings["TablePrefix"].Trim();
}
}
}
static void Main(string[] args)
{
var settings = new Properties.Settings();
var connectionString = settings.database;
var schema = settings.schema;
var tablePrefix = settings.TablePrefix;
//string inputfolder = "";
const string baseMask = "*_*.Json.gz";
string mask = baseMask;
CommandlineParameters.Set(args); //, new Properties.Settings());
CommandlineParameters.Set("database", connectionString);
CommandlineParameters.Set("schema", schema);
CommandlineParameters.Set("TablePrefix", tablePrefix);
foreach (var arg in args)
{
//if (arg.StartsWith("-f",StringComparison.InvariantCultureIgnoreCase))
//{
// inputfolder = arg.Remove(0, 2);
//}
if (arg.StartsWith("-m", StringComparison.InvariantCultureIgnoreCase))
{
mask = arg.Remove(0, 2);
if (mask.Length == 0)
{
mask = baseMask;
}
}
}
Console.WriteLine($"[{connectionString}].[{schema}].[{tablePrefix}...]");
//Console.WriteLine($"[{}]");
var f = new FindFiles(); // { SqlConnectionString = connectionString };
f.AllJson(CommandlineParameters._fileSaveFolder, mask, schema, tablePrefix);
//StringCompressDecompress();
}
