X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=tests%2Ftest-init.lisp;h=730169132db572e594d56de0d4ff815e6376ea4a;hb=7cffee5771647bc8ab8dc6de6891fb3829523d32;hp=99c3a47c5abbd215a1f472ba7700d2d3c22fd097;hpb=aced01441ccf8a826de544ed34bed4d8616a14ee;p=clsql.git diff --git a/tests/test-init.lisp b/tests/test-init.lisp index 99c3a47..7301691 100644 --- a/tests/test-init.lisp +++ b/tests/test-init.lisp @@ -64,14 +64,14 @@ :accessor employee-email :type (string 100) :initarg :email) - (companyid + (ecompanyid :type integer :initarg :companyid) (company :accessor employee-company :db-kind :join :db-info (:join-class company - :home-key companyid + :home-key ecompanyid :foreign-key companyid :set nil)) (managerid @@ -89,7 +89,7 @@ :db-kind :join :db-info (:join-class employee-address :home-key emplid - :foreign-key emplid + :foreign-key aemplid :target-slot address :set t))) (:base-table employee)) @@ -123,10 +123,8 @@ :db-kind :join :db-info (:join-class employee :home-key (companyid groupid) - :foreign-key (companyid groupid) - :set t))) - (:base-table company)) - + :foreign-key (ecompanyid groupid) + :set t)))) (def-view-class address () ((addressid @@ -150,19 +148,21 @@ :column "zip" :type integer :void-value 0 - :initarg :postal-code))) + :initarg :postal-code)) + (:base-table addr)) ;; many employees can reside at many addressess (def-view-class employee-address () - ((emplid :type integer + ((aemplid :type integer :initarg :emplid) - (addressid :type integer + (aaddressid :type integer :initarg :addressid) (address :db-kind :join :db-info (:join-class address - :home-key addressid + :home-key aaddressid :foreign-key addressid - :retrieval :immediate)))) + :retrieval :immediate))) + (:base-table "ea_join")) (defun test-connect-to-database (db-type spec) (when (db-backend-has-create/destroy-db? db-type)