public override void Execute(LiteShell shell, StringScanner s, Display display, InputCommand input)
{
if(s.Scan("false|off").Length > 0 && _writer != null)
{
display.TextWriters.Remove(_writer);
input.OnWrite = null;
_writer.Flush();
_writer.Dispose();
_writer = null;
}
else if(_writer == null)
{
if (shell.Database == null) throw LiteException.NoDatabase();
var dbfilename = shell.Database.ConnectionString.Filename;
var path = Path.Combine(Path.GetDirectoryName(dbfilename),
string.Format("{0}-spool-{1:yyyy-MM-dd-HH-mm}.txt", Path.GetFileNameWithoutExtension(dbfilename), DateTime.Now));
_writer = File.CreateText(path);
display.TextWriters.Add(_writer);
input.OnWrite = (t) => _writer.Write(t);
}
}
public override void Execute(LiteShell shell, StringScanner s, Display display, InputCommand input)
{
if (s.Scan("false|off").Length > 0 && _writer != null)
{
display.TextWriters.Remove(_writer);
input.OnWrite = null;
_writer.Flush();
_writer.Dispose();
_writer = null;
}
else if (_writer == null)
{
if (shell.Database == null)
{
throw LiteException.NoDatabase();
}
var dbfilename = shell.Database.ConnectionString.Filename;
var path = Path.Combine(Path.GetDirectoryName(dbfilename),
string.Format("{0}-spool-{1:yyyy-MM-dd-HH-mm}.txt", Path.GetFileNameWithoutExtension(dbfilename), DateTime.Now));
_writer = File.CreateText(path);
display.TextWriters.Add(_writer);
input.OnWrite = (t) => _writer.Write(t);
}
}
public override void Execute(LiteShell shell, StringScanner s, Display display, InputCommand input)
{
if (shell.Database == null) throw LiteException.NoDatabase();
shell.Database.Dispose();
shell.Database = null;
}
/// <summary>
/// Run a shell command in current database. Returns a BsonValue as result
/// </summary>
public BsonValue RunCommand(string command)
{
if (_shell == null)
{
_shell = new LiteShell(this);
}
return(_shell.Run(command));
}
public override void Execute(LiteShell shell, StringScanner s, Display display, InputCommand input)
{
var filename = s.Scan(@".+").Trim();
foreach (var line in File.ReadAllLines(filename))
{
input.Queue.Enqueue(line);
}
}
public override void Execute(LiteShell shell, StringScanner s, Display display, InputCommand input)
{
var ver = typeof(LiteDatabase).Assembly.GetName().Version;
display.WriteInfo(string.Format("v{0}.{1}.{2}",
ver.Major,
ver.Minor,
ver.Build));
}
public override void Execute(LiteShell shell, StringScanner s, Display display, InputCommand input)
{
var filename = s.Scan(@".+").Trim();
foreach (var line in File.ReadAllLines(filename))
{
input.Queue.Enqueue(line);
}
}
public override void Execute(LiteShell shell, StringScanner s, Display display, InputCommand input)
{
var ver = typeof(LiteDatabase).Assembly.GetName().Version;
display.WriteInfo(string.Format("v{0}.{1}.{2}",
ver.Major,
ver.Minor,
ver.Build));
}
public override void Execute(LiteShell shell, StringScanner s, Display display, InputCommand input)
{
if (shell.Database == null)
{
throw LiteException.NoDatabase();
}
shell.Database.Dispose();
shell.Database = null;
}
public override void Execute(LiteShell shell, StringScanner s, Display display, InputCommand input)
{
var filename = s.Scan(@".+");
if (shell.Database != null)
{
shell.Database.Dispose();
}
shell.Database = new LiteDatabase(filename);
}
public override void Execute(LiteShell shell, StringScanner s, Display display, InputCommand input)
{
var filename = s.Scan(@".+");
if (shell.Database != null)
{
shell.Database.Dispose();
}
shell.Database = new LiteDatabase(filename);
}
/// <summary>
/// Run a command shell formating $0, $1 to JSON string args item index
/// </summary>
public BsonValue Run(string command, params BsonValue[] args)
{
var shell = new LiteShell();
var cmd = Regex.Replace(command, @"\$(\d+)", (k) =>
{
var index = Convert.ToInt32(k.Groups[1].Value);
return(JsonSerializer.Serialize(args[index]));
});
return(shell.Run(_engine.Value, cmd));
}
public override void Execute(LiteShell shell, StringScanner s, Display display, InputCommand input)
{
var temp = Path.GetTempPath() + "LiteDB.Shell.txt";
// remove "ed" command from history
input.History.RemoveAt(input.History.Count - 1);
var last = input.History.Count > 0 ? input.History[input.History.Count - 1] : "";
File.WriteAllText(temp, last.Replace("\n", Environment.NewLine));
Process.Start("notepad.exe", temp).WaitForExit();
var text = File.ReadAllText(temp);
if (text == last) return;
input.Queue.Enqueue(text);
}
public override void Execute(LiteShell shell, StringScanner s, Display display, InputCommand input)
{
var temp = Path.GetTempPath() + "LiteDB.Shell.txt";
// remove "ed" command from history
input.History.RemoveAt(input.History.Count - 1);
var last = input.History.Count > 0 ? input.History[input.History.Count - 1] : "";
File.WriteAllText(temp, last.Replace("\n", Environment.NewLine));
Process.Start("notepad.exe", temp).WaitForExit();
var text = File.ReadAllText(temp);
if (text == last)
{
return;
}
input.Queue.Enqueue(text);
}
public override void Execute(LiteShell shell, StringScanner s, Display display, InputCommand input)
{
}
/// <summary>
/// Run a command shell
/// </summary>
public BsonValue Run(string command)
{
var shell = new LiteShell();
return(shell.Run(_engine.Value, command));
}
public override void Execute(LiteShell shell, StringScanner s, Display display, InputCommand input)
{
display.Pretty = !(s.Scan(@"off\s*").Length > 0);
}
public override void Execute(LiteShell shell, StringScanner s, Display display, InputCommand input)
{
}
public override void Execute(LiteShell shell, StringScanner s, Display d, InputCommand input)
{
var sb = new StringBuilder();
var full = s.Match("full");
if (!full)
{
d.WriteHelp("Basic Shell Commands - try `help full` for all commands");
d.WriteHelp("=======================================================");
d.WriteHelp("> db.<collection>.insert <jsonDoc>", "Insert a new document into collection");
d.WriteHelp("> db.<collection>.update <jsonDoc>", "Update a document inside collection");
d.WriteHelp("> db.<collection>.delete <filter>", "Delete documents using a filter clausule (see find)");
d.WriteHelp("> db.<collection>.find <filter> [skip N][limit N]", "Show filtered documents based on index search");
d.WriteHelp("> db.<collection>.count <filter>", "Show count rows according query filter");
d.WriteHelp("> db.<collection>.ensureIndex <field> [true|{options}]", "Create a new index document field. For unique key, use true");
d.WriteHelp("> db.<collection>.indexes", "List all indexes in this collection");
d.WriteHelp("<filter> = <field> [=|>|>=|<|<=|!=|like|between] <jsonValue>", "Filter query syntax");
d.WriteHelp("<filter> = (<filter> [and|or] <filter> [and|or] ...)", "Multi queries syntax");
d.WriteHelp("Try:");
d.WriteHelp(" > db.customers.insert { _id:1, name:\"John Doe\", age: 37 }");
d.WriteHelp(" > db.customers.ensureIndex name");
d.WriteHelp(" > db.customers.find name like \"John\"");
d.WriteHelp(" > db.customers.find (name like \"John\" and _id between [0, 100]) limit 10");
}
else
{
d.WriteHelp("Shell commands");
d.WriteHelp("==============");
d.WriteHelp("> open <filename>", "Open a new database");
d.WriteHelp("> close", "Close current database");
d.WriteHelp("> run <filename>", "Run commands inside filename");
d.WriteHelp("> pretty on|off", "Turns on/off pretty json format");
d.WriteHelp("> timer", "Show timer before prompt");
d.WriteHelp("> ed", "Open nodepad with last command to edit and execute");
d.WriteHelp("> spool on|off", "Spool all output in a spool file");
d.WriteHelp("> -- comment", "Do nothing, its just a comment");
d.WriteHelp("> /<command>/", "Support for multi line command");
d.WriteHelp("> version", "Show LiteDB version");
d.WriteHelp("> exit", "Close LiteDB shell");
d.WriteHelp();
d.WriteHelp("Transaction commands");
d.WriteHelp("====================");
d.WriteHelp("> begin", "Begins a new transaction");
d.WriteHelp("> commit", "Commit current transaction");
d.WriteHelp("> rollback", "Rollback current transaction");
d.WriteHelp();
d.WriteHelp("Collections commands");
d.WriteHelp("====================");
d.WriteHelp("> db.<collection>.insert <jsonDoc>", "Insert a new document into collection");
d.WriteHelp("> db.<collection>.update <jsonDoc>", "Update a document inside collection");
d.WriteHelp("> db.<collection>.delete <filter>", "Delete documents using a filter clausule (see find)");
d.WriteHelp("> db.<collection>.bulk <filename>", "Bulk insert a json file as documents");
d.WriteHelp("> db.<collection>.find [skip N][limit N]", "Show all documents. Can limit/skip results");
d.WriteHelp("> db.<collection>.find <filter> [skip N][limit N]", "Show filtered documents based on index search. See <filter> syntax below");
d.WriteHelp("> db.<collection>.count <filter>", "Show count rows according query filter");
d.WriteHelp("> db.<collection>.exec <filter> { Action<Object (id), BsonDocument (doc), Collection (col), LiteDatabase (db)> }", "Execute C# code for each document based on filter.");
d.WriteHelp("> db.<collection>.ensureIndex <field> [unique]", "Create a new index document field");
d.WriteHelp("> db.<collection>.indexes", "List all indexes in this collection");
d.WriteHelp("> db.<collection>.drop", "Drop collection and destroy all documents inside");
d.WriteHelp("> db.<collection>.dropIndex <field>", "Drop a index and make index area free to use with another index");
d.WriteHelp("> db.<collection>.rename <newCollectionName>", "Rename a collection");
d.WriteHelp("> db.<collection>.min <field>", "Returns min/first value from collection using index field");
d.WriteHelp("> db.<collection>.max <field>", "Returns max/last value from collection using index field");
d.WriteHelp("<filter> = <field> [=|>|>=|<|<=|!=|like|contains|in|between] <jsonValue>", "Filter query syntax");
d.WriteHelp("<filter> = (<filter> [and|or] <filter> [and|or] ...)", "Multi queries syntax");
d.WriteHelp("<jsonDoc> = {_id: ... , key: value, key1: value1 }", "Represent a json (extended version) for a BsonDocument. See special data types");
d.WriteHelp("Json Date", "{ mydate: { $date :\"2015-01-01T23:59:59Z\"} }");
d.WriteHelp("Json Guid", "{ myguid: { $guid :\"3a1c34b3-9f66-4d8e-975a-d545d898a4ba\"} }");
d.WriteHelp("Json Binary", "{ mydata: { $binary :\"base64 byte array\"} }");
d.WriteHelp();
d.WriteHelp("File storage commands");
d.WriteHelp("=====================");
d.WriteHelp("> fs.find", "List all files on datafile");
d.WriteHelp("> fs.find <fileId>", "List file info from a key. Supports * for starts with key");
d.WriteHelp("> fs.upload <fileId> <filename>", "Insert a new file inside database");
d.WriteHelp("> fs.download <fileId> <filename>", "Save a file to disk passing a file key and filename");
d.WriteHelp("> fs.update <fileId> {key:value}", "Update metadata file");
d.WriteHelp("> fs.delete <fileId>", "Remove a file inside database");
d.WriteHelp();
d.WriteHelp("Other commands");
d.WriteHelp("==============");
d.WriteHelp("> db.info", "Get database informations");
d.WriteHelp("> dump", "Display dump database information");
}
}
public override void Execute(LiteShell shell, StringScanner s, Display display, InputCommand input)
{
display.Pretty = !(s.Scan(@"off\s*").Length > 0);
}
public override void Execute(LiteShell shell, StringScanner s, Display d, InputCommand input)
{
var sb = new StringBuilder();
var full = s.Match("full");
if (!full)
{
d.WriteHelp("Basic Shell Commands - try `help full` for all commands");
d.WriteHelp("=======================================================");
d.WriteHelp("> db.<collection>.insert <jsonDoc>", "Insert a new document into collection");
d.WriteHelp("> db.<collection>.update <jsonDoc>", "Update a document inside collection");
d.WriteHelp("> db.<collection>.delete <filter>", "Delete documents using a filter clausule (see find)");
d.WriteHelp("> db.<collection>.find <filter> [skip N][limit N]", "Show filtered documents based on index search");
d.WriteHelp("> db.<collection>.count <filter>", "Show count rows according query filter");
d.WriteHelp("> db.<collection>.ensureIndex <field> [true|{options}]", "Create a new index document field. For unique key, use true");
d.WriteHelp("> db.<collection>.indexes", "List all indexes in this collection");
d.WriteHelp("<filter> = <field> [=|>|>=|<|<=|!=|like|between] <jsonValue>", "Filter query syntax");
d.WriteHelp("<filter> = (<filter> [and|or] <filter> [and|or] ...)", "Multi queries syntax");
d.WriteHelp("Try:");
d.WriteHelp(" > db.customers.insert { _id:1, name:\"John Doe\", age: 37 }");
d.WriteHelp(" > db.customers.ensureIndex name");
d.WriteHelp(" > db.customers.find name like \"John\"");
d.WriteHelp(" > db.customers.find (name like \"John\" and _id between [0, 100]) limit 10");
}
else
{
d.WriteHelp("Shell commands");
d.WriteHelp("==============");
d.WriteHelp("> open <filename>", "Open a new database");
d.WriteHelp("> close", "Close current database");
d.WriteHelp("> run <filename>", "Run commands inside filename");
d.WriteHelp("> pretty on|off", "Turns on/off pretty json format");
d.WriteHelp("> timer", "Show timer before prompt");
d.WriteHelp("> ed", "Open nodepad with last command to edit and execute");
d.WriteHelp("> spool on|off", "Spool all output in a spool file");
d.WriteHelp("> -- comment", "Do nothing, its just a comment");
d.WriteHelp("> /<command>/", "Support for multi line command");
d.WriteHelp("> version", "Show LiteDB version");
d.WriteHelp("> exit", "Close LiteDB shell");
d.WriteHelp();
d.WriteHelp("Transaction commands");
d.WriteHelp("====================");
d.WriteHelp("> begin", "Begins a new transaction");
d.WriteHelp("> commit", "Commit current transaction");
d.WriteHelp("> rollback", "Rollback current transaction");
d.WriteHelp();
d.WriteHelp("Collections commands");
d.WriteHelp("====================");
d.WriteHelp("> db.<collection>.insert <jsonDoc>", "Insert a new document into collection");
d.WriteHelp("> db.<collection>.update <jsonDoc>", "Update a document inside collection");
d.WriteHelp("> db.<collection>.delete <filter>", "Delete documents using a filter clausule (see find)");
d.WriteHelp("> db.<collection>.bulk <filename>", "Bulk insert a json file as documents");
d.WriteHelp("> db.<collection>.find [skip N][limit N]", "Show all documents. Can limit/skip results");
d.WriteHelp("> db.<collection>.find <filter> [skip N][limit N]", "Show filtered documents based on index search. See <filter> syntax below");
d.WriteHelp("> db.<collection>.count <filter>", "Show count rows according query filter");
d.WriteHelp("> db.<collection>.exec <filter> { Action<Object (id), BsonDocument (doc), Collection (col), LiteDatabase (db)> }", "Execute C# code for each document based on filter.");
d.WriteHelp("> db.<collection>.ensureIndex <field> [unique]", "Create a new index document field");
d.WriteHelp("> db.<collection>.indexes", "List all indexes in this collection");
d.WriteHelp("> db.<collection>.drop", "Drop collection and destroy all documents inside");
d.WriteHelp("> db.<collection>.dropIndex <field>", "Drop a index and make index area free to use with another index");
d.WriteHelp("> db.<collection>.rename <newCollectionName>", "Rename a collection");
d.WriteHelp("> db.<collection>.min <field>", "Returns min/first value from collection using index field");
d.WriteHelp("> db.<collection>.max <field>", "Returns max/last value from collection using index field");
d.WriteHelp("<filter> = <field> [=|>|>=|<|<=|!=|like|contains|in|between] <jsonValue>", "Filter query syntax");
d.WriteHelp("<filter> = (<filter> [and|or] <filter> [and|or] ...)", "Multi queries syntax");
d.WriteHelp("<jsonDoc> = {_id: ... , key: value, key1: value1 }", "Represent a json (extended version) for a BsonDocument. See special data types");
d.WriteHelp("Json Date", "{ mydate: { $date :\"2015-01-01T23:59:59Z\"} }");
d.WriteHelp("Json Guid", "{ myguid: { $guid :\"3a1c34b3-9f66-4d8e-975a-d545d898a4ba\"} }");
d.WriteHelp("Json Binary", "{ mydata: { $binary :\"base64 byte array\"} }");
d.WriteHelp();
d.WriteHelp("File storage commands");
d.WriteHelp("=====================");
d.WriteHelp("> fs.find", "List all files on datafile");
d.WriteHelp("> fs.find <fileId>", "List file info from a key. Supports * for starts with key");
d.WriteHelp("> fs.upload <fileId> <filename>", "Insert a new file inside database");
d.WriteHelp("> fs.download <fileId> <filename>", "Save a file to disk passing a file key and filename");
d.WriteHelp("> fs.update <fileId> {key:value}", "Update metadata file");
d.WriteHelp("> fs.delete <fileId>", "Remove a file inside database");
d.WriteHelp();
d.WriteHelp("Other commands");
d.WriteHelp("==============");
d.WriteHelp("> db.info", "Get database informations");
d.WriteHelp("> dump", "Display dump database information");
}
}
public override void Execute(LiteShell shell, StringScanner s, Display display, InputCommand input)
{
Environment.Exit(0);
}
