Scripts

A script has a name and a description. A particular engine has to be selected as well (the list of available scripting engines is in the Engine drop down). The Permission drop down allows to select a permission that the user must have to be able to execute the script (or to be even able to see it in the drop down of available scripts). A script can have one or more parameters. A parameter has a name (and it is referred by this name from the script), a label that is visible to the user, a type (various types are supported, see the example below) and it may have a default value.

Example

Here is an example of what is possible to do with a script (using ECMAScript engine). While the code looks like JavaScript it runs on the server and it can access parameters and all the UniTime classes.

// Logging

if (name != null) {

log.info(greeting + ' ' + name + '!');

} else {

log.info(greeting + '!');

log.warn('No name was given.');

}

// Reading an input (text) file

if (file != null) {

var lines = file.getString('utf-8').split('\n');

for (var i = 0; i < lines.length; i++) {

log.debug((1 + i) + ': ' + lines[i]);

}

} else {

log.error('No file to read.', null);

}

// Writing an output file

var file = log.createOutput('test', 'txt');

var out = new java.io.PrintWriter(new java.io.FileWriter(file));

out.println('This is a test.');

out.flush(); out.close();

// Special parameters

log.info('Current academic session: ' + session.getLabel());

if (dept != null) {

log.info('Selected department: ' + dept.getDeptCode() + ' - ' + dept.getLabel());

}

if (subjects != null) {

log.info('Selected subject areas:');

for (var i = 0; i < subjects.size(); i++) {

var subject = subjects.get(i);

log.info(' ' + subject.getSubjectAreaAbbreviation() + ' - ' + subject.getTitle());

}

}

if (type != null) {

var t = hibSession.createQuery('from RoomType where reference = :reference').setString('reference', type).uniqueResult();

log.info('Room type: ' + t.getLabel() + ' (' + t.countRooms(session.getUniqueId()) + ' rooms in ' + session.getLabel() + ')');

}

// Progress

log.setStatus('Counting to ten. Slowly.', 10);

for (var i = 0; i < 9; i++) {

java.lang.Thread.sleep(i * 1000);

log.incProgress();

log.debug('-- ' + (1 + i));

}

It has the following parameters:

Besides of the parameters, it can access a hibernate session (parameter hibSession of org.hibernate.Session class), current academic session (parameter session, of Session class) and the object running the script (parameter log, of ScriptExecution class). The hibernate session is opened with a transaction started. This transaction is committed when the script finishes fine, it is rollbacked otherwise. The log can be used to print debug, info, warn, and error message; to control script status and progress; and to create an output file.

The parameters can be of various types. Basic types are string, boolean, int, long, double, float, short, and byte. There can be a drop down selection of one or multiple departments (type department or departments of class Department or List<Department>), one or multiple subject areas (type subject or subjects of class SubjectArea or List<SubjectArea>), one or multiple buildings (type building or buildings of class Building or List<Building>), one or more locations (type location or locations of class Location or List<Location>), or one or more rooms (type room or rooms of class Room or List<Room>). It can also be an input file (type file). A selection of one of given strings (type enum) or a value from a reference table (type reference(RefTableEntry), where RefTableEntry is a model class inherited from RefTableEntry, the result is a string with the value of the reference column of the selected item) are also accepted.

If a user has a department dependent role (e.g., departmental schedule manager), only associated departments, subject areas, rooms, and buildings will be available in the drop downs.

Python

To allow python scripting, the standalone jar version of Jython (e.g., jython-standalone-2.5.3.jar, see Jython downloads) needs to be put in Tomcat/libs folder. After Tomcat is restarted, python should appear as an available engine. Here is an example script (same as the one above) written using python:

# Logging

if name:

print '%s %s!' % (greeting, name)

else:

print '%s!' % greeting

log.warn('No name was given.')

# Reading an input (text) file

if file:

i = 1

for line in file.getString('utf-8').split('\n'):

log.debug('%d: %s' % (i, line))

i = i + 1

else:

log.error('No file to read.', None)

# Writing an output file

f = open(log.createOutput('test','txt').getAbsolutePath(), 'w')

f.write('This is a test.\n')

f.close()

# Special parameters

print 'Current academic session: %s' % session.getLabel()

if dept:

print 'Selected department: %s - %s' % (dept.getDeptCode(), dept.getLabel())

if subjects:

for subject in subjects:

print '&nbsp;&nbsp;&nbsp;%s - %s' % (subject.getSubjectAreaAbbreviation(), subject.getTitle())

if type:

t = hibSession.createQuery('from RoomType where reference = :reference').setString('reference', type).uniqueResult()

print 'Room type: %s (%d rooms in %s)' % (t.getLabel(), t.countRooms(session.getUniqueId()), session.getLabel())

# Progress

log.setStatus('Counting to ten. Slowly.', 10)

from java.lang import Thread

for i in range(10):

Thread.sleep(i * 1000)

log.incProgress()

log.debug('-- %d' % (1 + i))