public static void Main(string[] args)
{
Console.WriteLine("Enter path of existing tree (empty if doesnt exist)");
string serializedPath = Console.ReadLine();
if (serializedPath != null && !serializedPath.Equals(""))
{
Tree = DecisionTree.DecisionTree.deserialize(serializedPath);
}
else
{
Console.Write("Password: "******"";
int keyCounter = 0;
ConsoleKeyInfo key;
do
{
key = Console.ReadKey(true);
// Ignore any key out of range.
if (((int)key.Key) >= 65 && ((int)key.Key <= 90))
{
// Append the character to the password.
// password.AppendChar(key.KeyChar);
password = password + key.KeyChar;
Console.Write("*");
keyCounter++;
}
if (key.Key == ConsoleKey.Backspace && keyCounter > 0)
{
Console.Write("\b \b");
password = password.Remove(password.Length - 1, 1);
keyCounter--;
}
// Exit if Enter key is pressed.
} while (key.Key != ConsoleKey.Enter);
Console.WriteLine();
Console.Write("Limit Dataset (-1 for no limit): ");
int limit = int.Parse(Console.ReadLine() ?? "100");
// sql connection string for db
var connStr = "Server=appleseed.keenant.com" +
";Database=appleseed" +
";User ID=johnny" +
";Password="******";SslMode=none";
Tree = CreateTree(connStr, limit);
Console.WriteLine("Enter path to save serialized file (empty to not save)\n" +
"NOTE: file extensions are not necessary");
serializedPath = Console.ReadLine();
if (serializedPath != null && !serializedPath.Equals(""))
{
Tree.serialize(serializedPath);
}
}
// web server host config
HostConfiguration hostConfig = new HostConfiguration();
hostConfig.UrlReservations.CreateAutomatically = true;
var hostAndPort = args.ElementAtOrDefault(0) ?? "localhost:1234";
Uri uri = new Uri("http://" + hostAndPort);
// start host
using (var host = new NancyHost(hostConfig, uri))
{
host.Start();
Console.WriteLine("Running on http://localhost:1234");
Console.ReadLine();
}
}
private static DecisionTree.DecisionTree CreateTree(string connStr, int limit)
{
MySqlConnection connection;
try
{
connection = new MySqlConnection(connStr);
connection.Open();
MySqlCommand cmd;
MySqlDataReader reader;
String listStr = null;
int maxId = -1;
{
cmd = new MySqlCommand();
cmd.Connection = connection;
cmd.CommandText = "SELECT MAX(id) FROM flights";
cmd.CommandTimeout = int.MaxValue;
cmd.Prepare();
reader = cmd.ExecuteReader();
while (reader.Read())
{
maxId = reader.GetInt32(0);
}
reader.Close();
}
if (limit > -1)
{
Random rand = new Random();
var listStrBuilder = new StringBuilder("(");
Console.WriteLine("Creating list string...");
for (int i = 0; i < limit; i++)
{
int id = rand.Next(maxId) + 1;
listStrBuilder.Append(id);
if (i != limit - 1)
{
listStrBuilder.Append(",");
}
}
listStrBuilder.Append(")");
listStr = listStrBuilder.ToString();
}
Console.WriteLine("Querying flights...");
cmd = new MySqlCommand();
cmd.Connection = connection;
cmd.CommandText = "SELECT * FROM flights";
if (listStr != null)
{
cmd.CommandText += " WHERE ID in " + listStr;
}
cmd.CommandTimeout = int.MaxValue;
cmd.Prepare();
Stopwatch watch = new Stopwatch();
watch.Start();
List <Example> trainingSet = new List <Example>();
Console.WriteLine("Retrieving data set...");
reader = cmd.ExecuteReader();
while (reader.Read())
{
var delay = reader.GetInt32("DEPARTURE_DELAY");
// it is considered delayed if it leaves more than 5 mins
// after scheduled departure time
var isDelayed = delay > 5;
// construct the example with the classification as
// "true" or "false" depending on if it was delayed
var example = new Example(isDelayed + "");
// fetch attributes
var month = reader.GetInt32("MONTH");
var day = reader.GetInt32("DAY");
var dayOfWeek = reader.GetInt32("DAY_OF_WEEK");
var airline = reader.GetString("AIRLINE");
var airport = reader.GetString("ORIGIN_AIRPORT");
// add attributes
example.AddAttribute(Attrs.Month, month);
example.AddAttribute(Attrs.Day, day);
example.AddAttribute(Attrs.DayOfWeek, dayOfWeek);
example.AddAttribute(Attrs.Airline, airline);
example.AddAttribute(Attrs.Airport, airport);
trainingSet.Add(example);
}
//
// Console.WriteLine("Selecting " + limit + " random entries from data set...");
// Random rand = new Random();
//
// var filteredSet = new List<Example>();
//
// while (filteredSet.Count < limit)
// {
// int index = rand.Next(trainingSet.Count);
// filteredSet.Add(trainingSet[index]);
// trainingSet.RemoveAt(index);
// }
//
// // discard the data
// trainingSet.Clear();
Console.WriteLine("Building decision tree...");
var tree = new DecisionTree.DecisionTree();
tree.BuildTree(trainingSet);
Console.WriteLine("Done.");
Console.Write("Elapsed Time (ms): ");
Console.WriteLine(watch.ElapsedMilliseconds);
return(tree);
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
return(null);
}
}
