CRUD

CRUD is a SOLoist sample application, a simple demo of a classical CRUD (Create, Read, Update, Delete) pattern for objects of a class.

The left-hand list box renders all objects of the class Person. When one is selected, its Bank Accounts are listed in the list box in the middle. When a Bank Account is selected, its slots can be edited in the slot editors on the right. A new Bank Account can be created, or an existing one can be deleted with the generic commands (the buttons at the bottom).

When a slot of a Bank Accoount is modified, as soon as its control loses its focus, the SOLoist notification mechanism updates all its manifestations on the page (try, for example, to change the number of an existing Bank Account and watch it in the list).

http://soloistdemo.org/SampleApplications/personsandbankaccounts.html
OQL Query: Persons
OQL Query: Bank Accounts

CreateAccountForPerson.java

public void execute() 
    // -------------<SOL id="399df754-74dc-47d2-bf14-83e6961185f2:___throw__" />
    // -------------<LOS id="399df754-74dc-47d2-bf14-83e6961185f2:___throw__" />
    {
        // ---------<SOL id="399df754-74dc-47d2-bf14-83e6961185f2:___body___" />
        Person p = person.val();
        if (p == null)
        {
        	throw new CommandPreconditionsException("Please, select person first.");
        }
 
        BankAccount ba = new BankAccount();
        ba.number.set(Text.fromString("xxx-xxx-xxx"));
        ba.amount.set(Currency.fromBigDecimal(BigDecimal.valueOf(0.)));
        ba.bankName.set(Text.fromString("New Bank"));
 
        p.accounts.add(ba);
        // ---------<LOS id="399df754-74dc-47d2-bf14-83e6961185f2:___body___" />
    }

package rs.sol.sampleapps;
 
import rs.sol.sampleapps.commands.CreateAccountForPerson;
import rs.sol.soloist.helpers.init.DefaultContextInit;
import rs.sol.soloist.helpers.init.Initializer;
import rs.sol.soloist.helpers.init.InitializerFailedException;
import rs.sol.soloist.server.builtindomains.builtincommands.CmdDestroyObject;
import rs.sol.soloist.server.guiconfiguration.components.GUIApplicationComponent;
import rs.sol.soloist.server.guiconfiguration.components.GUIButtonComponent;
import rs.sol.soloist.server.guiconfiguration.components.GUILabelComponent;
import rs.sol.soloist.server.guiconfiguration.components.GUIPanelComponent;
import rs.sol.soloist.server.guiconfiguration.construction.GUIComponentBinding;
import rs.sol.soloist.server.guiconfiguration.elementcomponents.GUIEdit;
import rs.sol.soloist.server.guiconfiguration.elementcomponents.GUIInput;
import rs.sol.soloist.server.guiconfiguration.layout.TableLayoutData;
import rs.sol.soloist.server.guiconfiguration.layout.VerticalAlignment;
import rs.sol.soloist.server.guiconfiguration.nonvisualcompoments.GUIFindAllInstancesSAPComponent;
import rs.sol.soloist.server.guiconfiguration.style.GUIContext;
import rs.sol.soloist.server.guiconfiguration.style.GUINumberTextFeature;
import rs.sol.soloist.server.guiconfiguration.style.GUIObjectSetting;
import rs.sol.soloist.server.guiconfiguration.style.GUIPictureFeature;
import rs.sol.soloist.server.guiconfiguration.style.GUITextFeature;
import rs.sol.soloist.server.server.SoloistServiceServlet;
 
public enum PersonsAndBankAccounts implements Initializer{
 
	INSTANCE;
 
	@Override
	public void init() throws InitializerFailedException
	{
		GUIApplicationComponent page = new GUIApplicationComponent(); // new web page
		page.setName("PersonsAndBankAccounts"); 
		SoloistServiceServlet.registerApplication(page);
 
		GUIContext context = createContextAndStyles(); 
		page.setContext(context);
 
		GUIPanelComponent root = GUIPanelComponent.createFlow(page);
 
		GUILabelComponent title = GUILabelComponent.create(root, "Persons and Bank Accounts");
		title.setStyle("titleStyle");
 
		GUIPanelComponent topPanel = GUIPanelComponent.createFlow(root);
		topPanel.setStyle("topPanel");
 
		GUIPanelComponent table = GUIPanelComponent.createTable(topPanel);
 
		// first row
		GUILabelComponent.create(table, "Persons", 0, 0);
		GUILabelComponent.create(table, "Person's Bank Accounts", 0, 1);
		GUILabelComponent.create(table, "Account Details", 0, 2);
 
		// second row
		// this component fetches all persons, it is invisible component but still, it has to have a parent
		GUIFindAllInstancesSAPComponent allPersons = GUIFindAllInstancesSAPComponent.create(root, Person.CLASSIFIER);
		GUIInput personsList = GUIInput.createList(table);
		personsList.setLayoutData(TableLayoutData.create(1, 0)); // shows all persons
		GUIComponentBinding.create(allPersons.opValue(), personsList.ipCollection());
		personsList.setSize("250px", "300px");
		personsList.setStyle("listWidget");
 
		GUIInput accountsList = GUIInput.createList(table, Person.PROPERTIES.accounts);
		accountsList.setLayoutData(TableLayoutData.create(1, 1));
		accountsList.setSize("250px", "300px");
		accountsList.setStyle("listWidget");
		GUIPanelComponent accountDetailsTable = GUIPanelComponent.createTable(table);
		accountDetailsTable.setRowColumn(1, 2); // place the accountDetailsTable
		accountDetailsTable.setCellAlignment(null, VerticalAlignment.TOP);
 
		// third row
		GUIButtonComponent createAccountButton = GUIButtonComponent.create(table, "Create Account for Person", new CreateAccountForPerson());
		createAccountButton.setLayoutData(TableLayoutData.create(2, 0));
		CmdDestroyObject destroyCmd = new CmdDestroyObject();
		destroyCmd.setType(BankAccount.CLASSIFIER);
		GUIButtonComponent destroyAccountButton = GUIButtonComponent.create(table, "Delete Account", destroyCmd);
		destroyAccountButton.setLayoutData(TableLayoutData.create(2, 1));
 
		// let's fill in the accoutDetailsTable
		GUILabelComponent.create(accountDetailsTable, "Number:", 0, 0);
		GUILabelComponent.create(accountDetailsTable, "Amount:", 1, 0);
		GUILabelComponent.create(accountDetailsTable, "Bank name:", 2, 0);
 
		GUIEdit numberEditor = GUIEdit.createField(accountDetailsTable, BankAccount.PROPERTIES.number, 0, 1);
		GUIEdit amountEditor = GUIEdit.createField(accountDetailsTable, BankAccount.PROPERTIES.amount, 1, 1);
		GUIEdit bankNameEditor = GUIEdit.createField(accountDetailsTable, BankAccount.PROPERTIES.bankName, 2, 1);
 
		// let's bind the components
		// account list will be populated for the selected person in the persons list
		GUIComponentBinding.create(personsList.opValue(), accountsList.ipSlotValueElement());
		// this specifies that account will be created for selected person
		GUIComponentBinding.create(personsList.opValue(), createAccountButton, CreateAccountForPerson.PROPERTIES.person);
		// this specifies that selected account will be destroyed
		GUIComponentBinding.create(accountsList.opValue(), destroyAccountButton, CmdDestroyObject.PROPERTIES.input);
		GUIComponentBinding.create(accountsList.opValue(), numberEditor.ipElement());
		GUIComponentBinding.create(accountsList.opValue(), amountEditor.ipElement());
		GUIComponentBinding.create(accountsList.opValue(), bankNameEditor.ipElement());
	}
 
	private GUIContext createContextAndStyles()
	{
		GUIContext context = new GUIContext();
		DefaultContextInit.getRoot().addContext(context);
 
		GUIObjectSetting bankAccount = GUIObjectSetting.create(context, BankAccount.CLASSIFIER);
		GUITextFeature.createName(bankAccount, BankAccount.PROPERTIES.number);
		GUITextFeature.createFixedSeparator(bankAccount, "/");
		GUINumberTextFeature.createDescription(bankAccount, BankAccount.PROPERTIES.amount);
		GUIPictureFeature.createSmallIcon(bankAccount, "images/icons/bankaccount.png");
 
		GUIObjectSetting person = GUIObjectSetting.create(context, Person.CLASSIFIER);
		GUITextFeature.createName(person, Person.PROPERTIES.name);
		GUITextFeature.createFixedSeparator(person, "Age:");
		GUITextFeature.createDescription(person, Person.PROPERTIES.age);
		GUIPictureFeature.createSmallIcon(person, "images/icons/person.png");
		return context;
	}
 
}