Rails-CMDB release 0.4.1

It’s been a while since I’ve managed to do a release of Rails-CMDB. This is mainly because I got stuck working parts of the test suite and I’ve been doing things that have kept me away from a computer.

However over the last few days I’ve managed to get an import integration story working, which seems to be working. I’ve also taken the chance to migrate to Ruby on Rails 1.2.5, but there are some DEPRECATION warnings still to dealt with.

Behind the cut is the changelog. Continue reading


Testing import of CSV imports in Ruby on Rails

It’s been a few weeks since I did any work on Rails-CMDB. This is mainly down me being busy and getting stuck on how to test the import of data. I’ve come to the conclusion that it really is an integration story, so now the problem is how to do the file uploads.

It’ll not be hard to generate a complete set of CSV files and place them on disk, but my issue would be how to upload them. Does anyone have any useful suggestions ?

Rails-CMDB release 0.4

It’s taken a long time to get this release of Rails-CMDB ready for release, as I’ve done some tidying of the code base, plus adding lots of unit and functional tests. I’ve also improved the the views into the database and added the notation of Environments within Locations.

The source code can be found here. Not sure what is going to be in the next version, however I would like to get a public Subversion repository set up when I feel the testing good enough to catch any issues.

See below the cut for the (incomplete) change logs for version 0.4 (and the unreleased 0.3).

Continue reading

Testing Love and Ruby on Rails

For the last couple of weeks in some of my spare time I’ve being writing unit and functional tests for Rails-CMDB. So far it’s helped me spot a more than a few issues, the most surprising to me was the naming of my os controller, which the functional test tried to test as O. So currently I’m in the process of refactoring things to mesh better with the Rails idiom.

The main upshot of all of this; it’s likely to be early October before the next release of Rails-CMDB, and the version number is very likely to jump a few points due to unreleased versions.

I’m also contemplating what new features the next released version will have and so far I’m thinking of the following:

  • Environments: Separating out different types of devices within the same location (e.g. test, stage and production).
  • Virtual Machines: Modeling devices that are virtual and running as a guest on physical device.

The Ruby on Rails way for Model naming

Following the comment from Graeme Mathieson on my last post on Rails-CMDB about the the Rails way for naming of columns within Models. I’m planning on doing the following column rename for the next release of Rails-CMDB:

rename_column :assets, :delivery_date, :delivered_on
rename_column :assets, :removal_date, :removed_on

rename_column :locations, :start_date, :started_on
rename_column :locations, :end_date, :ended_on

rename_column :purchase_orders, :order_date, :ordered_on

rename_column :vendors, :last_order_date, :stopped_ordering_on

So the question for the Rails coders out there – does this seem correct ? There’s also a single table who’s primary field is not called name, so I guess to do it in the Rails way it should be changed as well.

I’ve also created about 90 unit test stubs and now just comes the hard part of coding the tests 😉

Rails-CMDB release 0.2

Well it’s been a month since the first release of Rails-CMDB and it’s now time for another release. This is the rather large list of changes:

  • Added some unit tests for PurchaseOrder.
  • Added Export to CSV.
  • Added Import from CSV.
  • An asset can have many hardware items.
  • The Asset name does not need to be a number.
  • Catch trying to show a device that does not exist.
  • Add order_date column to PurchaseOrder Model.
  • Rename order_date column in Asset to delivery_date.
  • Correct typo’s in CreateNetworks which prevented loading of the schema.
  • Rename the database’s used to match the application name.
  • Added some simple doc’s on getting the system up and running.
  • Change to using host: in database.yml instead of sockets.

The source code can be found here. Not sure what is going to be in the next version, however I expect it’ll not be ready for release until mid to late September.

First release of Rails-CMDB (v0.1)

This is the first ever release (0.1) of Rails-CMDB, the Ruby on Rails project I’ve been working on since the end of last month. It’s best described as little rough round the edges and the under laying DB schema may change with no upgrade path. However it’s possible to enter (and change) all of information via the interface and also view all details for a device on a single page.

The source code can be found here on my main web site, I’ll try to do a second release within the next few weeks when I get an idea of what’s needed next (I’m currently thinking it’ll need to be import or export via an Excel speed sheet or a CSV file).

Update: It’s been pointed out the me that I did not say what this software is, you can find a lot more details ITIL defines as a configuration management database (cmdb) in this post from last month.