Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
835 check-ins using file docs/users/jss-new-database-considerations-1.doc or ppdb/docs/users/jss-new-database-considerations-1.doc or users/JSS - New Database Considerations 1.doc or docs/users/JSS - New Database Considerations 1.doc version 92e5fff6be
|
2016-08-25
| ||
| 08:20 | Add five more sheep born before their breeder joined the Society Closed-Leaf check-in: a906d12cfe user: home tags: ofb-0.41.x | |
|
2016-08-17
| ||
| 13:47 | Merge changes to test_sss_ofb.py from trunk. check-in: 89249c0528 user: home tags: ofb-0.41.x | |
| 09:26 | Added three more sheep born before their breeder became a member. check-in: 04603543af user: home tags: ofb-0.41.x | |
|
2016-08-12
| ||
| 08:35 | Added explanation of database connection security. check-in: cf86974b81 user: home tags: trunk | |
| 08:34 | Corrected 'current_member_status' view. check-in: 2f6b7bdb02 user: home tags: trunk | |
|
2016-07-16
| ||
| 10:48 | Added Selenium Web tests for the bugs of ticket [30d5f98b7f]. check-in: 1fad845734 user: home tags: ofb-0.41.x | |
|
2016-06-08
| ||
| 09:03 | Corrected typo in query to insert transfer audit records. check-in: 4613e1a94b user: home tags: ofb-0.41.x | |
| 09:02 | Corrected typo in query to insert transfer audit records. check-in: 7f2a5656d9 user: home tags: trunk | |
|
2016-06-03
| ||
| 10:16 | Added another two sheep born before their breeder (3351) became a member. check-in: 7e4f940f37 user: home tags: trunk | |
| 10:14 | Added another two sheep born before their breeder (3351) became a member. check-in: 8e1468412a user: home tags: ofb-0.41.x | |
|
2016-03-07
| ||
| 11:07 | Corrected role indicator merge for 'member' merge. check-in: 1c213a1df7 user: home tags: trunk | |
|
2016-03-06
| ||
| 17:49 | Hopefully the final version of the 'merge' algorith. No longer 'merges' single persons into the primary person. check-in: b368c1963c user: home tags: trunk | |
| 11:45 | Corrected 'merge' algorithm for merging persons of one member. check-in: d0f3c019e9 user: home tags: trunk | |
| 10:00 | Add 'Merge' checkbox to Roles tab. Correct flattening algorithm in get_persons_with_roles(). check-in: d359c2fbf1 user: home tags: trunk | |
| 09:29 | Corrections and updates to member reports form. check-in: 37c235e6ea user: home tags: trunk | |
| 09:15 | Reinstate method and templates removed by checkin [e47ff47296] - required by memberuri.Data class. check-in: b1df11e84d user: home tags: trunk | |
|
2016-03-05
| ||
| 13:41 | More corrections and updates for member reports. check-in: 7665a899d7 user: home tags: trunk | |
| 09:50 | Corrected un-selected tab colours in theme-green. check-in: 3f821a8f75 user: home tags: trunk | |
|
2016-03-04
| ||
| 17:05 | Corrections and updates for the 'reports' form. check-in: 607f5f7d26 user: home tags: trunk | |
| 10:17 | Correct shebang line in run_serve for ArchLinux check-in: 50216bcdb0 user: home tags: trunk | |
|
2016-03-02
| ||
| 15:50 | Added regions and updated output options im memreports. Improvements to css. check-in: f334a70e10 user: home tags: trunk | |
| 15:49 | Correct errors in query construction check-in: f0e82325f9 user: home tags: trunk | |
| 11:24 | Force Firefox style for <fieldset> tag, apply same style to 'boxed' divs. check-in: e011095b44 user: home tags: trunk | |
| 10:08 | Implement double-click to move items between lists. check-in: 6a3f357c65 user: home tags: trunk | |
| 09:29 | Make notebook tab labels look like part of the content area. check-in: a3e65941a5 user: home tags: trunk | |
| 09:18 | Added Society Roles tab to notebook. check-in: fb92a321d0 user: home tags: trunk | |
|
2016-03-01
| ||
| 15:16 | Added 3D depth to notebook. check-in: 23549f0f93 user: home tags: trunk | |
|
2016-02-28
| ||
| 14:59 | Added '..._code' columns to mem_source and non_renewal tables. check-in: a231edb84a user: home tags: trunk | |
|
2016-02-27
| ||
| 11:49 | Updates to member reports form. notebook.css assimilated into db_screen.css. check-in: 7ef716c83f user: home tags: trunk | |
|
2016-02-24
| ||
| 10:41 | Update test.con to match the changes in ppd.conf of checkins [590cbe70c7] and [c1e60b20e5].* check-in: 4816745c6e user: home tags: trunk | |
| 10:14 | New database version (14.1) and PPD version (0.42.0) for changes of chekin [6a1e8c8fb7]. check-in: 27ba29aecf user: home tags: trunk, 0.42.0 | |
| 10:13 | Updated docs for checkin [6a1e8c8fb7]. check-in: 35cd95cd99 user: home tags: trunk | |
| 09:47 | Ticket [9d49e7d8c4]. Added tables for member sources and non-renewal reasons. check-in: 6a1e8c8fb7 user: home tags: trunk | |
|
2016-02-20
| ||
| 18:21 | PPD pages are now optional - mounted only if 'ppdmanage' is specified in ppd.conf. check-in: c7139ebffe user: home tags: trunk | |
| 16:36 | Ticket [5891029ce3] - PPD pages now use their onn base template. They continue to use the ofb-screen CSS. check-in: 78690c2515 user: home tags: trunk | |
| 12:46 | Breed configuration files contain 'breed_conf' instead of 'app_conf' - theis rename better reflects the purpose of the configuration items. check-in: c1e60b20e5 user: home tags: trunk | |
| 12:11 | Web page colours now 'themed'. Theme is selected via app-conf parameter in ppd.conf. Currently green and grey themes are available. check-in: 590cbe70c7 user: home tags: trunk | |
|
2016-02-17
| ||
| 19:31 | Logo file is specified in ppd.conf. Fix for ticket [40d4f1b6ce]. check-in: eb1108b5ec user: home tags: trunk | |
| 12:23 | Merged in the nb-memrpts branch check-in: 7f1dff4148 user: home tags: trunk | |
| 12:21 | CSS improvements for notebook. All 'table' cells are now divs rather than spans. Closed-Leaf check-in: aa9d966366 user: home tags: nb-memrpts | |
| 11:08 | Create new branch named "ofb-0.41.x" check-in: a056ef1e74 user: home tags: ofb-0.41.x | |
|
2016-02-16
| ||
| 12:19 | Added Selenium Web tests for the bugs of ticket [30d5f98b7f]. check-in: f6a01d3ec3 user: home tags: trunk | |
|
2016-02-15
| ||
| 16:06 | Remove degugging print statements. check-in: 3f528ecb9d user: home tags: trunk | |
| 15:52 | Bump version to 0.41.2 check-in: ab8f6602ed user: home tags: trunk, 0.41.2 | |
| 15:50 | Fix OFB bugs of ticket[30d5f98b7f]. check-in: c12d8b6653 user: home tags: trunk | |
|
2016-02-13
| ||
| 12:23 | Merged in changes from trunk check-in: 8975da3bbf user: home tags: nb-memrpts | |
| 12:15 | Working tabbed notebook check-in: 636c789fa1 user: home tags: nb-memrpts | |
|
2016-02-12
| ||
| 16:22 | Removed unused cattledata page template. check-in: 9622e1077f user: home tags: trunk | |
| 16:19 | Change table to CSS table display and remove redundant CSS rules. check-in: f755e090d5 user: home tags: trunk | |
| 16:18 | Add 'source' column to query templates check-in: 4e5fa33756 user: home tags: trunk | |
|
2016-02-11
| ||
| 17:31 | Convert memreports page from flat to a tabbed notebook check-in: a01f9eaed7 user: home tags: nb-memrpts | |
| 17:27 | Update test.conf for database v14.0 check-in: 9fbbac0ee9 user: home tags: trunk | |
| 17:19 |
Update test.conf for database v14.0
Forgot to specify only test.conf in the commit... Leaf check-in: 7204198cd8 user: home tags: mistake | |
|
2016-02-09
| ||
| 12:35 | Correct query to populate member table for 'nomem'. New OFB version 0.41.1 check-in: b7a03583ec user: home tags: trunk, 0.41.1 | |
|
2016-02-08
| ||
| 16:19 | Correct query to populate member table for 'nomem'. Closed-Leaf check-in: 25d4bd863d user: home tags: mistake, 0.41.x | |
| 15:31 | Correct queries to populate roles tables. check-in: 9ab58c74e4 user: home tags: trunk | |
|
2016-02-06
| ||
| 17:45 | Changes to implement suggestions of ticket [e1d732654f]. check-in: fe6643c4b0 user: home tags: trunk | |
| 09:40 | Updated wbfaction ppd.conf. Bumped version to 0.41.1. check-in: 87902011a4 user: home tags: trunk | |
| 09:32 | Reverted OFB colours to green theme. New SSS logo replases the SHUB logo.sss.conf text updated. ppd.conf includes (commented out) webfaction parameters. check-in: 3ce8f0c5fe user: home tags: trunk | |
|
2016-02-05
| ||
| 13:22 | Added current SSS logo images check-in: 1d69ac037a user: home tags: trunk | |
|
2016-02-04
| ||
| 18:34 | Bumped version to 0.41.0 check-in: ca1b4d5c77 user: home tags: trunk, 0.41.0 | |
| 18:06 | Updates to bring dbapp in line with Paradox version 8.0.0 check-in: 01668635fc user: home tags: trunk | |
| 15:17 | Updated inspector conversion table for name changes (Hill, Gibbings, McCay). check-in: 5e1d08427d user: home tags: trunk | |
|
2015-12-12
| ||
| 12:34 | User function ts_from_seqno() handles sequence numbers > 59 correctly. Closed-Leaf check-in: c537fd0bc5 user: home tags: 0.31.x | |
| 12:19 | User function ts_from_seqno() handles sequence numbers > 59 correctly. check-in: 23df0036f1 user: home tags: trunk | |
| 09:52 | Added another 4 sheep born before their breeder (3386) became a member. check-in: 917438317a user: home tags: trunk | |
| 09:30 | Added another 4 sheep born before their breeder (3386) became a member. check-in: db3fc7587a user: home tags: 0.31.x | |
|
2015-10-22
| ||
| 13:22 | Updated for changes to Paradox 7.2.0 tables of current date. check-in: 86e1bd68d1 user: home tags: trunk | |
|
2015-10-21
| ||
| 16:27 | Merged new_roles branch check-in: 194ab3cf9b user: home tags: trunk | |
| 16:25 | Initial changes to memquery for new 'roles' tables Closed-Leaf check-in: abaf8ca684 user: home tags: new_roles | |
| 09:21 | Merged in changes from trunk check-in: bcf0d59e4a user: home tags: new_roles | |
|
2015-10-12
| ||
| 16:08 | Added 2 more sheep born before their breeder became a member. check-in: 919879700a user: home tags: trunk | |
| 16:07 | Added 2 more sheep born before their breeder became a member. check-in: bc898c440f user: home tags: 0.31.x | |
|
2015-07-31
| ||
| 08:46 | Updated docs for revised sheep schema. check-in: e4622e3a72 user: home tags: new_roles | |
| 08:46 | Revised main menu in line with Paradox 7.2.0 check-in: 82a0075216 user: home tags: new_roles | |
| 08:44 | reps_area person_id foreign key references roles instead of persons. Updated make-test.py for new schema. check-in: b64b5be564 user: home tags: new_roles | |
|
2015-07-30
| ||
| 12:48 | Updated schema and dataconv for paradox database 7.2.0 check-in: 38ea273e62 user: home tags: new_roles | |
|
2015-03-29
| ||
| 17:03 | Updates for changes to MEMBERS in paradox database Version 7.1.0. Bumped version to 0.31.7 check-in: 0f6f449f68 user: home tags: 0.31.x | |
|
2015-03-11
| ||
| 16:26 | Remove 'untunnel' tools as it a) no longer works due to cherrypy changes and b) is in any case redundant with the use of AJAX. check-in: aef7791d88 user: home tags: trunk | |
| 16:24 | Add file missed in prvious checkin. check-in: 4abc6d9382 user: home tags: trunk | |
| 16:21 | Implement 'Update Presumed Dead' function (on admin page). check-in: d144b17e73 user: home tags: trunk | |
|
2015-03-08
| ||
| 13:45 | Correct run_serve.serve() for changes of checkin [821c710d80]. check-in: 1ea318ba8f user: home tags: trunk | |
|
2015-03-05
| ||
| 16:24 |
Merged in changes from trunk
Closed branch. Overtaken by events (Pdx 7.2.0) Closed-Leaf check-in: 7fce89374b user: home tags: new-members | |
| 16:02 | Bring up to date with PDXDB 7.0.6 (aka 7.1) check-in: f743d8823d user: home tags: trunk | |
| 11:16 | Correct smtp server address in ppd.conf check-in: 38e4ada340 user: home tags: trunk | |
| 09:20 | Unintentionally committed trunk instead of the new 'new-members' branch. Closed-Leaf check-in: 5e134cc82c user: home tags: mistake | |
| 09:18 | Create new branch named "new-members" check-in: f148509e1f user: home tags: new-members | |
|
2015-02-09
| ||
| 19:47 |
Initial changes for revised Organisation tables.
Close leaf - replaced by new-members branch Closed-Leaf check-in: a4778110ce user: home tags: new-organisation | |
| 16:12 | Create new branch for new organisation tables and code check-in: a308fd8dc0 user: home tags: new-organisation | |
| 15:28 | Removed non-existant module run_modpy from refman. check-in: 0362b23301 user: home tags: trunk | |
| 14:57 | Merged in the multi-db.1 branch check-in: da5a28d064 user: home tags: trunk | |
| 13:11 | Updated deploy.py for new ppd.conf appications section. Closed-Leaf check-in: 531feb478b user: home tags: multi-db.1 | |
|
2014-12-23
| ||
| 20:05 | Removed redundant functions from pglib and sqlite3lib. Selenium Web and URI tests now use authenticatd access when accessing URLs protected by authentication in real life. check-in: 1265919a7d user: home tags: multi-db.1 | |
|
2014-12-22
| ||
| 18:03 | Revised 'apps' section in ppd.conf: app config now a dict and contains the database name for Sqlite3 and the schema name for PostgreSQL - the schema name is no longer built by library methods. check-in: 821c710d80 user: home tags: multi-db.1 | |
|
2014-12-19
| ||
| 15:16 | Merged in changes from trunk. check-in: 76e0bc08eb user: home tags: multi-db.1 | |
| 15:03 | Removed modpy deployment option and run_modpy.py startup file. check-in: 566b1ecf35 user: home tags: trunk | |
| 14:55 | Remove unsupported deployment options cgihost and mod_python check-in: 1a7607edf3 user: home tags: trunk | |
|
2014-12-17
| ||
| 10:05 | Updated docs for checkin [bc05ef58c0]. check-in: 89931dbead user: home tags: multi-db.1 | |
| 09:30 | Allow the global configuration file to be specified on the command line for mod_wsgi and cp server deployment (not appropriate for mod_python as no parameters can be passed). check-in: bc05ef58c0 user: home tags: multi-db.1 | |
|
2014-12-14
| ||
| 10:03 | Permit either the original 'single db/shema per app' setup or the 'db per app' setup of the multi-db branch. check-in: f0f8c67fcc user: home tags: multi-db.1 | |
| 10:00 | Create new branch named "multi-db.1" check-in: 6e222c5d19 user: home tags: multi-db.1 | |
|
2014-12-12
| ||
| 15:06 | Merged in the new-msgs branch check-in: 3837602d7c user: home tags: trunk | |
| 10:11 | Changed 'fmt' parameters of /sheep/pedigree and /sheep/progeny to 'type'. Added 'type' parameter to /sheep/commanc. HTTP status messages on HTML forms no longer show the status, only the user friendly message. Closed-Leaf check-in: b071ad0094 user: home tags: new-msgs | |
|
2014-12-11
| ||
| 20:20 |
URIs have a default representation if the 'Accept' header specifies an unsupported representation as permitted by HTTP/1.1.
As a consequence no 406 status codes are returned.
The flock/pfx URI now behaves per spec - the desired representation is specified by the 'Accept' header
instead of a path segment/query parameter.
Documentation updated to reflect the above changes. check-in: 393f2eec5d user: home tags: new-msgs | |
| 18:08 | Merged in update from trunk check-in: f17d9d50bd user: home tags: new-msgs | |
| 18:07 | Correct path to sqlite test database check-in: ce871daf39 user: home tags: trunk | |
|
2014-12-10
| ||
| 17:23 | Added four more sheep who's breeder joined after theri birth - see also checkin [89b30174e5] in 'trunk'. check-in: b35fa1a76b user: home tags: 0.31.x | |
|
2014-12-08
| ||
| 12:36 | New branch to improve messages per ticket [c523f19ea4]. check-in: 945680a115 user: home tags: new-msgs | |
|
2014-12-07
| ||
| 13:55 | Added 4 sheep born before their breeder became a member. Added another inspector name alias/conversion. check-in: 89b30174e5 user: home tags: trunk | |
|
2014-11-23
| ||
| 21:58 | Updates to get SCBA unit and selweb tests to run. check-in: dd8853e38e user: home tags: trunk | |
|
2014-11-22
| ||
| 16:10 | Ensure variable is initialised before use. check-in: 98baeb9552 user: home tags: trunk | |
| 16:09 | Corrections to data conversion and schema for SCBA. check-in: 82799784a4 user: home tags: trunk | |
| 15:42 | Merged in and closed the 'multi-db' branch check-in: 0b8e96712b user: home tags: trunk | |
|
2014-11-19
| ||
| 11:02 |
Added -R option to make_test to refresh the test databases from the newly created master files.
Leaf closed on merge into trunk Closed-Leaf check-in: a380598402 user: home tags: multi-db | |
|
2014-11-18
| ||
| 17:33 | The dataconv directory is now a package. make_test.py is moved from dataconv to ppdb/test and updated to suit its new location. Corrected comment in test.conf. check-in: 8ff5fa8e36 user: home tags: multi-db | |
| 09:30 | Merged in chsanges in trunk check-in: 5e0f7e0fd5 user: home tags: multi-db | |
|
2014-11-17
| ||
| 20:07 |
Removed print statement from ppd.py
Revised dbrefresh.py to better suit its being loaded as a module. Revised test infrastructure and test cases so that the SQLite and Postgres databases can be refreshed by test cases when necessary. check-in: e7d82bd900 user: home tags: multi-db | |
| 20:03 | Fixed two typos in make_test check-in: 181adc892e user: home tags: trunk | |
| 09:39 |
Removed redundant path additions to sys.path.
Relative path to the SQlite3 database files now specified by 'dbpath' in the [db-conf] section of the global configuration files. check-in: 06522d8ec3 user: home tags: multi-db | |
|
2014-11-16
| ||
| 15:31 | PPD now handles only one breed per instance, but can handle multiple apps per breed, e.g.Database and OFB. The SQLite database is located in PPD's root directory. check-in: 5e91784152 user: home tags: multi-db | |
|
2014-11-15
| ||
| 18:08 | Create new branch named "multi-db" check-in: 356d6f3a66 user: home tags: multi-db | |
| 18:02 | Bumped version number to 0.40.0 check-in: b43e60fe60 user: home tags: trunk, version-0.40.0 | |
|
2014-11-14
| ||
| 13:24 | Merged in database-v12 branch check-in: a152e9dd64 user: home tags: trunk | |
| 13:19 | Only check a partial list of tag prefixs for Island sheep to avoid continual updates as the list expands. Closed-Leaf check-in: c3d24579dd user: home tags: database-v12 | |
| 13:18 | Drop temporary tables in transform.py. Tidy up messages. make_test takes destination filename, not filename and path. check-in: a5836f8ff7 user: home tags: database-v12 | |
|
2014-11-13
| ||
| 15:33 | prp_genetics allele_1 and allele_2 CHECK constraints replaced by FK references to new lookup table prp_alleles check-in: 41d60eebf4 user: home tags: database-v12 | |
|
2014-11-12
| ||
| 17:16 | Added dcoumentation of paradox table constraints. check-in: 278e93e8e2 user: home tags: database-v12 | |
| 17:16 | sheep.reg_code references list of reg codes in reg_sex. fbk_order constrains 'copies' to be >= 1. check-in: 63f4521a13 user: home tags: database-v12 | |
| 10:01 | Added new inspector to inspector name map. Tweaked message in cleansqlite check-in: 5b80a7a55b user: home tags: trunk | |
| 09:58 | Added new inspector to inspector name map. Tweaked message in cleansqlite check-in: f8f43393a8 user: home tags: database-v12 | |
|
2014-09-30
| ||
| 19:50 |
sheep.uk_outward_code column deleted as it duplicates the first part of sheep.post-code.
REGEXP constraints added to phone.country_code and phone.number. New SQLite user function added to support REGEXP. Bug in dataconv.transform.py related to phone numbers corrected. tag_prefix.tag_prefix has a CHECK REGEXP constraint added. check-in: 4f37b81823 user: home tags: database-v12 | |
|
2014-09-28
| ||
| 22:27 | The sheep.litter_size column becomes VARCHAR(1) instead of INTEGER. Column definitions in sheep_schema are revised so that they are always two item tuples. Many columns now have CHECK constraints on permitted values. check-in: 1c89c61cb2 user: home tags: database-v12 | |
| 09:10 | Table flock_book_vol now lists all columes with a current_vol view to extract the current volume. The 'volume' column is constrained to a two digit string. Columns holding flock book volume values refer to the new table. check-in: c72bbb4937 user: home tags: database-v12 | |
| 09:05 | Initial empty checkin to create a new database-v12 branch. check-in: f1634f30cb user: home tags: database-v12 | |
|
2014-09-27
| ||
| 10:58 | Updates to sheep entry forms spec. check-in: 4c86a1c39e user: home tags: trunk | |
| 10:53 | Updated OFB tests for latest test database check-in: b01556f589 user: home tags: trunk | |
|
2014-09-25
| ||
| 19:30 | A simple change to a sheep's sex field now works. check-in: 29aa64f3cb user: home tags: trunk | |
| 18:55 | Updates to sheep validation for the PUT case. check-in: 624277b3c4 user: home tags: trunk | |
| 16:50 | Use a common function in shpval to validate both POST and PUT requests for sheep. check-in: 4e85543818 user: home tags: trunk | |
|
2014-09-23
| ||
| 19:18 | Revised sheep validator error handling. Revised handling of POST for new sheep. Further development of PUT for updating sheep. check-in: 488b2b1a3c user: home tags: trunk | |
| 18:54 | Updated for extra sheep in the test database check-in: 72d01ef0a6 user: home tags: trunk | |
| 18:41 | Updated for extra sheep in the test database check-in: 2995eb03eb user: home tags: trunk | |
|
2014-09-20
| ||
| 11:09 | Added another inspector name translation check-in: 4fcf8b4f53 user: home tags: trunk | |
|
2014-09-07
| ||
| 10:55 | Added new test to test_sheep_new. Test element class before content. Correct form check methods. check-in: 0036fa8f91 user: home tags: trunk | |
| 10:54 | 'has_progeny' element is only present on the sheep data form so test before using it check-in: a30e50c471 user: home tags: trunk | |
| 10:52 | Horns and Litter no longer used on sheepnew template and removed from html_appconf_items. check-in: 31e1381c28 user: home tags: trunk | |
|
2014-09-06
| ||
| 11:15 | Add doc string to SSSExtract class in extractpdx. Add test for unresolved duplicate transfer dates in cleansqlite. check-in: 5180114a54 user: home tags: trunk | |
| 10:19 | Display the flock number and name. POST sends the real flock number instead of the value in the form entry field. check-in: 25c2996236 user: home tags: trunk | |
|
2014-08-15
| ||
| 20:34 | Updates for tests for the sheep data form check-in: 3e1d4bae75 user: home tags: trunk | |
| 20:33 | Corrections to registration tests. check-in: 5c87dda2b2 user: home tags: trunk | |
|
2014-08-14
| ||
| 11:47 | Added script to display flock prefixes to assist developing the sheep data form. check-in: c7c75f300d user: home tags: trunk | |
| 11:45 | Registration form tests comprehensively check form is correctly initialised. 'Previous sheep' registration number is now displayed in a popup rather than in a field on the next sheep's registration form. check-in: 7765aac48e user: home tags: trunk | |
|
2014-07-22
| ||
| 11:17 | Corrected cross-references in sheep ui forms. check-in: 46be2cf5f0 user: home tags: trunk | |
| 11:05 | Updated docs for the registration/data form's Tag Prefix and Tag Prefix from controls. check-in: 621f0ad255 user: home tags: trunk | |
|
2014-07-21
| ||
| 19:57 | Updates for the tag prefix controls on the sheep data page, including a new corner case - owning flock has no prefixes. Minor layout changes to tag prefix controls on registration form. check-in: 3cb97258fa user: home tags: trunk | |
| 15:37 | Unit test cases for the previous commit. check-in: 5e5c215340 user: home tags: trunk | |
| 15:29 | validators/tag must not report an error if the tag is used by the subject sheep - subject sheep added to parameters and code and tests updated check-in: 90b21df019 user: home tags: trunk | |
| 10:41 | Renamed regsess.tmpl as regnew.tmpl (reverted to original filename). check-in: 1bbb1e5594 user: home tags: trunk | |
|
2014-07-20
| ||
| 16:39 | Updated sheep data form template to match documentation. check-in: b3421fd271 user: peter tags: trunk | |
| 12:48 | javascript changes for registration form to facilitate re-use on data form. check-in: 1068ea45f8 user: peter tags: trunk | |
| 12:02 | Don't show the full URL for a '404 Not found' from the regnew form. check-in: 88dc7a2f82 user: peter tags: trunk | |
|
2014-07-19
| ||
| 16:54 | Updated registration form to match docs - inspected and ignore warnings controls now disabled when not appropriate. check-in: 95952e1aa8 user: home tags: trunk | |
| 16:41 | Fix typo in Validators - was still checking for 'parents' instead of 'breeding' check-in: e7fcedd696 user: home tags: trunk | |
| 15:10 | IE < 10 is no longer supported for the database due to lack of standards compliance. Add banner to the base template to this effect check-in: d04e540281 user: home tags: trunk | |
| 10:27 | Added 'Ignore Warnings' control and minor layout changes to sheep entry forms doc. check-in: 689d67707f user: home tags: trunk | |
|
2014-07-15
| ||
| 11:26 | Correction to uri scheme docs. Replaced registration form docs with a section covering both registration and update forms as these are very similar in layut and function. check-in: 49544683a2 user: home tags: trunk | |
| 11:18 | Correct typo in animal new handler check-in: cdf6f4108f user: home tags: trunk | |
|
2014-06-19
| ||
| 17:24 | animal/validator/parents becomes animal/validator/breeding since it does not check the parents. The flock id passed to animal/new may be passed as a path segment or as a parameter 'inflock'. check-in: b102c753f4 user: home tags: trunk | |
|
2014-06-15
| ||
| 09:38 | Updated uri scheme docs. Closed-Leaf check-in: c2b0a9cf04 user: home tags: new-uris | |
| 09:36 | Updated uri-scheme docs to match code. Minor corrections to templates and js. check-in: 7656e127fb user: home tags: trunk | |
|
2014-06-14
| ||
| 20:37 | Updated URIs to make all parameters into query parameters as in trunk. Docs not yet updated. check-in: 2f32d7fed0 user: home tags: new-uris | |
| 14:49 | Don't make AJAX call to validator if text dob field is empty. check-in: 194009a0fe user: home tags: trunk | |
| 14:15 | HTML page message improved in the case where limit=limit results in no progeny found but limit=all gives progeny. check-in: 8df294a653 user: home tags: trunk | |
| 10:40 | Corrections to allow test cases to run. check-in: b49c4870fa user: home tags: new-uris | |
|
2014-06-13
| ||
| 21:36 | Updated URI scheme: All parameters now passed as query parameters. All representations specified in HTTP accept header. Docs, animal and flockbook code, and test cases updated. check-in: 5ef15cb7d9 user: home tags: trunk | |
|
2014-06-11
| ||
| 19:51 | Merged in new-css branch check-in: 00dbeaa304 user: home tags: trunk | |
| 19:49 |
Adjusted layout of animal new and data pages
Branch now closed. Closed-Leaf check-in: 731d177680 user: home tags: new-css | |
| 19:49 | 'inner' div now sized in em. check-in: 0e108098e0 user: home tags: new-css | |
| 17:12 | DB uses em sizes instead of px sizes. OFB and DB use the same common.css file. SSS OFB uses the same colours as PPD. check-in: 2f8120f79d user: home tags: new-css | |
|
2014-06-10
| ||
| 20:12 | Rename common.css and align the macros in ofb-common and db-common check-in: 77c4190496 user: home tags: new-css | |
| 20:05 | Corrected 'action' path for consistency between ofb and db check-in: 2a473d5d41 user: home tags: trunk | |
| 19:32 | Corrected initialisation test check-in: 23a91270c0 user: home tags: trunk | |
| 19:27 | Revised css, initially for the database, to better handle browser zooming check-in: 5e023ba945 user: home tags: new-css | |
|
2014-06-07
| ||
| 17:30 | Amalgamated the registration form tests into a single file. Corrected the template and javascript as a result of new errors shown up by amalgamated file. Replaced alert dialogs with a CSS/JS dialog to avoid the 'Prevent this page from creating additional dialogs' feature of the standard alert dialog. check-in: 837ecd57df user: home tags: trunk | |
|
2014-06-05
| ||
| 19:39 | Added last_changed to PED_QUERY and to sheep for. corrections to js files. check-in: 4df75c9c1c user: home tags: trunk | |
| 19:37 | Corrected autoreload_on to autoreload.on and added javascript file to autoreload list. check-in: a78581de34 user: home tags: trunk | |
| 08:59 | URI for new animal 'session' changed from animal/regsess to animal/new check-in: a1687fcaa6 user: home tags: trunk | |
| 08:42 | Revert to returning HTTP status 201 from POST to 'animal'. check-in: f9b067a14c user: home tags: trunk | |
|
2014-06-04
| ||
| 16:48 | Fix typo in animal.PUT check-in: f9b1bffabb user: home tags: trunk | |
| 16:14 | Added sheep data form based on registration form. check-in: d3cb107c7f user: home tags: trunk | |
| 11:54 |
The registration form's Horns field is changed from a SELECT control to and INPUT field for compatibility with the Paradox form.
The animal.execute_submit method takes the method as a parameter to allow for use with either POST or PUT methods. check-in: 750638d42d user: home tags: trunk | |
| 08:19 | Correct logo name on base template, correct 'New Flock' url on sheepnew template. check-in: 2f461ec029 user: home tags: trunk | |
|
2014-06-03
| ||
| 08:43 | Add 'flock_name' column to current_flock view and remove unnecessary JOIN from transfer methods for a x5 speedup. check-in: bb2ddc3647 user: home tags: trunk | |
| 07:54 | Merged in the 'revised-uris' branch check-in: 07d25e7a4d user: home tags: trunk | |
|
2014-05-31
| ||
| 14:31 | Merge update from trunk Closed-Leaf check-in: af7d5faf90 user: home tags: revised-uris | |
| 14:29 | Don't set Content-Type header until we know something will be returned to avoid HTML error pages being returned as something other than HTML check-in: 11c2bc2059 user: home tags: trunk | |
|
2014-05-28
| ||
| 14:11 | Added more GET uri tests and corrections to handler and html check-in: d705622fef user: home tags: revised-uris | |
|
2014-05-27
| ||
| 18:43 | Added tests for the 'GET' URIs check-in: 55850526d1 user: home tags: revised-uris | |
|
2014-05-26
| ||
| 09:23 | Merge in changes to testinit check-in: ff34a18c93 user: home tags: revised-uris | |
| 09:18 | testinit subclasses build_app to change the handler config. check-in: 712d675f11 user: home tags: trunk | |
|
2014-05-25
| ||
| 11:26 | Renamed /animal/regn/ URI to /animal/regsess to better match the URI's function check-in: 818aeaa00b user: home tags: revised-uris | |
| 08:30 | Changed OFB warning message colour from red to dark orange. Amended text of multi-hit warning. check-in: 6ec4889402 user: home tags: revised-uris | |
|
2014-05-24
| ||
| 07:56 | Corrections and revisions to URI scheme and implementation. check-in: a1326ca9a3 user: home tags: revised-uris | |
|
2014-05-22
| ||
| 16:10 | Flattened the /resurce/data branches of the URIs and merged the OFB and DB handler classes. check-in: bf61549d97 user: home tags: version-0.33.0, revised-uris | |
| 15:51 | Updated PPDDispatcher class to resolve problem of ticket [71af6ac6f4]. check-in: d03a778d5e user: home tags: revised-uris | |
| 13:10 | Layout and text of URI scheme docs in line with the docs for new-uris branch check-in: 3fb5338f1b user: home tags: revised-uris | |
| 13:09 |
Corrections to URI scheme docs
This branch closed as it has been sureceded by the 'revised-uris' branch. Branch re-opened to allow corrections and furh=ther development. check-in: 31eee29255 user: home tags: new-uris | |
| 08:48 | Revised URI docs and updated them for the new URI scheme. check-in: 23603d7a72 user: home tags: new-uris | |
|
2014-05-18
| ||
| 17:15 | Moved _cp_dispatch to package and changed to allow parameters as path segments. Flock and Animal handlers updated to differentiate between OFB and DB. check-in: bd007e1d48 user: home tags: new-uris | |
|
2014-05-17
| ||
| 16:13 | Updated OFB html pages for new URI scheme. Corrections and updates to URI handlers. check-in: bf9a0555b6 user: home tags: new-uris | |
| 16:12 | Added checks for empty err_msg on 'Find' pages> check-in: adfcb22352 user: home tags: new-uris | |
| 13:23 | Changes to handlers and init scripts for revised, more RESTful, URI scheme check-in: a7aab4a4ca user: home tags: new-uris | |
|
2014-05-16
| ||
| 11:28 | Added tool to limit accepted methods to 'GET' (for the OFB) check-in: 28601f2a7c user: home tags: trunk | |
| 11:26 | Refactored code for btter maintainability check-in: c9834950a7 user: home tags: trunk | |
| 11:26 | Set the 500 error mailfrom address to home@localhost for test cases check-in: 5eba5e8ee5 user: home tags: trunk | |
|
2014-05-15
| ||
| 15:34 | Module test_pg_pool now uses httplib instead of Selenium Web to make requests check-in: 758a3461f4 user: home tags: trunk | |
| 14:35 | Moved code from selweb.__init__.py to test.__init__.py check-in: 569dfcc375 user: home tags: trunk | |
| 13:53 | Moved package code for utests up a level. Moved and renamed the code to run a test instance of CherryPy so it can be used for unit tests aas wel all Webdriver tests. check-in: 9df2e31de8 user: home tags: trunk | |
| 11:12 | Corrections to test modules check-in: 330bcbc5e3 user: home tags: trunk | |
| 10:17 | Flattened sss_register and ofb subdirectories check-in: 76681d82a9 user: home tags: trunk | |
| 10:11 | Renamed selenium_web directory to selweb check-in: 6c06a0c039 user: home tags: trunk | |
| 09:57 | Extended registration test to include test of error message alert check-in: d9b0a1c5a2 user: home tags: trunk | |
|
2014-05-14
| ||
| 19:49 | Updates to allow selenium web tests to undo changes to the database check-in: 59c5769e4a user: home tags: trunk | |
|
2014-05-13
| ||
| 17:09 | Selenium tests to register an animal. Corrections to code to allow a sheep to be registered. check-in: a2cd4047bb user: peter tags: trunk | |
| 17:07 | Sanitise params now allows solidus (forward slash) for use in text dates. check-in: 7cfcdde90f user: peter tags: trunk | |
|
2014-05-12
| ||
| 16:42 | Database libraries have a common method to run SQL commands. check-in: d58855be8b user: home tags: trunk | |
| 10:11 | Corrections to test cases. Added docstrings to test methods. check-in: 9d52665a8f user: home tags: trunk | |
| 10:08 | Removed JSS test cases from test_findsheep check-in: 6eb3bf5d30 user: home tags: trunk | |
| 10:01 | Added new 'transfer_reason' of 'Mistake' to sheep schema. check-in: d5942a2bd3 user: home tags: trunk | |
| 09:48 | Added documentaton for sheep transfers check-in: 9409a14266 user: home tags: trunk | |
|
2014-05-07
| ||
| 20:03 | Updated test_sheepregn for new checked value of 'ignore_warnings' check-in: f22d2fc650 user: home tags: trunk | |
| 20:02 | Merged test_validatepost and test_validatetag into test.shpval with many added test cases. Renamed test_sheepval to test_sheepvalidators. Corrections to libraries resulting from additional tests - shpval library now has 99% coverage (one line can't be tested). check-in: f771401766 user: home tags: trunk | |
|
2014-05-06
| ||
| 10:04 | Flattened unit test directory - nose attributes allow test selection. check-in: c3cda830fc user: home tags: trunk | |
| 09:33 | Added missing import of fbkuri check-in: 08716bf7f1 user: home tags: trunk | |
| 09:28 | Merged in regn-test branch check-in: 910b8efce8 user: home tags: trunk | |
| 09:25 | Registration test extended to cover resurrecting sheep, and cleans up transfers. Closed-Leaf check-in: a650329e88 user: home tags: regn-test | |
|
2014-05-05
| ||
| 20:24 | File missed from checkin [64cbc2b8b4] check-in: b36e563319 user: home tags: regn-test | |
| 16:30 | User provided dates are stored in 'transfer' and 'flock_owner' as DATE columns instead of TIMESTAMP. cleansqlite.py removes rudundant records from sheep_flock - where a flock has moved to 'Unknown' and back to a real flock on the same date, and various mistakes and records inserted as user errors. Fixes ticket [f28872ce58]. check-in: 64cbc2b8b4 user: home tags: regn-test | |
| 16:21 | Updated CP configuration for CP 3.3.0 check-in: 0f138b7a70 user: home tags: regn-test | |
| 11:16 | deploy.py copies Sphinx docs source if 'devt' is specified check-in: 8d18b4040f user: home tags: trunk | |
|
2014-05-02
| ||
| 19:53 | Added tests for shpval.validate_post_data. Corrections and changes to shplib, transfer and shpval modules fot transfers at registration time. Updated tests in test_sheepreg.py and a minor correction to test_shpval.py check-in: a249e4792c user: home tags: regn-test | |
|
2014-05-01
| ||
| 11:57 | Added skeleton fbkuri.py so registration URI test can determine the current flock book volume. Basic registration test now runs but does not test transfers. check-in: 48ae3668ae user: home tags: regn-test | |
| 11:17 | Amended URI scheme for flockbook, tag, inspection and prp-genetics check-in: bb5df50da5 user: home tags: regn-test | |
| 09:35 | Corrected use of @attr decorator with multiple attributes check-in: e7ed3266e4 user: home tags: regn-test | |
|
2014-04-30
| ||
| 10:19 | Merged updates from trunk check-in: 745c463744 user: home tags: regn-test | |
|
2014-04-28
| ||
| 08:16 | Add set_update_ts trigger to all tables using audit_update trigger. Fixes ticket [dbe7790847] check-in: 42d7007ea1 user: home tags: trunk | |
|
2014-04-25
| ||
| 18:05 | Added attributes to test classes to allow selection by group - base, meth[ods], url, selweb and ofb check-in: bb75089a6e user: home tags: trunk | |
| 11:24 | Revised sheep_schema trigger definitions to improve documentation. reinstated test for presence of last_changed in pgsql audit function. check-in: 243ca8ebaa user: home tags: trunk | |
| 11:21 | Added padding to timestamps per ticket [36fd824b86]. Corrected test CD1. check-in: 2ef18daf08 user: home tags: trunk | |
| 11:18 | Updated docs for latest handler modules. check-in: 8462a4948f user: home tags: trunk | |
|
2014-04-24
| ||
| 20:12 | Expanded audit tests to test the whole 'new' and 'old' rows. Updates and corrections to trigger definitions for new tests. audit-insert trigger is deprecated as it is non-functional in SQLite check-in: 62b0b32dcb user: home tags: trunk | |
|
2014-04-23
| ||
| 15:29 | test_audit module re-written without the use of nested structures. sheep_schema includes corrections to triggers and trigger functions resulting from the new audit tests. check-in: 40c513f60f user: home tags: trunk | |
| 15:27 | iso_ts_now and iso_ts_now_delta functions return millisecond instead of microsecond resolution timestamps. All timestamps generated using date and datetime modules instead of time module. check-in: 40a1f810b5 user: home tags: trunk | |
| 15:24 | Added docstrings to RDBMS modules to document AUTOINCREMENT columns. Corrected create-table() method and added new trigger generation dict to sqlite3lib.py check-in: 4a8ddc8940 user: home tags: trunk | |
| 15:21 | Remove redundant print statement from deploy.py. Add information print statements to dbrefresh.py. check-in: 85d83836cf user: home tags: trunk | |
|
2014-04-22
| ||
| 10:01 | Merged in updates from trunk check-in: a846c430a4 user: home tags: regn-test | |
| 09:56 | Merged in mem_upd branch. check-in: 16f7695634 user: home tags: trunk | |
|
2014-04-12
| ||
| 09:37 | Set person created dates where person.last_changed = member.joined Closed-Leaf check-in: 4d656a34da user: home tags: mem_update | |
|
2014-04-11
| ||
| 08:45 | Inital changes to update member code for member table changes check-in: 68f6e5cdd2 user: home tags: mem_update | |
|
2014-04-09
| ||
| 12:42 | Removed print statement from deploy.py. sss.conf 'lastupdate' updated for 20140407 tables. check-in: ea25378732 user: home tags: 0.31.x | |
| 11:46 | deploy.py copies dataconv if 'cpsrv devt' is specified check-in: e92be4696c user: home tags: 0.31.x | |
| 09:55 | Handle the case where the Postgres server disconnects between requests check-in: 4faa134dd2 user: home tags: 0.31.x | |
| 09:49 | Don't try to create crumb trail if no crumb is passed check-in: 16c3a06cc2 user: home tags: 0.31.x | |
| 09:47 | Update copyright statement in footer check-in: 486ba259bf user: home tags: 0.31.x | |
| 09:45 | Updates to 0.31.3 - ppd.conf revised for separate ofb database, ppd.py sends email if a 500 error occurs. check-in: 849627f7c8 user: home tags: 0.31.x | |
| 09:06 | New branch for 0.31.x live code check-in: e38db06ec5 user: home tags: 0.31.x | |
|
2014-04-06
| ||
| 13:34 | New branch for sheep registration test changes check-in: 23bc8a7c72 user: home tags: regn-test | |
|
2014-04-04
| ||
| 10:47 | deploy.py copies the dataconv directory if 'cpsrv devt' is specified check-in: b95f0da8d8 user: home tags: trunk | |
| 09:57 | Sheep schema set_insert_ts uses an AFTER trigger for SQLite3 as a BEFORE trigger does not set an AUTOINC key field correctly - see docs. Added test for this to test_audit.py. Sheep schema sets ON DELETE CASCADE FK constraint on sheep secondary tables. check-in: 7756b9a967 user: home tags: trunk | |
| 09:51 | Removed print statement from util.py. sqlite3lib.py uses intermediate variables in exec_cmd() to assist debugging check-in: 673f8b7cd1 user: home tags: trunk | |
| 09:41 | Added non-empty __init__.py files - previous commit committed empty files check-in: 464ec15153 user: home tags: trunk | |
|
2014-04-02
| ||
| 15:31 | Added initial unit test cases for registration. Corrections to existing code now tested by the new test cases. check-in: 487a7ae8ce user: peter tags: trunk | |
| 10:30 | Split unit tests into sub-directories to ensure they run in the correct order. Revised messages to be more explicit about which tests are being run. check-in: 7b13a7ef71 user: peter tags: trunk | |
|
2014-03-12
| ||
| 09:40 | Selenium-Web test_pg_pool confirms that without the retry code killing the postgres connection processes will result in a 500 error. pglib.DB_CONF may have an additional key 'TEST_PG_POOL' which will disable the connection retry code. This key is set by selenium_web.start_externals. check-in: 2245510262 user: home tags: trunk | |
|
2014-03-06
| ||
| 16:19 | Merged in the 'testcase-db' branch - fix for ticket [526d8ac27f]. check-in: 5385a7c028 user: home tags: trunk | |
| 11:30 | Handle 500 errors gracefully if no email can be sent check-in: 266346760d user: peter tags: trunk | |
| 10:25 | Merged in changes from trunk Closed-Leaf check-in: 19c27afdb3 user: peter tags: testcase-db | |
| 09:51 | Reinstate commit in close_app_db_connection() - removed in error in the new-dbconn branch. check-in: 1baf56eb53 user: home tags: trunk | |
|
2014-03-05
| ||
| 13:01 | Added initial message. Improved test cases with 4xx status codes. check-in: 18fae33358 user: peter tags: trunk | |
|
2014-03-04
| ||
| 17:28 | Updated make_test to include entities necessary to run selenium tests. Test cases updated to suit test database. Config corrected. check-in: 272dc40988 user: peter tags: testcase-db | |
|
2014-03-02
| ||
| 16:31 | Initial checkin of updates for ticket [526d8ac27f] check-in: 5370804aa8 user: peter tags: testcase-db | |
| 14:59 | Use public method instead of private to read config. Missed from checkin [5e38c0dfaa], ticket [ff0cf19490] check-in: 9ebd3a8659 user: peter tags: trunk | |
| 11:18 | Set docs encoding to utf-8. Minor corrections to docs. check-in: 8abc0ce216 user: peter tags: trunk | |
|
2014-02-27
| ||
| 12:40 | Merged in the new-dbconn branch check-in: 4afa004a22 user: peter tags: trunk | |
| 12:38 | Revised exception handling to explicitly catch operational errors Closed-Leaf check-in: e6049af977 user: peter tags: new-dbconn | |
| 11:02 | Reverted to original function names in pglib. pglib now handles server disconnect in make_app_db_connection(). Tests for server disconnect added. check-in: 819917f3ca user: peter tags: new-dbconn | |
|
2014-02-24
| ||
| 11:35 | Added ASTERISK to sanitise whitelist - used as a wildcard in searches. Fix for ticket [9947ddcbb20] check-in: 4ef45df037 user: home tags: trunk | |
| 11:33 | Replaced 'test' with 'tmp' in function names to prevent functions being run as tests. check-in: 5a2e6faa3f user: home tags: trunk | |
| 11:31 | Checkout 24f18aab7a commite the wrong file check-in: 9cb06ca93b user: home tags: trunk | |
| 11:21 | Replaced 'test' with 'tmp' in function names to prevent functions being run as tests. check-in: 24f18aab7a user: home tags: trunk | |
|
2014-02-21
| ||
| 09:05 | Revised connection methods for PostgreSQL check-in: fadd5186c0 user: home tags: new-dbconn | |
| 09:03 | Added explanation od exclusions check-in: 2ebaaab293 user: home tags: trunk | |
|
2014-02-19
| ||
| 19:40 | New regexp for sanitising input with unit test cases in test_tools.py. check-in: e7bbb595ae user: home tags: trunk | |
|
2014-02-17
| ||
| 21:48 | Added rfc3986 (URI format) and input sanitising doc. check-in: cb66846877 user: home tags: trunk | |
|
2014-02-14
| ||
| 21:50 | Added clean-up of sheep names with bad characters. check-in: f67d21945e user: home tags: trunk | |
|
2014-02-11
| ||
| 15:49 | Modified sss OFB test EB for the fix of ticket [75a7095db4]. check-in: 06003d5b4e user: peter tags: trunk | |
| 15:23 | Audit tests may be excluded by specifying -a '!audit' when invoking tests. check-in: ff5a729ace user: peter tags: trunk | |
| 15:20 | Selenium web tests keep browser window open on failure. check-in: 293fc4dd35 user: peter tags: trunk | |
| 15:19 | Corrected columns in nomem member table. dbrefresh builds database schema without auditing if tar file does not contain change_history.txt check-in: 56354fd829 user: peter tags: trunk | |
| 09:21 | Fix for ticket [75a7095db4]. check-in: adbd72377a user: peter tags: trunk | |
|
2014-02-10
| ||
| 20:27 | Conversions with 'nomem' do not convert history or install auditing table and triggers check-in: 62b695d12f user: peter tags: trunk | |
| 09:05 | Data conversion only appends encoding to filenames if the encoding is NOT the default (UTF-8). check-in: 80bc10f239 user: home tags: trunk | |
|
2014-02-09
| ||
| 20:19 | Fix for ticket [ff0cf19490] - use cherrypy.lib.reprconf.Config() instead of cherrypy_cpconfig.merge(). check-in: 5e38c0dfaa user: home tags: trunk | |
| 17:14 | Module run_selweb only tests for the presence of SQLite databases for apps defined in ppd.conf [apps] section. check-in: 869b225a40 user: home tags: trunk | |
| 17:00 | merged animalbase, animaldb and animalbdsub into a single module animaluri. check-in: e2fc0e1c8e user: home tags: trunk | |
| 13:37 | Merged the audited branch. check-in: 37c531f885 user: home tags: trunk | |
| 13:30 | Added conversion of Paradox SHPCHNG to the audited database. Closed-Leaf check-in: df94f851fc user: home tags: audited | |
|
2014-02-05
| ||
| 15:40 | Corrected typo in mem_pmts transform. Closed-Leaf check-in: 0907aa4f22 user: peter tags: audited | |
|
2014-02-04
| ||
| 20:12 | Updated table auditing docs to add 'additional data' sub-section check-in: 16fc43aef7 user: home tags: tmp, audited | |
| 09:36 | new_data and old_data in command to insert payment history into change_history were reversed. check-in: 5bdd7197ac user: home tags: tmp, audited | |
|
2014-02-02
| ||
| 18:56 | Added conversion of mempmnts to transform.py. Non-existant flock removed from mempmnts by cleansqlite.py check-in: 16d8e571ef user: home tags: tmp, audited | |
|
2014-02-01
| ||
| 18:17 | test_audit.py now tests all possible audit triggers using test tables, and also tests a 'live' table. Corrections to sheep_schema and sslite3lib. check-in: 2f30c71ecc user: home tags: tmp, audited | |
| 18:15 | Additional text for MEMPMNTS conversion check-in: a1e0b73922 user: home tags: tmp, audited | |
|
2014-01-31
| ||
| 16:52 | Modified test_audit.py for comaptibility with other unit test files check-in: 0026ee2fa3 user: home tags: tmp, audited | |
| 16:17 | Audit unit tests create and drop a set of tables for testing triggers. Updates to supporting/tested modules. check-in: 2b1f3a0e1e user: home tags: tmp, audited | |
| 10:51 | New functions in pglib and sqlite3lib to create tables, triggers, indexes based on existing methods in dbrefresh and transform. Schema file revised to facilitate this change. Modules dbrefresh, transform and make_test use the new functions, replacing the old ones. check-in: f3f1baad2d user: home tags: tmp, audited | |
|
2014-01-30
| ||
| 10:19 | Corrected some errors in pgsql. Auditing now saves both old and new records. check-in: 2b9c5453a7 user: home tags: tmp, audited | |
|
2014-01-28
| ||
| 17:13 | Data conversion splits the memchng history into phone (two numbers) and address history. check-in: d88d2f603c user: home tags: tmp, audited | |
| 17:11 | change_history table has two columns to hold record key values. Columns are specified in a new 'row_id_cols' item in each master table's schema. Removed UNIQUE constraint on phone table as unnecessary check-in: a404f448b5 user: home tags: tmp, audited | |
| 17:06 | Set common county and country in MEMCHNG for 'ZE' postcodesand the various spellings of 'USA' check-in: 40bddff0c0 user: home tags: tmp, audited | |
|
2014-01-21
| ||
| 18:14 | Corrections and updates to auditing docs. check-in: 09f4d798e7 user: home tags: tmp, audited | |
| 13:24 | The PL/perl no_hstore audit function is removed leaving the PL/Tcl version. The hstore function remains in PL/pgsql as hstore can only be used with this language. check-in: a98d7b37a5 user: home tags: tmp, audited | |
|
2014-01-20
| ||
| 23:27 | no_hstore audit func rewritten in PL/perl. Another version written in PL/Tcl added as easier to follow than the PL/perl version. check-in: b7e880ec03 user: home tags: tmp, audited | |
|
2014-01-19
| ||
| 19:35 | New dbconf item 'hstore' to specify whether PostgreSQL has the 'hstore' extension or not. Schema and tests updated to support hstore/no hstore depending on setting in ppd.conf. check-in: c8f4fde97b user: home tags: tmp, audited | |
|
2014-01-18
| ||
| 17:45 | Views on change_history corrected and expanded. test_audit handles SQLite and PosgreSQL tests allowing for different formats of row_data check-in: 2765f92f38 user: home tags: tmp, audited | |
| 14:39 | SQLite audit row has same format as pgsql. pgsql audit table stores hstore instead of text check-in: 3db9922c20 user: home tags: tmp, audited | |
|
2014-01-17
| ||
| 21:07 | Auditing now uses only a single composite history table for all master tables. The history record has one column for the 'audited row' with all audited columns as a text 'dict' for SQLite or a text hstore for PostgreSQL check-in: 1ee597b295 user: home tags: tmp, audited | |
|
2014-01-15
| ||
| 17:16 | Added dependencies section to docs 'overview' chapter check-in: f14f4fb554 user: home tags: trunk | |
|
2014-01-14
| ||
| 14:47 | Corrected pgsql function in sheep_schema, removed 'print' statement in sqlite3lib check-in: a0f4bb15a1 user: home tags: tmp, audited | |
|
2014-01-13
| ||
| 17:31 | Updated audit unit testcases. Corrections to get testcases to run. check-in: 21754cb9e6 user: home tags: tmp, audited | |
| 10:50 | Updated licence and install docs. check-in: fa935aff21 user: home tags: trunk | |
|
2014-01-12
| ||
| 16:55 | Added a consolidated history option for auditing. All tables are now audited using either shadow tables or consolidated history. check-in: 117acd6118 user: home tags: tmp, audited | |
|
2014-01-10
| ||
| 17:57 | Added foreign key actions to table definitions check-in: a3119f5d0e user: peter tags: tmp, audited | |
| 17:30 | Auditing added, using a consolidated history by record, to all parent (ie referenced) tables. no_delete, no_update and mark_deleted triggers no loger used but remain in the schema. Added audit_insert triggers, but not yest used. check-in: 32a53e2f2a user: peter tags: tmp, audited | |
| 14:26 | Added checks for the pragma settings check-in: 97fef9f66e user: peter tags: tmp, audited | |
|
2014-01-09
| ||
| 17:42 | Improvements to audit unit test file to avoid repetition. Updated sheep_schema, transform, make_test and dbrefresh to improve audit mrc view generation. make_test brought up to date. check-in: 1b1c16df69 user: home tags: tmp, audited | |
|
2014-01-08
| ||
| 22:28 | Updates and corrections to table and trigger creation and trigger tests. check-in: 8654ef34a6 user: peter tags: tmp, audited | |
| 10:19 | Updated trigger definitions with corresponding change to dbrefresh check-in: 4df1558842 user: home tags: tmp, audited | |
|
2014-01-07
| ||
| 18:07 | Revised auditing unit tests. Triggers now set timestamps with millisecond resolution. New timestamp methods in 'util' module. check-in: db6d1f4811 user: home tags: tmp, audited | |
| 18:05 | Revised auditing documents check-in: 3226a129ac user: home tags: tmp, audited | |
| 18:04 | Set trigger_recursion pragma to off check-in: 9748757f7c user: home tags: tmp, audited | |
| 10:13 | Abandoned because 'foreign keys' must either be maintained forever or not used at all. Branch marked as 'closed'. Closed-Leaf check-in: ef56ac838c user: home tags: audit-new | |
|
2014-01-06
| ||
| 19:50 | Added test for finding a flock by tag prefix check-in: a92f409be0 user: peter tags: trunk | |
| 18:39 | Corrected trigger support. Added unit tests for mem_class triggers check-in: e859789ef1 user: peter tags: tmp, audited | |
| 17:52 | Fix bug on commanc page where sheep with spares pedigrees caused 500 error. check-in: 7b7ba7186c user: peter tags: trunk | |
|
2014-01-04
| ||
| 20:31 | Updated pxlib to fix bug where timestamps are incorrectly converted on i686 platforms. check-in: 5051bd8319 user: peter tags: trunk | |
|
2014-01-03
| ||
| 14:52 | Fix bug in find_flock. Add unit test file skeleton for find_flock check-in: 06125f2099 user: home tags: trunk | |
|
2014-01-02
| ||
| 22:39 | Changes to add audit tables and triggesr to PostgreSQL database check-in: 74e4c13016 user: peter tags: tmp, audited | |
| 21:15 | Corrections to get dataconv working (without audit tables) check-in: b2cab86fdd user: peter tags: tmp, audited | |
| 16:47 | Expanded and revised auditing documentation to include the 'roll-off' method from the audit-new branch. check-in: c1f453b8d4 user: home tags: tmp, audited | |
| 14:42 | Updates to new audit scheme check-in: ea3e9ce641 user: peter tags: audit-new | |
|
2014-01-01
| ||
| 12:05 | Initial docs for a new audit scheme check-in: 400fc354ba user: home tags: audit-new | |
|
2013-12-30
| ||
| 18:48 | Merged dataconv update from trunk check-in: 9ca39c6dea user: peter tags: tmp, audited | |
| 18:46 | Added 10 more sheep born before their real breeder registered a flock check-in: c2b025c253 user: peter tags: trunk | |
| 16:44 | Updated auditing docs check-in: 884e6ee7f2 user: peter tags: tmp, audited | |
| 16:42 | Added 'deleted' column to 'transfer' table check-in: e739ca84c9 user: peter tags: tmp, audited | |
| 11:36 | Removed unused file check-in: 287d1ece37 user: peter tags: trunk | |
| 11:35 | Corrected merge user mistake, removed unused file. check-in: 92bbe817eb user: peter tags: tmp, audited | |
|
2013-12-29
| ||
| 12:33 | Merged changes from trunk check-in: 1c7d579e50 user: peter tags: tmp, audited | |
| 11:38 | Use HOME environment variable to set docs output path check-in: b2e72146d2 user: peter tags: trunk | |
| 11:37 | Corrected syntax errors in new method check-in: b271419378 user: peter tags: trunk | |
|
2013-12-28
| ||
| 12:27 | Added method to flock library from equivalent method in the Paradox database. check-in: 2c0dfe91d0 user: home tags: trunk | |
|
2013-12-19
| ||
| 16:24 | Error email configuration moved to a new section in ppd.conf check-in: 5d734a7440 user: home tags: trunk, tmp | |
| 09:26 | Added custom 500 error page and code to email the webmaster on a 500. check-in: 5be7e3cebb user: home tags: trunk, tmp | |
|
2013-11-30
| ||
| 19:08 | merged in the schema-update branch. This fixes ticket [6df2990239]. check-in: ce516a797f user: home tags: trunk, tmp | |
| 19:05 | Updated modules and docs for the revised schema Closed-Leaf check-in: 1dc0091c34 user: home tags: schema-update | |
| 18:22 | Corrections to unit tests check-in: 662b367cd6 user: home tags: trunk, tmp | |
| 09:48 | Initial commit of changes for ticket [6df2990239] check-in: 763d025d4a user: home tags: schema-update | |
| 09:43 | Merged the ui-enhance branch check-in: 4ff73c9ef0 user: home tags: trunk, tmp | |
|
2013-11-29
| ||
| 18:29 | Changes to details of UI. Updated tests for revised messages and field contents. Closed-Leaf check-in: b4bb6fc787 user: home tags: ui-enhance | |
|
2013-11-28
| ||
| 21:25 | Tightened registration form layout. Errors now have red background. Ensure form is reset when loaded/reloaded. check-in: b86e6b2d84 user: peter tags: ui-enhance | |
| 11:16 | Merged changes from trunk check-in: 695b42c891 user: peter tags: ui-enhance | |
| 11:13 | Updated Javascript and web sibling tests for the added sibling data. check-in: 69c2234397 user: peter tags: trunk, tmp | |
| 09:19 | Change display of warnings and errors - use backgground colours instead of text colours. Change message field defaults and visibility so layout is unchanged when messages are displayed. check-in: 29c7789f7e user: peter tags: ui-enhance | |
| 09:13 | Selenium web tests take ip/port for requests from ppd.conf. check-in: 943c1c7754 user: peter tags: trunk, tmp | |
|
2013-11-26
| ||
| 18:17 | Another revision to check_siblings litter size tests to reduce the number of messages presented to the user. Unit tests updated and augmented. check-in: 971cb86d36 user: home tags: trunk, tmp | |
|
2013-11-23
| ||
| 21:44 | Revised the litter size checks in check_siblings. make_test.py adds some more sheep for the litter size checks. Test cases are updated for the revised tests. check-in: 9fb48d7cf9 user: home tags: trunk, tmp | |
|
2013-11-22
| ||
| 17:40 | Corrections and amendments to check_siblings. Upated javascript and test cases for new URL for sibs and parents validators check-in: cab907747a user: home tags: trunk, tmp | |
|
2013-11-21
| ||
| 12:18 | Additional parameter to check_siblings, and changes to that method to check either a new sheep or an existing sheep. Test cases need more revisions for the second case. check-in: 82bf3adbe3 user: home tags: trunk, tmp | |
| 10:06 | dbrefresh.py now detects the correct schemafile from the breed parameter. check-in: 0a60bb930f user: home tags: trunk, tmp | |
| 09:56 | Dataconv make_test now detects the correct schemafile from the breed parameter. check-in: 2a8f26d2ff user: home tags: trunk, tmp | |
|
2013-11-20
| ||
| 09:46 | Corrected parameters passed to shpval.check_siblings. 'dominbase' in ppd.conf must be empty for WebFaction deployment. check-in: 4719d9f483 user: home tags: trunk, tmp | |
|
2013-11-16
| ||
| 20:57 |
Convert now exports the table information with the -i option.
extractpdx.py refactored to remove unnecessary code duplication. check-in: 00c80d6e5b user: home tags: trunk, tmp | |
|
2013-11-15
| ||
| 21:07 |
Changes to support the SCBA OFB including searching for herds.
Selenium IDE tests for SCBA augmented and selenium web testcases file added. check-in: 6293c82fef user: home tags: trunk, tmp | |
| 09:16 | Dataconv now detects the correct schemafile from the breed parameter. The 'legacy' parameter is removed as OFB Version 0.23.1 is no longer in use anywhere. check-in: 818516a4ae user: home tags: trunk, tmp | |
| 08:46 | Merged changes to bring SCBA cattle up to date from the cattle-update branch, which has turned int a different set of changes. check-in: ed4f39218a user: home tags: trunk, tmp | |
| 08:44 | Minor text change to uri-scheme.rst. Add new method to transfer.py check-in: 3206b9f53c user: home tags: trunk, tmp | |
|
2013-11-11
| ||
| 14:19 | Grouping changed from 'herd' to 'group' as herd is not obviously generic. Closed-Leaf check-in: 0c3db8261e user: home tags: cattle-update | |
|
2013-11-08
| ||
| 20:40 | Generic grouping changes. Unit and Selenium tests now run. check-in: 5031d9b391 user: home tags: cattle-update | |
|
2013-11-07
| ||
| 21:26 | Generic grouping name changed from 'flock' to 'herd' - works for everything whereas 'flock' has limited application. check-in: 7dc51a9983 user: home tags: cattle-update | |
| 09:19 | Initial changes to bring cattle (SCBA) up to date. Includes changes to coomon modules. check-in: 1e1f157721 user: home tags: cattle-update | |
|
2013-11-06
| ||
| 20:31 | Allow for breeds that do not have a 'dead flock'. check-in: f3667c2c24 user: home tags: trunk, tmp | |
| 16:59 | Backed out checkin [8a99cc6b49] - colour_code is a foreign key in cattle, and the foreign key must be the primary key of the parent table or have a UNIQUE index constraint. check-in: b0a1aeb3e5 user: home tags: trunk, tmp | |
| 15:31 | Fix for ticket [e6c1786387] for the cattle tables only. Use view_order as the primary key. check-in: 8a99cc6b49 user: home tags: trunk, tmp | |
|
2013-11-03
| ||
| 21:06 |
Corrected ppd.conf for the webfaction deployment.
Corrected create_tables function name in transformscba.py - should be create_table. check-in: 8e0dccb4c1 user: home tags: trunk, tmp | |
|
2013-10-21
| ||
| 10:53 | Correct Selenium web tests for latest crumb-trail and message format. check-in: 9f28d7ecb5 user: home tags: trunk, tmp, release, version-0.31.1 | |
| 10:51 | Fix for ticket [016c57f892] - convert sequence number into a minute offset instead of an hour. check-in: 4686c30abc user: home tags: trunk, tmp | |
|
2013-10-07
| ||
| 18:36 | Merge in member file changes check-in: d0638eda3a user: peter tags: tmp, audited | |
| 18:26 | Merged in changes from trunk check-in: fbc6256143 user: peter tags: tmp, audited | |
| 08:36 | Ticket [ba059f0fdf] - share_data support added to member files. check-in: 50ae5cd757 user: home tags: trunk, tmp | |
|
2013-10-06
| ||
| 15:14 | Ticket [ba059f0fdf]. Tables, data conversion, documents and PostgreSQL database updated with member.share_data column to match paradox database 7.0.3 check-in: 046b2c139c user: home tags: trunk, tmp | |
| 14:09 | Correct bug in animalbase.py DataOFB.GET - 'Referer' header is only present if URL is reached from a link. Correct URL for link from flock number in flock list page. check-in: cfc664dcf4 user: home tags: trunk, tmp | |
| 13:15 | Don't try to create 'crumbtrail' if no crumb is passed. 'crumbtrail' is not used at all in the DB. check-in: 1f5ac92592 user: home tags: trunk, tmp | |
|
2013-10-05
| ||
| 11:09 | Removed JSS registration regs from docs appendix. Updated docs onf file for current version. check-in: ea57571548 user: home tags: trunk, tmp | |
| 10:39 | Updated OFB footer to make problem reporting link more explicit. check-in: efafcf05b8 user: home tags: trunk, tmp, Version-0.30.0 | |
|
2013-10-04
| ||
| 20:05 | Ticket [44dc12ed78] - correct cursor closing calls. check-in: f63895dd37 user: home tags: trunk, tmp | |
|
2013-09-15
| ||
| 08:24 | Put the OFB into maintenance mode when restarting it so a request won't restart it early. check-in: c8cec1db3d user: home tags: trunk, tmp | |
|
2013-09-13
| ||
| 16:37 | Configured ppd to serve static files at root from ppdb/static. Added robots.txt. check-in: 688f7fb56e user: home tags: trunk, tmp | |
|
2013-09-10
| ||
| 12:50 | Changed cherryPy logo and added the database logo to the OFB footer. check-in: 92e7d8c3a9 user: home tags: trunk, tmp | |
| 11:02 | Corrected query to build flockprefix_data - exclude 'None' prefixes except for breed flocks. check-in: 3d30c7b360 user: home tags: trunk, tmp | |
| 08:46 | Correct column names in FLOCK_SORT_TRANSLATE - SQLite requires table alias to disambiguate some column names. check-in: d327bccaa5 user: home tags: trunk, tmp | |
|
2013-09-09
| ||
| 20:35 | Sort buttons on flock and animal list pages are coloured when active (ie sorted by). check-in: f0396dcbec user: home tags: trunk, tmp | |
| 13:47 | 'sort by' parameters verified against keys in the translate dicts. check-in: 66b76c6198 user: home tags: trunk, tmp | |
| 13:17 | Set background colour on buttons to remove browser styles. Added rule for background of active button. check-in: ed1dc191aa user: home tags: trunk, tmp | |
| 13:10 | Changed 'pathcells' to 'breadcrumbs' on OFB pages. Removed unused path cells from DB pages. check-in: ce349fcc53 user: home tags: trunk, tmp | |
|
2013-09-08
| ||
| 09:04 | Correct column names in ANIMAL_SORT_TRANSLATE - SQLite requires table alias to disambiguate some column names. check-in: c00b214d68 user: home tags: trunk, tmp | |
|
2013-09-07
| ||
| 14:12 | Corrected ofbhome link list. Tidied up headers for animal and flock lists. check-in: 4669462bed user: home tags: trunk, tmp | |
| 08:10 | Added OFB breadcrumb line to flocklist. Set buttons to fill column width on flock and animal list pages. check-in: 6250334374 user: home tags: trunk, tmp | |
| 08:06 | Added an OFB breadcrumb line to the flock and animal find pages. check-in: e94fd9afec user: home tags: trunk, tmp | |
|
2013-09-06
| ||
| 19:23 | Extended 'server' parameter so that specifying 'devt' with a mode of 'cpsrv' sets autoreload on in run_serve.py check-in: 65051c6ba7 user: home tags: trunk, tmp | |
| 17:04 | Changes to the OFB sheep and flock listing pages to allow the sheep listing to be sorted by the user. check-in: 5c21eefb38 user: home tags: trunk, tmp | |
| 10:13 | Improved comments to exec_trans functions to clarify result formats. check-in: b291c8b224 user: home tags: trunk, tmp | |
|
2013-09-03
| ||
| 17:26 | Added tests for wildcards to selenium-web OFB tests. Bumped version. check-in: 0c8dba9119 user: home tags: trunk, tmp, Version-0.23.2 | |
|
2013-09-02
| ||
| 17:17 | Correct bug at line 157 - extra parameter. Wildcards in flockname must be explicit (line 94) check-in: 2425f8d57a user: home tags: trunk, tmp | |
| 17:05 | Update Sphinx module docs contents files for tha packagified directory structure. check-in: 36b5067543 user: home tags: trunk, tmp | |
| 17:04 | Moved configureation of server.socket_port and server.socket_host back into ppd.conf from run_serve.py so that the module docs will run and to get all the server config back into one place. check-in: fd10861af3 user: home tags: trunk, tmp | |
| 14:29 |
Bug fixes:
flockuri.py: correct parms fo get_flock_data at lines 179, 187 animalid.py: add assignment at line 56 member.py: correct misplaced ')' at line 57 sheeplib.py,: add missing comma at line 57 check-in: e04d19964d user: home tags: trunk, tmp | |
|
2013-07-23
| ||
| 13:32 | Added another 3 sheep born before their birth flock was registered. check-in: a476ca9d3f user: home tags: trunk, tmp | |
|
2013-04-08
| ||
| 17:52 |
Fix for ticket [382aa20206] - 500 error searching for progeny of a sheep with no progeny.
Also added element id to error message in animalfind.html, added test for this case to selenium tests, bumped minor version in ppd.py check-in: 6be1b92796 user: home tags: trunk, tmp | |
| 17:47 |
Added test/__init__.py yet again. This time remembered to give it some content so Fossil doesn't ignore it.
Added sockethost and socketport config values to run_selweb.py - got missed from checkin [fd81da81f3] where they were moved from ppd.conf to the run_serve.py module - the only other user. check-in: f4defac665 user: home tags: trunk, tmp | |
| 16:21 | Add check that FLOCKS and FLOCK_OWNER Paradox tables are in sync owner-wise. check-in: 2bdf279b3d user: home tags: trunk, tmp | |
|
2013-04-06
| ||
| 10:01 | Added tool to block IP(s). Bumped version number. check-in: 2d3632898f user: home tags: trunk, tmp, version-0.23.0 | |
|
2013-03-28
| ||
| 10:42 | Fixed problem of ticket [0cbd003735] - revised error classes to merge comment with DBAPI error. check-in: 1da0d40faf user: home tags: trunk, tmp, version-0.23.0 | |
| 10:37 | Added two more files to the WebFaction server config check-in: e97f3d354b user: home tags: trunk, tmp | |
|
2013-03-27
| ||
| 14:57 | Bumped version to 0.22.0 check-in: ac2de7fd54 user: home tags: trunk, tmp, version-0.22.0 | |
|
2013-03-10
| ||
| 11:30 | Added scripts and html page for WebFaction deployment. check-in: 0144d6568c user: home tags: trunk, tmp | |
|
2013-03-06
| ||
| 19:27 | Added command line script to refresh database. This reads the database connection parameters and 'DEAD_FLOCK' from the application files. check-in: 33cca29f63 user: home tags: trunk, tmp | |
| 19:18 | Removed spurious print statement from transform.py. deploy.py no longer copies all startup scripts. check-in: 6a8cb956fd user: home tags: trunk, tmp | |
|
2013-03-02
| ||
| 11:23 | Added script to stop PPDB in the WebFaction deployment. Updated deploy script revised startup script names and location. check-in: c7e75265b7 user: home tags: trunk, tmp | |
| 11:13 | Added __init__.py to make test directory a package. Added test script for WebFaction OFB deployment. check-in: 95e75c0cbb user: home tags: trunk, tmp | |
| 11:11 | Reverted to original style of startup scripts, but revised to work with the ppdb package. Server configuration moved to startup script when using the CherryPy WSGI server. check-in: fd81da81f3 user: home tags: trunk, tmp | |
|
2013-02-24
| ||
| 20:56 | Changes to get wsgi deployment to work - application() must be in the script executed by mod_wsgi. check-in: 0a79cbaf02 user: home tags: trunk, tmp | |
| 20:52 | Removed CherryPy as the world is now on 3.2.0 and it's not necessary to ship our own version any more. check-in: 389d142959 user: home tags: trunk, tmp | |
| 20:37 | Merged in the flexi-root branch. check-in: aa1fd05c1c user: home tags: trunk, tmp, version-0.21.0 | |
| 20:35 | Dbbuild progress page URLs updated for flexi-root. Closed-Leaf check-in: b0d51e8718 user: home tags: flexi-root | |
|
2013-02-23
| ||
| 17:24 | Updated dataconv to support ppdb as a package. check-in: e14aabc5e8 user: home tags: flexi-root | |
| 15:59 | Changes to support URI root being different to CP root. check-in: e92043b375 user: home tags: flexi-root | |
| 12:10 | Revised configuration parameters for the case (eg WebFaction) where the logical root is not the same as the absolute root. check-in: 746994d235 user: home tags: flexi-root | |
| 11:44 | Merged the pakagify branch and bumped the version to 0.20.0 check-in: e50730cb1d user: home tags: trunk, tmp, version-0.20.0 | |
| 11:40 | Renamed selenium ide directory to selenium_ide. Part of packageify branch, but fossil can't merge unless the directory exists first. check-in: 3fd9be7943 user: home tags: trunk, tmp | |
|
2013-02-22
| ||
| 15:20 | Changed deploy.py for changes of previous checkin. All sss and common Unit tests and Selenium Web tests for the SSS now run. Closed-Leaf check-in: 697bb4024e user: home tags: tmp, packagify | |
| 15:07 | Changes to get Selenium IDE and Selenium Web tests to run. check-in: 04cad16528 user: home tags: tmp, packagify | |
|
2013-02-21
| ||
| 18:38 | Corrections to get unit tests to run (sss and common). check-in: 8314b2875e user: home tags: tmp, packagify | |
| 16:59 |
Renamed ppdb/tes/selenium to ppdb/test/selenium_ide to avoid potential clash with the selenium package.
ppdb/test now a package. All imports now relative to ppdb where appropriate. check-in: c8852c1189 user: home tags: tmp, packagify | |
| 09:55 | Imports in app files now absolute. check-in: abcfd410b0 user: home tags: tmp, packagify | |
| 09:35 |
Moved startup scripts outside the ppdb package.
Moved the global constants DBLIB and JINJA_ENV back into const and moved const to the package root. Made imports absolute in ppd.py and the app_sss init files. check-in: 93ea8f9b3a user: home tags: tmp, packagify | |
|
2013-02-20
| ||
| 21:53 | Move the two variable initialised at startup into the package __init__.py file so that all users see the same data. check-in: 7f034f6dc3 user: home tags: tmp, packagify | |
| 21:37 | Initial changes to allow PPDB to be deployed as a package so that internal directories do not clash with the filesystem. check-in: f82b3c5b7a user: home tags: tmp, packagify | |
|
2013-01-24
| ||
| 17:54 | Added refman document discussing sibling checks (for ticket 68c93ae62c). check-in: 9c5be32c61 user: home tags: trunk, tmp | |
| 17:48 | Added Geany project configuration file. check-in: 6671fbf088 user: home tags: trunk, tmp | |
|
2012-11-15
| ||
| 10:10 | Documented sibling checks in sheep validation. check-in: b81b68135f user: home tags: trunk, tmp | |
|
2012-10-20
| ||
| 14:55 | Reinstated missing 'last_changed' column in flock_stats table. check-in: 89b91b1d00 user: home tags: trunk, tmp | |
| 09:22 | Updated data conversion for audit schema. check-in: cb003a612e user: home tags: tmp, audited | |
|
2012-10-19
| ||
| 14:25 | Schema and documentation changes. check-in: 3b1bf627bf user: home tags: tmp, audited | |
|
2012-10-18
| ||
| 10:28 | Updated and re-organised docs. new doc describing table auditing implementation. Versions bumped. Schema file updated for auditing. check-in: ba249700df user: home tags: tmp, audited | |
|
2012-10-13
| ||
| 18:10 | Initial changes for auditing implementation check-in: d355163b14 user: home tags: tmp, audited | |
| 13:33 | Merged 'autoinc_impl' branch. Bumped version to 0.18.0 check-in: 3f7307c33b user: home tags: trunk, tmp, version-0.18.0 | |
| 09:19 | Correct PostgreSQL database version in ppd.conf. Correct sqlite autoinc test. Closed-Leaf check-in: 073ea000dd user: home tags: tmp, autoinc_impl | |
| 09:06 | Merged trunk. check-in: 1c71087f1c user: home tags: tmp, autoinc_impl | |
|
2012-10-11
| ||
| 09:13 | Unit tests on PostgereSQL now run against a xxx_main_test schema within the main database rather than agains a xxx_main schema within a test database. check-in: d44dc2bd49 user: home tags: trunk, tmp | |
|
2012-10-09
| ||
| 17:45 | Updates to allow SQLite test database to be built and to allow PostgreSQL database to be populated from tsv files. check-in: b59367574d user: home tags: tmp, autoinc_impl | |
| 14:53 | Merged updates from Trunk check-in: d9e8b07516 user: home tags: tmp, autoinc_impl | |
| 14:50 | Updates to tests: Always create a new FF profile at startup for Selenium Web tests, enhanced messages at startup for unit tests, correct race in registration form test and correctly detect missing 'disabled' attribute. check-in: 48df7cf5e9 user: home tags: trunk, tmp | |
| 14:47 | Only initialise SSS applications check-in: 08fc403371 user: home tags: trunk, tmp | |
| 14:46 | Added PPD startup script for Selenium Web tests. Should have been added by checkin f1156271f9 check-in: 519b1f6bee user: home tags: trunk, tmp | |
| 14:35 | Rename calls to html_get() to calls to http_request() in dbbuild_results(). Missed from checkin 2d13ca0b1d check-in: 5f07ce847a user: home tags: trunk, tmp | |
|
2012-10-08
| ||
| 17:31 | Initial implementation of autoincrementing primary key fields. check-in: 3b88cbe1a8 user: home tags: tmp, autoinc_impl | |
|
2012-10-07
| ||
| 10:13 | Corrected error in application mount code. check-in: e06e43a9d3 user: home tags: trunk, tmp | |
| 09:55 | Moved css file added in previous commit to the correct place... check-in: a3f5f3b551 user: home tags: trunk, tmp | |
| 09:42 | Added docs theme css file - this time modified with a new SHA1 sum so Fossil doesn't think it's shunned. check-in: 539fd24072 user: home tags: trunk, tmp | |
|
2012-08-15
| ||
| 14:16 | All tests now run against both PostgreSQL and SQLite. The tests may be selected by the nose attrs 'pgsql' and 'sqlite' check-in: f1156271f9 user: home tags: trunk, tmp | |
| 09:10 | If SQLite is specified as the RDBMS check that the SQLite database exists when initialising each app. check-in: f581f200f9 user: home tags: trunk, tmp | |
|
2012-08-13
| ||
| 09:31 | Use correct schema files when building database from /ppd pseudo-app check-in: 2567bdf249 user: home tags: trunk, tmp | |
|
2012-08-12
| ||
| 10:43 | Removed redundant schema definition files check-in: bdc8fc435f user: home tags: trunk, tmp | |
| 10:32 | Bumped version to 0.17.1 check-in: d5fd5055ac user: home tags: trunk, tmp, version-0.17.1 | |
| 10:31 | Merged auto-inc branch. check-in: 56a0041403 user: home tags: trunk, tmp | |
| 10:21 | Revised unit tests to run against both PostgreSQL and SQlite Closed-Leaf check-in: 2bd4e53a70 user: home tags: tmp, auto-inc | |
|
2012-08-11
| ||
| 10:42 | Added autoincrement support documentation. Improved checking of AUTOINC keyword. User modules always specify keyword arguments to DBLI.exec_xxxx in full. check-in: 478eb619d7 user: home tags: tmp, auto-inc | |
|
2012-08-10
| ||
| 10:45 | Moved unit tests to their own subdirectory and no longer use unittest. Updated unit test initialisation to allow the RDBMS to be forced. Added tests for the RDBMS autoincrement abstraction. check-in: 0b74fc861a user: home tags: tmp, auto-inc | |
|
2012-08-09
| ||
| 10:04 | Changes to RDMS abstraction modules to support auto-increment primary keys. check-in: 20303eb17c user: home tags: tmp, auto-inc | |
|
2012-08-08
| ||
| 09:22 | Reinstated document theme css file. Added cattle schema to module docs. Version bumped to 0.17.0. check-in: 1679cd913e user: home tags: trunk, tmp, version-0.17.0 | |
|
2012-08-07
| ||
| 16:05 | Merged pyschema branch - schemas as python modules. check-in: 51db6403c7 user: home tags: trunk, tmp | |
| 15:32 | Cattle schema converted to Python module. Dataconv modules updated to work with new schema module. Closed-Leaf check-in: 48f779483a user: home tags: tmp, pyschema | |
| 11:21 | Added missing theme .css file check-in: f0f13ff63d user: home tags: trunk, tmp | |
| 10:50 | Fixed typo in exec_trans if asdict = False and row_cnt = 1 and col = None check-in: 35a1d7c2dc user: home tags: trunk, tmp | |
|
2012-08-06
| ||
| 09:28 | Updated docs - schema is now self-documenting in the xxx_schema module. Table changes moved from the Appendix to the DB section. check-in: 021c33ef48 user: home tags: tmp, pyschema | |
| 09:03 | Update make-test.py for schema module. check-in: c7cc1b4443 user: home tags: tmp, pyschema | |
| 09:01 | Correction to allow make_test.py to run Closed-Leaf check-in: 2f7f52f8c5 user: home tags: tmp, audit-trail | |
|
2012-08-05
| ||
| 09:56 | Correct sheep_schema.py. dbbuild and transform updated to use new schema module. check-in: 8e24a66ffc user: home tags: tmp, pyschema | |
| 08:36 | New branch to implement sheep-schema as a self-documenting python module allowing for extending the number of table creation options. check-in: 9bcb1ca143 user: home tags: tmp, pyschema | |
|
2012-08-01
| ||
| 20:03 | lib/sheep_schema.py now contains the schema as individual objects so that the schema can be self-documenting. The vars() builtin is used to access the objects as a dict so no other changes are required to the using code. Documentation revised to remove the schema documentation and move the table change docs into the database section. check-in: 68349d8ec1 user: home tags: tmp, audit-trail | |
| 11:22 | Changes to allow a legacy database to be created. check-in: 91c578a5bc user: home tags: tmp, audit-trail | |
|
2012-07-21
| ||
| 08:41 | Added code to make 'date_changed' and 'change_date' fields in mempmnts and memchng tables unique. check-in: d127afbb61 user: home tags: tmp, audit-trail | |
|
2012-07-20
| ||
| 11:44 | Removed redundant sheep_schema.conf. Added code to convert sheep_flock_audit table to transfer_audit. check-in: e0fefb8e2c user: home tags: tmp, audit-trail | |
|
2012-07-19
| ||
| 09:09 | Fix bugs in transform.py. Renamed table and view lists in sheep schema. Updated make_test to use new scheema module. ** All unit and web tests run against V11 schema ** check-in: ffcc4e9da9 user: home tags: tmp, audit-trail | |
|
2012-07-18
| ||
| 21:15 | Merged checkins from trunk so unit and selenium tests should run. check-in: 97f20c3c48 user: home tags: tmp, audit-trail | |
| 21:12 | Corrected more errors due to chages of checkin [166b96bc5d]. check-in: 152dda8627 user: home tags: trunk, tmp | |
| 20:43 | Correct call to validators/parents in validate_breeding(). Missed from checkin [166b96bc5d]. check-in: ef9a1b6143 user: home tags: trunk, tmp | |
| 20:41 | Correct dam transfer dates - now 1 day before progeny DOB (changed in checkin [bbeb3d1312]). check-in: 8262e63201 user: home tags: trunk, tmp | |
| 16:29 | Revised sheep_schema.py. dataconv/transform updated for revised schema module. dbbuild.py refactored as a class using code from transform.py, also uses the new schema module. check-in: 8f8b099282 user: home tags: tmp, audit-trail | |
|
2012-07-17
| ||
| 20:30 | Removed redundant XML schema files. Revised sheep_schema.py: now a dict of dicts with an array specifying creation order. Interploation to be by string.template. All primary keys now NOT NULL PRIMARY KEY as SQLite otherwise does not enforce NOT NULL (incorrectly). Most INTEGER PRIMARY KEY fields are now auto-increment - specified in object dict and column specified as SERIAL NOT NULL PRIMARY KEY - SQLite requires this to be changed from SERIAL to INTEGER. check-in: 5a8bf11b76 user: home tags: tmp, audit-trail | |
| 11:35 | Added sheep schema as Python module for better flexibility when adding new options and objects. check-in: 66bc58c95d user: home tags: tmp, audit-trail | |
| 11:33 | SQLite module explicitly disables trigger recursion. Revised audit trigger description to include trigger and functions for PostgreSQL. check-in: 239b08dcc4 user: home tags: tmp, audit-trail | |
|
2012-07-16
| ||
| 19:09 | Table changes and additions to schema for auditing. Dataconv uses new schema with SQLite. check-in: 9304031774 user: home tags: tmp, audit-trail | |
|
2012-07-15
| ||
| 10:20 | Added audit tables and triggers to membership tables and transfer table. check-in: fdb0d766a7 user: home tags: tmp, audit-trail | |
| 10:19 | New branch to implement an audit trail in the database. Docs updated to include the audit trail description. Database version bumped to 11.0 check-in: ab31110902 user: home tags: tmp, audit-trail | |
| 10:14 | Sphinx docs now built to a directory outside the local checkout. check-in: 09edc16be6 user: home tags: trunk, tmp | |
| 10:09 | Added missing theme CSS file to Sphinx docs. check-in: cc8b262873 user: home tags: trunk, tmp | |
|
2012-07-13
| ||
| 19:01 | Added transfer data to shpval.validate_post_data(). Corrected transfer.get_parent_transfer() check-in: bbeb3d1312 user: home tags: trunk, tmp | |
| 17:59 | Functions to check text dates now also accept an ISO format date as input. check-in: 9c728864d6 user: home tags: trunk, tmp | |
| 17:56 | Remove redundant 'text_dob' item from parameter list to validators/sibs and associated functions. check-in: 166b96bc5d user: home tags: trunk, tmp | |
| 17:40 | Added 'last_changed' column to transfer table. Revised descriptions of table auditing options. check-in: 636ae6a550 user: home tags: trunk, tmp | |
|
2012-07-12
| ||
| 14:18 | Darken 'warning' colour for increased contrast on forms. check-in: 22b5976dff user: home tags: trunk, tmp | |
| 14:18 | URL encode parameters to sheep/validators branches. check-in: a2d01ecbb2 user: home tags: trunk, tmp | |
|
2012-07-11
| ||
| 11:21 | Wrapped 'print' in an 'if DEBUG:' statement check-in: 46bd3a4a62 user: home tags: trunk, tmp | |
| 10:50 | Corrected shepval.check_colour_genetics(). Added tests for validators/colgen and validators/parents URI branches. check-in: c809e1c442 user: home tags: trunk, tmp | |
| 08:28 | Documentation for the sheep/validators URI branch updated. check-in: fa5b2964ea user: home tags: trunk, tmp | |
|
2012-07-10
| ||
| 17:44 | Added new controls to registration form to allow sire to be resurrected into either the progeny birth flock or his last live flock. 'Cancel' button now properly clears all fields - changes to dob, tag and colour code to implement this. check-in: 55db3074b5 user: home tags: trunk, tmp | |
| 10:55 | Corrected error handling in sheeplib.insert_new_animal. Errors thrown by the database abstraction modules are now classes in those modules. Revised code handing those errors. check-in: 18ce41e0f0 user: home tags: trunk, tmp | |
| 10:51 | Corrected rules for hovering on our button class. check-in: 5e26b7dbd0 user: home tags: trunk, tmp | |
| 10:48 | Removed cript tag for json_parse.js. Should have been removed in checkin [f8554d140d] check-in: 1d3e58098e user: home tags: trunk, tmp | |
|
2012-07-08
| ||
| 11:15 | Renamed database 'query' functions. Added function to lock table. Added while loop to sheeplib.insert_new_record(). check-in: 7721f6611b user: home tags: trunk, tmp | |
|
2012-07-07
| ||
| 17:24 | Added 'Last Sire' and 'Last Dam' buttons to regsitration form. 'Cancel' button now clears form rather than reloading it so that the last sir/dam are not lost. check-in: 68999e6f34 user: home tags: trunk, tmp | |
| 09:02 | Replaced json_parse by native JSON object. Tidied js code. check-in: f8554d140d user: home tags: trunk, tmp | |
|
2012-07-06
| ||
| 21:36 | Revised Javascript implementing XMLHTTPRequest to use a single method for all HTTP methods. Code to handle a 500 response displays the server generated HTML page. Register button uses js to create request body for POST and resets form and displays result. check-in: 2d13ca0b1d user: home tags: trunk, tmp | |
| 21:32 | Fixes for bugs in code to validate and register new sheep. check-in: b95c10a7ce user: home tags: trunk, tmp | |
| 21:30 | Removed redundant code. Renamed variables to avoid name conflict with outer scope. check-in: 6aaee64662 user: home tags: trunk, tmp | |
|
2012-07-05
| ||
| 18:00 | Added new database functions for multi-query transactions. The several execute* and query* functions are replaced by an new query() function. Unit tests and Selenium tests run. check-in: 66df17da12 user: home tags: trunk, tmp | |
| 16:23 | Correct errors introduced in recent checkins. check-in: 84f37bf427 user: home tags: trunk, tmp | |
|
2012-07-03
| ||
| 10:29 | Added missing css file to sphinx docs 'ppd-theme'. check-in: 6e5492c96a user: home tags: trunk, tmp | |
|
2012-07-02
| ||
| 17:05 | Updated copyright dates. Bumped version to 0.16.0 check-in: 0f6035cdf2 user: home tags: trunk, tmp, version-0.16.0 | |
| 15:05 | Changes to build process to allow for multiple processes at the server, only one of which runs the build sub-process. check-in: 5aff2031b3 user: home tags: trunk, tmp | |
|
2012-06-27
| ||
| 09:29 | Deploy script no longer copies .pyc files in app subdirectories. Removed Bazaar SVN stuff. check-in: 479f54d130 user: home tags: trunk, tmp | |
|
2012-06-26
| ||
| 22:08 | Bug fixes and other corrections for mod_wsgi deployment. check-in: 25bc3efff9 user: home tags: trunk, tmp | |
| 08:52 | Reinstated authentication settings mistakenly committed in checkin dfe67bbef5. check-in: 2a8afae740 user: home tags: trunk, tmp | |
|
2012-06-23
| ||
| 20:36 | Removed rudundant line from ppd.conf. Updated serverconf versions of ppd.conf to latest version. check-in: 78fe07bb8a user: home tags: trunk, tmp | |
| 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 | |
| 11:13 | Renamed all documents to remove spaces in names check-in: bd11ec11e8 user: anonymous tags: trunk, tmp | |
|
2010-02-12
| ||
| 14:43 | Joined webapp-docs as docs check-in: 241b9c9855 user: home@system06 tags: trunk, tmp | |
|
2008-04-14
| ||
| 16:42 | Version numbers reset after loss of .bzr directories check-in: d7efff7b26 user: peter@ssbg.zetnet.co.uk tags: trunk, tmp.2 | |