DevOps, CI/CD and Automation

Hi,

for people hopping on the Oracle/PHP bandwagon, there's a PHP object oriented Web Application framework that supports Oracle 8.0.5, Oracle 8i, 9i and 10G.

It's called 'Achievo ATK' and can be found on http://www.achievo.org/atk

It makes developing a webinterface to an existing Oracle database pretty easy. It boils down to creating PHP classes around the tables, defining the relationships, and an application to manipulate the data (crud) is generated dynamically by the framework.

To give an example, a complete employee administration application for the 'emp/dept' tables from the scott schema is as much code as:

<?php

  userelation("atkmanytoonerelation");

  class employee extends atkNode
  {
    function employee()
    {
      $this->atkNode("employee");
      $this->add(new atkAttribute("empno", AF_AUTOKEY));
      $this->add(new atkAttribute("ename", 
                                    AF_SEARCHABLE));
      $this->add(new atkManyToOneRelation("deptno", 
                         "scott.department",
                         AF_SEARCHABLE));
      $this->setTable("emp");
    }
  }

?>

<?php

  class department extends atkNode
  {
    function department()
    {
      $this->atkNode("department");
      $this->add(new atkAttribute("deptno", AF_AUTOKEY));
      $this->add(new atkAttribute("dname", 
                                AF_SEARCHABLE));
    }

    function descriptor_def()
    {
      return "[dname]";
    }
  }
?>

The demo application that can be downloaded contains basic emp/dept examples, including the ability to edit a departments employees etc. A slightly different version (including manager link etc.) of the dept/emp example can be found on http://www.achievo.org/atk/demo, lesson 2 in the demo's menu.