Lisp HUG Maillist Archive

Problems with DEF-VIEW-CLASS

Hi

I think I am missing something with DEF-VIEW-CLASS.  Here is my  
example straight from the Gene Ontology (godatabase).  GENE_PRODUCT is  
a table in the (MySQL) db.


(def-view-class gps (standard-db-object)
   ((id :db-kind :key
        :type integer)
    (symbol :db-kind :base
            :reader gene-product-symbol)
    (dbxref_id :db-kind :base
               :reader gene-product-dbxref
               )
    (species_id :db-kind :base
                :reader gene-product-species-id
                )
    (type_id :db-kind :base
             :reader gene-product-type-id
             )
    (full_name :db-kind :base
               :reader gene-product-full-name
               ))
   (:documentation "The GENE-PRODUCT data base view class.")
   (:base-table gene_product)
   )

Then I do:

CL-USER 4 > sql:create-view-from-class 'godbtest::gps

Error: Table GODBTEST::GENE_PRODUCT already exists in database  
#<SQL::MYSQL-DATABASE "root{go_local}" 21BFC11B>
   1 (abort) Return to level 0.
   2 Return to top loop level 0.

Type :b for backtrace, :c <option number> to proceed,  or :? for other  
options



What am I missing?  Can't I create a view that is just a view of a  
table?

Thanks


--
Marco Antoniotti



Re: Problems with DEF-VIEW-CLASS

Unable to parse email body. Email id is 8802

Updated at: 2020-12-10 08:41 UTC