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