brunkb

class InventorySystem {

    boolean open(String token) {
        // open a socket connection to some back-end mainframe system
        println "opening connection to mainframe, token: ${token}"
        true
    }

    BigDecimal pricingLookup(String clientId, String itemUuid)
    {

brunkb

class InventorySystem {

    boolean open(String token) {
        // open a socket connection to some back-end mainframe system
        println "opening connection to mainframe, token: ${token}"
        true
    }

    BigDecimal pricingLookup(String clientId, String itemUuid)
    {

brunkb

class AuthenticationProvider {

    String authenticateUser(String username, String password) {
        "validToken"
    }
}

brunkb

class InventoryApiConnectionFactory {

       // these properties would ordinarily be injected
       def authenticationProvider = new AuthenticationProvider()
       String username  = "username"
       String password  = "password"
       
       def logError(String msg) { println msg } // simulated logger

    def withInventoryConnection(Closure c) {

brunkb

class PricingService {

    // would be injected
    InventoryApiConnectionFactory fac = new InventoryApiConnectionFactory()

    def priceLookup(String clientId, String itemUUID) {
        
        fac.withInventoryConnection { connection ->
            connection.pricingLookup(clientId, itemUUID)
        }

brunkb

PricingService ps = new PricingService()  // probably injected into a controller if this isn't a batch app

println ps.priceLookup("client1", "item-11-22-33")

brunkb

class PricingServiceFirstTry {

    // these dependencies would normally be injected
    AuthenticationProvider auth = new AuthenticationProvider()
    InventorySystem inv = new InventorySystem()
    String username = 'test'
    String password = 'test'
    
    def logError(String msg) { println msg } // simulated logger
    

brunkb

INSERT INTO myclobs (data, date_created) VALUES('<attrs><attr name="name"><string>Barney</string></attr></attrs>',
SYSDATE);

UPDATE myclobs m SET data=UPDATEXML(
    XMLTYPE.createXML(data),'/attrs/attr[@name="name"]/string /text()','Gumble').getClobVal()
WHERE m.id=26;

brunkb

update myclobs set data = '{ "changingTheJSON": "Test" }' where id=2

brunkb

DELETE FROM myclobs where id=21