[FEATURE REQUEST] Possibility to shut down the database and start it up again.

[nLeonardt95]

Possibility to shut down the database and start it up again.

https://firebirdsql.org/rlsnotesh/rnfb20x-util-gfix.html#rnfb20x-util-gfix-shut

[arvanus]

IBPP already has this features, it's just a question of building a interface for Flamerobin

flamerobin/src/ibpp/service.cpp

Lines 446 to 476 in fa4e3d5

	void ServiceImpl::Shutdown(const std::string& dbfile, IBPP::DSM mode, int sectimeout)
	{
	if (mHandle == 0)
	throw LogicExceptionImpl("Service::Shutdown", _("Service is not connected."));
	if (dbfile.empty())
	throw LogicExceptionImpl("Service::Shutdown", _("Main database file must be specified."));
	IBS status;
	SPB spb;
	spb.Insert(isc_action_svc_properties);
	spb.InsertString(isc_spb_dbname, 2, dbfile.c_str());
	switch (mode)
	{
	case IBPP::dsDenyAttach :
	spb.InsertQuad(isc_spb_prp_deny_new_attachments, sectimeout);
	break;
	case IBPP::dsDenyTrans :
	spb.InsertQuad(isc_spb_prp_deny_new_transactions, sectimeout);
	break;
	case IBPP::dsForce :
	spb.InsertQuad(isc_spb_prp_shutdown_db, sectimeout);
	break;
	}
	(*gds.Call()->m_service_start)(status.Self(), &mHandle, 0, spb.Size(), spb.Self());
	if (status.Errors())
	throw SQLExceptionImpl(status, "Service::Shutdown", _("isc_service_start failed"));
	Wait();
	}

I'd put the menu here, with 2 distinct menus for Database Shutdown and Database Online:

What do you think?

[nLeonardt95]

that's exactly how I imagined it too

[Jdochoa]

IBPP already has this features, it's just a question of building a interface for Flamerobin

flamerobin/src/ibpp/service.cpp

Lines 446 to 476 in fa4e3d5

	void ServiceImpl::Shutdown(const std::string& dbfile, IBPP::DSM mode, int sectimeout)
	{
	if (mHandle == 0)
	throw LogicExceptionImpl("Service::Shutdown", _("Service is not connected."));
	if (dbfile.empty())
	throw LogicExceptionImpl("Service::Shutdown", _("Main database file must be specified."));
	IBS status;
	SPB spb;
	spb.Insert(isc_action_svc_properties);
	spb.InsertString(isc_spb_dbname, 2, dbfile.c_str());
	switch (mode)
	{
	case IBPP::dsDenyAttach :
	spb.InsertQuad(isc_spb_prp_deny_new_attachments, sectimeout);
	break;
	case IBPP::dsDenyTrans :
	spb.InsertQuad(isc_spb_prp_deny_new_transactions, sectimeout);
	break;
	case IBPP::dsForce :
	spb.InsertQuad(isc_spb_prp_shutdown_db, sectimeout);
	break;
	}
	(*gds.Call()->m_service_start)(status.Self(), &mHandle, 0, spb.Size(), spb.Self());
	if (status.Errors())
	throw SQLExceptionImpl(status, "Service::Shutdown", _("isc_service_start failed"));
	Wait();
	}

I'd put the menu here, with 2 distinct menus for Database Shutdown and Database Online:

What do you tkink?

it's fine, but include gfix -online too

[luronumen]

Hi @arvanus and @Jdochoa

Is it also possible to add in this Tools menu an option to extract the Database metadata (DDL.SQL file) using the following isql command?

isql.exe -user SYSDBA -password masterkey -extract -output "DDL.SQL" LOCALHOST:"TEST_DB"

Thanks in advance,
Luciano

[arvanus]

Hi @arvanus and @Jdochoa

Is it also possible to add in this Tools menu an option to extract the Database metadata (DDL.SQL file) using the following isql command?

isql.exe -user SYSDBA -password masterkey -extract -output "DDL.SQL" LOCALHOST:"TEST_DB"

Thanks in advance,
Luciano

Isn't what already exists in the database property, DDL tab?

[luronumen]

Hi @arvanus

There is but the sequence that the instructions are shown on this page doesn't always work for the database re-creation because it doesn't perfectly consider the dependencies between the objects. The best solution would be for this page to show the DDL extracted using isql instead of the instructions extracted by FlameRobin. What do you think? Is it possible to refresh this page to show the DDL statement extracted via isql?

[arvanus]

Hi @arvanus

There is but the sequence that the instructions are shown on this page doesn't always work for the database re-creation because it doesn't perfectly consider the dependencies between the objects. The best solution would be for this page to show the DDL extracted using isql instead of the instructions extracted by FlameRobin. What do you think? Is it possible to refresh this page to show the DDL statement extracted via isql?

Not possible that I know, but I know nothing 😄
iSQL is simply a client do Fb, like gbak is a simple client too
Also, even isql has this problem:
FirebirdSQL/firebird#6862
This DDL fail to replicate:

create view v_test as select 1 as x from rdb$database;
create procedure sp_test(a_x type of column v_test.x) as begin end;
commit;

Please, create a new issue referring this problem

[nLeonardt95]

when can we except the next release version?