Install script example

　Install Script is DDL of the application located under the ALINOUS_HOME folder. This is a habit of Alinous-Core.

By prepare these DDL, you can setup application database automatically. In addiditon to the install script, preparing backuping and restoring database module, you can use this system in test automation.

Index

Install script in the project
Automatic database setup
After reading this page

Install script in the project

The install script is in "ALINOUS_HOME/install/" folder of the example project.

Location of install script

The install.alns is the main module. The source code is below.


include("/install/autocomplete.alns");
include("/install/gridatabledata.alns");
include("/install/calendar.alns");

installDdl();


return 0;

function installDdl()
{
	BEGIN;
	
	CREATE TABLE serial(
		serial_id varchar(32),
		number int,
		primary key(serial_id)
	);
	
	CREATE TABLE job_progress(
		job_id varchar(128),
		
		job_done int not null default 0,
		job_max int not null default 0,
		
		PRIMARY KEY(job_id)
	);
	
	CREATE TABLE double_button_lock(
		session_id varchar(255),
		access_token varchar(255),
		update_time TIMESTAMP not null default now(),

		PRIMARY KEY(session_id, access_token)
	);
	
	
	CREATE TABLE sample_items(
		item_id int,
		item_label varchar(255) not null default '',
		PRIMARY KEY(item_id)
	);
	
	INSERT INTO sample_items(item_id, item_label) VALUES(1, 'Item 1');
	INSERT INTO sample_items(item_id, item_label) VALUES(2, 'Item 2');
	INSERT INTO sample_items(item_id, item_label) VALUES(3, 'Item 3');
	INSERT INTO sample_items(item_id, item_label) VALUES(4, 'Item 4');
	INSERT INTO sample_items(item_id, item_label) VALUES(5, 'Item 5');
	INSERT INTO sample_items(item_id, item_label) VALUES(6, 'Item 6');
	
	COMMIT;
	
	AutoComplete.ddl();
	DridTableData.ddl();
	FullCalendar.ddl();
}

This script execute "create table" and other included module making other tables and data. The main module includes below.

Automatic database setup

The install script is to automate the first installation of application's database. In order to setup, access url below after making database instance and launch Alinous-Core server.

http://localhost:8080/install/install.html

After reading this page

After reading this page, please take a look at Backup and restore database example. And when you read other examples using database table, please remember this page.