public static UpdatableElement GetFakeTransaction(int number, int amount) { var lastUpdated = DateTime.Now.JavascriptTicks(); var transaction = new Transaction() { amount = amount, comment = "Comment" + number, currency = "ccy" + number, @from = "from" + number, to = new []{"to" + number}, id = number.ToString(), lastUpdated = lastUpdated }; var jsonTransaction = JsonConvert.SerializeObject(transaction); return new UpdatableElement() { id = number.ToString(), lastUpdated = lastUpdated, SerializedValue = jsonTransaction }; }
public List<Transaction> getSkinnyTransactionSet(int qty) { Console.WriteLine(Environment.NewLine); Console.WriteLine("LOAD SKINNY TRANSACTION SET"); var transactions = new List<Transaction>(); for (int i = 1; i <= qty; i++) { var newTrans = new Transaction() { Amount = i, Comment = "Transaction no. " + i.ToString(), Identifier = "AA-" + i.ToString() }; transactions.Add(newTrans); } return transactions; }
public void _Deletes_Typed_Record() { _setup.CheckSetUp(); var model = new DBTable(_connectionStringName, _testTableName, _tablePkColumn); var newRecord = new Transaction() { Amount = 100, Comment = "I Overspent!", Identifier = "XXX" }; model.Insert(newRecord); int recordPk = newRecord.TransactionId; newRecord = model.Find<Transaction>(recordPk); int deleted = model.Delete(newRecord.TransactionId); newRecord = model.Find(recordPk); Assert.True(deleted > 0 && newRecord == null); }
public void _Updates_Typed_Record() { _setup.CheckSetUp(); var model = new DBTable(_connectionStringName, _testTableName, _tablePkColumn); var newRecord = new Transaction() { Amount = 100, Comment = "I Overspent!", Identifier = "XXX" }; // Dump the new record in as an UPDATE: model.Insert(newRecord); int recordPk = newRecord.TransactionId; string newValue = "I changed it!"; newRecord.Identifier = newValue; int updated = model.Update(newRecord); newRecord = model.Find<Transaction>(recordPk); Assert.True(updated > 0 && newRecord.Identifier == newValue); }
public void _Inserts_Single_Typed_Record() { _setup.CheckSetUp(); var newRecord = new Transaction() { Amount = 100, Comment = "I Overspent!", Identifier = "XXX" }; var model = new DBTable(_connectionStringName, _testTableName, _tablePkColumn); var inserted = model.Insert(newRecord); Assert.True(newRecord.TransactionId > 0); }