public ISqlService CreatePlayerSqlService(int version, Action <SQLiteConnection, double> onUpdate = null)
{
var dbTypes = new List <Type> {
typeof(QueueSong)
};
var config = new SqlServiceConfig
{
Tables = dbTypes,
CurrentVersion = version,
Path = Path.Combine(this.folderPath, "player.sqldb"),
OnUpdate = onUpdate
};
return(new SqlService(config));
}
public ISqlService CreatePlayerSqlService(int version, Action <SQLiteConnection, double> onUpdate = null)
{
var dbTypes = new List <Type>
{
typeof(QueueSong)
};
var config = new SqlServiceConfig
{
Tables = dbTypes,
CurrentVersion = version,
Path = Path.Combine(folderPath, Core.PlayerConstants.BgDataBasePath),
//OnUpdate = onUpdate
};
return(new SqlService(config));
}
private SqlService CreatePlayerSqlService()
{
var bgDbTypes = new List <Type>
{
typeof(QueueSong)
};
var bgConfig = new SqlServiceConfig
{
Tables = bgDbTypes,
CurrentVersion = 6,
Path = "player.sqldb"
};
var sql = new SqlService(bgConfig);
sql.Initialize();
return(sql);
}
private SqlService CreateHistorySqlService()
{
var historyDbTypes = new List <Type>
{
typeof(HistoryEntry)
};
var historyConfig = new SqlServiceConfig
{
Tables = historyDbTypes,
CurrentVersion = 2,
Path = "history.sqldb"
};
var sql = new SqlService(historyConfig);
sql.Initialize();
return(sql);
}
public ISqlService CreateCollectionSqlService(int version, Action <SQLiteConnection, double> onUpdate = null)
{
var dbTypes = new List <Type>
{
typeof(Artist),
typeof(Album),
typeof(Song),
typeof(RadioStation),
typeof(Playlist),
typeof(PlaylistSong)
};
var config = new SqlServiceConfig
{
Tables = dbTypes,
CurrentVersion = version,
Path = Path.Combine(this.folderPath, "collection.sqldb"),
OnUpdate = onUpdate
};
return(new SqlService(config));
}
public ISqlService CreateCollectionSqlService(int version, Action <SQLiteConnection, double> onUpdate = null)
{
var dbTypes = new List <Type>
{
typeof(Artist),
typeof(Album),
typeof(Song),
typeof(Video),
typeof(Playlist),
typeof(PlaylistSong),
typeof(Lyrics),
typeof(Folder)
};
var config = new SqlServiceConfig
{
Tables = dbTypes,
CurrentVersion = version,
Path = Path.Combine(folderPath, Core.PlayerConstants.DataBasePath),
//OnUpdate = onUpdate
};
return(new SqlService(config));
}
private SqlService CreateCollectionSqlService()
{
var dbTypes = new List <Type>
{
typeof(Artist),
typeof(Album),
typeof(Song),
typeof(RadioStation),
typeof(Playlist),
typeof(PlaylistSong)
};
var config = new SqlServiceConfig
{
Tables = dbTypes,
CurrentVersion = 11,
Path = "collection.sqldb"
};
var sql = new SqlService(config);
sql.Initialize();
return(sql);
}
private SqlService CreateHistorySqlService()
{
var historyDbTypes = new List<Type>
{
typeof (HistoryEntry)
};
var historyConfig = new SqlServiceConfig
{
Tables = historyDbTypes,
CurrentVersion = 2,
Path = "history.sqldb"
};
var sql = new SqlService(historyConfig);
sql.Initialize();
return sql;
}
private SqlService CreateCollectionSqlService()
{
var dbTypes = new List<Type>
{
typeof (Artist),
typeof (Album),
typeof (Song),
typeof (RadioStation),
typeof (Playlist),
typeof (PlaylistSong)
};
var config = new SqlServiceConfig
{
Tables = dbTypes,
CurrentVersion = 11,
Path = "collection.sqldb"
};
var sql = new SqlService(config);
sql.Initialize();
return sql;
}
private SqlService CreatePlayerSqlService()
{
var bgDbTypes = new List<Type>
{
typeof (QueueSong)
};
var bgConfig = new SqlServiceConfig
{
Tables = bgDbTypes,
CurrentVersion = 6,
Path = "player.sqldb"
};
var sql = new SqlService(bgConfig);
sql.Initialize();
return sql;
}
public ISqlService CreatePlayerSqlService(int version, Action<SQLiteConnection, double> onUpdate = null)
{
var dbTypes = new List<Type> { typeof(QueueSong) };
var config = new SqlServiceConfig
{
Tables = dbTypes,
CurrentVersion = version,
Path = Path.Combine(this.folderPath, "player.sqldb"),
OnUpdate = onUpdate
};
return new SqlService(config);
}
public ISqlService CreateCollectionSqlService(int version, Action<SQLiteConnection, double> onUpdate = null)
{
var dbTypes = new List<Type>
{
typeof(Artist),
typeof(Album),
typeof(Song),
typeof(RadioStation),
typeof(Playlist),
typeof(PlaylistSong)
};
var config = new SqlServiceConfig
{
Tables = dbTypes,
CurrentVersion = version,
Path = Path.Combine(this.folderPath, "collection.sqldb"),
OnUpdate = onUpdate
};
return new SqlService(config);
}
