public Application[] Get(string filter)
{
if (Session.Disconnected)
{
Session.Reconnect();
}
var request = Session.GetSessionRequest("/rest/system/app", Method.GET);
if (!filter.IsNullOrEmpty())
{
request.Parameters.Add(new Parameter()
{
Name = "filter",
Value = filter,
Type = ParameterType.GetOrPost
});
}
var response = Session.Client.Execute <ApplicationDescriptorList>(request);
var check = DreamFactoryException.ValidateIRestResponse(response);
if (check != null)
{
throw new DeserializationException(string.Format("Failed to retrieve Application descriptors: {0}", response.ErrorMessage), check);
}
switch (response.StatusCode)
{
case System.Net.HttpStatusCode.OK:
var apps = new List <Application>();
var data = response.Data;
if (data != null)
{
foreach (var app in data.record)
{
apps.Add(new Application(app));
}
}
return(apps.ToArray());
case HttpStatusCode.Forbidden:
case HttpStatusCode.Unauthorized:
if (Debugger.IsAttached)
{
Debugger.Break();
}
Session.Disconnected = true;
throw DreamFactoryException.Parse(response);
default:
throw DreamFactoryException.Parse(response);
}
}
internal Table(Session session, string tableName)
{
Session = session;
m_uris = new UriFactory(Session.ServerVersion);
if (Session.Disconnected)
{
Session.Reconnect();
}
var request = Session.GetSessionRequest(string.Format("{0}/{1}", m_uris.SchemaRoot, tableName), Method.GET);
var response = Session.Client.Execute <TableDescriptor>(request);
var check = DreamFactoryException.ValidateIRestResponse(response);
if (check != null)
{
throw new DeserializationException(string.Format("Failed to retrieve the schema for table '{0}': {1}", tableName, response.ErrorMessage), check);
}
switch (response.StatusCode)
{
case HttpStatusCode.OK:
var descriptor = response.Data;
Name = descriptor.name;
Label = descriptor.label;
var fieldList = new List <Field>();
foreach (var f in descriptor.field)
{
var fld = f.AsField();
fieldList.Add(fld);
if (f.is_primary_key.HasValue && f.is_primary_key.Value)
{
KeyField = fld;
}
}
Fields = fieldList.ToArray();
break;
case HttpStatusCode.Forbidden:
case HttpStatusCode.Unauthorized:
if (Debugger.IsAttached)
{
Debugger.Break();
}
Session.Disconnected = true;
throw DreamFactoryException.Parse(response);
default:
throw DreamFactoryException.Parse(response);
}
}
public int GetRecordCount(string filter)
{
if (Session.Disconnected)
{
Session.Reconnect();
}
var request = Session.GetSessionRequest(string.Format("/rest/db/{0}", Name), Method.GET);
request.Parameters.Add(new Parameter()
{
Name = "limit", Value = 1, Type = ParameterType.GetOrPost
});
request.Parameters.Add(new Parameter()
{
Name = "include_count", Value = "true", Type = ParameterType.GetOrPost
});
if (!string.IsNullOrEmpty(filter))
{
request.Parameters.Add(new Parameter()
{
Name = "filter", Value = filter, Type = ParameterType.GetOrPost
});
}
var response = Session.Client.Execute <ResourceDescriptorList>(request);
var check = DreamFactoryException.ValidateIRestResponse(response);
if (check != null)
{
throw new DeserializationException(string.Format("Failed to retrieve a record count on table '{0}': {1}", Name, response.ErrorMessage), check);
}
switch (response.StatusCode)
{
case HttpStatusCode.OK:
// TODO: this feels fragile - we should look at improving it
return(Convert.ToInt32(((SimpleJson.DeserializeObject(response.Content) as JsonObject)[1] as JsonObject)[0]));
case HttpStatusCode.Forbidden:
case HttpStatusCode.Unauthorized:
if (Debugger.IsAttached)
{
Debugger.Break();
}
Session.Disconnected = true;
throw DreamFactoryException.Parse(response);
default:
throw DreamFactoryException.Parse(response);
}
}
public Container GetContainer(string containerName)
{
if (Session.Disconnected)
{
Session.Reconnect();
}
// todo: add caching
// The trailing slash here is *required*. Without it we'll get back a NotFound
var request = Session.GetSessionRequest(string.Format("/rest/app/{0}/", containerName), Method.GET);
var response = Session.Client.Execute <ContainerDescriptor>(request);
var check = DreamFactoryException.ValidateIRestResponse(response);
if (check != null)
{
throw new DeserializationException(string.Format("Failed to container descriptor for '{0}': {1}", containerName, response.ErrorMessage), check);
}
switch (response.StatusCode)
{
case System.Net.HttpStatusCode.OK:
var container = response.Data;
if (container != null)
{
return(new Container(container));
}
return(null);
case System.Net.HttpStatusCode.NotFound:
return(null);
case HttpStatusCode.Forbidden:
case HttpStatusCode.Unauthorized:
if (Debugger.IsAttached)
{
Debugger.Break();
}
Session.Disconnected = true;
throw DreamFactoryException.Parse(response);
default:
var error = SimpleJson.DeserializeObject <ErrorDescriptorList>(response.Content);
// TODO: make a library-specific Exception class
throw new Exception(error.error[0].message);
}
}
public Container[] GetContainers()
{
if (Session.Disconnected)
{
Session.Reconnect();
}
// this is non-intuitive based on the published API.
var request = Session.GetSessionRequest("/rest/app", Method.GET);
var response = Session.Client.Execute <ContainerDescriptor>(request);
var check = DreamFactoryException.ValidateIRestResponse(response);
if (check != null)
{
throw new DeserializationException(string.Format("Failed to retrieve Container descriptors: {0}", response.ErrorMessage), check);
}
switch (response.StatusCode)
{
case System.Net.HttpStatusCode.OK:
var containers = new List <Container>();
var container = response.Data;
if (container != null)
{
foreach (var app in container.folder)
{
containers.Add(new Container(app));
}
}
return(containers.ToArray());
case HttpStatusCode.Forbidden:
case HttpStatusCode.Unauthorized:
if (Debugger.IsAttached)
{
Debugger.Break();
}
Session.Disconnected = true;
throw DreamFactoryException.Parse(response);
default:
var error = SimpleJson.DeserializeObject <ErrorDescriptorList>(response.Content);
// TODO: make a library-specific Exception class
throw new Exception(error.error[0].message);
}
}
private SystemConfigDescriptor GetSystemConfig()
{
var request = GetSessionRequest("/rest/system/config", Method.GET, false);
var response = Client.Execute <SystemConfigDescriptor>(request);
var check = DreamFactoryException.ValidateIRestResponse(response);
if (check != null)
{
throw new DeserializationException(string.Format("Failed to deserialize the Session descriptor: {0}", response.ErrorMessage), check);
}
switch (response.StatusCode)
{
case HttpStatusCode.Created:
case HttpStatusCode.OK:
return(response.Data);
default:
throw DreamFactoryException.Parse(response);
}
}
public Table GetTable(string tableName)
{
if (m_tableCache.ContainsKey(tableName))
{
return(m_tableCache[tableName]);
}
// TODO: enable caching of this info
if (Session.Disconnected)
{
Session.Reconnect();
}
// var request = Session.GetSessionRequest(string.Format("/rest/schema/{0}", tableName), Method.GET);
var request = Session.GetSessionRequest(m_uris.GetTableSchema(tableName), Method.GET);
var response = Session.Client.Execute <ResourceDescriptor>(request);
var check = DreamFactoryException.ValidateIRestResponse(response);
if (check != null)
{
// we've seen problems in Mono (3.2.3 on the windows desktop) with GZip decompression failure
throw new DeserializationException(string.Format("Failed to deserialize schema response for table '{0}': {1}", tableName, response.ErrorMessage), check);
}
switch (response.StatusCode)
{
case HttpStatusCode.OK:
var table = new Table(Session, response.Data);
if (!m_tableCache.ContainsKey(tableName))
{
m_tableCache.Add(tableName, table);
}
return(table);
case HttpStatusCode.NotFound:
return(null);
case HttpStatusCode.Forbidden:
case HttpStatusCode.Unauthorized:
if (Debugger.IsAttached)
{
Debugger.Break();
}
Session.Disconnected = true;
// TODO: attempt to-reconnect?
throw DreamFactoryException.Parse(response);
default:
var error = SimpleJson.DeserializeObject <ErrorDescriptorList>(response.Content);
if (error.error.Count > 0)
{
// As of 10/24/13 DreamFactory has a bug where it returns a 500 instead of a 404 for a not-found table
// Oddly, the error code inside the error returned is a 404, so they know it's not found. This is the workaround.
if (error.error[0].code == 404)
{
return(null);
}
throw DreamFactoryException.Parse(response);
}
throw DreamFactoryException.Parse(response);
}
}
public Table[] GetTables(bool useCache)
{
if (Session.Disconnected)
{
Session.Reconnect();
}
var request = Session.GetSessionRequest("/rest/db", Method.GET);
var response = Session.Client.Execute <ResourceDescriptorList>(request);
var check = DreamFactoryException.ValidateIRestResponse(response);
if (check != null)
{
throw new DeserializationException(string.Format("Failed to deserialize the list of tables: {0}", response.ErrorMessage), check);
}
switch (response.StatusCode)
{
case HttpStatusCode.OK:
var list = new List <Table>();
lock (m_tableCache)
{
foreach (var resource in response.Data.resource)
{
Table t = null;
if (useCache)
{
if (m_tableCache.ContainsKey(resource.name))
{
t = m_tableCache[resource.name];
list.Add(t);
}
}
if (t == null)
{
try
{
t = new Table(Session, resource);
list.Add(t);
if (!m_tableCache.ContainsKey(t.Name))
{
m_tableCache.Add(t.Name, t);
}
else
{
m_tableCache[t.Name] = t;
}
}
catch (Exception ex)
{
// TODO: log this?
if (Debugger.IsAttached)
{
Debugger.Break();
}
Debug.WriteLine(ex.Message);
throw;
}
}
}
}
return(list.ToArray());
case HttpStatusCode.Forbidden:
case HttpStatusCode.Unauthorized:
if (Debugger.IsAttached)
{
Debugger.Break();
}
Session.Disconnected = true;
throw DreamFactoryException.Parse(response);
default:
throw DreamFactoryException.Parse(response);
}
}
public IEnumerable <object[]> GetRecords(int limit, int offset, string filter, string order)
{
if (Session.Disconnected)
{
Session.Reconnect();
}
var request = Session.GetSessionRequest(string.Format("/rest/db/{0}", Name), Method.GET);
if (limit > 0)
{
request.Parameters.Add(new Parameter()
{
Name = "limit", Value = limit, Type = ParameterType.GetOrPost
});
}
if (offset > 0)
{
request.Parameters.Add(new Parameter()
{
Name = "offset", Value = offset, Type = ParameterType.GetOrPost
});
}
if (!filter.IsNullOrEmpty())
{
request.Parameters.Add(new Parameter()
{
Name = "filter", Value = filter, Type = ParameterType.GetOrPost
});
}
if (!order.IsNullOrEmpty())
{
request.Parameters.Add(new Parameter()
{
Name = "order", Value = order, Type = ParameterType.GetOrPost
});
}
var response = Session.Client.Execute <ResourceDescriptorList>(request);
var check = DreamFactoryException.ValidateIRestResponse(response);
if (check != null)
{
throw new DeserializationException(string.Format("Failed to retrieve a records from table '{0}': {1}", Name, response.ErrorMessage), check);
}
switch (response.StatusCode)
{
case HttpStatusCode.OK:
JsonObject results = SimpleJson.DeserializeObject <JsonObject>(response.Content);
var records = new List <object[]>();
foreach (JsonObject item in results["record"] as JsonArray)
{
var array = new object[Fields.Length];
var index = 0;
foreach (var field in Fields)
{
array[index++] = item[field.Name];
}
records.Add(array);
}
return(records);
case HttpStatusCode.NotFound:
// table doesn't exist, make sure it's not in the cache (e.g. remote delete)
Session.Data.RemoveTableFromCache(this.Name);
throw new TableNotFoundException(this.Name);
case HttpStatusCode.Forbidden:
case HttpStatusCode.Unauthorized:
if (Debugger.IsAttached)
{
Debugger.Break();
}
Session.Disconnected = true;
throw DreamFactoryException.Parse(response);
default:
throw DreamFactoryException.Parse(response);
}
}
public IEnumerable <object[]> GetRecords(string filterStatement, params object[] resourceIDs)
{
if (Session.Disconnected)
{
Session.Reconnect();
}
var request = Session.GetSessionRequest(string.Format("/rest/db/{0}", Name), Method.GET);
if ((resourceIDs != null) && (resourceIDs.Length > 0))
{
request.Parameters.Add(new Parameter()
{
Name = "ids",
Value = string.Join(",", resourceIDs.Select(i => i.ToString()).ToArray()),
Type = ParameterType.GetOrPost
});
}
if (!filterStatement.IsNullOrEmpty())
{
request.Parameters.Add(new Parameter()
{
Name = "filter",
Value = filterStatement,
Type = ParameterType.GetOrPost
});
}
var response = Session.Client.Execute <ResourceDescriptorList>(request);
var check = DreamFactoryException.ValidateIRestResponse(response);
if (check != null)
{
throw new DeserializationException(string.Format("Failed to retrieve a records from table '{0}': {1}", Name, response.ErrorMessage), check);
}
switch (response.StatusCode)
{
case HttpStatusCode.OK:
JsonObject results = SimpleJson.DeserializeObject <JsonObject>(response.Content);
var records = new List <object[]>();
if (results.Count != 0)
{
// {"record":["Could not find record for id = '9'"]}
var jarray = results["record"] as JsonArray;
if (jarray.Count > 0)
{
if (jarray[0] as JsonObject == null)
{
Debug.WriteLine("No results");
return(records);
}
foreach (JsonObject item in jarray)
{
var array = new object[Fields.Length];
var index = 0;
foreach (var field in Fields)
{
array[index++] = item[field.Name];
}
records.Add(array);
}
}
}
return(records);
case HttpStatusCode.Forbidden:
case HttpStatusCode.Unauthorized:
if (Debugger.IsAttached)
{
Debugger.Break();
}
Session.Disconnected = true;
throw DreamFactoryException.Parse(response);
default:
throw DreamFactoryException.Parse(response);
}
}
public void Initialize()
{
// ServicePointManager.SecurityProtocol = SecurityProtocolType.Ssl3;
Client = new RestClient(DSPRootAddress);
var request = new RestRequest("/rest/user/session", Method.POST);
request.AddHeader("X-DreamFactory-Application-Name", ApplicationName);
request.RequestFormat = DataFormat.Json;
var creds = new CredentialDescriptor
{
email = Username,
password = Password
};
request.AddBody(creds);
if (EnableCompressedResponseData)
{
request.AcceptDecompression = DecompressionMethods.Deflate | DecompressionMethods.GZip | DecompressionMethods.None;
}
else
{
request.AcceptDecompression = DecompressionMethods.None;
}
var response = Client.Execute <SessionDescriptor>(request);
var check = DreamFactoryException.ValidateIRestResponse(response);
if (check != null)
{
throw new DeserializationException(string.Format("Failed to deserialize the Session descriptor: {0}", check.Message), check);
}
switch (response.StatusCode)
{
case HttpStatusCode.Created:
case HttpStatusCode.OK:
// successful session opened
Disconnected = false;
break;
default:
throw DreamFactoryException.Parse(response);
}
SessionDescriptor = response.Data;
// TODO: set some properties that might be of interest
// get the server version
ConfigDescriptor = GetSystemConfig();
ServerVersion = new Version(ConfigDescriptor.dsp_version);
if (Data == null)
{
Data = new Data(this);
}
if (Applications == null)
{
Applications = new Applications(this);
}
}
