db.sync() creates sqlite3 files with a ':' at the end of the filename

[beaugunderson]

For example:

var orm = require('orm');

orm.connect('sqlite://storage.sqlite3', function (err, db) {
  if (err) throw err;

  var Alert = db.define('alert', {
    title: String,
    url: String,
    date: Date,
    body: Buffer
  }, {

  });

  db.sync(function (err) {
    if (err) throw err;

    console.log('Synced');
  });
});

This creates the file storage.sqlite3: in the current directory.

I'm using orm@2.0.15 and sqlite3@2.1.7 with node v0.10.12.

[beaugunderson]

lib/ORM.js:60 uses url.parse to fill in opts given a connection URL like "sqlite://storage.sqlite3".

lib/Drivers/DML/sqlite.js:17 has conditional logic to append a : if opts.host exists. Support for Windows drive letters appears to be breaking support for relative file paths in this case.

The workaround is to supply an opts object with pathname filled in.

[dresende]

Please try the latest git version, it should be fixed :)

npm install dresende/node-orm2