InitialData - Revision history

Sed: use to highlight

2016-11-16T16:58:42Z

use <source> to highlight

← Older revision		Revision as of 12:58, 16 November 2016
Line 15:		Line 15:
	= Example =		= Example =

	<~~pre~~>		<source lang="perl">
	@ScripConditions = (		@ScripConditions = (
	{ Name =~~>~~ 'On Some Event',		{ Name => 'On Some Event',
	Description =~~>~~ 'When some event happens',		Description => 'When some event happens',
	ExecModule =~~>~~ 'SomeEvent',		ExecModule => 'SomeEvent',
	Argument =~~>~~ 'some argument',		Argument => 'some argument',
	ApplicableTransTypes =~~>~~ 'Any'		ApplicableTransTypes => 'Any'
	},		},
	);		);
	</~~pre~~>		</source>

	= How it works =		= How it works =

Bduye: /* Example */

2016-07-20T21:53:23Z

Example

← Older revision		Revision as of 17:53, 20 July 2016
Line 15:		Line 15:
	= Example =		= Example =

			<pre>
	@ScripConditions = (		@ScripConditions = (
	{ Name => 'On Some Event',		{ Name => 'On Some Event',
Line 23:		Line 24:
	},		},
	);		);
			</pre>

	= How it works =		= How it works =

Bduye: add

blocks

2016-07-20T21:53:06Z

add <pre> </pre> blocks

← Older revision		Revision as of 17:53, 20 July 2016
Line 29:		Line 29:

	You put hashes with key/value pairs into these arrays. So it looks like this:		You put hashes with key/value pairs into these arrays. So it looks like this:

			<pre>

	@SomeArray = (		@SomeArray = (
Line 50:		Line 52:
	);		);

			</pre>

	Usually you don't write any code, but this doesn't mean you can not. Sometimes you do want to write a bit of code, for example to load a bunch of data from a text file.		Usually you don't write any code, but this doesn't mean you can not. Sometimes you do want to write a bit of code, for example to load a bunch of data from a text file.

Admin: 3 revisions imported

2016-04-06T20:11:25Z

3 revisions imported

New page

= Adding new records into RT's database =

This might be helpful if you want to add a record in the RT DB and don't want to mess things by SQL INSERT queries and don't want to write code.

This is especially helpful when you write custom scrip actions/conditions as module files instead of using <code>User Defined</code> and want to register them in the DB.

= rt-setup-database and initialdata =

RT comes with <code>etc/initialdata</code> file that is parsed and inserted into newly created DB when you install for the first time. When you upgrade RT, database changes comes in similar file.

Basic idea is that you can write such files and use <code>sbin/rt-setup-database</code> script to insert the data:

/path/to/rt3/sbin/rt-setup-database --action insert --datafile /path/to/data-file

= Example =

@ScripConditions = (
{ Name => 'On Some Event',
Description => 'When some event happens',
ExecModule => 'SomeEvent',
Argument => 'some argument',
ApplicableTransTypes => 'Any'
},
);

= How it works =

File should be a valid perl scrip that fill a bunch of arrays with data that should be inserted, for example: @Queues, @Scrips, @Groups and so on. Full list of available arrays you can find in method InsertData that is in <code>lib/RT/Handle.pm</code> file.

You put hashes with key/value pairs into these arrays. So it looks like this:

@SomeArray = (
{
key => 'value',
key => 'value',
...
},
{
key => 'value',
key => 'value',
...
},
...
);
@AnotherArray = (
{
...
},
...
);

Usually you don't write any code, but this doesn't mean you can not. Sometimes you do want to write a bit of code, for example to load a bunch of data from a text file.

= Where to find more info =

There is no much to document about it and there are plenty of examples in RT itself. Start from <code>etc/initialdata</code> then look at <code>etc/upgrade/*/content</code> files, then look at the same set in [[RTIR]] extension or any other extension.

= See also =

[[WriteCustomAction]] and [[WriteCustomCondition]] for details on @ScripActions and @ScripConditions