The Bi-Polar Programmer

// [2015–02–26T07:45:03–06:00]
// [TODO] Write database tables
// [TODO] Write API Models
// [TODO] Write Proxy Classes for ajax
// [TODO] Write controllers
// [TODO] Write views

—- [2015–02–26T08:15:55–06:00]
—- write sequence since Oracle is too braindead to have an auto-increment
—- write trigger to implement sequence
—- coffee
—- google for calling sequence from trigger
—- screw it, I’ll add the unique sequence at the model level
—- create a table for sub-objects?

// [2015–02–26T09:32:46–06:00]
// no. no sub tables.
// write serializer to json-ify objects before shoving them in the database.

-— // [2015–02–26T09:52:16–06:00]
-— google: oracle alter table change column type
-— ALTER TABLE SYSDBA.MYTABLE MODIFY ( OBJECT1 CLOB );
-— ALTER TABLE SYSDBA.MYTABLE MODIFY ( OBJECT2 CLOB );
-— ALTER TABLE SYSDBA.MYTABLE MODIFY ( OBJECT3 CLOB );

// [2015–02–26T10:06:27–06:00]
// [TODo] write unit test to test object serializer.

#> phpunit 

DELETE FROM SYSDBA.MYTABLE

#> phpunit 

DELETE FROM SYSDBA.MYTABLE

#> phpunit 

DELETE FROM SYSDBA.MYTABLE

#> phpunit 

DELETE FROM SYSDBA.MYTABLE

// Google php orm oracle
// screw it. lunch.