private void Init() { var str = string.Format("SELECT max(r.{0}) FROM {1} r", m_idMember, m_table); var query = new ScalarQuery<object>(m_type, str); object highestId; try { highestId = query.Execute(); } catch (Exception e) { OnError(e); highestId = query.Execute(); } if (highestId == null) { m_highestId = 0; } else { m_highestId = (long)Convert.ChangeType(highestId, typeof(long)); } if (m_highestId < m_minId) { m_highestId = m_minId; } }
public void IncompatibleGenericTypesThrowMeaningfulErrorsOnMediatorCall() { int result; var query = new ScalarQuery<int>(typeof(Post), validQuery); try { result = ActiveRecordMediator<Post>.ExecuteQuery2(query); } catch (Exception ex) { Assert.IsInstanceOf(typeof(NHibernate.QueryException), ex); Assert.IsTrue(ex.Message.Contains("Int32")); Assert.IsTrue(ex.Message.Contains("Int64")); } }
public int NumberOfChildrens() { ScalarQuery q = new ScalarQuery(typeof(Category), "select count(*) from Category where Parent = ?", Id); return (int) ExecuteQuery(q); }
private static uint GetNextHighestPlayerId() { ScalarQuery idQuery = new ScalarQuery(typeof(CharacterRecord), QueryLanguage.Hql, "select max(chr.EntityId) from CharacterRecord chr"); object highestId = ActiveRecordMediator.ExecuteQuery(idQuery); return (highestId == null ? 0 : (highestId as CharacterRecord).EntityLowId + 1); }
public void InvalidGenericQueryWithDirectCall() { var query = new ScalarQuery<int>(typeof(Post), invalidQuery); Assert.AreEqual(default(int), query.Execute()); }
public void InvalidResultGeneric() { ScalarQuery<int> query = new ScalarQuery<int>(typeof(Post), invalidQuery); int result = ActiveRecordMediator<Post>.ExecuteQuery2(query); Assert.AreEqual(default(int), result); }
public void InvalidResultWithNonGenericQueryYieldsNull() { ScalarQuery query = new ScalarQuery(typeof(Post), invalidQuery); Assert.IsNull(ActiveRecordMediator<Post>.ExecuteQuery(query)); }
public void ValidGenericQueryWithDirectCall() { var query = new ScalarQuery<long>(typeof(Post), validQuery); Assert.AreEqual(1, query.Execute()); }
public void ValidResultGeneric() { ScalarQuery<long> query = new ScalarQuery<long>(typeof(Post), validQuery); long result = ActiveRecordMediator<Post>.ExecuteQuery2(query); Assert.AreEqual(1, result); }
public void ValidResult() { ScalarQuery query = new ScalarQuery(typeof(Post), validQuery); long result = (long) ActiveRecordMediator<Post>.ExecuteQuery(query); Assert.AreEqual(1, result); }
public static int FindLastIdMsg(int chat) { ScalarQuery q = new ScalarQuery(typeof(ChatMessage), @" SELECT MAX(C.Id) FROM ChatMessage C WHERE C.Chat = ?", chat); // return (int) ExecuteQuery(q); object val = ExecuteQuery(q); if (val != null) return (int)val; else return 0; }