mariuz / flamerobin

FlameRobin is a database administration tool for Firebird RDBMS. Our goal is to build a tool that is: lightweight (small footprint, fast execution) cross-platform (Linux, Windows, Mac OS X, FreeBSD) dependent only on other Open Source software
http://flamerobin.org
MIT License
211 stars 64 forks source link

Add "Script Executor" like functionality #342

Closed arvanus closed 7 months ago

arvanus commented 8 months ago

Add a special SQL Editor that provides the ability in script to connect to any database and in-sequence execute SQLs inside this connection, user can connect how many times and how many databases he wishes, SQL Executor isn't obliged to have connection pool, but having is a great improvement. Example:

CONNECT "LOCALHOST:EMPLOYEE" user 'SYSDBA' password 'secret' role 'RDB$ADMIN' character set  'ISO8859_1';
execute procedure ppp(1,2,3);
commit;
CONNECT "LOCALHOST/3051:EMPLOYEE" user 'SYSDBA' password 'secret' role 'RDB$ADMIN' character set  'ISO8859_1';
execute procedure ppp2(1,2,3);
--commit is implied
--Reconnect to first database (could by any other)
CONNECT "LOCALHOST:EMPLOYEE" user 'SYSDBA' password 'secret' role 'RDB$ADMIN' character set  'ISO8859_1';
execute procedure ppp(1,2,3);
select * from table_n;
--user can commit manually like any other SQL Editor