public static bool UpgradeThis(string sqlfilename)
{
Assembly _assembly;
StreamReader _textStreamReader;
string resname = "KlonsF.SQL." + sqlfilename + ".txt";
_assembly = Assembly.GetExecutingAssembly();
_textStreamReader = new StreamReader(
_assembly.GetManifestResourceStream(resname));
string sql = _textStreamReader.ReadToEnd();
FbConnection conn = DataSetHelper.GetFbConnection(KlonsData.St.KlonsTableAdapterManager.ParamsTableAdapter);
if (conn == null)
{
return(false);
}
FbScript script = new FbScript(sql);
script.Parse();
FbBatchExecution fbe = new FbBatchExecution(conn);
foreach (var cmd in script.Results)
{
fbe.Statements.Add(cmd);
}
fbe.Execute();
return(true);
}
public static bool ExecuteBatchScript(
string connectionString,
string pathToScriptFile)
{
FbScript script = new FbScript(pathToScriptFile);
if (script.Parse() > 0)
{
using (FbConnection connection = new FbConnection(connectionString))
{
connection.Open();
try
{
FbBatchExecution batch = new FbBatchExecution(connection, script);
batch.Execute(true);
}
catch (FbException ex)
{
log.Error(ex);
throw new Exception(pathToScriptFile, ex);
}
finally
{
connection.Close();
}
}
}
return(true);
}
private static void ExecuteDbCreationScript()
{
using (var connection = new FbConnection(GetConnectionString()))
{
var batchExecution = new FbBatchExecution(connection);
var script = new FbScript(DbCreationScript ?? Resources.create_db);
script.Parse();
batchExecution.AppendSqlStatements(script);
batchExecution.Execute();
}
}
//teste para bloco de codigo
public static void ExecuteCommandBloco(string ibge, string scripttext)
{
using (var conn = new FbConnection(ibge))
{
conn.Open();
FbScript script = new FbScript(scripttext);
script.Parse();
FbBatchExecution fbe = new FbBatchExecution(conn);
fbe.AppendSqlStatements(script);
fbe.Execute();
}
}
/// <summary>
/// Parses the script.
/// </summary>
/// <param name="scriptText">The script text.</param>
/// <param name="handler"></param>
/// <returns></returns>
public static FbStatementCollection ParseScript(string scriptText, EventHandler <UnknownStatementEventArgs> handler)
{
FbScript script = new FbScript(scriptText);
//Set unkown statement handler
script.UnknownStatement += handler;
//Parse the script
script.Parse();
//Return the results back to the caller
return(script.Results);
}
private void CreateDatabase()
{
// create db folder
var dbFolderPath = Path.GetDirectoryName(this.dbPath);
if (!Directory.Exists(dbFolderPath))
{
Directory.CreateDirectory(dbFolderPath);
}
if (!File.Exists(this.dbPath))
{
try
{
var connString = @"ServerType=1; DataSource=localhost; Database={0}; Pooling=false; User=SYSDBA; Password=NA;".Format2(this.dbPath);
FbConnection.CreateDatabase(connString);
var assembly = Assembly.GetExecutingAssembly();
using (var conn = new FbConnection(connString))
using (var stream = assembly.GetManifestResourceStream("BitSharp.Storage.Firebird.Sql.CreateDatabase.sql"))
using (var reader = new StreamReader(stream))
{
conn.Open();
var script = new FbScript(reader.ReadToEnd());
script.Parse();
new FbBatchExecution(conn, script).Execute();
}
}
catch (Exception e)
{
Debug.WriteLine("Database create failed: {0}".Format2(e.Message));
Debugger.Break();
if (File.Exists(this.dbPath))
{
File.Delete(this.dbPath);
}
throw;
}
}
}