18 lines
632 B
C#
18 lines
632 B
C#
 
|
#:package Microsoft.Data.Sqlite@10.0.12
|
||
|
|
// dotnet run scripts/Query.cs -- <cad_index.db> <sql>
|
||
|
|
using Microsoft.Data.Sqlite;
|
||
|
|
|
||
|
|
using var connection = new SqliteConnection($"Data Source={args[0]};Mode=ReadOnly");
|
||
|
|
connection.Open();
|
||
|
|
using var command = connection.CreateCommand();
|
||
|
|
command.CommandText = args[1];
|
||
|
|
using var reader = command.ExecuteReader();
|
||
|
|
int righe = 0;
|
||
|
|
while (reader.Read())
|
||
|
|
{
|
||
|
|
righe++;
|
||
|
|
var valori = Enumerable.Range(0, reader.FieldCount).Select(i => reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString());
|
||
|
|
Console.WriteLine(string.Join(" | ", valori));
|
||
|
|
}
|
||
|
|
Console.WriteLine($"({righe} righe)");
|
||
|
|
return 0;
|