using System.Data;
using System.Data.SQLite;

namespace TheAgileWorkshop.SQLiteWithSchemaSupport
{
    public class SQLiteWithSchemaTransaction : IDbTransaction
    {
        private readonly SQLiteWithSchemaConnection connection;
        private readonly SQLiteTransaction transaction;

        public SQLiteWithSchemaTransaction(SQLiteWithSchemaConnection connection, SQLiteTransaction transaction)
        {
            this.connection = connection;
            this.transaction = transaction;
        }

        public void Dispose()
        {
            transaction.Dispose();
        }

        public void Commit()
        {
            transaction.Commit();
        }

        public void Rollback()
        {
            transaction.Rollback();
        }

        public IDbConnection Connection
        {
            get { return connection; }
        }

        public IsolationLevel IsolationLevel
        {
            get { return transaction.IsolationLevel; }
        }

        internal SQLiteTransaction InnerTransaction
        {
            get { return transaction; }
        }

    }
}