gistfile1.txt

njero@alexandria:/var/www/bart$ rake db:migrate:reset RAILS_ENV=test
(in /private/var/www/bart)
== 20080711115602 CreateSessions: migrating ===================================
-- create_table(:sessions)
   -> 0.0022s
-- add_index(:sessions, :session_id)
   -> 0.0087s
-- add_index(:sessions, :updated_at)
   -> 0.0048s
== 20080711115602 CreateSessions: migrated (0.0171s) ==========================

== 20080802132925 AddRegimens: migrating ======================================
rake aborted!
Mysql::Error: Table 'openmrs_test.encounter' doesn't exist: CREATE VIEW patient_regimen_ingredients (ingredient_concept_id, regimen_concept_id, patient_id, encounter_id, dispensed_date) AS
  SELECT 
    regimen_ingredient.ingredient_id as ingredient_concept_id,
    regimen_ingredient.concept_id as regimen_concept_id,
    encounter.patient_id as patient_id, 
    encounter.encounter_id as encounter_id, 
    encounter.encounter_datetime as dispensed_date
  FROM encounter
  INNER JOIN orders ON orders.encounter_id = encounter.encounter_id
  INNER JOIN drug_order ON drug_order.order_id = orders.order_id
  INNER JOIN drug ON drug_order.drug_inventory_id = drug.drug_id
  INNER JOIN drug_ingredient as dispensed_ingredient ON drug.concept_id = dispensed_ingredient.concept_id
  INNER JOIN drug_ingredient as regimen_ingredient ON regimen_ingredient.ingredient_id = dispensed_ingredient.ingredient_id 
  INNER JOIN concept as regimen_concept ON regimen_ingredient.concept_id = regimen_concept.concept_id 
  WHERE encounter.encounter_type = 3 AND regimen_concept.class_id = 18 AND orders.voided = 0
  GROUP BY encounter.encounter_id, regimen_ingredient.concept_id, regimen_ingredient.ingredient_id;

(See full trace by running task with --trace)
njero@alexandria:/var/www/bart$ mysql -u root openmrs_test < db/schema.sql 
njero@alexandria:/var/www/bart$ rake db:migrate RAILS_ENV=test
(in /private/var/www/bart)
== 20080802132925 AddRegimens: migrating ======================================
== 20080802132925 AddRegimens: migrated (0.0041s) =============================

== 20080802141735 AddPrescriptions: migrating =================================
== 20080802141735 AddPrescriptions: migrated (0.0596s) ========================

== 20080802141956 AddStartDateAndRegistrationDates: migrating =================
== 20080802141956 AddStartDateAndRegistrationDates: migrated (0.0061s) ========

== 20080802143111 AddOutcomes: migrating ======================================
== 20080802143111 AddOutcomes: migrated (0.0118s) =============================

== 20080804092558 CreateWeightForHeight: migrating ============================
== 20080804092558 CreateWeightForHeight: migrated (0.0066s) ===================

njero@alexandria:/var/www/bart$ script/spec spec/models/patient_prescription_total_spec.rb 
F

1)
ActiveRecord::StatementInvalid in 'PatientPrescriptionTotal should have the view'
Mysql::Error: Table 'openmrs_test.patient_prescriptions_total' doesn't exist: SELECT * FROM `patient_prescriptions_total`     
/private/var/www/bart/app/models/patient_prescription_total.rb:13:in `find'
./spec/models/patient_prescription_total_spec.rb:9:
script/spec:4:

Finished in 2.130954 seconds

1 example, 1 failure