Permalink 03:14:32 pm, by mholmes, 35 words, 95 views   English (CA)
Categories: Activity log; Mins. worked: 45

Moved instructions into a separate include file

Minor task that's been on my todo list for ages. This makes it simpler to maintain the instructions for a specific project distinct from the base instructions. Also deleted obsolete search_instructions file and tested.


Permalink 04:49:16 pm, by mholmes, 103 words, 95 views   English (CA)
Categories: Activity log; Mins. worked: 120

Fixed bug in JSRDocs

JS-R reported a bug in the JSRDocs db, which took some time to figure out. I updated the server code to the latest version of the source, and then fixed some JS warnings, none of which was causing the problem. Eventually it turned out that there was a character 0x10 in one of the text fields; it's not allowed in XML, so it was causing Firefox to gack on any search results containing that record.

Not sure how it got in there, and not sure either how to protect against it; perhaps I need to add another component to the data sanitization code.


Permalink 04:15:13 pm, by mholmes, 48 words, 137 views   English (CA)
Categories: Activity log; Mins. worked: 120

Added a new field type: MdhDecimalField

GN's current project is storing data in decimal format, so I've added a new field type to handle this, mapping to the SQL Decimal field (which is also supported in Postgres). Updated the sandbox db and tested it -- seems to work fine -- and regenerated the documentation.


Permalink 03:17:42 pm, by mholmes, 58 words, 170 views   English (CA)
Categories: Activity log; Mins. worked: 60

Reorganized documentation system

Cleaned out any project-specific stuff (except for the sample project), removed all doxygen-generated files from SVN, and regenerated all docs, after installing all the required libraries locally. I can now generate docs OK by running doxywizard, then loading the Doxygen file and running it; to get a PDF, I switch to docs/latex and run make refman.pdf.

Permalink 02:01:00 pm, by mholmes, 135 words, 261 views   English (CA)
Categories: Activity log; Mins. worked: 60

Moved settings into separate user-controlled file

Moved the memory and timeout settings into a file called <proj/project_settings{_SAMPLE}.php> so that it can be user-controlled and set on a per-project basis. Took the opportunity to rework the JSRDocs project setup to make it more robust, for testing this rollout (it previously had only one incarnation, and no testing version):

  • Created parallel live and dev versions of the db.
  • Created live and dev code trees.
  • Wrote scripts for copying data from live to dev, and rolling out changes to dev, from dev to live local, and to dev on server.
  • Tested and backed up.

Also noticed some floating users in mySQL that had been created for testing purposes and should have been deleted. Removed them. Now watching out for any unexpected behaviour in dbs, but not expecting any.


Permalink 02:22:33 pm, by mholmes, 67 words, 442 views   English (CA)
Categories: Activity log; Mins. worked: 300

Link checker working

I have the link checker requested by AC coded up and working, and it's been tested in the VPN, Manifest and Trials dbs (tested in dev, then rolled out to live). I will also roll it out to JSRDocs when I get a chance (there's no dev there, so I always do that one last), and possible Properties (although there are no links in that DB AFAIK).


Permalink 03:28:57 pm, by mholmes, 153 words, 203 views   English (CA)
Categories: Activity log; Mins. worked: 180

First pass at a link-checking utility page

I have a working link-checker for FLD_LINK and FLD_LINKSET fields throughout the database, which uses CURL to check links and reports when they fail. There is still some work to do on this, because I'm not yet correctly escaping characters such as apostrophes which should never turn up in filenames or folder names, but which do regularly turn up because users love to ignore instructions. I'll have to decide whether I should report these as errors even though the links work (on the basis that the names are likely to cause problems down the road), in which case I should also add regex checking to the input fields on the page, or whether I should just escape the characters so that CURL can handle them, and give up on trying to badger people into using sensible filenames.

This feature was requested for VPN, but will also be useful for JW's projects.


Permalink 09:31:33 am, by mholmes, 32 words, 199 views   English (CA)
Categories: Activity log; Mins. worked: 20

Fixed AdaptiveDB bug

The table returned from record deletion was embellished with the old column-header filter fields. I've now got rid of those, since they're obsolete. PUshed out the fix to all current live projects.


Permalink 09:52:34 am, by mholmes, 15 words, 193 views   English (CA)
Categories: Activity log; Mins. worked: 60

Updated existing dbs with new code

Updated the VPN, Properties, Trials, Manifest, and JSRDocs database projects with the new codebase changes.

Permalink 09:51:17 am, by mholmes, 61 words, 303 views   English (CA)
Categories: Activity log, Tasks; Mins. worked: 30

Task: rework the db instructions integration with project_variables.php

DONE 2013-11-26. Right now the project_variables_SAMPLE.php file, which is copied to create a working file, contains a hard-coded set of instructions for the db. These should be linked via an include somehow, because as the db code develops, the instructions change, and the ones in project files get out of date and have to be updated manually.

:: Next Page >>

Adaptive Database

This project aims to design a flexible online database which can be set up as very quickly for a researcher requiring a relational database, and is easy to modify and extend. The Web GUI provides tools for data-entry in as simple and convenient a manner as possible, while also allowing data-integrity checks. The application development sandbox is currently at https://hcmc.uvic.ca/people/martin/potluck/editor/index.php; and half a dozen UVic projects are already using the codebase. The code is managed through SVN here: https://revision.tapor.uvic.ca/svn/adaptivedb/.



April 2014
Sun Mon Tue Wed Thu Fri Sat
 << <   > >>
    1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30      

XML Feeds