Esempio n. 1
0
    public string Query(QueryOutputType type, SQLiteCommand cmd)
    {
        switch (type)
        {
        case QueryOutputType.MarkdownTable: return(QueryToMarkdownTable(cmd));

        case QueryOutputType.Scalar: return(QueryToScalar(cmd)?.ToString() ?? "");

        case QueryOutputType.Csv: return(QueryToCsv(cmd));

        default: throw new Exception("invalid QueryOutputType");
        }
    }
Esempio n. 2
0
        public void SetOutputType(QueryOutputType outputType, string fileName = "")
        {
            switch (outputType)
            {
            case QueryOutputType.File:
                OutputToFile = fileName;
                break;

            case QueryOutputType.Text:
            case QueryOutputType.DataGrid:
            default:

                break;
            }
        }
Esempio n. 3
0
    public string RecallQuery(QueryOutputType type, string name, string[] args)
    {
        var cmd = CreateCommand(@"SELECT body FROM nquery_queries WHERE name = @name");

        cmd.Parameters.AddWithValue("@name", name);
        var sql = cmd.ExecuteScalar()?.ToString();

        if (sql == null)
        {
            throw new UserCommandException($"no such stored query: {name}");
        }
        var cmd2 = CreateCommand(sql);

        cmd2.Parameters.AddWithValue("@0", String.Join(" ", args));
        for (var i = 0; i < args.Length; i++)
        {
            cmd2.Parameters.AddWithValue($"@{i + 1}", args[i]);
        }
        return(Query(type, cmd2));
    }