public void FromStringSimple()
{
string input = @"
6; 3; 5; 7
2; 4; 6; 9
1; 5; 7; 2
";
var expected = new List <List <double> >
{
new List <double> {
6, 3, 5, 7
},
new List <double> {
2, 4, 6, 9
},
new List <double> {
1, 5, 7, 2
}
};
var converter = new CsvToList();
var result = converter.FromString(input);
Assert.IsTrue(Compare(expected, result));
}
public async Task FromStreamSimple()
{
string input = @"
6; 3; 5; 7
2; 4; 6; 9
1; 5; 7; 2
";
var stream = new MemoryStream(Encoding.UTF8.GetBytes(input));
var expected = new List <List <double> >
{
new List <double> {
6, 3, 5, 7
},
new List <double> {
2, 4, 6, 9
},
new List <double> {
1, 5, 7, 2
}
};
var converter = new CsvToList();
var result = await converter.FromStreamAsync(stream);
Assert.IsTrue(Compare(expected, result));
}
public void UsingAnotherSeparatorSimple()
{
char separator = ',';
string input = @"
6, 3, 5, 7
2, 4, 6, 9
1, 5, 7, 2
";
var expected = new List <List <double> >
{
new List <double> {
6, 3, 5, 7
},
new List <double> {
2, 4, 6, 9
},
new List <double> {
1, 5, 7, 2
}
};
var converter = new CsvToList(separator);
var result = converter.FromString(input);
Assert.IsTrue(Compare(expected, result));
}
public void UsingBadSeparator()
{
string input = @"
6, 3, 5, 7
2, 4, 6, 9
1, 5, 7, 2
";
var expected = new List <List <double> >
{
new List <double> {
6, 3, 5, 7
},
new List <double> {
2, 4, 6, 9
},
new List <double> {
1, 5, 7, 2
}
};
var converter = new CsvToList();
var result = converter.FromString(input);
Assert.IsFalse(Compare(expected, result));
}
public async Task FromStreamLarge()
{
string input = @"
2.4; 45; 10; 201; 4.566; 102; 400.34; 70.2; 122; 6044
153; 56; 455; 22; 56.65; 1.2; 0.34; 890.2; 1345; 1222
3434; 2323; 454; 2.22; 46.5; 2.3; 2122; 7; 12.0; 1233
56.6; 1.02; 0.001; 2; 21; 1.2; 0.3; 0.03; 0.22; 3.141
4.3; 156; 5; 23; 5.65; 1.0; 0.034; 8922.2; 1345; 1332
2.4; 45; 10; 201; 4.566; 102; 400.34; 70.2; 122; 6044
56.6; 1.02; 0.001; 2; 21; 1.2; 0.3; 0.03; 0.22; 3.141
3434; 2323; 454; 2.22; 2.2; 1345; 1332; 7; 12.0; 0.22
";
var expected = new List <List <double> >
{
new List <double> {
2.4, 45, 10, 201, 4.566, 102, 400.34, 70.2, 122, 6044
},
new List <double> {
153, 56, 455, 22, 56.65, 1.2, 0.34, 890.2, 1345, 1222
},
new List <double> {
3434, 2323, 454, 2.22, 46.5, 2.3, 2122, 7, 12.0, 1233
},
new List <double> {
56.6, 1.02, 0.001, 2, 21, 1.2, 0.3, 0.03, 0.22, 3.141
},
new List <double> {
4.3, 156, 5, 23, 5.65, 1.0, 0.034, 8922.2, 1345, 1332
},
new List <double> {
2.4, 45, 10, 201, 4.566, 102, 400.34, 70.2, 122, 6044
},
new List <double> {
56.6, 1.02, 0.001, 2, 21, 1.2, 0.3, 0.03, 0.22, 3.141
},
new List <double> {
3434, 2323, 454, 2.22, 2.2, 1345, 1332, 7, 12.0, 0.22
}
};
var stream = new MemoryStream(Encoding.UTF8.GetBytes(input));
var converter = new CsvToList();
var result = await converter.FromStreamAsync(stream);
Assert.IsTrue(Compare(expected, result));
}
public void UsingAnotherSeparatorLarge()
{
char separator = ',';
string input = @"
2.4, 45, 10, 201, 4.566, 102, 400.34, 70.2, 122, 6044
153, 56, 455, 22, 56.65, 1.2, 0.34, 890.2, 1345, 1222
3434, 2323, 454, 2.22, 46.5, 2.3, 2122, 7, 12.0, 1233
56.6, 1.02, 0.001, 2, 21, 1.2, 0.3, 0.03, 0.22, 3.141
4.3, 156, 5, 23, 5.65, 1.0, 0.034, 8922.2, 1345, 1332
2.4, 45, 10, 201, 4.566, 102, 400.34, 70.2, 122, 6044
56.6, 1.02, 0.001, 2, 21, 1.2, 0.3, 0.03, 0.22, 3.141
3434, 2323, 454, 2.22, 2.2, 1345, 1332, 7, 12.0, 0.22
";
var expected = new List <List <double> >
{
new List <double> {
2.4, 45, 10, 201, 4.566, 102, 400.34, 70.2, 122, 6044
},
new List <double> {
153, 56, 455, 22, 56.65, 1.2, 0.34, 890.2, 1345, 1222
},
new List <double> {
3434, 2323, 454, 2.22, 46.5, 2.3, 2122, 7, 12.0, 1233
},
new List <double> {
56.6, 1.02, 0.001, 2, 21, 1.2, 0.3, 0.03, 0.22, 3.141
},
new List <double> {
4.3, 156, 5, 23, 5.65, 1.0, 0.034, 8922.2, 1345, 1332
},
new List <double> {
2.4, 45, 10, 201, 4.566, 102, 400.34, 70.2, 122, 6044
},
new List <double> {
56.6, 1.02, 0.001, 2, 21, 1.2, 0.3, 0.03, 0.22, 3.141
},
new List <double> {
3434, 2323, 454, 2.22, 2.2, 1345, 1332, 7, 12.0, 0.22
}
};
var converter = new CsvToList(separator);
var result = converter.FromString(input);
Assert.IsTrue(Compare(expected, result));
}
public void FromStringLarge()
{
string input = @"
2.4; 45; 10; 201; 4.566; 102; 400.34; 70.2; 122; 6044
153; 56; 455; 22; 56.65; 1.2; 0.34; 890.2; 1345; 4422
3434; 2323; 454; 2.22; 46.5; 2.3; 2122; 7; 12.0; 1233
56.6; 1.02; 0.001; 2; 21; 1.2; 0.3; 0.03; 0.22; 0.133
4.3; 156; 5; 23; 5.65; 1.0; 0.034; 8922.2; 1345; 1332
2.4; 45; 10; 201; 4.566; 102; 400.34; 70.2; 122; 2334
56.6; 1.02; 0.001; 2; 21; 1.2; 0.3; 0.03; 0.22; 3.141
3434; 2323; 454; 2.22; 2.2; 1345; 1332; 7; 12.0; 0.22
";
var expected = new List <List <double> >
{
new List <double> {
2.4, 45, 10, 201, 4.566, 102, 400.34, 70.2, 122, 6044
},
new List <double> {
153, 56, 455, 22, 56.65, 1.2, 0.34, 890.2, 1345, 4422
},
new List <double> {
3434, 2323, 454, 2.22, 46.5, 2.3, 2122, 7, 12.0, 1233
},
new List <double> {
56.6, 1.02, 0.001, 2, 21, 1.2, 0.3, 0.03, 0.22, 0.133
},
new List <double> {
4.3, 156, 5, 23, 5.65, 1.0, 0.034, 8922.2, 1345, 1332
},
new List <double> {
2.4, 45, 10, 201, 4.566, 102, 400.34, 70.2, 122, 2334
},
new List <double> {
56.6, 1.02, 0.001, 2, 21, 1.2, 0.3, 0.03, 0.22, 3.141
},
new List <double> {
3434, 2323, 454, 2.22, 2.2, 1345, 1332, 7, 12.0, 0.22
}
};
var converter = new CsvToList();
var result = converter.FromString(input);
Assert.IsTrue(Compare(expected, result));
}
/// <summary>
/// コンストラクタです。
/// 環境変数を設定します。
/// </summary>
public CsvToUserList(Entity.Configure EntityConfig)
{
CSS.Library.Timecard.Entity.Config.Properties props = new CSS.Library.Timecard.Entity.Config.Properties();
props.User = EntityConfig.User;
props.Password = EntityConfig.Password;
props.UriAdress = EntityConfig.UriAdress;
props.FolderName = EntityConfig.FolderName;
props.Domain = EntityConfig.Domain;
CsvToList csvList = new CsvToList();
SharedFile smbUserList = new SharedFile(props);
if (smbUserList.SmbExists("UserList.txt"))
{
_Users = csvList.Users(smbUserList.SmbReader("UserList.txt"));
}
}
