public static void Save(Account account, PersistenceConnection connection = null)
{
Queries.Save.Start()
.Param <Account>("account", account)
.Connect(connection)
.Execute();
}
public static void Save(IEnumerable <Account> accounts, PersistenceConnection connection = null)
{
Queries.Save.Start()
.Batch <Account>(accounts, "account")
.Connect(connection)
.Execute();
}
public static EdgeField Get(int fieldID, PersistenceConnection connection = null)
{
return(Queries.GetByID.Start()
.Param <int>("fieldID", fieldID)
.Connect(connection)
.Execute()
.FirstOrDefault()
);
}
public static Channel Get(int channelID, PersistenceConnection connection = null)
{
var results = Queries.Get.Start()
.Input <int>("channelID", channelID)
.Connect(connection)
.Execute();
Channel result = null;
foreach (Channel r in results)
{
result = r;
break;
}
return(result);
}
public static IEnumerable <Measure> GetInstances(int accountID, FlagsQuery?options = null, PersistenceConnection connection = null)
{
return(GetInstances(new Account()
{
ID = accountID
}, options, connection));
}
public static IEnumerable <Measure> GetInstances(Account account = null, FlagsQuery?options = null, PersistenceConnection connection = null)
{
return(Measure.Queries.GetInstances.Start()
.Param <Account>("account", account)
.Param <FlagsQuery?>("options", options)
.Execute());
}
public static IEnumerable <EdgeField> Get(int accountID = -1, int channelID = -1, PersistenceConnection connection = null)
{
return(Queries.Get.Start()
.Param <int>("accountID", accountID)
.Param <int>("channelID", channelID)
.Connect(connection)
.Execute()
);
}
public static IEnumerable <Account> Get(int accountID = -1, bool flat = false, PersistenceConnection connection = null)
{
var results = Queries.Get.Start()
.Param <int>("accountID", accountID)
.Connect(connection)
.Execute();
if (flat)
{
return(results);
}
else
{
return(results.Where(account => account.ParentAccount == null));
}
}
protected virtual Query OnPrepare(PersistenceConnection connection)
{
return(new Query(this, connection));
}
public Query Prepare(PersistenceConnection connection = null)
{
return(OnPrepare(connection));
}
public static IEnumerable <EdgeType> Get(Account account = null, Channel channel = null, PersistenceConnection connection = null)
{
return(Queries.Get.Start()
.Param <Account>("account", account)
.Param <Channel>("channel", channel)
.Connect(connection)
.Execute());
}
public static IEnumerable <Measure> Get(Account account = null, Channel channel = null, PersistenceConnection connection = null)
{
return(Measure.Queries.Get.Start()
.Select(
Measure.Properties.Name,
Measure.Properties.DisplayName,
Measure.Properties.TEMPConnections
)
.Param <Account>("account", account)
.Param <Channel>("channel", channel)
.Filter(Measure.Properties.DataType, " = ", MeasureDataType.Currency)
.Execute(QueryExecutionMode.Buffered));
}
public static IEnumerable <Channel> Get(PersistenceConnection connection = null)
{
return(Queries.Get.Start()
.Connect(connection)
.Execute());
}
public override PersistenceAdapter GetAdapter(PersistenceConnection connection)
{
return(new SqlTextCommandAdapter((SqlPersistenceConnection)connection, this));
}
internal Query(QueryDefinition definition, PersistenceConnection connection)
{
_definition = definition;
_connection = connection;
}
