static void Main(string[] args)
{
string RootDirectory = @"C:\Users\mpound\Desktop\140215";
string ImageDirectory = RootDirectory;//RootDirectory.Remove(RootDirectory.LastIndexOf("\\"));
Dictionary <string, string> FileTagMap = new Dictionary <string, string>();
using (StreamReader strm = new StreamReader(RootDirectory + "\\mapped.txt"))
{
while (!strm.EndOfStream)
{
string line = strm.ReadLine();
string[] parts = line.Split(new char[] { '\t' }, StringSplitOptions.RemoveEmptyEntries);
string fullPath = ImageDirectory + "\\" + parts[0];
string cropPath = fullPath.Insert(fullPath.LastIndexOf("\\") + 1, "crop\\");
string tag = parts[1].Replace("\"", "");
FileTagMap.Add(fullPath, tag);
}
}
#region DB connect and test
byte[] key = Encoding.ASCII.GetBytes("ght29cj8f230f30d");
byte[] IV = Encoding.ASCII.GetBytes("a32fg32bnds2df90");
byte[] enc = new byte[] { 138, 208, 147, 69, 17, 213, 75, 13, 125, 185, 237, 113, 181, 64, 221, 16 };
ConnectionParams cp = new ConnectionParams()
{
Server = "ssbmb.nottingham.ac.uk",
Database = "arab_rootnav",
Port = "3306",
Source = ConnectionSource.MySQLDatabase,
Username = "******",
Password = "******"//DecryptStringFromBytes_Aes(enc, key, IV)
};
System.Console.Write("Connecting to database: ");
MySQLDatabaseManager manager = new MySQLDatabaseManager();
manager.Open(cp.ToMySQLConnectionString());
string imagesTableCheckString = "SELECT TABLE_NAME as name FROM information_schema.TABLES WHERE TABLE_SCHEMA = '" + manager.Connection.Database + "'";
MySqlCommand imagesTableCheckCommand = new MySqlCommand(imagesTableCheckString, manager.Connection as MySqlConnection);
bool confirmedImageDB = false;
using (MySqlDataReader Reader = imagesTableCheckCommand.ExecuteReader())
{
while (Reader.Read())
{
if (Reader["name"] as String == "images")
{
confirmedImageDB = true;
}
}
}
if (manager.IsOpen)
{
System.Console.WriteLine("Done");
}
else
{
System.Console.WriteLine("Could not connect");
}
if (!confirmedImageDB)
{
Console.WriteLine("Updating database to include image table");
string creationString = "CREATE TABLE IF NOT EXISTS images(" +
"Tag CHAR(64) NOT NULL, " +
"Stamp TIMESTAMP NOT NULL, " +
"Image LONGBLOB, " +
"CONSTRAINT pk_image_one PRIMARY KEY (Tag, Stamp) " +
") ENGINE=INNODB";
MySqlCommand creationCommand = new MySqlCommand(creationString, manager.Connection as MySqlConnection);
int success = creationCommand.ExecuteNonQuery();
}
#endregion
foreach (var kvp in FileTagMap)
{
string file = kvp.Key;
string tag = kvp.Value;
// if (file != @"I:\Michael\Savannah Rialto DH panel exps\RSDH08 (Marcus) HN vs LN\22\crop\10001.JPG") continue;
if (tag != "#N/A")
{
byte[] image = File.ReadAllBytes(file);
InjectImageIntoDB(tag, image, manager.Connection as MySqlConnection);
Console.WriteLine("Inserted " + tag);
}
}
//byte[] jpg = File.ReadAllBytes(@"C:\Users\mpound\Desktop\0002.jpg");
//string tag = "mp1,0002,test";
/******************************/
}