import fdb

print fdb.__version__

att1=fdb.connect(dsn='/3255:e25',user='SYSDBA',password='masterkey')
att2=fdb.connect(dsn='/3255:e25',user='SYSDBA',password='masterkey')

trn1=att1.trans()
cur1=trn1.cursor()

cur1.execute("create table t(a int, b int, c int)")   # att_12, tra_4
cur1.execute("create view v as select a,b from t")
trn1.commit()

cur1.execute("insert into t values(1,2,3)")           # att_12, tra_5
cur1.execute("select * from v")

for c in cur1.fetchall():
    print(c)

trn1.commit()

trn2=att2.trans()
cur2=trn2.cursor()
cur2.execute("select * from v")                       # att_13, tra_7
trn2.commit()

cur1.execute("alter view v as select a, b, c from t") # att-12, tra_8
trn1.commit()

cur2.execute("select * from v")                       # att_13, tra_9

for c in cur2.fetchall():
    print(c)

set term ^;
execute block as
begin
  execute statement 'drop view v';
  when any do begin end
end
^
set term ;^
commit;

recreate table t(a integer, b integer, c integer);
commit;
insert into t values(1,2,3);
commit;

recreate view v(a, b) as
select a, b from t;
commit;

set transaction read committed; --  no wait;

select current_connection as this_att, current_transaction as this_trn, v.* from v;

set term ^;
execute block returns(this_att int, this_trn int, a int, b int, c int) as
begin
  for 
      execute statement (' select current_connection, current_transaction, v.* from v ')
      on external 'localhost:'||rdb$get_context('SYSTEM', 'DB_NAME')
      as user 'SYSDBA' password 'masterke'
  into this_att, this_trn, a, b
  do suspend;

  execute statement 'alter view v as select a, b, c from t' with autonomous transaction;

  for 
      execute statement (' select current_connection, current_transaction, v.* from v ')
      on external 'localhost:'||rdb$get_context('SYSTEM', 'DB_NAME')
      as user 'SYSDBA' password 'masterke' 
      -- role 'r2'
      with autonomous transaction
  into this_att, this_trn, a, b
  do suspend;

end
^
set term ;^