[Babase] More on FoxPro queries for testing

Catherine Markham (amarkham@Princeton.EDU) babase@www.eco.princeton.edu
Wed, 10 Nov 2004 13:27:56 -0500


Hi,

This is follow-up to my last message about the FoxPro queries needed for testing.  To better archive the information on the Babase listserv, I'm simply listing the queries below.  Again, these queries are for all Babase tables, with the exception of SexSkins, for the purpose of comparing the new and old systems.

Catherine


select birth, bstatus, sex, matgrp, pid, sname, name, statdate, status, dcause, matured, mstatus, ranked, consorted, dispersed from biograph order by sname, pid to file biograph noconsole

select pid, parity, conceive, resume from pregs order by pid to file pregs noconsole

select cid, sname, seq, mdate, emdate, lmdate, tdate, etdate, ltdate, ddate, eddate, lddate from cycles order by cid to file cycles noconsole

select cenid, date, sname, grp, status, cen from census order by cenid to file census noconsole

select sname, role, iid from parts order by iid, role to file parts noconsole

select cenid, reference, comment from demog order by cenid to file demog noconsole

select iid, sid, act, date, start, stop, datetime from interact order by iid to file interact noconsole

select sname, date, grp, origin, interp from members order by sname, date to file members noconsole

select sname, rnkdate, grp, rnktype, rank from ranks order by sname, rnkdate, grp, rnktype to file ranks noconsole

select gid, name, from_group, permanent, supergroup from groups order by gid to file groups noconsole

select rid, date, sname, state, dins, dr, cids, cide, pid from repstats order by rid to file repstats noconsole

select csid, date, sname, state, dins, dr, cids, cide from cycstats order by csid to file cycstats noconsole

select sid, date, observer, grp, sname, mins, miniss, setupid, psionid from samples order by sid to file samples noconsole

select jpid, sid, activity, posture, time, foodcode, datetime from jpsamps order by jpid to jpsamps noconsole

select jpid, sname, code, unkid from jpneighbors order by jpid, code to jpneighbors noconsole

select fpid, sid, activity, posture, kidcontact, kidsuckle, time, foodcode, datetime from fpsamps order by fpid to fpsamps noconsole

select fpid, sname, code, unkid from fpneighbors order by fpid, code to fpneighbors noconsole

select act, descr, class, old from acts order by act to file acts noconsole

select status, descr from statuses order by status to file statuses noconsole

select bstatus, descr from bstats order by bstatus to file bstats noconsole

select mstatus, descr from mstats order by descr to file mstats noconsole

select dcause, descr from dcauses order by dcause to file dcauses noconsole

select rnktype, descr, query from rnktypes order by rnktype to file rnktypes noconsole

select sid, time, txt from adlibs order by sid, time, txt to file adlibs noconsole