select * from all_constraints where table_name='TABLE_NAME' and owner='OWNER_NAME';
SELECT cols.table_name, cols.column_name, cols.position, cons.status, cons.owner
| 1) For a given UHID, I want the details in the Patient model as above | |
| 2) For a given UHID, I want a list of Textual and Numeric Results (Profiles and Special are also a part of the texual result) | |
| 3) For a given UHID, I want a list of Textual and Numeric Results, since a given Result Date | |
| 4) For a given UHID, get a list of encounters | |
| 5) For a given UHID, get a list of encounters since a given date | |
| 6) For a given encounter id, get a list of procedures | |
| 7) For a given encounter id, get the discharge summary | |
| 8) For a given Doctor ID, get me a the details in the doctor model. |
| # app/controllers/application_controller.rb | |
| class ApplicationController < ActionController::Base | |
| rescue_from(ActionController::RoutingError) { | |
| render :template => 'errors/404' | |
| } | |
| end | |
| # config/initializers/show_exceptions.rb | |
| require 'action_dispatch/middleware/show_exceptions' |
| // Copyright (c) 2011, the Dart project authors. Please see the AUTHORS file | |
| // for details. All rights reserved. Use of this source code is governed by a | |
| // BSD-style license that can be found in the LICENSE file. | |
| // Simple test program invoked with an option to eagerly | |
| // compile all code that is loaded in the isolate. | |
| // VMOptions=--compile_all | |
| class HelloDartTest { | |
| static testMain() { | |
| print("Hello, Darter!"); |
| global | |
| log 127.0.0.1 local0 | |
| log 127.0.0.1 local1 notice | |
| maxconn 4096 | |
| nbproc 1 | |
| pidfile /var/run/haproxy.pid | |
| user haproxy | |
| group haproxy |
| $:.unshift File.expand_path("#{File.dirname(__FILE__)}") | |
| APP_ROOT = File.expand_path(File.dirname(__FILE__)) | |
| puts APP_ROOT | |
| require 'sinatra' | |
| get '*' do | |
| rpath=File.join(APP_ROOT,params[:splat][0][1..-1]) | |
| mimetype = `file -Ib #{rpath}`.gsub(/\n/,"") | |
| puts "serving #{rpath} with mimetype #{mimetype}" | |
| send_file rpath, :stream=>true, :type=>mimetype, :disposition=>:inline |
| <!doctype html> | |
| <html> | |
| <head> | |
| <title>Segment Graph</title> | |
| <style> | |
| #segmentChart { | |
| width: 400px; | |
| height: 100px; | |
| } | |
| </style> |
| <!doctype html> | |
| <html> | |
| <head> | |
| <title>Segment Graph</title> | |
| <link href="//netdna.bootstrapcdn.com/twitter-bootstrap/2.1.1/css/bootstrap-combined.min.css" rel="stylesheet"> | |
| <style> | |
| #segmentChart { | |
| float: left; | |
| width: 400px; | |
| height: 100px; |
| var lib = require("./manifest.js"); | |
| lib.mkmanifest({ | |
| filename : "cache" | |
| ,path : "../coffee" | |
| ,version : "02" | |
| ,exclude : ['/.DS_Store', '/.htaccess', '/cache.manifest'] | |
| /* | |
| ,network : ['/connect.php','/read.php'] | |
| ,fallback : ['/offline.html'] |
| // Load Ember into the global scope by requiring it | |
| require('ember'); | |
| // Go have fun | |
| var app = Ember.Application.create(); |