public void listSql_not_a_test() { _dir = new dir(constantinople.XML_FILEPATH); var x = _dir.listSql(); }
static void Main(string[] args) { server _server = new server(constantinople.XML_FILEPATH); dir _dir = new dir(constantinople.XML_FILEPATH); if (args == null || args.Length == 0) { return; } switch (args[0]) { case "help": runHelp(); break; case "servername": Console.WriteLine(_server.Name); setter(args, () => new server(constantinople.XML_FILEPATH, args[2], string.Empty)); break; case "db": Console.WriteLine(_server.Db); setter(args, () => new server(constantinople.XML_FILEPATH, string.Empty, args[2])); break; case "cs": // connection string Console.WriteLine(_server.connectionString); break; case "dir": Console.WriteLine(_dir.Dirpath); setter(args, () => new dir(constantinople.XML_FILEPATH, args[2])); break; case "recursive": Console.WriteLine(_dir.Recursive); setter(args, () => new dir(constantinople.XML_FILEPATH, args[2].ToLowerInvariant() == "true" || args[2].ToLowerInvariant() == "t")); break; case "load": _dir.loadSql(args) .ForEach(p => Console.WriteLine(p)); break; case "add": _dir.addSql(args).ForEach(p => Console.WriteLine(p)); break; case "leave": _dir.leaveSql(args).ForEach(p => Console.WriteLine(p)); break; case "list": _dir.listSql().ForEach(p => Console.WriteLine(p)); break; case "exists": if (args.Count() > 1) { Console.WriteLine("The filename {0} is {1} the current list.", args[1], _dir.exists(args[1]) ? "in" : "NOT in"); } else { Console.WriteLine("The exists needs one filename argument."); } break; case "run": runSql runsql = new runSql(_server.connectionString, _dir); runsql.run().ForEach(p => { Console.WriteLine(p); }); break; case "change": if (args.Length > 2) { editor ed = new editor(_dir.listSql(), _dir.Dirpath); ed.change(args[1], args[2]).ForEach(p => { Console.WriteLine(p); }); } break; case "show": if (args.Length == 2) { Console.WriteLine(System.IO.File.ReadAllText(_dir.Dirpath + "\\" + args[1])); } break; case "addsql": if (args.Length > 2) { editor ed = new editor(_dir.listSql(), _dir.Dirpath); ed.add(args[1], args[2]).ForEach(p => { Console.WriteLine(p); }); } break; case "edit": if (args.Length > 1) { Process.Start(_dir.Dirpath + "\\" + args[1]); } break; case "delSql": if (args.Length > 2) { var delSp = new deleteSql(_server.connectionString, args[1]); args.Skip(2).ToList().ForEach(p => { Console.WriteLine(delSp.run(p)); }); } else { Console.WriteLine("To delete an SQL entity you need the type of sql (ie function, procedure...) and then a list of names."); } break; } }