Commits

Kirill Simonov  committed 181bb9a

Enabled several SQLite tests.

  • Participants
  • Parent commits 2e7cd81

Comments (0)

Files changed (3)

File test/input/translation.yaml

     - uri: /{count(school),this(){count(school)}?true(),this(){count(school)}?false()}
     - uri: /school{code,name,this(){code}?name!~'art',
                    root().school{code}?name!~'art'}
-      ifndef: sqlite    # no support for `~` operator yet
     - uri: /school{name,count(department),this(){count(department)}?name!~'art'}
-      ifndef: sqlite    # no support for `~` operator yet
     - uri: /school{name,exists(department),this(){exists(department)}?name!~'art'}
-      ifndef: sqlite    # no support for `~` operator yet
 
   - title: Table Expressions
     tests:

File test/input/tutorial.yaml

   # Comparison Operators
   - uri: /course?title='Drawing'
   - uri: /course?title~'lab'
-    ifndef: sqlite  # no support for `~` operator yet
   - uri: /course?title!~'lab'
-    ifndef: sqlite  # no support for `~` operator yet
   - uri: /course?title!='Organic Chemistry Laboratory I'
   - uri: /course{department,number,title}?number=101
   - uri: /course?department!={'arthis','stdart'}

File test/output/sqlite.yaml

              FROM "course" AS "course"
              WHERE ("course"."title" = 'Drawing')
              ORDER BY 1 ASC, 2 ASC
+        - uri: /course?title~'lab'
+          status: 200 OK
+          headers:
+          - [Content-Type, text/plain; charset=UTF-8]
+          body: |2
+             | (course?title~'lab')                                                                                |
+            -+-----------------------------------------------------------------------------------------------------+-
+             | department | number | title                            | credits | description                      |
+            -+------------+--------+----------------------------------+---------+----------------------------------+-
+             | astro      |    142 | Solar System Lab                 |       2 | Laboratory studies that          |
+             :            :        :                                  :         : complement the lecture course    :
+             :            :        :                                  :         : ASTRO 137.                       :
+             | chem       |    115 | Organic Chemistry Laboratory I   |       2 | Complements Organic Chemistry I. |
+             :            :        :                                  :         : Practical laboratory             :
+             :            :        :                                  :         : experiments.                     :
+             | chem       |    314 | Laboratory Chemistry             |       3 | Experimental chemistry for       |
+             :            :        :                                  :         : students who are planning to     :
+             :            :        :                                  :         : major in chemistry. Covers       :
+             :            :        :                                  :         : principles and applications of   :
+             :            :        :                                  :         : chemical laboratory techniques,  :
+             :            :        :                                  :         : including preparation and        :
+             :            :        :                                  :         : analysis of chemical materials.  :
+             | comp       |    710 | Laboratory in Computer Science   |       4 | Independent research opportunity |
+             :            :        :                                  :         : using the university computer    :
+             :            :        :                                  :         : lab. Requires instructor         :
+             :            :        :                                  :         : permission and may be repeated.  :
+             | ee         |    412 | Laboratory in Electrical         |       4 | Hands-on experience covering     |
+             :            :        : Engineering                      :         : areas of optical transforms,     :
+             :            :        :                                  :         : electro-optics devices, signal   :
+             :            :        :                                  :         : processing, fiber optics         :
+             :            :        :                                  :         : transmission, and holography.    :
+             | psych      |    450 | Laboratory in Applied Behavioral |       4 | This course will provide         |
+             :            :        : Science                          :         : students with hands-on training  :
+             :            :        :                                  :         : in the application of behavioral :
+             :            :        :                                  :         : research technology to a         :
+             :            :        :                                  :         : clinical population.             :
+                                                                                                            (6 rows)
+
+             ----
+             /course?title~'lab'
+             SELECT "course"."department",
+                    "course"."number",
+                    "course"."title",
+                    "course"."credits",
+                    "course"."description"
+             FROM "course" AS "course"
+             WHERE ("course"."title" LIKE '%lab%' ESCAPE '\')
+             ORDER BY 1 ASC, 2 ASC
+        - uri: /course?title!~'lab'
+          status: 200 OK
+          headers:
+          - [Content-Type, text/plain; charset=UTF-8]
+          body: |2
+             | (course?title!~'lab')                                                                               |
+            -+-----------------------------------------------------------------------------------------------------+-
+             | department | number | title                            | credits | description                      |
+            -+------------+--------+----------------------------------+---------+----------------------------------+-
+             | acc        |    100 | Practical Bookkeeping            |       2 |                                  |
+             | acc        |    200 | Principles of Accounting I       |       3 | The initial course in the theory |
+             :            :        :                                  :         : and practice of financial        :
+             :            :        :                                  :         : accounting. Topics emphasized    :
+             :            :        :                                  :         : include the preparation,         :
+             :            :        :                                  :         : reporting, and analysis of       :
+             :            :        :                                  :         : financial data.                  :
+             | acc        |    315 | Financial Accounting             |       5 | Integration of the conceptual    |
+             :            :        :                                  :         : and computational aspects of     :
+             :            :        :                                  :         : asset, liability and             :
+             :            :        :                                  :         : stockholders equity accounting.  :
+             | acc        |    426 | Corporate Taxation               |       3 | Concepts and methods of          |
+             :            :        :                                  :         : determining federal tax          :
+             :            :        :                                  :         : liability of corporations.       :
+             | acc        |    527 | Advanced Accounting              |       3 | Theory and practical             |
+             :            :        :                                  :         : applications of accounting for   :
+             :            :        :                                  :         : consolidated entities and        :
+             :            :        :                                  :         : partnerships; includes foreign   :
+             :            :        :                                  :         : currency transactions, hedging   :
+             :            :        :                                  :         : and derivatives.                 :
+             | acc        |    606 | Corporate Financial Law          |       3 | Law governing business           |
+             :            :        :                                  :         : corporations; fiduciary duties   :
+             :            :        :                                  :         : of managers and directors in     :
+             :            :        :                                  :         : situations such as mergers,      :
+             :            :        :                                  :         : acquisitions, securities         :
+             :            :        :                                  :         : offerings, market domination,    :
+             :            :        :                                  :         : litigation.                      :
+             | arthis     |    202 | History of Art Criticism         |       3 | An introductory survey course on |
+             :            :        :                                  :         : Prehistoric through              :
+             :            :        :                                  :         : late-Medieval art history.       :
+             | arthis     |    340 | Arts of Asia                     |       3 | An introduction to the history   |
+             :            :        :                                  :         : and criticism of Far Eastern     :
+             :            :        :                                  :         : art, including the art of China  :
+             :            :        :                                  :         : and Japan, fine and decorative   :
+             :            :        :                                  :         : arts.                            :
+             | arthis     |    623 | Contemporary Latin American Art  |       3 | A survey of the last twenty      |
+             :            :        :                                  :         : years of Latin American art with :
+             :            :        :                                  :         : a focus on the Caribbean and     :
+             :            :        :                                  :         : Central America.                 :
+             | arthis     |    710 | Methods in Art History           |       3 | This seminar focuses on basic    |
+             :            :        :                                  :         : types of art-historical method.  :
+             :            :        :                                  :         : Some meetings focus on a single  :
+             :            :        :                                  :         : author who exemplifies a         :
+             :            :        :                                  :         : particular approach.             :
+             | arthis     |    712 | Museum and Gallery Management    |       4 | Supervised independent field     |
+             :            :        :                                  :         : experience and practical work in :
+             :            :        :                                  :         : all areas of Art Museum          :
+             :            :        :                                  :         : management in the university and :
+             :            :        :                                  :         : greater metropolitan area        :
+             :            :        :                                  :         : communities.                     :
+             | arthis     |    809 | Materials and Construction in    |       3 | A scientific examination of the  |
+             :            :        : European Art                     :         : materials and manufacturing      :
+             :            :        :                                  :         : techniques employed in Europe    :
+             :            :        :                                  :         : over the last two centuries.     :
+             | astro      |    137 | The Solar System                 |       3 | Introductory survey of the solar |
+             :            :        :                                  :         : system, including structure and  :
+             :            :        :                                  :         : motion of the planets,           :
+             :            :        :                                  :         : properties of the sun, and       :
+             :            :        :                                  :         : comparison to extrasolar         :
+             :            :        :                                  :         : systems.                         :
+             | astro      |    155 | Telescope Workshop               |       1 | Introduction to correct use of   |
+             :            :        :                                  :         : the 8-inch Schmidt-Cassegrain    :
+             :            :        :                                  :         : type telescope. You will learn   :
+             :            :        :                                  :         : about magnification, how to      :
+             :            :        :                                  :         : locate an object, and how        :
+             :            :        :                                  :         : setting circles work.            :
+             | astro      |    254 | Life in the Universe             |       3 | Nature and origin of large       |
+             :            :        :                                  :         : numbers in the cosmos, the       :
+             :            :        :                                  :         : formation of planets, formation  :
+             :            :        :                                  :         : of life, and the anthropic       :
+             :            :        :                                  :         : principle.                       :
+             | be         |    112 | Introduction to Biomedical       |       3 | This course covers topics in     |
+             :            :        : Engineering                      :         : multiple formats ranging from    :
+             :            :        :                                  :         : lectures by faculty or guest     :
+             :            :        :                                  :         : speakers to presentations by     :
+             :            :        :                                  :         : participating students.          :
+             | be         |    308 | Fundamentals of Biochemistry     |       3 | Fundamental aspects of human     |
+             :            :        :                                  :         : biochemistry are introduced in   :
+             :            :        :                                  :         : this course for students in the  :
+             :            :        :                                  :         : bioinstrumentation/biosensors,   :
+             :            :        :                                  :         : biomechanics, and                :
+             :            :        :                                  :         : medical-imaging tracks.          :
+             | be         |    415 | Internship in Biomedical         |       8 | The student will work twenty     |
+             :            :        : Engineering                      :         : hours per week in an area firm   :
+             :            :        :                                  :         : to gain experience in the        :
+             :            :        :                                  :         : application of biomedical        :
+             :            :        :                                  :         : engineering principles in an     :
+             :            :        :                                  :         : industrial setting.              :
+             | be         |    509 | Systems of Drug Delivery         |       3 | The mathematics of diffusion     |
+             :            :        :                                  :         : through various types of         :
+             :            :        :                                  :         : biological media is discussed.   :
+             | capmrk     |    712 | International Financial Markets  |       3 | Offers an understanding of the   |
+             :            :        :                                  :         : international financial          :
+             :            :        :                                  :         : structure and studies its impact :
+             :            :        :                                  :         : on business and individuals in   :
+             :            :        :                                  :         : various nations.                 :
+             | capmrk     |    756 | Capital Risk Management          |       3 | This course introduces           |
+             :            :        :                                  :         : fundamental principles and       :
+             :            :        :                                  :         : techniques of financial risk     :
+             :            :        :                                  :         : management.                      :
+             | capmrk     |    808 | Principles of Portfolio          |       3 | Comprehensive coverage of the    |
+             :            :        : Management                       :         : theory and practice of money     :
+             :            :        :                                  :         : management as well as in-depth   :
+             :            :        :                                  :         : analysis of the theory and       :
+             :            :        :                                  :         : practice involved when           :
+             :            :        :                                  :         : securities are combined into     :
+             :            :        :                                  :         : portfolios.                      :
+             | capmrk     |    818 | Financial Statement Analysis     |       3 | This course presents techniques  |
+             :            :        :                                  :         : for analyzing current and        :
+             :            :        :                                  :         : projected financial statements   :
+             :            :        :                                  :         : for the purposes of credit       :
+             :            :        :                                  :         : analysis, security analysis, and :
+             :            :        :                                  :         : internal financial analysis, and :
+             :            :        :                                  :         : cash flow forecasting.           :
+             | chem       |    100 | Principles of Chemistry          |       3 | This course offers an            |
+             :            :        :                                  :         : introduction to the biological,  :
+             :            :        :                                  :         : inorganic, and chemical          :
+             :            :        :                                  :         : molecules, with an emphasis on   :
+             :            :        :                                  :         : basic principles of atomic and   :
+             :            :        :                                  :         : molecular electronic structure.  :
+             | chem       |    110 | Organic Chemistry I              |       3 | This course offers a practical   |
+             :            :        :                                  :         : introduction to organic          :
+             :            :        :                                  :         : chemistry, including a full set  :
+             :            :        :                                  :         : of problem sets with solutions.  :
+             :            :        :                                  :         : Focus is on the basic principles :
+             :            :        :                                  :         : of understanding the structure   :
+             :            :        :                                  :         : and reactivity of organic        :
+             :            :        :                                  :         : molecules.                       :
+             | chem       |    655 | Protein Folding Problem          |       3 | Focuses on the mechanisms        |
+             :            :        :                                  :         : through which the amino acid     :
+             :            :        :                                  :         : sequence of polypeptide chains   :
+             :            :        :                                  :         : determine their                  :
+             :            :        :                                  :         : three-dimensional conformation.  :
+             | comp       |    102 | Introduction to Computer Science |       3 | This course in an introduction   |
+             :            :        :                                  :         : to the discipline of computer    :
+             :            :        :                                  :         : science. Topics include          :
+             :            :        :                                  :         : algorithmic foundations,         :
+             :            :        :                                  :         : hardware concepts, virtual       :
+             :            :        :                                  :         : machine concepts, software       :
+             :            :        :                                  :         : systems, applications, and       :
+             :            :        :                                  :         : social issues.                   :
+             | comp       |    230 | History of Computing             |       3 | This course will survey the      |
+             :            :        :                                  :         : history of the computing field   :
+             :            :        :                                  :         : from antiquity to the present,   :
+             :            :        :                                  :         : focusing on the era of the       :
+             :            :        :                                  :         : electronic digital computer.     :
+             :            :        :                                  :         : Topics will include historical   :
+             :            :        :                                  :         : developments in hardware,        :
+             :            :        :                                  :         : software, and the theoretical    :
+             :            :        :                                  :         : foundations of computer science. :
+             | comp       |    350 | Introduction to Signal           |       3 | This course covers the nature of |
+             :            :        : Processing                       :         : information, signals,            :
+             :            :        :                                  :         : transforms, and applications.    :
+             :            :        :                                  :         : Topics include analog to digital :
+             :            :        :                                  :         : and digital to analog            :
+             :            :        :                                  :         : conversion, data storage (such   :
+             :            :        :                                  :         : as the audio format MP3), data   :
+             :            :        :                                  :         : transforms, and filters.         :
+             | comp       |    615 | Introduction to Automata         |       3 | Theory of computing devices and  |
+             :            :        :                                  :         : the languages they recognize.    :
+             | comp       |    810 | Thesis Research                  |       3 | Guided research leading to       |
+             :            :        :                                  :         : production of the thesis.        :
+             :            :        :                                  :         : Requires instructor permission   :
+             :            :        :                                  :         : and may be repeated.             :
+             | comp       |    819 | Advanced Algorithms in           |       3 | This course is focused on        |
+             :            :        : Bioinformatics                   :         : fundamental algorithmic          :
+             :            :        :                                  :         : techniques in Bioinformatics,    :
+             :            :        :                                  :         : including classed methods such   :
+             :            :        :                                  :         : as dynamic programming, support  :
+             :            :        :                                  :         : vector machines and other        :
+             :            :        :                                  :         : statistical and learning         :
+             :            :        :                                  :         : optimization methods.            :
+             | corpfi     |    234 | Accounting Information Systems   |       3 | This course bridges the gap      |
+             :            :        :                                  :         : between two disciplines critical :
+             :            :        :                                  :         : to business operations.  This    :
+             :            :        :                                  :         : course of study teaches students :
+             :            :        :                                  :         : to design and deploy information :
+             :            :        :                                  :         : technology to improve the        :
+             :            :        :                                  :         : accounting systems of an         :
+             :            :        :                                  :         : organization.                    :
+             | corpfi     |    404 | Corporate Financial Management   |       3 | This course covers advanced      |
+             :            :        :                                  :         : topics in corporate financial    :
+             :            :        :                                  :         : management, including its role   :
+             :            :        :                                  :         : in corporate governance.         :
+             | corpfi     |    601 | Case Studies in Corporate        |       3 | A course designed to use case    |
+             :            :        : Finance                          :         : studies and financial analysis   :
+             :            :        :                                  :         : to further knowledge and ability :
+             :            :        :                                  :         : to make financial management     :
+             :            :        :                                  :         : decisions.                       :
+             | edpol      |    202 | Technology in the Classroom      |       3 | Theories and practice of using   |
+             :            :        :                                  :         : educational technologies to      :
+             :            :        :                                  :         : support problem-based learning.  :
+             | edpol      |    313 | Technology, Society and Schools  |       3 | Examination of theories and      |
+             :            :        :                                  :         : history of interaction of        :
+             :            :        :                                  :         : society and technology with      :
+             :            :        :                                  :         : implications for instructional   :
+             :            :        :                                  :         : technology and schooling.        :
+             :            :        :                                  :         : Resources for constructing       :
+             :            :        :                                  :         : personal definitions of          :
+             :            :        :                                  :         : technology.                      :
+             | edpol      |    505 | Qualitative Research for         |       3 | This course provides an          |
+             :            :        : Educators                        :         : introduction to qualitative      :
+             :            :        :                                  :         : research at the Master level.    :
+             | edpol      |    551 | Classroom Visit                  |         | Elective visit to a local        |
+             :            :        :                                  :         : classroom for observation.       :
+             | edpol      |    617 | Educational Policy Analysis      |       3 | Frameworks for analyzing,        |
+             :            :        :                                  :         : designing policy proposals, and  :
+             :            :        :                                  :         : implementing plans.              :
+             | ee         |    107 | Exploration of Electrical        |       3 | "Exploration of electrical       |
+             :            :        : Engineering                      :         : engineering through several      :
+             :            :        :                                  :         : hands-on activities that cover a :
+             :            :        :                                  :         : broad spectrum of applications   :
+             :            :        :                                  :         : and fundamental concepts. "      :
+             | ee         |    202 | Engineering Electromagnetics     |       3 | Static electric and magnetic     |
+             :            :        :                                  :         : fields; solutions to static      :
+             :            :        :                                  :         : field problems, electromagnetic  :
+             :            :        :                                  :         : waves, boundary conditions,      :
+             :            :        :                                  :         : engineering applications.        :
+             | ee         |    505 | Information Theory               |       3 | Mathematical measurement of      |
+             :            :        :                                  :         : information; information         :
+             :            :        :                                  :         : transfer in discrete systems;    :
+             :            :        :                                  :         : redundancy, efficiency, and      :
+             :            :        :                                  :         : channel capacity; encoding       :
+             :            :        :                                  :         : systems.                         :
+             | ee         |    615 | Learning and Adaptive Systems    |       3 | Adaptive and learning control    |
+             :            :        :                                  :         : systems; system identification;  :
+             :            :        :                                  :         : performance indices; gradient,   :
+             :            :        :                                  :         : stochastic approximation,        :
+             :            :        :                                  :         : controlled random search         :
+             :            :        :                                  :         : methods; introduction to pattern :
+             :            :        :                                  :         : recognition.                     :
+             | eng        |    101 | Introduction to Composition      |       3 | Provides students with the       |
+             :            :        :                                  :         : fundamental skills to read,      :
+             :            :        :                                  :         : interpret, and write critically  :
+             :            :        :                                  :         : at the college level.            :
+             | eng        |    175 | College Newspaper                |       2 | Students will perform            |
+             :            :        :                                  :         : journalistic writing exercises   :
+             :            :        :                                  :         : for publication in the college   :
+             :            :        :                                  :         : newspaper.                       :
+             | eng        |    247 | Boccaccio's Decameron            |       3 | Follows of the arc of of the     |
+             :            :        :                                  :         : career Boccaccio with an         :
+             :            :        :                                  :         : emphasis on the Decameron, which :
+             :            :        :                                  :         : is read in light of its cultural :
+             :            :        :                                  :         : density and contextualized in    :
+             :            :        :                                  :         : terms of its antecedents,        :
+             :            :        :                                  :         : especially the Commedia of       :
+             :            :        :                                  :         : Dante.                           :
+             | eng        |    276 | Introduction to Science Writing  |       3 | This course provides an          |
+             :            :        :                                  :         : introduction to science writing. :
+             :            :        :                                  :         : Students will learn about the    :
+             :            :        :                                  :         : business of science writing and  :
+             :            :        :                                  :         : will become familiar with the    :
+             :            :        :                                  :         : craft of making complex          :
+             :            :        :                                  :         : scientific research              :
+             :            :        :                                  :         : understandable for the general   :
+             :            :        :                                  :         : public.                          :
+             | eng        |    311 | Writing Styles                   |       3 | This practical course aids in    |
+             :            :        :                                  :         : understanding and writing        :
+             :            :        :                                  :         : non-fiction. We will look at     :
+             :            :        :                                  :         : some of the ways that prominent  :
+             :            :        :                                  :         : English writers have constructed :
+             :            :        :                                  :         : their sentences and paragraphs.  :
+             :            :        :                                  :         : Students will write weekly       :
+             :            :        :                                  :         : exercises exploring these        :
+             :            :        :                                  :         : stylistic patterns.              :
+             | eng        |    412 | Ecology Writing Workshop         |       2 | This monthly workshop will focus |
+             :            :        :                                  :         : on creation of a course          :
+             :            :        :                                  :         : assignment, a feature-length     :
+             :            :        :                                  :         : magazine article covering a      :
+             :            :        :                                  :         : complex topic in ecology.        :
+             | hist       |    112 | The United States in World       |       3 | Examines the meaning of empire   |
+             :            :        : History                          :         : in relationship to the           :
+             :            :        :                                  :         : historical development of the    :
+             :            :        :                                  :         : United States of America.        :
+             | hist       |    212 | Historical Perspective on the    |       3 | This course covers the           |
+             :            :        : Constitution                     :         : development of the               :
+             :            :        :                                  :         : constitutional doctrine from     :
+             :            :        :                                  :         : 1787 to the present. The         :
+             :            :        :                                  :         : Constitution as an experiment in :
+             :            :        :                                  :         : Republicanism.                   :
+             | hist       |    333 | History of American Education    |       3 | A study of informal and formal   |
+             :            :        :                                  :         : education in American history    :
+             :            :        :                                  :         : leading to an understanding of   :
+             :            :        :                                  :         : present educational theory and   :
+             :            :        :                                  :         : practice.                        :
+             | hist       |    415 | History of the Family in Global  |       3 | Has the family really declined?  |
+             :            :        : Perspective                      :         : What has changed in the last     :
+             :            :        :                                  :         : 1000 years? Drawing on           :
+             :            :        :                                  :         : cross-cultural examples,         :
+             :            :        :                                  :         : primarily from Latin America,    :
+             :            :        :                                  :         : the U.S. and Europe, this        :
+             :            :        :                                  :         : seminar explores the varieties   :
+             :            :        :                                  :         : of domestic forms.               :
+             | hist       |    505 | Science and History              |       3 | Introduces students to           |
+             :            :        :                                  :         : approaches and methods in the    :
+             :            :        :                                  :         : history of science, technology,  :
+             :            :        :                                  :         : and medicine                     :
+             | lang       |    201 | Introduction to Spanish          |       4 | Introduction to the Spanish      |
+             :            :        :                                  :         : language, with an emphasis on    :
+             :            :        :                                  :         : every day conversation and basic :
+             :            :        :                                  :         : grammar.                         :
+             | lang       |    203 | Intermediate Spanish             |       3 | Continuation of fundamental      |
+             :            :        :                                  :         : Spanish language learning,       :
+             :            :        :                                  :         : including verb tenses, reading   :
+             :            :        :                                  :         : skills, and basic conversation.  :
+             | lang       |    207 | Child Second Language            |       3 | Examines issues in child second  |
+             :            :        : Development                      :         : language acquisition, including  :
+             :            :        :                                  :         : the critical period hypothesis   :
+             :            :        :                                  :         : and universal grammar.           :
+             | lang       |    304 | Spanish Conversation Group       |       2 | Informal weekly conversation     |
+             :            :        :                                  :         : group designed to improve        :
+             :            :        :                                  :         : understanding of spoken Spanish. :
+             :            :        :                                  :         : Suitable for both majors and     :
+             :            :        :                                  :         : casual speakers who wish to      :
+             :            :        :                                  :         : improve their skills for         :
+             :            :        :                                  :         : personal enjoyment or travel.    :
+             | lang       |    305 | Second Language Syntax           |       3 | This course examines the form    |
+             :            :        :                                  :         : and acquisition of nonnative     :
+             :            :        :                                  :         : syntax. Consideration of whether :
+             :            :        :                                  :         : nonnative grammars are           :
+             :            :        :                                  :         : fundamentally different than     :
+             :            :        :                                  :         : native grammars.                 :
+             | me         |    111 | Introduction to Mechanical       |       3 | Topics include an overview of    |
+             :            :        : Engineering                      :         : career opportunities, problem    :
+             :            :        :                                  :         : solving processes, an            :
+             :            :        :                                  :         : introduction to the basic        :
+             :            :        :                                  :         : engineering design process,      :
+             :            :        :                                  :         : professionalism, professional    :
+             :            :        :                                  :         : registration, and ethics.        :
+             | me         |    344 | Undergraduate Research           |       4 | Undergraduates will conduct      |
+             :            :        :                                  :         : independent research activities  :
+             :            :        :                                  :         : under the direction of their     :
+             :            :        :                                  :         : major adviser.                   :
+             | me         |    501 | Advanced Welding                 |       3 | Advanced applications of welding |
+             :            :        :                                  :         : and machine tool technology.     :
+             :            :        :                                  :         : Computer numerical control,      :
+             :            :        :                                  :         : multi-axis machining set-up, gas :
+             :            :        :                                  :         : tungsten arc welding, and gas    :
+             :            :        :                                  :         : metal arch welding.              :
+             | me         |    627 | Advanced Heating and Air         |       4 | ""                               |
+             :            :        : Conditioning                     :         :                                  :
+             | me         |    712 | Graphic Communication and Design |       3 | Sketching and orthographic       |
+             :            :        :                                  :         : projection. Covers detail and    :
+             :            :        :                                  :         : assembly working drawings,       :
+             :            :        :                                  :         : dimensioning, tolerance          :
+             :            :        :                                  :         : specification, and design        :
+             :            :        :                                  :         : projects.                        :
+             | mth        |    101 | College Algebra                  |       5 | This course, taken mostly by     |
+             :            :        :                                  :         : members from the School of       :
+             :            :        :                                  :         : Business is a primary graduate   :
+             :            :        :                                  :         : student funding vehicle for the  :
+             :            :        :                                  :         : the Department of                :
+             :            :        :                                  :         : Mathematics.  This is a 1000     :
+             :            :        :                                  :         : person lecture reviews basic     :
+             :            :        :                                  :         : concepts taught in high school.  :
+             | phys       |    211 | General Physics I                |       3 | This course deals primarily with |
+             :            :        :                                  :         : motions of objects and the       :
+             :            :        :                                  :         : forces that underlie these       :
+             :            :        :                                  :         : motions, including free fall,    :
+             :            :        :                                  :         : collisions between objects,      :
+             :            :        :                                  :         : rolling, and spinning.           :
+             | phys       |    303 | Relativity & Cosmology           |       3 | The course will describe         |
+             :            :        :                                  :         : developments that led to special :
+             :            :        :                                  :         : relativity and its implications  :
+             :            :        :                                  :         : about the nature of space and    :
+             :            :        :                                  :         : time, as well as general         :
+             :            :        :                                  :         : relativity and quantum           :
+             :            :        :                                  :         : mechanics.                       :
+             | phys       |    388 | Experimental Physics I           |       2 | In this course students will     |
+             :            :        :                                  :         : perform several experiments in   :
+             :            :        :                                  :         : different areas of physics. They :
+             :            :        :                                  :         : will also learn fundamental      :
+             :            :        :                                  :         : experimental techniques and how  :
+             :            :        :                                  :         : to record and report results and :
+             :            :        :                                  :         : perform analysis.                :
+             | phys       |    512 | Quantum Field Theory             |       3 | This course will cover the basic |
+             :            :        :                                  :         : quantization of bosonic and      :
+             :            :        :                                  :         : fermionic fields, discrete       :
+             :            :        :                                  :         : spacetime symmetries,            :
+             :            :        :                                  :         : perturbative methods in QFT,     :
+             :            :        :                                  :         : definition of the S-matrix for   :
+             :            :        :                                  :         : scattering and decay processes.  :
+             | phys       |    713 | Quarks, Nuclei, and Cosmology    |       3 | General topics covered will      |
+             :            :        :                                  :         : include the structure of the     :
+             :            :        :                                  :         : nucleon, beta decay and weak     :
+             :            :        :                                  :         : interactions, and                :
+             :            :        :                                  :         : nucleon-nucleon interaction.     :
+             | phys       |    819 | Superconductivity                |       3 | This course provides a           |
+             :            :        :                                  :         : phenomenological approach to     :
+             :            :        :                                  :         : superconductivity, emphasizing   :
+             :            :        :                                  :         : super-conducting electronics.    :
+             | poli       |    113 | American Government and Politics |       3 | This course examines the         |
+             :            :        :                                  :         : structure, services, functions,  :
+             :            :        :                                  :         : and problems of government and   :
+             :            :        :                                  :         : politics at the national level.  :
+             | poli       |    347 | American Foreign Policy          |       3 | Theories, processes, and problem |
+             :            :        :                                  :         : of American foreign policy and   :
+             :            :        :                                  :         : the craft of diplomacy, with     :
+             :            :        :                                  :         : special attention to             :
+             :            :        :                                  :         : contemporary issues.             :
+             | poli       |    402 | Government Internship: Semester  |       4 | Junior or seniors with a 3.0     |
+             :            :        : in Washington                    :         : grade point average or higher    :
+             :            :        :                                  :         : may apply for a limited number   :
+             :            :        :                                  :         : of internship opportunities in   :
+             :            :        :                                  :         : Washington, DC. Interns will     :
+             :            :        :                                  :         : live at University House on      :
+             :            :        :                                  :         : Capitol Hill and continue their  :
+             :            :        :                                  :         : normal class schedule at the DC  :
+             :            :        :                                  :         : Campus.                          :
+             | poli       |    431 | American Government and          |       3 | This course will examine the     |
+             :            :        : Corporate Interests              :         : methods by which American        :
+             :            :        :                                  :         : business exert influence over    :
+             :            :        :                                  :         : legislators and the legislative  :
+             :            :        :                                  :         : process.                         :
+             | poli       |    644 | Research Seminar in Middle       |       3 | Government and Politics of the   |
+             :            :        : Eastern Affairs                  :         : Middle East and North Africa     :
+             :            :        :                                  :         : Spring. Historical background,   :
+             :            :        :                                  :         : contemporary setting, political  :
+             :            :        :                                  :         : processes, and major problems of :
+             :            :        :                                  :         : some of the countries of Middle  :
+             :            :        :                                  :         : East and North Africa.           :
+             | poli       |    715 | #5 is the 50% Solution           |       3 | A history of the two-state       |
+             :            :        :                                  :         : solution and other approaches to :
+             :            :        :                                  :         : Palestian Statehood              :
+             | psych      |    102 | General Psychology               |       3 | This course introduces the       |
+             :            :        :                                  :         : student to the major topics in   :
+             :            :        :                                  :         : scientific psychology as applied :
+             :            :        :                                  :         : to human behavior. Applications  :
+             :            :        :                                  :         : of these principles will be made :
+             :            :        :                                  :         : to the human experience.         :
+             | psych      |    304 | Introduction to Cognitive        |       3 | An introduction to the basic     |
+             :            :        : Psychology                       :         : concepts of cognitive            :
+             :            :        :                                  :         : psychology, including areas such :
+             :            :        :                                  :         : as perception, attention,        :
+             :            :        :                                  :         : memory, language, and thought.   :
+             | psych      |    560 | Examination of Real-Time         |       4 | This lab course examines methods |
+             :            :        : Language Processing              :         : for the real-time examination of :
+             :            :        :                                  :         : language processing in normal    :
+             :            :        :                                  :         : and disordered  language         :
+             :            :        :                                  :         : populations.                     :
+             | psych      |    610 | Applied Child Psychology         |       3 | Introduction to major concepts   |
+             :            :        :                                  :         : and models used in psychological :
+             :            :        :                                  :         : assessment and psychotherapeutic :
+             :            :        :                                  :         : intervention of children.        :
+             :            :        :                                  :         : Several modalities of            :
+             :            :        :                                  :         : psychotherapy (individual,       :
+             :            :        :                                  :         : group, and family) will be       :
+             :            :        :                                  :         : reviewed along with research on  :
+             :            :        :                                  :         : their efficacy.                  :
+             | stdart     |    119 | Spring Basket Weaving Workshop   |         | A just-for-fun chance to learn   |
+             :            :        :                                  :         : the basics of basket weaving.    :
+             | stdart     |    333 | Drawing                          |       3 | Exploration of the structure and |
+             :            :        :                                  :         : interrelationships of visual     :
+             :            :        :                                  :         : form in drawing, painting, and   :
+             :            :        :                                  :         : sculpture. Principal historical  :
+             :            :        :                                  :         : modes of drawing are examined.   :
+             | stdart     |    411 | Underwater Basket Weaving        |       4 | This course provides a novel     |
+             :            :        :                                  :         : perspective on the traditional   :
+             :            :        :                                  :         : art of basketry as it is         :
+             :            :        :                                  :         : experienced in reduced gravity   :
+             :            :        :                                  :         : and in the context of fluid      :
+             :            :        :                                  :         : dynamics. Requires instructor    :
+             :            :        :                                  :         : permission and a valid c-card.   :
+             | stdart     |    509 | Twentieth Century Printmaking    |       4 | Development of personalized      |
+             :            :        :                                  :         : concepts and individual          :
+             :            :        :                                  :         : aesthetic expression in          :
+             :            :        :                                  :         : printmaking with reference to    :
+             :            :        :                                  :         : various styles and trends in     :
+             :            :        :                                  :         : Twentieth Century printmaking.   :
+             | stdart     |    512 | Art in Therapy                   |       3 | Surveys methods and results of   |
+             :            :        :                                  :         : using art and craft therapy with :
+             :            :        :                                  :         : developmentally disabled adults. :
+             | stdart     |    614 | Drawing Master Class             |       5 | For fine arts majors only, an    |
+             :            :        :                                  :         : intensive studio study including :
+             :            :        :                                  :         : field trips to local parks and   :
+             :            :        :                                  :         : museums and a final group art    :
+             :            :        :                                  :         : show.                            :
+             | stdart     |    714 | Peer Portfolio Review            |       0 | An opportunity to practice       |
+             :            :        :                                  :         : giving and receiving             :
+             :            :        :                                  :         : constructive criticism.          :
+             | tched      |    122 | Theory and Practice of Early     |       3 | Emphasis on the skills and       |
+             :            :        : Childhood Education              :         : processes needed for the design  :
+             :            :        :                                  :         : and implementation of optimal    :
+             :            :        :                                  :         : learning environments.           :
+             :            :        :                                  :         : Exploration of issues related to :
+             :            :        :                                  :         : societal and cultural influences :
+             :            :        :                                  :         : on the education of young        :
+             :            :        :                                  :         : children.                        :
+             | tched      |    155 | Methods of Early Science         |       3 | A study of the curriculum        |
+             :            :        : Education                        :         : methods, concepts, techniques,   :
+             :            :        :                                  :         : and materials in the teaching of :
+             :            :        :                                  :         : general science to children in   :
+             :            :        :                                  :         : the early grades.                :
+             | tched      |    367 | Problems in Education Management |       3 | This course is designed to       |
+             :            :        :                                  :         : assist the student to prepare    :
+             :            :        :                                  :         : for management of educational    :
+             :            :        :                                  :         : organizations and programs.      :
+             :            :        :                                  :         : Emphasis will be placed upon     :
+             :            :        :                                  :         : identifying specific problems    :
+             :            :        :                                  :         : and developing specific          :
+             :            :        :                                  :         : techniques by which to solve     :
+             :            :        :                                  :         : them.                            :
+             | tched      |    501 | Challenges of Teaching the       |       3 | The nature and needs of the      |
+             :            :        : Gifted and Talented              :         : talented and gifted in all areas :
+             :            :        :                                  :         : of development are explored.     :
+             | tched      |    609 | Supervised Internship in         |       4 | Supervised Internship I provides |
+             :            :        : Education                        :         : on-site, supervised              :
+             :            :        :                                  :         : instructional experience within  :
+             :            :        :                                  :         : a public school setting under    :
+             :            :        :                                  :         : the leadership of an             :
+             :            :        :                                  :         : appropriate, competent           :
+             :            :        :                                  :         : professional.                    :
+                                                                                                           (94 rows)
+
+             ----
+             /course?title!~'lab'
+             SELECT "course"."department",
+                    "course"."number",
+                    "course"."title",
+                    "course"."credits",
+                    "course"."description"
+             FROM "course" AS "course"
+             WHERE ("course"."title" NOT LIKE '%lab%' ESCAPE '\')
+             ORDER BY 1 ASC, 2 ASC
         - uri: /course?title!='Organic Chemistry Laboratory I'
           status: 200 OK
           headers:
                                            FROM "school" AS "school") AS "school"
                                      WHERE 0) AS "!"
                                     ON 1
+          - uri: /school{code,name,this(){code}?name!~'art', root().school{code}?name!~'art'}
+            status: 200 OK
+            headers:
+            - [Content-Type, text/plain; charset=UTF-8]
+            body: |2
+               | school                                                                                            |
+              -+---------------------------------------------------------------------------------------------------+-
+               | code | name                          | this(){code}?name!~'art' | root().school{code}?name!~'art' |
+              -+------+-------------------------------+--------------------------+---------------------------------+-
+               | art  | School of Art and Design      |                          |                                 |
+               | bus  | School of Business            | bus                      | bus                             |
+               | edu  | College of Education          | edu                      | edu                             |
+               | eng  | School of Engineering         | eng                      | eng                             |
+               | la   | School of Arts and Humanities |                          |                                 |
+               | mus  | School of Music & Dance       | mus                      | mus                             |
+               | ns   | School of Natural Sciences    | ns                       | ns                              |
+               | ph   | Public Honorariums            | ph                       | ph                              |
+               | sc   | School of Continuing Studies  | sc                       | sc                              |
+                                                                                                            (9 rows)
+
+               ----
+               /school{code,name,this(){code}?name!~'art',root().school{code}?name!~'art'}
+               SELECT "school_1"."code",
+                      "school_1"."name",
+                      "school_2"."code",
+                      "school_2"."code"
+               FROM "school" AS "school_1"
+                    LEFT OUTER JOIN (SELECT "school"."code"
+                                     FROM "school" AS "school"
+                                     WHERE ("school"."name" NOT LIKE '%art%' ESCAPE '\')) AS "school_2"
+                                    ON ("school_1"."code" = "school_2"."code")
+               ORDER BY 1 ASC
+          - uri: /school{name,count(department),this(){count(department)}?name!~'art'}
+            status: 200 OK
+            headers:
+            - [Content-Type, text/plain; charset=UTF-8]
+            body: |2
+               | school                                                                                    |
+              -+-------------------------------------------------------------------------------------------+-
+               | name                          | count(department) | this(){count(department)}?name!~'art' |
+              -+-------------------------------+-------------------+---------------------------------------+-
+               | School of Art and Design      |                 2 |                                       |
+               | School of Business            |                 3 |                                     3 |
+               | College of Education          |                 2 |                                     2 |
+               | School of Engineering         |                 4 |                                     4 |
+               | School of Arts and Humanities |                 5 |                                       |
+               | School of Music & Dance       |                 4 |                                     4 |
+               | School of Natural Sciences    |                 4 |                                     4 |
+               | Public Honorariums            |                 0 |                                     0 |
+               | School of Continuing Studies  |                 0 |                                     0 |
+                                                                                                    (9 rows)
+
+               ----
+               /school{name,count(department),this(){count(department)}?name!~'art'}
+               SELECT "school_1"."name",
+                      COALESCE("department"."count", 0),
+                      "school_2"."count"
+               FROM "school" AS "school_1"
+                    LEFT OUTER JOIN (SELECT COUNT(1) AS "count",
+                                            "department"."school"
+                                     FROM "department" AS "department"
+                                     GROUP BY 2) AS "department"
+                                    ON ("school_1"."code" = "department"."school")
+                    LEFT OUTER JOIN (SELECT COALESCE("department"."count", 0) AS "count",
+                                            "school"."code"
+                                     FROM "school" AS "school"
+                                          LEFT OUTER JOIN (SELECT COUNT(1) AS "count",
+                                                                  "department"."school"
+                                                           FROM "department" AS "department"
+                                                           GROUP BY 2) AS "department"
+                                                          ON ("school"."code" = "department"."school")
+                                     WHERE ("school"."name" NOT LIKE '%art%' ESCAPE '\')) AS "school_2"
+                                    ON ("school_1"."code" = "school_2"."code")
+               ORDER BY "school_1"."code" ASC
+          - uri: /school{name,exists(department),this(){exists(department)}?name!~'art'}
+            status: 200 OK
+            headers:
+            - [Content-Type, text/plain; charset=UTF-8]
+            body: |2
+               | school                                                                                      |
+              -+---------------------------------------------------------------------------------------------+-
+               | name                          | exists(department) | this(){exists(department)}?name!~'art' |
+              -+-------------------------------+--------------------+----------------------------------------+-
+               | School of Art and Design      | true               |                                        |
+               | School of Business            | true               | true                                   |
+               | College of Education          | true               | true                                   |
+               | School of Engineering         | true               | true                                   |
+               | School of Arts and Humanities | true               |                                        |
+               | School of Music & Dance       | true               | true                                   |
+               | School of Natural Sciences    | true               | true                                   |
+               | Public Honorariums            | false              | false                                  |
+               | School of Continuing Studies  | false              | false                                  |
+                                                                                                      (9 rows)
+
+               ----
+               /school{name,exists(department),this(){exists(department)}?name!~'art'}
+               SELECT "school_1"."name",
+                      EXISTS(SELECT 1
+                             FROM "department" AS "department"
+                             WHERE ("school_1"."code" = "department"."school")),
+                      "school_2"."exists"
+               FROM "school" AS "school_1"
+                    LEFT OUTER JOIN (SELECT EXISTS(SELECT 1
+                                                   FROM "department" AS "department"
+                                                   WHERE ("school"."code" = "department"."school")) AS "exists",
+                                            "school"."code"
+                                     FROM "school" AS "school"
+                                     WHERE ("school"."name" NOT LIKE '%art%' ESCAPE '\')) AS "school_2"
+                                    ON ("school_1"."code" = "school_2"."code")
+               ORDER BY "school_1"."code" ASC
         - id: table-expressions
           tests:
           - uri: /(school?code='art').department