Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
297 check-ins using file serverconf/devisland-ssbg/live/ppd.cfg or serverconf/devisland-ssbg/live/ppd.conf version feea8e5421
|
2012-06-23
| ||
| 20:19 | Renamed serverconf ppd.cfg files to current name of ppd.conf check-in: a052122ec0 user: home tags: trunk, tmp | |
|
2012-06-11
| ||
| 10:43 | Added WebDriver OFB test file for the SSS check-in: d0ef99e215 user: home tags: trunk, tmp | |
| 08:32 | Selenium WebDriver support methods changed to be more general-purpose. Added new methods for OFB tests. check-in: ceeba8ad0d user: home tags: trunk, tmp | |
|
2012-06-06
| ||
| 15:37 | Added colour genetics check to registration form: refactored animal.js; added String.trim() function to ppdb.js; added ccode and pcode hidden text to sheepnew.tmpl; corrected shpval.check_colour_genetics(); added vpath = parents to validators URI; associated changes to other source files. check-in: 8005626d8c user: home tags: trunk, tmp | |
|
2012-05-25
| ||
| 20:53 | Added new function to validate sheep post data to shpval. Minor corrections and amendments to other modules resulting from the new function. check-in: d9cfa1f77e user: home tags: trunk, tmp | |
|
2012-05-05
| ||
| 21:31 | Refactored/rewrote sss_register tests to no longer use the unittest framework and to have multiple tests per class with a single test fixture for all tests in the class. check-in: c2fa34a1d1 user: home tags: trunk, tmp | |
| 10:43 | Correct bug in progeny listing which caused a blank ear-tag to be displayed for the root animal. Add 'show_fndtn' flag to breed make_public_regn_no methods to allow regn no to be built for foundation animals. check-in: f66fe33cf2 user: home tags: trunk, tmp | |
| 09:39 | Added sire/dam serach field onblur event handlers to reset the parent's fields (and dependants) if the search field is empty. check-in: e3a84b4755 user: home tags: trunk, tmp | |
|
2012-05-04
| ||
| 21:34 | Buttons now all use the same CSS class. register and Sex buttons bae on span rather than anchor tags. Refactored animal.validate_parent and its display methods to use elements from an object initialised when the form loads instead of ddoing getElementById each time the element is used. check-in: ee8bb5339a user: home tags: trunk, tmp | |
| 14:33 | Transfer status message now includes date of transfer. Revised transfer message colours and added event to 'transfer' checkbox to change colours. Changing org flock refreshes parent status. Test cases updated. check-in: c327cda429 user: home tags: trunk, tmp | |
|
2012-05-03
| ||
| 20:29 | Changes to regitration form template and scripts with associated changes to stylesheet and tests so that all necessary data is sent with the form POST data. check-in: 9d955f5fcb user: home tags: trunk, tmp | |
| 17:21 | animal/validator/sire, dam and sibs take birth flock, not regn flock. test case corrections for error fields cleared to a space instead of empty. check-in: 68ef0df5be user: home tags: trunk, tmp | |
| 16:45 | Added method to submit the registration form. 'Register' button submits via the new method. check-in: 9c6cdaf4a9 user: home tags: trunk, tmp | |
| 10:16 | Added more comprehensive checks for fields affected by test cases. Updated test_siblings for revised messages. animal.js explicitly sets class and text on invisible fields. check-in: 0050ba9e08 user: home tags: trunk, tmp | |
| 09:40 | Corrected and refactored shpval.check_siblings. Test cases updated. check-in: 279ee7896c user: home tags: trunk, tmp | |
| 09:08 | Reverted type of sheep.sort_dob to DATE NOT NULL from TIMESTAMP NOT NULL. This got changed inadvertently in the transition from tables V9 to tables V10. check-in: 419b656d5e user: home tags: trunk, tmp | |
|
2012-05-02
| ||
| 16:44 | Set form fatal error message colour and colour warning message colour check-in: d61e7a4cd2 user: home tags: trunk, tmp | |
| 16:26 | Added scripts Jinja block to contain page-specific script tags check-in: 30f7aeb2d4 user: home tags: trunk, tmp | |
| 15:43 | Merged new parent validation code check-in: a8b17d87f2 user: home tags: trunk, tmp | |
|
2012-05-01
| ||
| 21:18 | Changed all 'onblur' events to 'onchange' to avoid the need for tricks to prevent circular calls. Added onblur handler to dob and tag fields to check for empty field as the user tabs past them - onchange doesn't fire unless field was changed from a value to empty. Selenium test cases updated and now use a local method to clear fields as the WebDriver clear() method does not work with onchange. Closed-Leaf check-in: 042d7df2ba user: home tags: tmp, alt-parent-validate | |
| 12:16 | Revised method order in animal.js. WebDriver test cases now flag only the discrepancies for focus. check-in: 0b32c219d3 user: home tags: tmp, alt-parent-validate | |
|
2012-04-30
| ||
| 22:03 | Removed redundant calls to element.focus(). check_dob no longer checks for blank date - done via Ajax to get focus set correctly. check_dob calls validate_parent dam first instead of sire first to avoid duplicate calls to dam/rcode/sibs due to UI calling validate_parent. check-in: c4f2c5c29f user: home tags: tmp, alt-parent-validate | |
| 20:35 | Parent validation Javascript re-written to chain only one Ajax request at a time per Ajax callback. Selenium WebDriver tests modified to print control having focus after each test - all focus() calls commented out except for those setting focus to the xxx_xfer_date field where appropriate. Tab order otherwise entirely controlled by HTML tabindex attributes. check-in: b7225bb9e3 user: home tags: tmp, alt-parent-validate | |
|
2012-04-29
| ||
| 08:34 | New branch to develop an alternate strategy for checking the parents on the sheep registration/change forms. The previous strategy results in a large number of Ajax requests and does not allow the order in which they occur to be easily defined if the Ajax requests arte asynchronous. check-in: 22972fd084 user: home tags: tmp, alt-parent-validate | |
|
2012-04-28
| ||
| 18:10 | Added extra acces keys to those of checkin 4b8e356d21 (not in checkin comment!). Set tab order via HTML tabindex attributes. Updated testcases to test that tabbing moves focus as expected. Updates to Javascript to implement tabbing. *** test_siblings has shown up a problem with properly sequencing ajax requests *** check-in: a4ac0884f6 user: home tags: trunk, tmp | |
| 07:58 | Merged fixed-width branch into trunk check-in: 4b8e356d21 user: home tags: trunk, tmp | |
| 07:55 | Adjusted fixed content width to maximise size on a 1024x768 screen. Refactored style-sheets. Closed-Leaf check-in: 5ae4067da8 user: home tags: tmp, fixed-width | |
|
2012-04-27
| ||
| 16:06 | Revised get_parent_transfer_status to use a single query for PostgreSQL and SQLite and eliminate the query on last_live_flock. check-in: 91d4971366 user: home tags: trunk, tmp | |
|
2012-04-26
| ||
| 16:56 | Removed the 'web' command line option from dbbuild.py check-in: dfe67bbef5 user: home tags: trunk, tmp | |
| 14:08 | 'wait_for' delay now set via module global variable. check-in: 0686b2b4d7 user: home tags: trunk, tmp | |
| 14:07 | SQLite testing: Corrected typo in strftime in check_siblings. Refactored queries in get_parent_transfer_status to perform sorts in Python for a 3-order performance improvement (3400ms > 1ms using time.time). (postgresql is 23ms). check-in: a7d10c47ab user: home tags: trunk, tmp | |
| 08:22 | Merged lastest revisions from trunk check-in: 541dade961 user: home tags: tmp, fixed-width | |
|
2012-04-25
| ||
| 18:48 | Corrected an error in animaldb. Revised messages from check_register. All messages get colour set explicitly. Test cases check colour classes as well as text. Revised layout of register Code field on form. check-in: 15f58ea9b9 user: home tags: trunk, tmp | |
|
2012-04-24
| ||
| 21:53 |
Removed 'container' div and added 'fixed' class for the content div to be used where appropriate on forms.
Removed border around fixed content. Centered the menu in the menubar. check-in: 447a937ec2 user: home tags: tmp, fixed-width | |
| 18:18 | New branch to evaluate a fixed-width layout using pixel dimensions instead of ems. check-in: 9767c09f97 user: home tags: tmp, fixed-width | |
|
2012-04-23
| ||
| 21:45 | WebDriver tests now all run. Added registering flock parameter to sibling check. Warnings now displayed in orange. Added buttons to registration form. check-in: 15ea39e1c7 user: home tags: trunk, tmp | |
| 21:43 | Added another sheep for validators check-in: 3023f59cb2 user: home tags: trunk, tmp | |
|
2012-04-22
| ||
| 21:14 | Added Selenium WebDriver test cases to eventually replace the Selenium IDE versions. check-in: e3b4b87832 user: home tags: trunk, tmp | |
| 13:50 | Migrating Selenium IDE tests to Selenium WebDriver - tests in subdirectories of seleium_web. check-in: 81bb4b87ac user: home tags: trunk, tmp | |
| 09:51 | More Selenium IDE tests added for register code and siblings with accompanying changes to code, unit tests and page template. check-in: 40f83fc33a user: home tags: trunk, tmp | |
|
2012-04-20
| ||
| 20:59 | Revised layout of Registration form to put all messages next to the relevant field. Selenium test cases updated and expanded. Added nose testcases for the flock/validator URI. check-in: c84701b0af user: home tags: trunk, tmp | |
| 10:55 | Updates and corrections from testing registration form. check-in: 3d9348ab7d user: home tags: trunk, tmp | |
|
2012-04-19
| ||
| 15:08 | Updated docs for version 0.15.1 check-in: 99524d5556 user: home tags: trunk, tmp | |
| 14:42 | Schema version 10.10. Fixes tickets 60f4f04a62 and 0109e76cec. check-in: b538f8a675 user: home tags: trunk, tmp, version-0.15.1 | |
| 09:37 | Corrected another typo in ppdinit.py - missed in checkin dbf14adb90 check-in: 176358b281 user: home tags: trunk, tmp | |
| 09:04 |
Updated Selenium test case sss-db.sel to run - was just a hacked copy of sss-ofb.sel
Fixed typos in animalhtml.py - was using old field names. Added missing hidden fields to sheepdata.tmpl (found while running ss-db.sel) check-in: b752ccf0a4 user: home tags: trunk, tmp | |
|
2012-04-18
| ||
| 19:32 | Added Selenium IDE tests for the sheep registration page check-in: c2871ac3aa user: home tags: trunk, tmp | |
|
2012-04-15
| ||
| 10:03 |
Updated jsslib.check_register().
Added testcases for jss check_register - renamed sss testcase file so each breed has its own file. check-in: c5a662cccd user: home tags: trunk, tmp | |
|
2012-04-14
| ||
| 18:59 | Modify test database and test_rcode.py to get a male sheep for tests HEx which exists in the Paradox database and the test database. check-in: 2589a46a27 user: home tags: trunk, tmp | |
| 15:02 | check_register() - rationalised messages and refactored check_register for compactness and consistency. check-in: 9af230f169 user: home tags: trunk, tmp | |
| 10:15 | Expanded rcode test cases to cover both member's flocks and foundation and foreign flocks. check-in: 5055664012 user: home tags: trunk, tmp | |
| 08:29 | New unit test file for check_register. Removed rcode tests from test_validators. Amendments and corrections to SSS check_register(). check-in: 982eb01d59 user: home tags: trunk, tmp | |
| 08:27 | Removed dummy founders 900000X and 900001X from test database. 'Missing' ancestors are now set to Adam/Eve. check-in: cd7af0aa47 user: home tags: trunk, tmp | |
| 08:23 | Corrected typo in ppdinit check-in: dbf14adb90 user: home tags: trunk, tmp | |
| 08:21 | Added registration regs for SSS and JSS to the docs reference manual check-in: d0246d911d user: home tags: trunk, tmp | |
|
2012-04-12
| ||
| 13:45 | Pedigree searches now stop at mainland root sheep 100000X/100001X instead of descending to Adam/Eve. check-in: 23947906c3 user: home tags: trunk, tmp | |
|
2012-04-08
| ||
| 11:14 | Added missing case to ssslib.check_regiater and added test case to test_validators.py check-in: 31cd0d71ba user: home tags: trunk, tmp | |
|
2012-04-06
| ||
| 21:31 | Correct call to flock.get_flock_prefixes. check-in: a4bc5c2344 user: home tags: trunk, tmp | |
|
2012-04-04
| ||
| 15:41 |
make_test.py now makes a jss test database if breed=jss nose attributes simplified. JSS test cases now use jss-test database. check-in: 88d11fe55b user: home tags: trunk, tmp | |
|
2012-03-18
| ||
| 19:15 | More revisions for the registration form check-in: 1d9f437c0d user: home tags: trunk, tmp | |
|
2012-03-17
| ||
| 22:50 | More work on the sheepnew form and associated javascript and CSS. check-in: 1f32b066b9 user: home tags: trunk, tmp | |
|
2012-03-16
| ||
| 22:27 |
Changes and corrections to animal/validator/sire|dam. Brought client side code up to date for this URI. check-in: 6c13a330e1 user: home tags: trunk, tmp | |
|
2012-03-15
| ||
| 20:56 | Fixed 401 retry problem of ticket [464b6936ad] by adding retry to ppdb.html_get(). check-in: caab7156d2 user: home tags: trunk, tmp | |
| 20:12 | Added sibling test and test cases to animal/validator. check-in: 0770b98d84 user: home tags: trunk, tmp | |
|
2012-03-13
| ||
| 12:32 | breed.check_register() no longer uses reg_code and reg_sex tables. The logic required is no more complex than that required to interpret the tables. Added more register code test cases. check-in: c0e01fea33 user: home tags: trunk, tmp | |
|
2012-03-12
| ||
| 11:51 | Split animal/validators register code check and sibling check out into separate path elements to avoid excessively lengty parameter lists. Revised ssslib.check_register and test cases. avoid sire and dam check-in: c29c147f87 user: home tags: trunk, tmp | |
|
2012-03-10
| ||
| 12:01 | Revised make_test to create database with only sheep specifically required for test_findsheep and test_validatetag, and sheep with ancestors for test_validators. Breedclass is now an instance variable of TransformSqlite and derived classes. check-in: 28e6f88afe user: home tags: trunk, tmp | |
|
2012-03-09
| ||
| 21:24 | Added code to dataconv programs to set sys.path so that ppdb modules can be imported with __import__. sheep_schema reverts to a single CREATE VIEW for last_live_flock view. convert.py puts default export_xxx directories outside the working tree. check-in: 95a2fd3fbd user: home tags: trunk, tmp | |
| 10:03 | Added ear tags for 900000X and 900001X to test database. More validator test cases and associated changes and corrections. All 'check parent' test cases now run. check-in: b52af0f5a9 user: home tags: trunk, tmp | |
|
2012-03-08
| ||
| 10:48 | Updated sheeplib.findsheep and testcases to allow X suffix sheep to be found. check-in: 366e5ddb52 user: home tags: trunk, tmp | |
|
2012-03-07
| ||
| 22:14 | Corrected last_live_transfer view and split the CREATE VIEW for PostgreSQL and SQLite More test cases for animal.validator/sire and test cases for animal/validator/dam with code corrections. Added new breed constants for gestation periods. check-in: 946c806ec2 user: home tags: trunk, tmp | |
|
2012-03-06
| ||
| 21:31 | Corrections and updates for the animal/validators/sire URI and its unit tests. check-in: a2ffb9ca1d user: home tags: trunk, tmp | |
| 10:46 | Revised link from docs to Fossil repo. Registration form UI description uses enumerated lists for validation description. check-in: a003046a1c user: home tags: trunk, tmp | |
| 09:54 | Removed and shunned www. This contained compiled Sphinx docs and should never have been under version control - the source is in docs/ppdb. check-in: 9dcdfd677b user: home tags: trunk, tmp | |
|
2012-03-05
| ||
| 12:01 | Updated testcases for changes of checkin [526d66a12d]. Folded jss and sss findsheep tests back into a single module. testcases now use the nose attrib plugin to allow selective running of tests in groups 'breed' (3) , 'common' (to all breeds) and 'all'. check-in: a2cc82a2eb user: home tags: trunk, tmp | |
| 11:00 | Revised runtime values which were in breed.DBSCHEMA and breed.SQLITE_FILE. Both are removed from the breed libraries. The dbschema is now computed from DBLIB.schema_name by the app init classes. The sqlite file name is passed to the app init classes from the app tuples in ppd.conf. Additionally the name of the app configuration file is now set in the app tuples in ppd.conf instead of a class constant in the app init classes. check-in: 526d66a12d user: home tags: trunk, tmp | |
|
2012-03-04
| ||
| 17:26 | Added sheep in make_test to facilitate unit tests. Renamed parameter passed to pglib.make_app_connection for clairty (parameter is unused for pgsql). Split findsheep tests for JSS and SSS into separate modules. Modified unit tests to use db_ssbg_test database instead of the live database. check-in: 3741726eb0 user: home tags: trunk, tmp | |
| 12:30 | Removed redundant ppdb/wid directory check-in: 85ab36dacd user: home tags: trunk, tmp | |
| 12:27 | Corrected output file path generation. Inserted Adam and Eve sheep and dummy parents 900000X and 900001X and pointed all 'missing' parents to the dummy parents. Pruned unnecesary records from fock_stats, flock_prefix and flock_health to avoid foreign key errors. Inserted Inspector, PrP testing owners and primary persons into person. check-in: ff1f8a6618 user: home tags: trunk, tmp | |
|
2012-03-03
| ||
| 20:30 | Tuned make_test.py to improve the spread of sheep attributes (tag prefix, reg code, reg nos). Added debug option to sqlitebuild.py to supress messages unless set. check-in: 62e89b17aa user: home tags: trunk, tmp | |
|
2012-03-02
| ||
| 21:18 | Added module to build and SQLite database from a TSV .tar.gz data file. check-in: 082cb28e00 user: home tags: trunk, tmp | |
| 20:07 | Added executable make_test.py to create a truncated database for test purposes. The TSV tar.gz file is small enough to be maintained as part of this repository (but not included yet). check-in: 18a4b90cf2 user: home tags: trunk, tmp | |
|
2012-02-29
| ||
| 09:53 | Previous checkin used incorrect version - should have been 0.15.0 check-in: 5047089831 user: home tags: trunk, tmp, version-0.15.0 | |
| 09:46 | Bumped version number to 0.2.0 check-in: ba08cd0527 user: home tags: trunk, tmp | |
| 09:43 | Merged branch schema-v10 into trunk check-in: dbb9d3fd41 user: home tags: trunk, tmp | |
|
2012-02-28
| ||
| 16:59 | Compiled updates Sphinx docs Closed-Leaf check-in: 40daa70833 user: home tags: tmp, schema-v10 | |
| 15:32 | Corrected errors in sheep_schema.conf complex views. check-in: ce8cfef599 user: home tags: tmp, schema-v10 | |
|
2012-02-27
| ||
| 22:23 | Merged in changes in trunk checkin 823f56b859 check-in: 087e41809d user: home tags: tmp, schema-v10 | |
| 22:13 | sheep_schema.conf and cattle_schema.conf revised to allow different SQL statements to be specified for different database engines. Database build and data conversion modified to use the revised schemas. Data conversion restructured to reduce code size. check-in: 823f56b859 user: home tags: trunk, tmp | |
|
2012-02-26
| ||
| 18:36 | Merged changes from trunk checkin 0e5ad369a7 check-in: 54910172a1 user: home tags: tmp, schema-v10 | |
| 18:32 |
Removed addition of path to sys.path in convert.py - serves no purpose.
dataconv/transform.py now looks up FLOCK_DEAD valuse directly from the breed library file foe sheep. check-in: 0e5ad369a7 user: home tags: trunk, tmp | |
| 15:56 | Merged in changes from trunk check-in: 028226b66b user: home tags: tmp, schema-v10 | |
| 11:25 |
Fixed typos in sheep_schema.conf and transform.py.
This branch is now using new database db_schema_v10. check-in: 3cd30f8b55 user: home tags: tmp, schema-v10 | |
| 11:20 |
View last_live_flock was not being created due to needing a breed-specific item in a WHERE clause.
The breed 'FLOCK_DEAD' constant is now interpolated into sheep_schema.conf using the DEFAULT dict of ConfigParser. To allow the breed class to be loaded without knowing its name the Shetland and Jacob breed classes are rename to Breed. Dataconv cannot load the breed classes due to problems with Python imports so the DEAD_FLOCK constants are hardcoded into transform.py for the time being. check-in: fd94b21578 user: home tags: trunk, tmp | |
|
2012-02-23
| ||
| 20:48 | Updated datconv for new schema. Added UNIONs to views. check-in: b9c73ab973 user: peter tags: tmp, schema-v10 | |
| 14:21 |
Schema V10.00:
Reverted the database schema to that of Version 8.00. sheep.registration_date becomes sheep.registered. sheep_flock table becomes transfer. check-in: 5238a92dd5 user: home tags: tmp, schema-v10 | |
| 10:33 | Initial unit tests for the animal/validator URI branch check-in: b180b3ff1f user: home tags: trunk, tmp | |
|
2012-02-21
| ||
| 22:36 | Fixes for cattle.get_progeny. Set domainbase correctly for local deployments. check-in: b07591a365 user: home tags: trunk, tmp | |
| 19:11 | Revised app initialisation to move configuration item 'breed' into the breed classes. The 'breedlib' variables were actually class instances, not libraries and have been renamed to 'breed' throughout. check-in: d8d4a144eb user: home tags: trunk, tmp | |
| 15:54 | Removed unsed configuration item 'appconf' check-in: 93cb99eb29 user: home tags: trunk, tmp | |
| 15:51 | Ignore (don't convert) non-UK phone numbers with no country code. Emit a message instead. check-in: 85cf1a91cd user: home tags: trunk, tmp | |
| 11:32 | Added cherrypy/test - required to run some of our test cases. check-in: 4c3b65d691 user: home tags: trunk, tmp | |
|
2012-02-13
| ||
| 17:59 | Udpates to sire/dam validation for SSS sheep registrations check-in: 5900915eb9 user: home tags: trunk, tmp | |
|
2012-02-10
| ||
| 11:48 | Updated registration form description, fixed Sphinx docstring warning check-in: e049863a24 user: home tags: trunk, tmp | |
|
2012-02-09
| ||
| 12:44 | Reinstated import of lib/tools mistakenly removed in checkin [6021b28e44]. Tools will not be loaded if this import is missing so nothing will work. check-in: a6d03991a2 user: home tags: trunk, tmp | |
| 11:31 | Revised links between Sphinx docs and fossil home page check-in: 918fc6182f user: home tags: trunk, tmp | |
|
2012-02-07
| ||
| 21:13 | Corrected Sphinx docs backlink check-in: 45ca28ee0a user: home tags: trunk, tmp | |
| 21:03 | Sphinx docs updates with changed bacling to Fossil repo and relbar changed to match Fossil 'gradient, rounded corners' theme. check-in: 51da647c06 user: home tags: trunk, tmp | |
|
2012-02-06
| ||
| 12:17 | Updated Sphinx Makefile and conf.py for revised structure. Build Sphinx docs at 0.14.0 check-in: c3400fc963 user: home tags: trunk, tmp | |
| 12:05 | Created fossil ui home-page with link to Sphinx docs. Added template to Sphinx docs to add link back to Fossil from Sphinx docs check-in: 237bd31885 user: home tags: trunk, tmp | |
| 11:56 | Moved ppdb/docs (Sphinx docs) to docs/ppdb. check-in: cf946ce788 user: home tags: trunk, tmp | |
|
2012-02-05
| ||
| 18:50 | Startup scripts ensure the 'logs' directory exists. check-in: 6021b28e44 user: home tags: trunk, tmp | |
| 18:42 | Moved PPD entry point files from deploy to ppdb. Updated deploy script for new location check-in: 070db7f932 user: home tags: trunk, tmp | |
| 18:37 | Added CherryPy 3.2.2. Functional files only; no test, scaffold or tutorial check-in: 6689d74494 user: home tags: trunk, tmp | |
|
2012-02-04
| ||
| 18:26 | Removed and added files as suggested in ticket [2d636892da]. check-in: 76a0070393 user: home tags: trunk, tmp | |
|
2012-02-01
| ||
| 09:35 | Updated docs for query performance with SQLite 3.7.10 check-in: e46ebb4e43 user: home tags: trunk, tmp | |
|
2012-01-31
| ||
| 14:55 | Change to re-open trunk check-in: c0bcf851e9 user: home tags: trunk, tmp | |
|
2012-01-29
| ||
| 16:55 | Create new branch named "dbapp-os" Closed-Leaf check-in: 4041c8b98a user: home tags: mistake, tmp | |
|
2012-01-28
| ||
| 23:13 | Rollup bug fixes for merge of dbapp-newschema (Checkin [faeba100ca]). Converted testcases to use nose for CP >= 3.2 check-in: 3a4aabfccb user: home tags: trunk, tmp | |
|
2012-01-23
| ||
| 22:03 | Added NE Turner to Inspectors translation dict check-in: 9c9f689279 user: home tags: trunk, tmp | |
|
2012-01-07
| ||
| 21:42 | Transform now handles phone numbers with no space between country code and first brace surrounding local access code. Clean recreate_flock_owner() now handles the case where a member has a second flock but has not yet registered any animals in the flock. check-in: 173e0514b0 user: home tags: trunk, tmp | |
| 21:38 | Revised auditing documentation check-in: 054f5ae355 user: home tags: trunk, tmp | |
|
2011-12-20
| ||
| 10:54 | Corrected format error Sphinx doc. check-in: fd59bde982 user: home tags: trunk, tmp | |
| 10:24 | Reverted docs build directory to Sphinx default of _build check-in: 2bbce37c09 user: home tags: trunk, tmp | |
| 10:20 | Removed 'wish-list' from docs. 'Wishes' now documented by tickets check-in: da5b2be97e user: home tags: trunk, tmp | |
|
2011-12-19
| ||
| 20:50 | Reinstated missing file in 'localhost'. Added package for mod_wsgi built with Python25 to arch configuration check-in: 9b1bdcb3b0 user: home tags: trunk, tmp | |
| 20:20 | Flattened serverconf local server configurations check-in: 1be572e4d3 user: home tags: trunk, tmp | |
| 20:13 | Updated Apache configuration for ArchLinux - files missed due to incomplete understanding of Fossil. check-in: fd93807bb0 user: home tags: trunk, tmp | |
| 20:08 | Updated Apache configuration for ArchLinux check-in: b242def4ec user: home tags: trunk, tmp | |
|
2011-12-17
| ||
| 10:41 | Added configuration files and vital (old versions) AUR packages to arch-base check-in: 82fd652324 user: home tags: trunk, tmp | |
| 10:37 | Added config files for bash and the Intel nic to NetBSD configuration check-in: 282f132345 user: home tags: trunk, tmp | |
| 09:24 | Updated serverconf for NetBSD for current hardware and NetBSD 5.1 check-in: a95d33cb5c user: home tags: trunk, tmp | |
|
2011-12-10
| ||
| 17:54 | Merged dbapp-newschema. Now using the new schema... check-in: faeba100ca user: anonymous tags: trunk, tmp | |
|
2011-12-09
| ||
| 15:02 | Added more docs. Added sheep history form to test schema changes. check-in: 4a2c3bfd8d user: anonymous tags: trunk, tmp | |
| 14:58 | Added sheep history page - mostly to validate new schema check-in: 5b95264548 user: anonymous tags: trunk, tmp | |
| 14:54 | breedlib.DBSCHEMA now unused - all queries have the schemaname removed from tables. Revised animalget.get_progeny to halve the number of queries required. Queries in sheeplib modified to suit. Corrected error in sheep_schema. Bumped version to 0.14.0 check-in: e3eb04c95f user: anonymous tags: trunk, version-0.14.0, tmp | |
|
2011-12-06
| ||
| 18:52 | Corrected synfax error in ppduri.py. PostgrSQL sets the schema for the request using the db_connect/db_disconnect tools. Commit PRAGMA query for sqlite3. check-in: 851776d701 user: anonymous tags: trunk, tmp | |
| 16:16 | Update transfer.py for column name-change text_xfer_date to text_transfer_date. Omitted from rev 164. check-in: b861cb77a8 user: anonymous tags: trunk, tmp | |
| 16:10 | Set SQLite3 to enforce foreign keys when creating a connection. This has unnacountably been omitted till now./convert.py check-in: 518a74b761 user: anonymous tags: trunk, tmp | |
| 16:09 | Database schemas now in lib/sheep_schema.conf and lib/cattle_schema.conf. Database build files converted to use new schema files instead of XML and to use Ajax to update results page instead of streaming the results. Changes to templates and css to suit. check-in: aa1805a8a0 user: anonymous tags: trunk, tmp | |
| 16:03 | Schema file now in ppdb/lib. convert .py takes extra parameter to specify schema file. transformscba now uses a schema.conf the same as transformsheep. check-in: 47c9d8750d user: anonymous tags: trunk, tmp | |
|
2011-12-04
| ||
| 22:35 | Corrected errors in transformscba.py introduced in rev161. transform.py now uses schema.conf to create all database objects. Corrected error in schema.conf check-in: c158241263 user: anonymous tags: trunk, tmp | |
| 17:56 | New module transformsheep.py with classes for current and legacy transforms. Current transforms in transform.py, and legacy methods in legacy class. --legacy flag to convert forces Latin-1 and nomem. Output file and directory names for legacy omit encoding and nomem name fragments. New file schema.conf to hold database schema. Not used yet. check-in: 63e5751c80 user: anonymous tags: trunk, tmp | |
|
2011-12-03
| ||
| 21:33 | Updated Sphinx docs for new schema check-in: 9a7c05d1b3 user: anonymous tags: trunk, tmp | |
| 21:30 | dataconv/transform transfoms to revised schema. Old schema now supported by transform_legacy.py check-in: 2f3af4f5c3 user: anonymous tags: trunk, tmp | |
|
2011-12-02
| ||
| 10:01 | Corrected error in .bzrignore which led to dataconv/exportsqlite.py being excluded. Added that file. check-in: 2bc263634c user: anonymous tags: trunk, tmp | |
|
2011-11-29
| ||
| 20:30 | Updates to extend sheep parent validation to checking register code and checking siblings check-in: 590f7b84c7 user: anonymous tags: trunk, tmp | |
| 11:06 | Renamed lib/anival.py to lib/shpval.py as it is sheep specific. Split animaluri.py into animalbase, animaldb and animaldbsub as it was getting too big and had a lot more code to add. Co-req changes to app initialisation modules. check-in: 491cc27019 user: anonymous tags: trunk, tmp | |
|
2011-11-28
| ||
| 16:15 | Tweaked background and tect colours of menu check-in: 027ce0fa42 user: anonymous tags: trunk, tmp | |
| 14:06 | Added 'more than one result' message and link instructions for db to animal list, pedigree and commanc templates. check-in: fc3ed9994f user: anonymous tags: trunk, tmp | |
|
2011-11-26
| ||
| 14:43 | URI handlers, html generators and templates updated to use /data/ path segments and to update hyperlinks on pedigree, progeny and commanc pages. Unified animal find/search templates. Leaf check-in: 7d0a8d0f9e user: anonymous tags: trunk, version-0.13.0, tmp | |
|
2011-11-24
| ||
| 20:39 | Updates to URI handlers, menu and javascript for minor URI changes and HTTP status codes. check-in: 92cc84c0a6 user: anonymous tags: trunk, tmp | |
| 20:37 | Revised description of URIs in uri-scheme.rst. Bumped minor version to 0.12.2. check-in: 0f3379ca3c user: anonymous tags: trunk, version-0.12.2, tmp | |
|
2011-11-22
| ||
| 10:59 | Added colour error display below colour input field. Shortened error messages from server. check-in: 2a21952516 user: anonymous tags: trunk, tmp | |
|
2011-11-21
| ||
| 20:38 | More changes to Ajax functions of sheepnew and supporting changes. Split validate .py into separate modules for animal and member. Tightened messages from util.check_date. check-in: d2d48b5e06 user: anonymous tags: trunk, tmp | |
| 20:33 | Layout changes and css improvements. check-in: 9a439ee7c1 user: anonymous tags: trunk, tmp | |
| 10:39 | Removed status bar - status within form looks better and takes up less screen height on WXGA and WXGA+ screens (800px and 900px high). check-in: 71202a0834 user: anonymous tags: trunk, tmp | |
|
2011-11-20
| ||
| 10:57 | Revised validators URIs - validator name comes before parameter instead of after parameter. Updated date of birth validators. Added explicit validator for flock to jest return the flock name and number (duplicates a base data URL). Added status bar at bottom of database pages above the footer. check-in: 19a6148b71 user: anonymous tags: trunk, tmp | |
|
2011-11-18
| ||
| 09:42 | Reinstate original make_app_db_connection() function in pglib.py (just a 'pass'). Add new function make_test_db_connection() to pglib and sqlite3lib for test purposes. test/appsetup.py uses new function. check-in: 2e2270278e user: anonymous tags: trunk, tmp | |
|
2011-11-15
| ||
| 22:49 | Removed app/util URI branch. Added new animal/validator and flock/validator branches to provide URIs for Ajax requests for data validation. Updates javascript and docs for new URIs. Updated docs for registration form. check-in: 5b1b004d12 user: anonymous tags: trunk, tmp | |
|
2011-11-14
| ||
| 14:59 | Updates to javascript and CSS for sheepnew.html layout changes check-in: c8d0917d16 user: anonymous tags: trunk, tmp | |
|
2011-11-11
| ||
| 22:11 | Added new config item for breed id char in db forms. More work on registration form. Member Listings and labels form no longer uses tables. check-in: 558fcc66a0 user: anonymous tags: trunk, tmp | |
|
2011-11-09
| ||
| 17:12 | Added 'unquote' function (from urllib) to util.py for check_text_date() check-in: 2de4134af1 user: anonymous tags: trunk, tmp | |
| 17:10 | Updated all HTML templates to put the whole of the 'ontent' div in the individual templates instead of being split betwwe xx-head.tmpl and the individual template. check-in: af1c086f31 user: anonymous tags: trunk, tmp | |
| 15:10 | Added new URI to the 'app' branch to allow access to PPD utility functions from AJAX on forms. Split modal dialog and db 'table' css out into separate files. db-base.tmpl restructured to place the 'content' div immediately before the </body> tag so scripts can be loaded after the HTML is parsed.e regnew and sheepnew forms revised to use CSS layout instead of HTML tables. check-in: 3af43ac732 user: anonymous tags: trunk, tmp | |
|
2011-11-06
| ||
| 22:07 | Moved Javascript files to subdirectory of 'static'. ppdinit adds template files to autoreload list. All js event handlers now added dynamically as properties using DOM 0 methods. check-in: f1c27c86cc user: anonymous tags: trunk, tmp | |
| 09:00 | Corrected pdx/register.rst, updated ui/register.rst check-in: f952cdc3b3 user: anonymous tags: trunk, tmp | |
|
2011-10-07
| ||
| 20:01 | Corrected formatting check-in: 0ed4913dea user: anonymous tags: trunk, tmp | |
|
2011-10-06
| ||
| 15:35 | RST-ified docstrings for Sphinx documentation check-in: 723a79ae80 user: anonymous tags: trunk, tmp | |
| 13:35 | Updated reference manual pages to fuly qualify module names in section headers. Now using 'natural' theme and custom html_title. check-in: 3318342ad6 user: anonymous tags: trunk, tmp | |
|
2011-10-05
| ||
| 17:42 | ppd (internals) renamed refman. All python modules added to docs in refman. check-in: 9f5b69faa7 user: anonymous tags: trunk, tmp | |
| 12:06 | Restructured PPD Sphinz documentation with some text changes check-in: 697be52463 user: anonymous tags: trunk, tmp | |
|
2011-10-03
| ||
| 09:49 | Added warning comment to 'recreate_flock-owner_table'. Default encoding is now utf-8. check-in: 124f15a0ad user: anonymous tags: trunk, tmp | |
|
2011-09-29
| ||
| 19:31 | Updated modal dialog with Close button and using CSS table-like layout instead of tables. Updated db-base to utf-8 coding. Updated ofb-base to utf-8 and HTML5. check-in: de8409abc4 user: anonymous tags: trunk, tmp | |
| 19:28 | Updated docs with new chapters and changes. check-in: d904935287 user: anonymous tags: trunk, tmp | |
|
2011-09-20
| ||
| 16:11 | Corrected pdx-register.rst. Removed print statements from animaluri.py. Added template and CSS rules for a modal dialog. check-in: 4aced18ae9 user: anonymous tags: trunk, tmp | |
| 16:06 | Don't create .nonce directory in deploy.py check-in: 78b82c0eeb user: anonymous tags: trunk, tmp | |
|
2011-09-18
| ||
| 17:41 | Added new chapters to documentation.o Amended Makefile to put compiled fiels in build instead of _build directory. check-in: 05199404bd user: anonymous tags: trunk, tmp | |
|
2011-09-14
| ||
| 21:23 | Ajax base URLs passed as paremeters to event handlers by HTML instead of being wholly in js files. URLs use path segment parameters instead of query parameters. Added progress indicator to ajax forms - not yet activated. Fixed some bugs in handler for regnew 'start session'. 'path segment' URL for checking tag changed - tag and prefix passed as colon separated 'rid' segment. check-in: 22ed1e70d5 user: anonymous tags: trunk, tmp | |
|
2011-09-09
| ||
| 16:03 | Split restful_auth tool out of tools into it's own library - may make it into a class in future. check-in: bae49833d6 user: anonymous tags: trunk, tmp | |
| 16:00 | Removed 'ppdm' pseudo-app and moved all it's function to ppdinit, ppduri, ppdhtml and templates to new directory ppd. Having PPD management as a separate app was unnecessary. check-in: 2248060b67 user: anonymous tags: trunk, version-0.12.0, tmp | |
| 09:44 | appsetup.py updated for change from ppd.cfg to ppd.conf check-in: 8c5db36ae6 user: anonymous tags: trunk, tmp | |
|
2011-09-08
| ||
| 13:40 | All pages now HTML 5 instead of 4.01 strict check-in: 839baf2a26 user: anonymous tags: trunk, tmp | |
| 13:38 | Added gif omitted from rev 119. Revised sheep change and registration pages. check-in: f9a5878b7c user: anonymous tags: trunk, tmp | |
| 13:33 | Revised ppdm dbbuild pages so that build results can either be streamed or retrieved by ajax polling. Added progress indicator to page for both versions. result page switch is done by response.stream configuration in ppdminit.py check-in: aa0fcdc0da user: anonymous tags: trunk, tmp | |
|
2011-09-07
| ||
| 10:34 | Revised operation of 'legacy' and 'encoding' options so that 'legacy' creates tar files for the deployed version 0.2.0b with encoding forced to Latin-1 check-in: 5da10a5ab3 user: anonymous tags: trunk, tmp | |
|
2011-08-30
| ||
| 21:27 | Changes to support registration 'start session' form 'regnew' check-in: 0182c91f1e user: anonymous tags: trunk, tmp | |
| 21:26 | dblib.query_row with 'asdict' returns an empty dict if the row is empty. Sqlite3 param conversion to unicode moved after opening cursor to avoid exception in finally clause if param conversion fails check-in: bde49bfec6 user: anonymous tags: trunk, tmp | |
|
2011-08-29
| ||
| 20:37 | Rationalised names of data entry forms - were called xxxview, now xxxdata. Added methods to flok and fbklib libraries to support sheep registration. check-in: 409158f64a user: anonymous tags: trunk, tmp | |
| 16:57 | Added missing table flock_stats (from flkstats). check-in: a1126f5e0f user: anonymous tags: trunk, tmp | |
| 08:44 | Reverted to original URL scheme with 'rid' after sub-resource as having the rid partway down the path makes it hard to have a consistent URL scheme for both path-segment and query-parameter style URLs. check-in: 42c9f01024 user: anonymous tags: trunk, version-0.11.0, tmp | |
|
2011-08-27
| ||
| 10:25 | Refined registration and sheep view forms. Added member, flock stats and flockbook order controls to regnew form. Refactored animal.js to make callbacks inner functions of main functions. Adde new item to wish-list. Moved registration URLs to their own path segment. check-in: 1072d5b043 user: anonymous tags: trunk, tmp | |
|
2011-08-25
| ||
| 11:06 | transfer.get_curr_flock_info now returns a dict instead of a complex tuple. Revised layout of sheepnew and sheepview forms again. check-in: bd7c6f3e55 user: anonymous tags: trunk, tmp | |
|
2011-08-24
| ||
| 18:47 | Revised sheepview.tmpl to be similar to sheepnew.tmpl. Many changes to code to provide data for this new template. check-in: a79648c845 user: anonymous tags: trunk, tmp | |
|
2011-08-23
| ||
| 16:48 | Added and revised code for animal registration form. Added page to allow user to start a registration 'sesion'. Corrected, updated and spell-checked documentation. check-in: af23b896ca user: anonymous tags: trunk, tmp | |
|
2011-08-21
| ||
| 08:41 | Rationalised attribute order in form elements. Added hidden input fields for sire and dam regn nos. JSON item names have underscores not hyphens. check-in: 7a8dd4b553 user: anonymous tags: trunk, tmp | |
|
2011-08-20
| ||
| 17:02 | Refactored JavaScript into namespaces and split animal stuff off from generic ppdb stuff. Minor layout changes to shepnew.tmpl and schanges to match JavaScript. Set expires tool on for static files. check-in: 666ae8ba8b user: anonymous tags: trunk, tmp | |
|
2011-08-19
| ||
| 22:49 | Revised layout of registration form (sheepnew.tmpl) to be similar to the Paradox form. Added JS to set tag prefix list when user changes the originting flock. Other changes to support the above. check-in: 51fa70570e user: anonymous tags: trunk, tmp | |
| 14:12 | sheepnew table layout changed. Toggle sex button and get org flock added. Supporting code and css changes. check-in: 86311cb73e user: anonymous tags: trunk, tmp | |
|
2011-08-18
| ||
| 21:35 | New form sheepnew.tmpl - sheep registration form. Other changes to support and provide infrastructure for the new form check-in: d996de83c7 user: anonymous tags: trunk, tmp | |
|
2011-08-16
| ||
| 10:20 | Must only have one realm per app - realms in animal and member branches removed. check-in: 57a21e92d0 user: anonymous tags: trunk, tmp | |
| 08:43 | Docs: added 'wish' to wish-list. Corrected application-design User Authentication section check-in: 6165a1eb07 user: anonymous tags: trunk, tmp | |
|
2011-08-14
| ||
| 09:24 | OFB and DB now have their own animal root classes to simplify access control check-in: a45eb8ce06 user: anonymous tags: trunk, tmp | |
|
2011-08-13
| ||
| 08:58 | Added user with regsec and memsec roles to app_sss.dbinit. animaluri.Animal.GET only has popargs for parameters allowed in 'path segment' format URLs. animaluri.find_page takes and passes only one message parameter (template updated to suit). Also always returns the find page for the calling handler (animal summary, commanc, pedigree, progeny). Other handlers must use the cherrypy 404 page or a different custom page. check-in: 82691995a7 user: anonymous tags: trunk, tmp | |
|
2011-08-12
| ||
| 16:17 | Revised variable names in ppdinit.PPDDispatcher. Added handler class placeholders in animaluri and invoked them in app_sss.dbinit. Updated links in commanc, pedigree, progeny and summary list templates/macros for new URI scheme. Updates to URI scheme. check-in: 950b3f0b7a user: anonymous tags: trunk, tmp | |
| 09:59 | Replaced animauri.return_find_page with find_page. Changed animal handler classes , animalhtml and animalfind template to suit. Re-ordered sections in uri-scheme.rst. Added print statements selected by DEBUG global to animalid and sheeplib. check-in: 9c7ae03ff6 user: anonymous tags: trunk, tmp | |
|
2011-08-11
| ||
| 09:04 | Removed old version of PPDDispatcher from ppdinit.py. odf generation updated for unicode. URI parameter 'type' changed to 'fmt' to avoin name collision with Python builtin. animal/pedcert branch now supports multiple pedcerts and three compression types per the URI spec. check-in: 2fd6cb5233 user: anonymous tags: trunk, tmp | |
|
2011-08-08
| ||
| 22:00 | Docs updated for URI scheme with resource ids next to resource. PPDDispatcher partially modified for new URI scheme. Corrected error in db-base.tmpl. Updated animalsearch.tmpl Bumped version to 0.10.0 check-in: d92c216eab user: anonymous tags: trunk, version-0.10.0, tmp | |
| 08:26 | Revno 94 moved wrong directory! Reversed and moved correct directory. check-in: c91eb10768 user: anonymous tags: trunk, tmp | |
|
2011-08-07
| ||
| 20:30 | Moved sdocs into ppdb directory as docs check-in: 0ceeaaefc1 user: anonymous tags: trunk, tmp | |
| 16:07 | Work on Sphinx docs. check-in: 9f0214ed23 user: anonymous tags: trunk, tmp | |
|
2011-08-06
| ||
| 11:55 | Specification documents converted to reStructuredText format in new directory 'sdocs' for formatting with Sphinx. check-in: 8db0f9c9a5 user: anonymous tags: trunk, tmp | |
|
2011-07-30
| ||
| 18:24 | Merged updates for deploy.py check-in: d9362a9066 user: anonymous tags: trunk, tmp | |
| 18:23 | deploy/deploy.py updated for new ppd.conf apps section. unrepr module added - required by deploy.py. check-in: 7051a067cb user: anonymous tags: trunk, tmp | |
| 16:16 | Membersip and Registration Database uses a separate 'app' from the OFB, though musch of the OFB code is also used by the database. The apps may share a conf file but have different xxxinit modules and different stylesheets amd base templates. check-in: d3201989f5 user: anonymous tags: trunk, tmp | |
| 15:37 | Database app names shortened to xxdb. 'appname' appconf item defined in *init modules instead of in conf files. Database menu updated - stell needs working on. check-in: 199408fe37 user: anonymous tags: trunk, tmp | |
| 12:44 | Moved base template selection from 8 separate files into the templates proper using Jinja if-else block. Updated DB menu and Selenium test cases. check-in: 917ef74b3e user: anonymous tags: trunk, tmp | |
| 09:46 | Comprehensive changes to templates, css an init modules to support split of Database and OFB into separate applications. check-in: 71580e0279 user: anonymous tags: trunk, tmp | |
|
2011-07-29
| ||
| 17:50 | ppd.conf [app] section modified. init modules modified to suit. New init file for sssdb - membership and registration database. sssinit now provides OFB only. New Selenium test script for sssdb. check-in: e9b2d82fce user: anonymous tags: trunk, tmp | |
| 13:37 | deploy.py uses new name for PPD config file. Copies test subdir. check-in: 20f6811d32 user: anonymous tags: trunk, tmp | |
| 12:48 | Changed extension of configuration files from .cfg to .conf check-in: 97b2d3c273 user: anonymous tags: trunk, tmp | |
| 09:57 | Moved callables (for animal html view and form pages) from breedlibs to appconf. The callables got passed 'self' if in breedlib. Fixed typo in sheepform.tmpl check-in: 03bebaadd5 user: anonymous tags: trunk, tmp | |
|
2011-07-27
| ||
| 12:14 | Removed unnecessary print statements. check-in: 0c622d4044 user: anonymous tags: trunk, tmp | |
|
2011-07-25
| ||
| 08:35 | Merged dbapp-tmpl - converted from string.Template() HTML templating to Jinja2 templating (using Jinja2-2.5.5 as a package local to ppdb). check-in: e6f2c49aee user: anonymous tags: trunk, version-0.9.0, tmp | |
| 08:31 | Added missing field pmt_method.method_code to jss_db.xml (missed from rev 0.2.228. Added method to pglib to allow test cases to make a connection. Fixed some Jinja2 conversion bugs. Updated test cases for Jinja2. check-in: 6b49c0a71f user: anonymous tags: trunk, tmp | |
|
2011-07-24
| ||
| 09:09 | Added missing import to util.py. Templates use {{resource}} instead of {{animal}} - animalhtml.py already removed 'animal'. check-in: d1a6a2c2a7 user: anonymous tags: trunk, tmp | |
|
2011-07-23
| ||
| 21:47 | Remove all calls to html.websafe(). HTML escaping now done in templates with the |e filter. check-in: a83e220dc9 user: anonymous tags: trunk, tmp | |
| 18:01 | html.__init__.websafe ignores lists in dicts. member.get_person_data getss data in the form best suited to the memberview HTML page. memberview HTML converted to Jinja2. uses Jinja2 escaping not websafe. check-in: 04db12d467 user: anonymous tags: trunk, tmp | |
|
2011-07-22
| ||
| 22:11 | Member and flock list HTML pages working. Moved nav link generation to function and naav links template to macro. Fixed bug in member.member_data_for_list - sortorder name not working. Commented out line in util.html_appconf_items as unnecesary. check-in: 0b003326a1 user: anonymous tags: trunk, tmp | |
| 10:24 | Removed unused parameters from URI methods and function calls to HTML generators. DBLIB constant moved from util to const. Jinja_env now held in const.JINJA_ENV instead of cherrypy.config. check-in: 52889b6860 user: anonymous tags: trunk, tmp | |
|
2011-07-21
| ||
| 21:09 | Converted PPD to use Jinja2 templating engine. All .html template files replaced by .tmpl Jinja2 templates. Version number bumped to 0.9.0 check-in: 0c6ee91d28 user: anonymous tags: trunk, tmp | |
|
2011-07-20
| ||
| 09:40 | Changes to dataconv/convert.py to allow encoding of tsv files to be specified. check-in: 532d19ef75 user: anonymous tags: trunk, tmp | |
| 09:33 | Merged Unicode branch. PPD now operates end-to-end in UTF-8. PostGresQL database may use a different encoding if necessary. Version bumped to 0.8.0. check-in: 6c1fafa7c9 user: anonymous tags: trunk, version-0.8.0, tmp | |
| 09:31 | Bumped version number to 0.8.0 after moving to UTF-8. Removed some redundant commented out lines. check-in: 6956ab67d7 user: anonymous tags: trunk, tmp | |
| 09:12 | PPD is now UTF-8 end-to-end only - no other client/browser encodings are available. This still allows PostgreSQL server to be other than UTF-8 if necessary. check-in: 780f9f0357 user: anonymous tags: trunk, tmp | |
|
2011-07-19
| ||
| 17:46 | Removed redundant 'print' statement. Removed 'commented out' renderpage tool. Changes to ppd.cfg, ppdinit.py, pglib.py and sqlite3.py to allow PPD to be run either as unicode (UTF-8 client) or as some other encoding - tested only with LATIN-1. This has been tested with Sqlite3 and PostgreSQL UTF-8 and LATIN1 servers with LATIN-1 client (all 3 servers) and UTF-8 client (UTF-8 servers only). check-in: 12bf8a9308 user: anonymous tags: trunk, tmp | |
|
2011-07-16
| ||
| 15:35 | Updated module docstring in database libraries to cover the databases text data encoding. Set sqlite3 to always return bytestrings for TEXT types instead of unicode. check-in: ef85fa36a9 user: anonymous tags: trunk, tmp | |
|
2011-07-15
| ||
| 20:06 | Merged changes to revise breed classes and remove renderpage tool check-in: 23e4f639d7 user: anonymous tags: trunk, tmp | |
| 20:03 | Revisions to Animal pedcert URL and corresponding changes to the handler. ppdmuri.py got missed from the change removing the renderpage tool. check-in: 0a0b263369 user: anonymous tags: trunk, tmp | |
|
2011-07-14
| ||
| 09:10 | Removed redundant URI specification. Added HTTP method summary to URL specification. check-in: 3830a95d38 user: anonymous tags: trunk, tmp | |
|
2011-07-13
| ||
| 11:39 | Moved input table to lh side of window in ppd-base.css Fixed some errors in flock and member data diplay. Corrected comment in animaluri.py check-in: ccf5df8ae6 user: anonymous tags: trunk, tmp | |
|
2011-07-10
| ||
| 16:56 | Removed 'renderpage' tool as it conflicts with CherryPy 3.2. See the CP 3.1->3.2 changes page on the CP wiki. All handlers not reurning strings modfied to call the html generator directly. All html rendering functions renamed from xxx_html to xxx_page - the module name indicates html. check-in: aa519d7b8c user: anonymous tags: trunk, tmp | |
| 10:14 | Tidied up breed classes and associated calls from libraries check-in: 80c6077fcc user: anonymous tags: trunk, tmp | |
|
2011-07-09
| ||
| 20:16 | dbapp-mod with the breed module hierarchy replaced with conventional Python class hierarchy. Slightly less efficient but more pythonic. check-in: 2caa29c658 user: anonymous tags: trunk, tmp | |
| 15:17 | New version of dbapp repo barnched from dbapp. - ppdb uses procedural code with nested modules replacing classes for all except app initialisation and URI handlers. - removed redundant dataconv-old directory (Paradox scripts) - updated tests to test new structure check-in: a91220f332 user: anonymous tags: trunk, tmp | |
|
2011-07-08
| ||
| 11:28 | Check fo a numeric individual number if prefix is a MAFF prefix check-in: 03db109bfb user: anonymous tags: trunk, tmp | |
|
2011-07-07
| ||
| 11:57 | Corrections to flock/herd superclassing to get SCBA OFB to work check-in: 5728f9fa57 user: anonymous tags: trunk, tmp | |
|
2011-07-06
| ||
| 17:14 | Corrected typos in jssclasses._parse_regn_no check-in: 58bc5789b0 user: anonymous tags: trunk, tmp | |
|
2011-07-05
| ||
| 15:02 | Both SSS and JSS now have sheep.sort_regn_no column. Index added on this column. check-in: fd11d7825a user: anonymous tags: trunk, tmp | |
| 14:58 | Corrected type in ppd.cfg. SSS now has 'sheep.sort_regn_no' column to make sss and jss schemas identical check-in: 3c087454c0 user: anonymous tags: trunk, tmp | |
|
2011-06-22
| ||
| 17:47 | Amended inspector list - NJ Bennett has no space between N and J, extra line for T Findlay. Inspector name map code upper cases first letter of surname. check-in: 7dc2540beb user: anonymous tags: trunk, tmp | |
|
2011-03-18
| ||
| 14:28 | Added some support for members - mostly the listings and labels form and supporting changes check-in: 792526f2f1 user: anonymous tags: trunk, tmp | |
| 14:18 | Added three indexes to ear_tag - SQLite is very slow without them. Added comment to svr_conf.pythonpath config item. Added document on UK EID number allocation. check-in: 02d883d3f7 user: anonymous tags: trunk, tmp | |
|
2011-02-14
| ||
| 10:11 | Reversed changes to transform.py of revno72 and corresponding changes in table_changes.odt as they are unnecessary and clutter the tables. SELECT DISTINCT removes duplicate rows. check-in: 04f3ffd65c user: anonymous tags: trunk, tmp | |
|
2011-02-13
| ||
| 16:28 | Corrected entities-relationships. Added extra dummy rows to county, country and region tables in transform.py. Updated table-changes for above, and added explanation of date and datetime handling. check-in: ee80057cfb user: anonymous tags: trunk, tmp | |
|
2011-02-08
| ||
| 20:45 | Added comments to transform.py explaining blank rows in county and region tables. Updated member, animal, flock uri handlers for new URL scheme. Added new paths to sssinit Updated and fixed bugs in member reports template, js and html generator. Added bottom border to ctrlcell css. check-in: 698733a990 user: anonymous tags: trunk, tmp | |
|
2011-02-07
| ||
| 21:40 | Updated more tables in url-specification to document new URL scheme. check-in: c61bd3c980 user: anonymous tags: trunk, tmp | |
| 18:32 | Removed old pars_id from sssclasses.py. Added flock URLs to sssinit.py. Changed member and flocks links up to current URL scheme format. Corrected bugs in queries using IN in flock and member classes. check-in: fce2de85fe user: anonymous tags: trunk, tmp | |
| 12:32 | All uri handlers set info['requestpath'] from cherrypy.request.path instead of fabricating it by magic knowledge. animalget.data_for_view converts datetime objects to dates - require to convert the data to JSON check-in: 2da51b5ac8 user: anonymous tags: trunk, tmp | |
|
2011-02-06
| ||
| 21:26 | Revised URL scheme to one similar to that prior to revno 0.2.206. Documented in ppd-url-specification.odt (replaces ppd-uri-specification.odt. Revised ppdinit.PPDDispatcher to remove the path rewrite to remove rid from path. Added vpath back to restful_auth tool and removed legacy_args tool. renderpage tool skips template if none specified (for JSON output). findanimal.html reverts to original. animaluri, animalhtml, apphome and sssinit revised for new url scheme. animaluri and animalget revised to support JSON output. check-in: 318865c287 user: anonymous tags: trunk, tmp | |
|
2011-02-02
| ||
| 11:33 | sss_db.xml changed back to a single schema. Flock_Owner views moved to be adjacent to flock_owner table in file. check-in: c6a2aa5b86 user: anonymous tags: trunk, tmp | |
| 11:04 | Updated ppdmuri.POST for indirect import of dblib. Added XML file for SSS with multiple schemas (for reference). check-in: b5ca98bfa3 user: anonymous tags: trunk, tmp | |
|
2011-02-01
| ||
| 20:43 | Added characters to regexp for sanitise_params in ppdinit.py Added JSS tests to test_findsheep.py. Reinstated resource base class in util.py FlockResource class no longer a mixin - instantiated by other classes as requires instead. Numerous changes to AnimalID and breed classes to get findsheep test cases to run clean. check-in: b4178332f2 user: anonymous tags: trunk, tmp | |
|
2011-01-31
| ||
| 09:44 | Addded test cases for util.py. Added test cases for animal.find_animal.py (sss-findsheep.py). Rewritten find_animal and parse_id - too much common code duplicated in the old parse_id methods. check-in: e0f6800cf7 user: anonymous tags: trunk, tmp | |
|
2011-01-27
| ||
| 14:16 | Refactored and amemded 'find_animal' so that it assumes a regn no/tag only if the third character is numeric, and if that fails trys a name before giving up check-in: 8db0f5138a user: anonymous tags: trunk, tmp | |
| 14:14 | Changed BSPD to App in specification docs check-in: d7891c5281 user: anonymous tags: trunk, tmp | |
|
2011-01-21
| ||
| 20:27 | Initial port of prepare_member_query. Added query constants to const.py check-in: 569e3cfc15 user: anonymous tags: trunk, tmp | |
|
2011-01-20
| ||
| 17:22 | Added Selenium test script for JSS. Moved FBK_START_YEAR animal subclass constant to an appconf item ('fbk_start') as it needs to be available to flocks and flockbook classes too. check-in: 541cbd1318 user: anonymous tags: trunk, tmp | |
| 12:18 | function from soundex.py moved to util.py. html specific functions from util.py moved to html.__init__ module and odf.__init__ module check-in: b75527f33e user: anonymous tags: trunk, tmp | |
|
2011-01-17
| ||
| 18:12 | Renamed test cases to match current module names. Updated test cases to use crrent structure. Rewrote and corrected test_validatetag test cases. Corrected errata in eartag, util and validate shown up by test cases. check-in: ba84400934 user: anonymous tags: trunk, tmp | |
|
2011-01-16
| ||
| 12:37 | Renamed utils to util, and consts to const. Completely revised exception classes. Added exception handling to (dblib).execute_query and execute_many to avoid importing (dblib) into user modules check-in: d17d172361 user: anonymous tags: trunk, tmp | |
|
2011-01-15
| ||
| 21:47 |
Moved constants from genlib.py to consts.py
Moved PPDDispatcher class from genlib to ppdinit.py (where it is used)
Moved FileCache class from genlib to html.__init__.py
Delete Baseresource class and moved code to AnimalResource and MemberResource
classes.
Moved utility functions and error classes to utils.py
Other changes to modules to take account of the above changes Added (non-functional) test case for validate.validate_ear_tag check-in: edd699c13f user: anonymous tags: trunk, tmp | |
| 11:25 | Merged changes from Paradox r97 (6.14.2): Added validate_ear_tag method and removed is_tag_used and check_tag from validate.py. Updated find_flock and removed find_flock_from_prefix in flock.py. check-in: 976384822e user: anonymous tags: trunk, tmp | |
|
2011-01-13
| ||
| 22:03 | Major revision of the way resource classes are passed to handler. The instead of passing class callables in config the name of the breed class module is passed. This allows easier use of multiple classes for different handlers. formatters and validate temporarily reinstated. New module addnewprefix with code ported from FLOCKBRW.AddNewPrefix. check-in: 6d1122fe41 user: anonymous tags: trunk, tmp | |
|
2011-01-12
| ||
| 17:44 | Moved methods from formatter and validate into animal and member. Too many mixins make maintenance harder. check-in: f2625d94fc user: anonymous tags: trunk, tmp | |
| 13:00 | Added all sheep and flock views to transform. check-in: 86ea0545ef user: anonymous tags: trunk, tmp | |
| 11:00 | Added trailing message to transformscba. Fixed bugs in convert and added new 'keepfiles' option. check-in: 541ccb6bb1 user: anonymous tags: trunk, tmp | |
|
2011-01-11
| ||
| 14:12 | Revised terminology to make function clearer - instead of convert->clean->convert->export now have extract(data)->clean->transform->export.- Added licence statement - GPL as pxlib is GPL check-in: 352370e96b user: anonymous tags: trunk, tmp | |
|
2011-01-10
| ||
| 18:35 |
Bug fixes:
Add ROLES dict and get_user to bisbginit.py
Use get_users instead of genlib.get_users in ppdminit.py
Use self.schema to set schema in queries in jsclasses.py
New tools db_conn and db_disc to connect/disconnect SQLite database at before_handler / before_finalize. All app xxxinit.py enable these tools for branches which use the database. appinit.py doesn't test database. New methods AnimalResource.progeny_dict and pedigree_dict to allow override if query parameters vary (scba vs sss/jss) check-in: 8e6938674e user: anonymous tags: trunk, tmp | |
| 13:51 | Reinstated imports removed in r46- they are required after all. check-in: dbf4ce85e1 user: anonymous tags: trunk, tmp | |
| 10:43 | Removed un-needed imports. Added line to get dblib from configuration check-in: 2f0bdba545 user: anonymous tags: trunk, tmp | |
|
2011-01-09
| ||
| 18:33 | appinit.Application.app_config() renamed to configure_app to be of same form as other class methods. SQLite databases held in the applications directory instead of ppdb root: New appconf['appdir'] config item holdin application's directory. sqlite3lib.make_app_db_connection is passed appdir and tests for an existing connection handle. Two tools added to tools.py (unused) to make connection by hook. check-in: af03bb0a5c user: anonymous tags: trunk, tmp | |
| 18:20 | animal.py omitted from rev43. animauri module docstring re-written to better describe handler page generation process check-in: cecc25f7b7 user: anonymous tags: trunk, tmp | |
| 18:15 | flock.FlockResources now a mixin as required by both Member and Animal. Flock methods duplicated in animal.py deleted. Mixin classes based on object, not ResourceBase. genlib.ResourceBase class renamed Resource. check-in: a813cfe5e2 user: anonymous tags: trunk, tmp | |
| 18:05 | Added doc describing CherryPy request/response handling check-in: 35f6df6cf1 user: anonymous tags: trunk, tmp | |
|
2011-01-08
| ||
| 18:49 | Merged changes from dbapp-sqlite deveopment branch check-in: f17a551ae7 user: anonymous tags: trunk, tmp | |
| 18:48 | Moved breed auth and role dicts and get_user() from genlib to the respective xxxinit.py files. Moved exception clases for validation from genlib to validate. Tidied sqlite3lib and animal. check-in: 370a3b4549 user: anonymous tags: trunk, tmp | |
| 11:13 | Renamed all documents to remove spaces in names check-in: bd11ec11e8 user: anonymous tags: trunk, tmp | |
|
2011-01-07
| ||
| 15:17 | App now fully supports either SQlite or PostgreSQl. Some further optimisation can be applied to improve performance on SQLite check-in: 1b5de9cc4f user: anonymous tags: trunk, tmp | |
| 15:14 | Queries have the full schema name inserted at runtime using the new appconf item 'dbschema'. 'dbschema' is set by calling dblib.schema_name for each application in appinit.py. check-in: 76a3c398a2 user: anonymous tags: trunk, tmp | |
|
2011-01-06
| ||
| 20:48 |
1) Corrected link errors in progeny HTML page.
2) revised progeny data query in get_progeny method of animal.py. Documented in 'SQLite and PostgreSQL Query Optimisation.odt' 3) Removed unnecessary print statement in animaluri.py check-in: db923e31a5 user: anonymous tags: trunk, tmp | |
|
2011-01-05
| ||
| 19:09 |
New library sqlite3lib to interface with an SQLite3 database.
Changes to other modules to call connection methods for SQLite and, fix errors in (so far) unsused code, and to remove all reference to DB-API methods and attributes. check-in: b7eb37b8ca user: anonymous tags: trunk, tmp | |
|
2011-01-04
| ||
| 16:01 |
ppdb is now able to use database engines other than PostgreSQL:
lib/dblib.py renamed lib/pglib.py. The appropriate database access library is now imported at run-time in ppdinit.py using the db_conf.dbengine value in ppd.cfg and passed to users in cherrypy.config['db_lib'] configuration item. Queries now all use the 'qmark' parameter insertion format. The database access library handles any conversion to other formats. Table aliases removed from all INSERT, DELEET and UPDATE queries as Sqlite3 objects to them and they serve no purpose in a single table query. Line continuation charaters and triple quoted strings in all query templates converted to use bracketed implicit continuation instead. lib/format.py renamed lib/formatters.py as 'format' is the name of a built-in string method. check-in: 82c7eaa33b user: anonymous tags: trunk, tmp | |
| 15:54 |
Queries now all use the 'qmark' parameter insertion format. The db interface
library handles any conversion to other formats.
Table aliases removed from all INSERT, DELEET and UPDATE queries as Sqlite3 objects to them and they serve no purpose in a single table query. Line continuation charaters and triple quoted strings in all query templates converted to use bracketed implicit continuation instead. lib/format.py renamed lib/formatters.py as 'format' is the name of a built-in string method. check-in: e5ae65e6e6 user: anonymous tags: trunk, tmp | |
| 13:18 |
lib/dblib.py renamed lib/pglib.py
Database access library now imported at run-time in ppdinit.py and passed to users in cherrypy.config['db_lib'] configuration item. check-in: 5d80ac8f2d user: anonymous tags: trunk, tmp | |
|
2011-01-03
| ||
| 14:38 | Merged dbapp-sqlite rev 37 :- Added 'dbengine' key/value to ppd.cfg db_conf section throughout. ppd/dbbuild URI now only present if dbengine=postgresql. All code uses dblib to execute queries - only dblib imports psycopg2. check-in: ef16f9567b user: anonymous tags: trunk, tmp | |
|
2011-01-02
| ||
| 21:56 | Added 'dbengine' key/value to ppd.cfg db_conf section throughout. ppd/dbbuild URI now only present if dbengine=postgresql. All code uses dblib to execute quries - only dblib imports psycopg2. check-in: 100bbc6a1f user: anonymous tags: trunk, tmp | |