US flag signifying that this is a United States Federal Government website An official website of the United States Government

Open Opportunities: Add Sails-DB-Migrations

Closed
Ended on 03/14/2016
Winning bid (Christian G. Warden): $2,198.00

Skills

Chai, Express, Mocha, Node.js, and Sails.js

Open Opportunities uses the open source sails.js MVC framework (Node.js / Express). We want to use the sails-db-migrate package so deployments can be executed in Javascript, and developers can easily manage migrations.

We need to support new developers starting with no prior database, as well as future migrations for people at the current version. (It's ok for people who have code from several versions ago to need to run the current scripts with psql).

Auction rules

Registered users on micropurchase.18f.gov may bid to deliver the requirements in this auction. The lowest bidder at the time the auction closes shall receive the award. The awarded bidder shall have five business days to deliver the requirements. Upon successful completion of the requirements, 18F shall pay the winning bidder.

Also see our policies and guidelines page.

Acceptance Criteria

Ensuring the migrations run

When a developer runs either npm run init, npm run install, or npm run demo from the command-line,

Then all the database migrations should be run before the app loads.


Warning about pending migrations

When a developer runs npm run start or npm run watch from the command-line,

Then they should receive a warning if there are pending migrations. The warning should that state which migrations are pending.


Documentation

The pull request must include new documentation that describes how to create a migration in the following files:

  • INSTALL.md
  • CONTRIBUTING.md

  • When the instructions in the documentation are followed for writing a new migration, the database should be modified as described, and the app should run and be able to access the new model or attribute.

General acceptance criteria

  • All new functionality does not degrade code climate rating
  • Tests run on Travis-CI and do not break the build.
  • New features do not degrade accessibility (use pa11y/HTML Code Sniffer).

Resources

Deliverables

A single pull request submitted to https://github.com/18F/openopps-platform with clear, descriptive commits that satisfy all of the above acceptance criteria.

Bidder DUNS Amount Date (EST)
Christian G. Warden 080033077 $2,198.00 * March 14, 2016 01:59:48 PM EDT
Dan Siddoway 080014807 $2,199.00 March 14, 2016 01:59:46 PM EDT
Christian G. Warden 080033077 $2,299.00 March 14, 2016 01:59:38 PM EDT
Scott Construction, Inc. 144182268 $2,300.00 March 14, 2016 01:59:34 PM EDT
Dan Siddoway 080014807 $2,499.00 March 14, 2016 01:59:18 PM EDT
Scott Construction, Inc. 144182268 $2,900.00 March 14, 2016 01:58:58 PM EDT
Dan Siddoway 080014807 $2,999.00 March 14, 2016 01:58:46 PM EDT
Scott Construction, Inc. 144182268 $3,400.00 March 14, 2016 12:24:13 PM EDT
Christian G. Warden 080033077 $3,497.00 March 14, 2016 11:44:58 AM EDT
Scott Construction, Inc. 144182268 $3,498.00 March 12, 2016 07:04:07 PM EST
Christian G. Warden 080033077 $3,499.00 March 11, 2016 07:32:29 PM EST

* - winning bid

Bidding closed

Bidding for this auction closed on March 14, 2016 02:00:00 PM EDT.

Auction started at

March 10, 2016 01:00:00 PM EST

Auction ended at

March 14, 2016 02:00:00 PM EDT

Delivery deadline

March 21, 2016 02:00:00 PM EDT

Eligible vendors

SAM.gov only

Auction type:

Reverse (rules)

Paid at:

April 01, 2016 10:47:27 AM EDT

Accepted at:

March 21, 2016 02:00:00 PM EDT

View on GitHub