public static void ReadDatabase( bscr bscrFile, string ConnectionString )
{
SQLiteConnection Connection = new SQLiteConnection( ConnectionString );
Connection.Open();
bscrFile.Strings = new List<bscrString>();
using ( SQLiteTransaction Transaction = Connection.BeginTransaction() )
using ( SQLiteCommand Command = new SQLiteCommand( Connection ) ) {
Command.CommandText = "SELECT english, PointerRef FROM Text ORDER BY PointerRef";
SQLiteDataReader r = Command.ExecuteReader();
while ( r.Read() ) {
String SQLText;
try {
SQLText = r.GetString( 0 ).Replace( "''", "'" );
} catch ( System.InvalidCastException ) {
SQLText = "";
}
int PointerRef = r.GetInt32( 1 );
bscrString b = new bscrString();
b.Position = (uint)PointerRef;
b.String = SQLText;
bscrFile.Strings.Add( b );
}
Transaction.Rollback();
}
return;
}
public static int Export( List<string> args )
{
if ( args.Count < 3 ) {
Console.WriteLine( "Usage: db bscr.old bscr.new" );
return -1;
}
string InDatabase = args[0];
string InFile = args[1];
string OutFile = args[2];
bscr b = new bscr( InFile );
ReadDatabase( b, "Data Source=" + InDatabase );
b.CreateFile( OutFile );
return 0;
}