static UsageDataMessage FetchDataForUpload(SQLiteConnection connection, bool fetchIncompleteSessions)
{
UsageDataMessage message = new UsageDataMessage();
// Retrieve the User ID
using (SQLiteCommand cmd = connection.CreateCommand()) {
cmd.CommandText = "SELECT value FROM Properties WHERE name = 'userID';";
string userID = (string)cmd.ExecuteScalar();
message.UserID = new Guid(userID);
}
// Retrieve the list of sessions
using (SQLiteCommand cmd = connection.CreateCommand()) {
if (fetchIncompleteSessions)
{
cmd.CommandText = @"SELECT id, startTime, endTime FROM Sessions;";
}
else
{
// Fetch all sessions which are either closed or inactive for more than 24 hours
cmd.CommandText = @"SELECT id, startTime, endTime FROM Sessions
WHERE (endTime IS NOT NULL)
OR (ifnull((SELECT max(time) FROM FeatureUses WHERE FeatureUses.session = Sessions.id), Sessions.startTime)
< datetime('now','-1 day'));" ;
}
using (SQLiteDataReader reader = cmd.ExecuteReader()) {
while (reader.Read())
{
UsageDataSession session = new UsageDataSession();
session.SessionID = reader.GetInt64(0);
session.StartTime = reader.GetDateTime(1);
if (!reader.IsDBNull(2))
{
session.EndTime = reader.GetDateTime(2);
}
message.Sessions.Add(session);
}
}
}
string commaSeparatedSessionIDList = GetCommaSeparatedIDList(message.Sessions);
StringInterner stringInterning = new StringInterner();
// Retrieve the environment
using (SQLiteCommand cmd = connection.CreateCommand()) {
cmd.CommandText = "SELECT session, name, value FROM Environment WHERE session IN (" + commaSeparatedSessionIDList + ");";
using (SQLiteDataReader reader = cmd.ExecuteReader()) {
while (reader.Read())
{
long sessionID = reader.GetInt64(0);
UsageDataSession session = message.FindSession(sessionID);
session.EnvironmentProperties.Add(
new UsageDataEnvironmentProperty {
Name = stringInterning.Intern(reader.GetString(1)),
Value = stringInterning.Intern(reader.GetString(2))
});
}
}
}
// Retrieve the feature uses
using (SQLiteCommand cmd = connection.CreateCommand()) {
cmd.CommandText = "SELECT session, time, endTime, feature, activationMethod FROM FeatureUses WHERE session IN (" + commaSeparatedSessionIDList + ");";
using (SQLiteDataReader reader = cmd.ExecuteReader()) {
while (reader.Read())
{
long sessionID = reader.GetInt64(0);
UsageDataSession session = message.FindSession(sessionID);
UsageDataFeatureUse featureUse = new UsageDataFeatureUse();
featureUse.Time = reader.GetDateTime(1);
if (!reader.IsDBNull(2))
{
featureUse.EndTime = reader.GetDateTime(2);
}
featureUse.FeatureName = stringInterning.Intern(reader.GetString(3));
if (!reader.IsDBNull(4))
{
featureUse.ActivationMethod = stringInterning.Intern(reader.GetString(4));
}
session.FeatureUses.Add(featureUse);
}
}
}
// Retrieve the exceptions
using (SQLiteCommand cmd = connection.CreateCommand()) {
cmd.CommandText = "SELECT session, time, type, stackTrace FROM Exceptions WHERE session IN (" + commaSeparatedSessionIDList + ");";
using (SQLiteDataReader reader = cmd.ExecuteReader()) {
while (reader.Read())
{
long sessionID = reader.GetInt64(0);
UsageDataSession session = message.FindSession(sessionID);
UsageDataException exception = new UsageDataException();
exception.Time = reader.GetDateTime(1);
exception.ExceptionType = stringInterning.Intern(reader.GetString(2));
if (!reader.IsDBNull(3))
{
exception.StackTrace = stringInterning.Intern(reader.GetString(3));
}
session.Exceptions.Add(exception);
}
}
}
return(message);
}
/// <summary>
/// Starts the upload of the usage data.
/// </summary>
/// <exception cref="IncompatibleDatabaseException">The database version is not compatible with this
/// version of the AnalyticsSessionWriter.</exception>
public void StartUpload(Binding binding, EndpointAddress endpoint)
{
UsageDataMessage message;
bool addDummySession = false;
using (SQLiteConnection connection = OpenConnection()) {
using (SQLiteTransaction transaction = connection.BeginTransaction()) {
CheckDatabaseVersion(connection);
HasUploadedTodayStatus status = HasAlreadyUploadedToday(connection);
if (status == HasUploadedTodayStatus.Yes)
{
message = null;
}
else
{
message = FetchDataForUpload(connection, false);
if (status == HasUploadedTodayStatus.NeverUploaded)
{
addDummySession = true;
}
}
transaction.Commit();
}
}
if (message != null)
{
string commaSeparatedSessionIDList = GetCommaSeparatedIDList(message.Sessions);
if (addDummySession)
{
// A dummy session is used for the first upload to notify the server of the user's environment.
// Without this, we couldn't tell the version of a user who tries SharpDevelop once but doesn't use it long
// enough for an actual session to be uploaded.
UsageDataSession dummySession = new UsageDataSession();
dummySession.SessionID = 0;
dummySession.StartTime = DateTime.UtcNow;
dummySession.EnvironmentProperties.AddRange(UsageDataSessionWriter.GetDefaultEnvironmentData());
if (this.EnvironmentDataForDummySession != null)
{
dummySession.EnvironmentProperties.AddRange(this.EnvironmentDataForDummySession);
}
message.Sessions.Add(dummySession);
}
DataContractSerializer serializer = new DataContractSerializer(typeof(UsageDataMessage));
byte[] data;
using (MemoryStream ms = new MemoryStream()) {
using (GZipStream zip = new GZipStream(ms, CompressionMode.Compress)) {
serializer.WriteObject(zip, message);
}
data = ms.ToArray();
}
UdcProxy.UDCUploadServiceClient client = new UdcProxy.UDCUploadServiceClient(binding, endpoint);
try {
client.BeginUploadUsageData(productName, new MemoryStream(data),
ar => UsageDataUploaded(ar, client, commaSeparatedSessionIDList), null);
} catch (CommunicationException) {
// ignore error (maybe currently not connected to network)
} catch (TimeoutException) {
// ignore error (network connection trouble?)
}
}
}