properties코드 복사# Common settingsspring.jpa.show-sql=truespring.jpa.properties.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect# Ensure data.sql is executedspring.sql.init.mode=always# Logginglogging.level.org.hibernate.SQL=DEBUGlogging.level.org.hibernate.type.descriptor.sql.BasicBinder=TRACE
sql코드 복사-- Initialize speciesINSERT INTO species (name, description) VALUES ('Dog', 'A common domestic animal');INSERT INTO species (name, description) VALUES ('Cat', 'A common domestic animal');INSERT INTO species (name, description) VALUES ('Parrot', 'A colorful bird');INSERT INTO species (name, description) VALUES ('Rabbit', 'A small mammal');INSERT INTO species (name, description) VALUES ('Koala', 'A herbivorous marsupial');INSERT INTO species (name, description) VALUES ('Squirrel', 'A small rodent');-- Initialize diseasesINSERT INTO disease (name, description) VALUES ('Constipation', 'A common digestive problem');INSERT INTO disease (name, description) VALUES ('Diabetes', 'A metabolic disease');INSERT INTO disease (name, description) VALUES ('Skin', 'Various skin conditions');INSERT INTO disease (name, description) VALUES ('Coat', 'Issues with coat health');INSERT INTO disease (name, description) VALUES ('Stomach', 'Gastrointestinal issues');INSERT INTO disease (name, description) VALUES ('Intestines', 'Intestinal issues');INSERT INTO disease (name, description) VALUES ('Digestion', 'Digestive problems');INSERT INTO disease (name, description) VALUES ('Tartar', 'Dental plaque');INSERT INTO disease (name, description) VALUES ('Oral', 'Oral health issues');INSERT INTO disease (name, description) VALUES ('Bone', 'Bone health issues');INSERT INTO disease (name, description) VALUES ('Joint', 'Joint problems');