public UserCountsRepository(ICassandraSession session, IMapper mapper)
{
_session = session;
_mapper = mapper;
// Preparing statements
TableAttribute tableAttribute = typeof (UserCountsEntity).GetCustomAttributes(typeof (TableAttribute), true).Select(a => (TableAttribute)a).First();
string entityName = tableAttribute.Name;
string userIdPropertyName = NameOfHelper.PropertyName<UserCountsEntity>(x => x.UserId);
string likesPropertyName = NameOfHelper.PropertyName<UserCountsEntity>(x => x.Likes);
string dislikesPropertyName = NameOfHelper.PropertyName<UserCountsEntity>(x => x.Dislikes);
string viewsPropertyName = NameOfHelper.PropertyName<UserCountsEntity>(x => x.Views);
string abusesPropertyName = NameOfHelper.PropertyName<UserCountsEntity>(x => x.Abuses);
_getStatement = new Lazy<PreparedStatement>(() => _session.Get().Prepare(string.Format("SELECT * FROM \"{0}\" WHERE \"{1}\" = ?", entityName, userIdPropertyName)));
_incViewsStatement =
new Lazy<PreparedStatement>(
() => _session.Get().Prepare(string.Format("UPDATE \"{0}\" SET \"{2}\" = \"{2}\" + 1 WHERE \"{1}\" = ?", entityName, userIdPropertyName, viewsPropertyName)));
_incLikesStatement =
new Lazy<PreparedStatement>(
() => _session.Get().Prepare(string.Format("UPDATE \"{0}\" SET \"{2}\" = \"{2}\" + 1 WHERE \"{1}\" = ?", entityName, userIdPropertyName, likesPropertyName)));
_incDislikesStatement =
new Lazy<PreparedStatement>(
() => _session.Get().Prepare(string.Format("UPDATE \"{0}\" SET \"{2}\" = \"{2}\" + 1 WHERE \"{1}\" = ?", entityName, userIdPropertyName, dislikesPropertyName)));
_decLikesStatement =
new Lazy<PreparedStatement>(
() => _session.Get().Prepare(string.Format("UPDATE \"{0}\" SET \"{2}\" = \"{2}\" - 1 WHERE \"{1}\" = ?", entityName, userIdPropertyName, likesPropertyName)));
_decDislikesStatement =
new Lazy<PreparedStatement>(
() => _session.Get().Prepare(string.Format("UPDATE \"{0}\" SET \"{2}\" = \"{2}\" - 1 WHERE \"{1}\" = ?", entityName, userIdPropertyName, dislikesPropertyName)));
_incAbuseStatement =
new Lazy<PreparedStatement>(
() => _session.Get().Prepare(string.Format("UPDATE \"{0}\" SET \"{2}\" = \"{2}\" + 1 WHERE \"{1}\" = ?", entityName, userIdPropertyName, abusesPropertyName)));
}
public ItemSignalsRepository(ICassandraSession session, IMapper mapper)
{
_session = session;
_mapper = mapper;
// Preparing statements
TableAttribute tableAttribute = typeof (ItemSignalsEntity).GetCustomAttributes(typeof (TableAttribute), true).Select(a => (TableAttribute)a).First();
string entityName = tableAttribute.Name;
string rowKeyPropertyName = NameOfHelper.PropertyName<ItemSignalsEntity>(x => x.ItemIdSignalType);
string isAnticolumnPropertyName = NameOfHelper.PropertyName<ItemSignalsEntity>(x => x.IsAnticolumn);
string userIdPropertyName = NameOfHelper.PropertyName<ItemSignalsEntity>(x => x.UserId);
string dateTimePropertyName = NameOfHelper.PropertyName<ItemSignalsEntity>(x => x.DateTime);
_insertStatement =
new Lazy<PreparedStatement>(
() =>
_session.Get()
.Prepare(string.Format("INSERT INTO \"{0}\" (\"{1}\",\"{2}\",\"{3}\",\"{4}\") VALUES(?,false,?,?)", entityName, rowKeyPropertyName, isAnticolumnPropertyName,
userIdPropertyName,
dateTimePropertyName)));
_getStatement =
new Lazy<PreparedStatement>(
() => _session.Get().Prepare(string.Format("SELECT * FROM \"{0}\" WHERE \"{1}\" = ? AND \"{2}\" = ?", entityName, rowKeyPropertyName, isAnticolumnPropertyName)));
_deleteStatement =
new Lazy<PreparedStatement>(
() =>
_session.Get()
.Prepare(string.Format("INSERT INTO \"{0}\" (\"{1}\",\"{2}\",\"{3}\",\"{4}\") VALUES(?,true,?,?)", entityName, rowKeyPropertyName, isAnticolumnPropertyName,
userIdPropertyName,
dateTimePropertyName)));
}
public AffinityGroupItemCountsRepository(ICassandraSession session, IMapper mapper)
{
_session = session;
_mapper = mapper;
// Preparing statements
TableAttribute tableAttribute = typeof (AffinityGroupItemCountsEntity).GetCustomAttributes(typeof (TableAttribute), true).Select(a => (TableAttribute)a).First();
string entityName = tableAttribute.Name;
string rowKeyPropertyName = NameOfHelper.PropertyName<AffinityGroupItemCountsEntity>(x => x.AffinityGroupSignalType);
string itemIdPropertyName = NameOfHelper.PropertyName<AffinityGroupItemCountsEntity>(x => x.ItemId);
string countPropertyName = NameOfHelper.PropertyName<AffinityGroupItemCountsEntity>(x => x.Count);
_getByIdStatement =
new Lazy<PreparedStatement>(() => _session.Get().Prepare(string.Format("SELECT * FROM \"{0}\" WHERE \"{1}\" = ? AND \"{2}\" = ?", entityName, rowKeyPropertyName, itemIdPropertyName)));
_getStatement =
new Lazy<PreparedStatement>(
() => _session.Get().Prepare(string.Format("SELECT * FROM \"{0}\" WHERE \"{1}\" = ?", entityName, rowKeyPropertyName)));
_incStatement =
new Lazy<PreparedStatement>(
() =>
_session.Get()
.Prepare(string.Format("UPDATE \"{0}\" SET \"{1}\" = \"{1}\" + 1 WHERE \"{2}\" = ? AND \"{3}\" = ?", entityName, countPropertyName, rowKeyPropertyName, itemIdPropertyName)));
_decStatement =
new Lazy<PreparedStatement>(
() =>
_session.Get()
.Prepare(string.Format("UPDATE \"{0}\" SET \"{1}\" = \"{1}\" - 1 WHERE \"{2}\" = ? AND \"{3}\" = ?", entityName, countPropertyName, rowKeyPropertyName, itemIdPropertyName)));
}
public AffinityGroupMostSignaledRepository(ICassandraSession session, IMapper mapper)
{
_session = session;
_mapper = mapper;
// Preparing statements
TableAttribute tableAttribute = typeof (AffinityGroupMostSignaledEntity).GetCustomAttributes(typeof (TableAttribute), true).Select(a => (TableAttribute)a).First();
string entityName = tableAttribute.Name;
string rowKeyPropertyName = NameOfHelper.PropertyName<AffinityGroupMostSignaledEntity>(x => x.AffinityGroupSignalType);
string countPropertyName = NameOfHelper.PropertyName<AffinityGroupMostSignaledEntity>(x => x.Count);
string itemIdPropertyName = NameOfHelper.PropertyName<AffinityGroupMostSignaledEntity>(x => x.ItemId);
_insertStatement =
new Lazy<PreparedStatement>(
() => _session.Get().Prepare(string.Format("INSERT INTO \"{0}\" (\"{1}\",\"{2}\",\"{3}\") VALUES(?,?,?)", entityName, rowKeyPropertyName, countPropertyName, itemIdPropertyName)));
_getStatement =
new Lazy<PreparedStatement>(
() => _session.Get().Prepare(string.Format("SELECT * FROM \"{0}\" WHERE \"{1}\" = ? ORDER BY \"{2}\" DESC", entityName, rowKeyPropertyName, countPropertyName)));
_deleteStatement =
new Lazy<PreparedStatement>(
() =>
_session.Get()
.Prepare(string.Format("DELETE FROM \"{0}\" WHERE \"{1}\" = ?", entityName, rowKeyPropertyName)));
}
public AffinityGroupMostSignaledVersionRepository(ICassandraSession session, IMapper mapper)
{
_session = session;
_mapper = mapper;
// Preparing statements
TableAttribute tableAttribute = typeof (AffinityGroupMostSignaledVersionEntity).GetCustomAttributes(typeof (TableAttribute), true).Select(a => (TableAttribute)a).First();
string entityName = tableAttribute.Name;
string rowKeyPropertyName = NameOfHelper.PropertyName<AffinityGroupMostSignaledVersionEntity>(x => x.AffinityGroupSignalType);
string versionPropertyName = NameOfHelper.PropertyName<AffinityGroupMostSignaledVersionEntity>(x => x.Version);
_updateStatement =
new Lazy<PreparedStatement>(
() => _session.Get().Prepare(string.Format("UPDATE \"{0}\" SET \"{1}\" = ? WHERE \"{2}\" = ?", entityName, versionPropertyName, rowKeyPropertyName)));
_getStatement =
new Lazy<PreparedStatement>(
() => _session.Get().Prepare(string.Format("SELECT * FROM \"{0}\" WHERE \"{1}\" = ?", entityName, rowKeyPropertyName)));
}
public TimeSeriesRawRepository(ICassandraSession session, IMapper mapper)
{
_session = session;
_mapper = mapper;
// Preparing statements
TableAttribute tableAttribute = typeof (TimeSeriesRawEntity).GetCustomAttributes(typeof (TableAttribute), true).Select(a => (TableAttribute)a).First();
string entityName = tableAttribute.Name;
string rowKeyPropertyName = NameOfHelper.PropertyName<TimeSeriesRawEntity>(x => x.EventIdYymmddhh);
string dateTimePropertyName = NameOfHelper.PropertyName<TimeSeriesRawEntity>(x => x.DateTime);
string payloadPropertyName = NameOfHelper.PropertyName<TimeSeriesRawEntity>(x => x.Payload);
_insertStatement =
new Lazy<PreparedStatement>(
() =>
_session.Get().Prepare(string.Format("INSERT INTO \"{0}\" (\"{1}\",\"{2}\",\"{3}\") VALUES(?,?,?)", entityName, rowKeyPropertyName, dateTimePropertyName, payloadPropertyName)));
_getStatement =
new Lazy<PreparedStatement>(
() => _session.Get().Prepare(string.Format("SELECT * FROM \"{0}\" WHERE \"{1}\" = ? AND \"{2}\" >= ? AND \"{2}\" <= ?", entityName, rowKeyPropertyName, dateTimePropertyName)));
}
public TimeSeriesRollupsDayRepository(ICassandraSession session, IMapper mapper)
{
_session = session;
_mapper = mapper;
// Preparing statements
TableAttribute tableAttribute = typeof (TimeSeriesRollupsDayEntity).GetCustomAttributes(typeof (TableAttribute), true).Select(a => (TableAttribute)a).First();
string entityName = tableAttribute.Name;
string rowKeyPropertyName = NameOfHelper.PropertyName<TimeSeriesRollupsDayEntity>(x => x.EventId);
string dayPropertyName = NameOfHelper.PropertyName<TimeSeriesRollupsDayEntity>(x => x.Day);
string countPropertyName = NameOfHelper.PropertyName<TimeSeriesRollupsDayEntity>(x => x.Count);
_getStatement =
new Lazy<PreparedStatement>(
() => _session.Get().Prepare(string.Format("SELECT * FROM \"{0}\" WHERE \"{1}\" = ? AND \"{2}\" >= ? AND \"{2}\" <= ?", entityName, rowKeyPropertyName, dayPropertyName)));
_incStatement =
new Lazy<PreparedStatement>(
() =>
_session.Get()
.Prepare(string.Format("UPDATE \"{0}\" SET \"{1}\" = \"{1}\" + 1 WHERE \"{2}\" = ? AND \"{3}\" = ?", entityName, countPropertyName, rowKeyPropertyName, dayPropertyName)));
}
