[TIMOB-4543] Ti.Database API filesystem discrepancies between iOS and Android

When a database is created at the default locations using Ti.Database.open() or Ti.Database.install(), the resulting files are at different filesystem locations and with different filenames. The code below demonstrates how the user must access them directly using filesystem commands, on the respective platforms. Issues: * on Android, there is no way to access the default database directory (using applicationDataDirectory/../database is not allowed by design, for example) other than to specify the full filesystem path. On iOS, however, applicationSupportDirectory may be used. * Android does not automatically add a file extension whereas a .sql extension is added to the file name on iOS Just for incidental information, note that on Android: * Ti.Filesystem.applicationSupportDirectory is undefined. See TIMOB-3041 and TIMOB-4215 * Ti.Filesystem.applicationDataDirectory is located at /data/data/appID/app_appdata * var db = Ti.Database.open(dbName); database created at /data/data/appID/databases/${dbName} by default

var dbName = 'myDB';
var db = Ti.Database.open(dbName);
db.close();
var dbPath;
var dbFile;
var dbPlatform = Ti.Platform.osname;
Ti.API.info("dbName: " + dbName);

if(dbPlatform === 'android'){
  dbPath = 'file:///data/data/' + Ti.App.getID() + '/databases';
  Ti.API.info("dbPath: " + dbPath);
  dbFile = Ti.Filesystem.getFile(dbPath, dbName);
  Ti.API.info("dbFile.nativePath: " + dbFile.nativePath);
} else {
  dbPath = Ti.Filesystem.applicationSupportDirectory + '/database';
  Ti.API.info("dbPath: " + dbPath);
  dbFile = Ti.Filesystem.getFile(dbPath, dbName + '.sql');
  Ti.API.info("dbFile.nativePath: " + dbFile.nativePath);
}

if(dbFile.exists()){
  Ti.API.info('On the platform ' + dbPlatform + ', the database file was created at ' + dbFile.nativePath);
} else {
  Ti.API.info('On the platform ' + dbPlatform + ', the database file was NOT created at ' + dbFile.nativePath);
}

See Doug's comments at: [http://developer.appcelerator.com/question/121945/update-database-from-remote-source] [http://developer.appcelerator.com/question/96771/location-of-titanium-sql-database-on-android]