Jump to: navigation, search
ISFDB Discussion Pages and Noticeboards
Before posting to this page, consider whether one of the other discussion pages or noticeboards might suit your needs better.
Help desk
Questions about doing a specific task, or how to correct information when the solution is not immediately obvious.
• New post • Archives
Verification requests
Help with bibliographic, image credit, and other questions which require a physical check of the work in question.
• New post • Archives
Rules and standards
Discussions about the rules and standards, as well as questions about interpretation and application of those rules.
• New post • Rules changelog • Archives
Community Portal
General discussion about anything not covered by the more specialized noticeboards to the left.
• New post • Archives
Moderator noticeboard
Get the attention of moderators regarding submission questions.
• New post • Archives • Cancel submission
Roadmap: For the original discussion of Roadmap 2017 see this archived section. For the current implementation status, see What's New#Roadmap 2017.

Related resources:

This page serves as the hub for discussing ISFDB-related software development.


Developers and Testers

  • MartyD — developer
  • Kpulliam — developer (of meager ability) / Tester
  • Roglo — developer (inactive since mid-2009)
  • Ahasuerus — developer, tester and installer/administrator
  • Alvonruff — currently unavailable, but has full development and administrative access
  • Marc Kupper — has full administrative access and a partial development setup
  • JesseW — developer
  • Uzume — developer, tester, etc.

The following editors are currently in the process of setting up a local copy of the application:

Software Development Process

At this time the development process works as follows:

  • A Bug, Support Request ("SR") or Feature Request ("FR") is created in SourceForge. Anyone can do it, even "anonymous".
  • FRs should be discussed on the Community Portal and approved by the community before the work begins. Obvious bugs can be fixed and submitted without a prior discussion.
  • Once a developer decides to work on a Bug/SR/FR, s/he identifies the scripts that are affected and lists the Bug/SR/FR along with the scripts on the Development page under "Outstanding Changes". This helps avoid effort duplication.
  • The developer makes changes on his or her development server and tests them. S/he then sends to the ISFDB administrator (Ahasuerus since 2009), who tests them on his local development server. In some cases the administrator may ask another developer to test the changes.
  • If everything works fine, the administrator commits the changes to the SourceForge repository using the SVN "commit" command, e.g.:
    • svn commit -m "FR 1099 Add Last Activity date to 'Top Contributor/Moderator/etc' lists - Part 1"
  • The administrator gets the latest revision number from the SourceForge repository:
    • svn info --show-item=revision -r HEAD
  • The administrator creates a deployable tarball file from the modified source files, e.g:
    • tar -cvf ~/patches/3.tar biblio/, where '3' is the revision number retrieved in the previous step
  • The administrator copies the tarball to the ISFDB server and moves it to /home/avonruff/isfdb2/, where the main copy of the source code currently resides
  • The administrator untars the tarball and types "make install" (or "make -B install" if the patch added new scripts or otherwise requires a complete rebuild)
  • The administrator gzips the tarball and moves it to the archive area
  • The administrator marks the Bug(s)/SR(s)/FR(s) as "Fixed/Completed" in SourceForge
  • The administrator moves the completed change(s) from the list of Outstanding Changes on the Development page to the "Recent Patches" sub-page. "Recent Changes" covers all builds for the current year, so it's a useful page for developers to review.

Changes and Patches

Recent Patches

Patch Archive for 2009–2019

See Development/Recent Patches for the list of changes implemented recently.

Outstanding changes

Bug or Feature Description Modules and versions Developer Tester Date Passed Patch

Planned changes

Bug or Feature Description Modules and versions Developer Tester Date Passed Patch
SR 3183863 Static and dynamic content cannot be "rehomed" correctly
  • TBD

Current Activity


Rename the three PrintNavBar's to distinguish them

See SR 3115118. It'd be very easy, but I want some feedback before I do it. JesseW 05:58, 22 November 2010 (UTC)

Clarify the license

See SR 3115153; it's not good that the actual files make no mention of the license the code is released under. JesseW 07:09, 22 November 2010 (UTC)



Concentrating on bugs, clean-up/consolidation, and small features. If anything ever comes of the tagging discussion at ISFDB:Community Portal#Title type tags in bibliography display, I will revisit the tagging used, too.

Development Process

General Principles

The ISFDB code base is over 5MB in size and has a number of dependencies, which are not always obvious. For this reason, developers should follow the "if it ain't broken, don't fix it" principle. Developers should also try to address one problem at a time. If a feature or a bug fix requires mass changes, discuss it with other developers and the administrator first.

Coding style

Among the developers, there is a wide variety of backgrounds and levels of Python experience. Due to this, it's important to take care to keep the code understandable without a high level of Python-specific knowledge. Using basic structured programming constructs (i.e., def, if, while, etc.) and simple classes rather than heavy object-orientation or more esoteric functional programming tricks is recommended. If you need to create a complex class, method or functions, you may want to discuss it with other developers and the administrator first and then document the code thoroughly.

Where is db defined?

Whenever is imported, a database connection is created, and assigned to the variable db. is copied by the makefiles from common/ into all the other directories, and imported by more or less everything, often multiple times. This is may be suboptimal.

Code Format


Older ISFDB modules tend to use tabs. Newer ISFDB modules tend to use 8 spaces. A few ISFDB modules use 4 spaces. Some modules use a mix of spaces and tabs, which can cause problems, especially if and when we migrate from Python 2 to Python 3.

  • For new development, use 8 spaces.
  • When modifying existing modules which use either spaces OR tabs, use the current indentation method.
  • When modifying existing modules which use a mix of spaces and tabs, change the module to use 8 spaces. This may require additional testing to ensure that nothing got broken.

Other Standards

  • When modifying existing code, use the naming conventions and other standards found within the module.
  • For new development, use PEP 8: Style Guide for Python Code unless it goes ISFDB-wide coding conventions.

How to Add a New Cleanup Report

ISFDB has two background jobs. The first one runs nightly and regenerates certain computationally intensive Statistics and Top Lists. It also regenerates most of our 240+ Cleanup Reports.

The second background job runs monthly and is meant to generate cleanup reports which take a very long time (hours) to run. At this time it is only used to regenerate the "Suspected Duplicate Authors" report.

If you want to add another cleanup report, use the following steps:

  1. Develop a SQL query to find potentially problematic records. Your query should return only one column, which should contain the record ID of a suspicious record. Any subsequent columns will be ignored by the report generator. Note that you should only retrieve one record type (titles, pubs, series, etc) per report. If you need to return multiple record types, create one report per record type.
  2. Add a new report to the bottom of module "nightly/". Set the "query" variable to the body of the SQL statement that you created in the previous step. Invoke "standardReport(query, NN)" where NN is the report number of your report. To determine the value of NN, take the last report number used and add 1. When this module is run by the nightly job, it will extract the specified record IDs and add them to the "cleanup" table in the database.
  3. In module mod/, add the name of the new report to dictionary "reports" in function reportsDict. Increment the last use key to get the key for your report -- it should be the same as the report number that you created in the previous step. In the same function, add this report number to the appropriate tuple of the "sections" list. For example, if you are developing a cleanup report that affects magazines, add the report number to the "Magazines" tuple.
  4. In module mod/, create a new function called "functionNN" where NN is the report number describe in the last two steps. The function should take no arguments, e.g. "def function99()". Defined a SQl query that contains the same logic as the query describe in the first step except that it also limits the search to the records stored in table cleanup for this report number. To do this, add the following logic to WHERE clause of the SQL statement: "and TABLE_NAME.RECORD_ID=cleanup.record_id and cleanup.report_type=NN and cleanup.resolved IS NULL", where TABLE_NAME is the table name of the record that you are extracting, RECORD_ID is the name of the column of the record ID and NN is the report number. Display the retrieved data using other reports as an example. Use function PrintTableColumns to print table columns. Use functions PrintSeriesRecord, PrintPublicationRecord, PrintTitleRecord, PrintAuthorRecord, PrintPublisherRecord and PrintPubSeriesRecord to print simple rows consisting of two columns: row number and a link to the problematic database record. These functions also support an optional third column for "Ignore this record" links. See the function definitions for the parameters that they take.

How to Add a new Field to Title records

  1. Create a SQL script to add the new field to the titles tables
  2. Modify the load and cgi2obj methods of the Title class
  3. Add the new field to the Edit Title modules (edit/, edit/, mod/
  4. Add the new field to the DisplayTitleEdit function in biblio/
  5. Add the new field to biblio/
  6. Consider whether the field needs to be displayed in the Content section of the Publication display page, similar to non-genre or graphic. If so, modify biblio/
  7. Consider whether the field should appear on Summary/Series pages, similar to non-genre or graphic
  8. Consider whether the new field should be added to the New Pub data entry form, similar to non-genre or graphic
  9. Add mouse-over help in edit/ If the field has also been added to NewPub, make sure to add it to two places in edit/, one for Title Help and one for Pub Help.
  10. Account for the new field in the following module groups, including the data entry forms, the relevant functions and the filers:
    • Title Merge
    • Title Unmerge
    • Add Variant
    • Variant Title
  11. Consider adding the new field to the Title section of the Advanced Search

How to Add a New Language

  1. Note that only ISO 639-2-recognized languages are supposed to be added to the ISFDB.
  2. Add the requested language to the MySQL table "languages". For example, here is the body of scripts/add_middle_high_german_language.sql which added Middle High German:
    • INSERT INTO languages (lang_id, lang_code, lang_name) VALUES (102, 'gmh','Middle High German')
      • "102" is the primary key and "gmh" is the ISO 639-2 code for this language. (ISO 639-2 codes are not displayed by the ISFDB software at this time.)
  3. Add the name of the newly added language to the end of the tuple "LANGUAGES" in common/ This tuple must be kept in sync with the "languages" table at all times. Even though it was originally added to improve performance, if this tuple ever gets out of sync with the "languages" table, the ISFDB software will stop working.

How to Add a New External ID Type

  1. Add the requested External ID Type to the MySQL table "identifier_types". For example, here is the command that added KBR as a new External ID Type:
    • INSERT INTO identifier_types (identifier_type_name, identifier_type_full_name) VALUES ('KBR', 'De Belgische Bibliografie/La Bibliographie de Belgique');
  2. If the new External ID Type links to one or more third party URL, add that URL (or URLs) to the MySQL table "identifier_sites", one URL per command. Use "%s" for the part of the URL which will be replaced with the actual External ID at run time. Use the value of "identifier_type_id" generated by the previous command. For example, here is the command that added the URL of De Belgische Bibliografie:
  3. If applicable, add a matching linking template to the function ISFDBTemplates in common/ See the comments section at the beginning of the function for details. See an existing linking template like "ASIN" for an example.

How to Add a New Banner Image

  1. Make sure that the new image file contains a valid JPG image
  2. Put a copy of the new image file in the css subdirectory
  3. Change the name of the new JPG file to IsfdbBannerNN where "NN" is 1 higher than the highest currently existing file name
  4. Add "IsfdbBannerNN.jpg" to css/Makefile
  5. In common/, find the variable which contains the number of the last IsfdbBanner file and increment it by one to match NN

Duplicate Functions and Duplicate Filenames

WARNING — There are duplicate file names and duplicate functions. The function PrintNavBar for instance, appears in /biblio/ (with 5 arguments) and in /edit/ (with 2 arguments) and again in /mod/ (with no arguments). Be sure to watch your directory of the file you are editing, and you cannot count on a function in one directory behaving the same when working in another directory.

Indeed. When looking for "SQLwikiLinkExists" it turns out we have five of them, and rather too many "" files. We could do with some comparisons and centralisation, although this obviously has possibly far-ranging effects and would need lots of regression testing. BLongley
Files living in common are master files and are copied to the other parts of the tree during the build process. The good news is, CVS won't let you commit the others, as they don't actually exist in those directories in CVS. TortoiseCVS distinguishes them as local files with a different icon.... —MartyD 20:48, 14 June 2009 (UTC)
This isn't a case of common files. This is duplicate file and function naming. Kevin 03:25, 15 June 2009 (UTC)
I have begun the first step in the journey to fixing the PrintNavBar duplication problem. I've created a new common/ and made all of the other directories share it. We can slowly move NavBar things into it. —MartyD 21:14, 5 July 2009 (UTC)

Related Projects

Personal tools