internal void EvaluateComputedDataObjects(SQLContext sqlContext) { //insert data in sql this.PersistBaseDataObjects(sqlContext); //set computed data tables this.SetComputedDataObjectContext(sqlContext); }
internal void SetComputedDataObjectContext(SQLContext context) { foreach (DataObject dob in this.dataObjectCollection.Where(d => d.IsComputed)) { var table = context.GetDataTable(dob.ComputeQuery); SetDataContext(dob, table); } }
private void PersistBaseDataObjects(SQLContext sqlContext) { if (dataObjectCollection.Any(d => d.IsComputed) && !isBaseDataPersisted) { foreach (DataObject dob in this.dataContextDictionary.Keys.Where(d => !d.IsComputed)) { WriteLog(Constants.BlankLine); var ctx = dataContextDictionary[dob]; if (!ctx.IsSQLTableCreated) { var sql1 = ctx.GetCreateTableQuery(); WriteLog(Environment.NewLine + sql1); sqlContext.ExecuteNonQuery(sql1); WriteLog($"SQLLite Table[{dob.Alias}] Created"); } if (!ctx.IsDataInserted) { var sql2 = ctx.GetInsertQuery(); var idx = sql2.NthIndexOf(Environment.NewLine, 3); if (idx > -1) { WriteLog(Environment.NewLine + sql2.Substring(0, idx) + "..................."); } else { WriteLog(sql2); } sqlContext.ExecuteNonQuery(sql2); WriteLog("Data Persited"); } isBaseDataPersisted = true; } } }
public DataObjectContext(DataObject dataObject, SQLContext Conn, Action <string> LogDelegate) { throw new NotImplementedException(); }
public PersistedDataObject(SQLContext context, DataObjectContext dataobjContext) { }