protected void RenderTable()
{
var tableOrView = (schema::TableOrView)SchemaManager.GetDatabaseObjectByKey(Request.QueryString["objid"]);
var codegen = SqlCodeGeneratorFactory.CreateCodeGenerator(tableOrView.Dataset);
var sql = codegen.GenerateSelectStarQuery(tableOrView, 100);
DbProviderFactory dbf;
string cstr;
GetServerSettings(tableOrView.Dataset, out cstr, out dbf);
using (var cn = dbf.CreateConnection())
{
cn.ConnectionString = tableOrView.Dataset.ConnectionString;
cn.Open();
using (var cmd = cn.CreateCommand())
{
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
using (var dr = cmd.ExecuteReader(CommandBehavior.SequentialAccess))
{
RenderTable(Response.Output, dr);
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string objid = Request.QueryString["objid"];
obj = SchemaManager.GetDatabaseObjectByKey(objid);
// Make sure it's in MYDB
// *** TODO: implement security logic and replace this
if (StringComparer.InvariantCultureIgnoreCase.Compare(obj.DatasetName, MyDBDatabaseDefinition.Name) != 0)
{
throw new InvalidOperationException(); // *** TODO
}
if (!IsPostBack)
{
SchemaName.Text = obj.SchemaName;
ObjectName.Text = obj.ObjectName;
}
}
private void ScheduleExportTableJob()
{
var table = (Jhu.Graywulf.Schema.Table)SchemaManager.GetDatabaseObjectByKey(TableName.SelectedValue);
var format = FileFormatFactory.GetFileFormatDescription(FileFormat.SelectedValue);
// Make sure it's in MYDB
if (StringComparer.InvariantCultureIgnoreCase.Compare(table.DatasetName, MyDBDatabaseDefinition.Name) != 0)
{
throw new InvalidOperationException(); // *** TODO
}
var queue = EntityFactory.CombineName(EntityType.QueueInstance, Federation.ControllerMachine.GetFullyQualifiedName(), Jhu.Graywulf.Registry.Constants.LongQueueName);
var f = new Jhu.Graywulf.Jobs.ExportTables.ExportTablesFactory(RegistryContext);
// TODO: maybe add comments?
var job = f.ScheduleAsJob(Federation, new[] { table }, null, format, queue, "");
job.Save();
}
protected void Page_Load(object sender, EventArgs e)
{
var parts = Request.QueryString["objid"].Split(',');
objs = new List <DatabaseObject>();
ObjectList.Items.Clear();
foreach (var objid in parts)
{
var obj = SchemaManager.GetDatabaseObjectByKey(objid);
// Make sure it's in MYDB
if (StringComparer.InvariantCultureIgnoreCase.Compare(obj.DatasetName, MyDBDatabaseDefinition.Name) != 0)
{
throw new InvalidOperationException(); // *** TODO
}
objs.Add(obj);
ObjectList.Items.Add(obj.DisplayName);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DatabaseObject dbobj = null;
var dbobjid = (string)Request.QueryString["objid"] ?? SelectedSchemaObject;
if (dbobjid != null)
{
try
{
dbobj = SchemaManager.GetDatabaseObjectByKey(dbobjid);
}
catch
{
}
}
if (dbobj != null)
{
RefreshDatasetList();
DatasetList.SelectedValue = dbobj.DatasetName;
RefreshObjectTypeList();
ObjectTypeList.SelectedValue = Jhu.Graywulf.Schema.Constants.SimpleDatabaseObjectTypes[dbobj.ObjectType].ToString();
RefreshObjectList();
ObjectList.SelectedValue = dbobj.UniqueKey;
ShowDetails(dbobjid);
}
else
{
RefreshDatasetList();
RefreshObjectTypeList();
RefreshObjectList();
}
}
}
private void ShowDetails(string dbobjid)
{
HideAllPanels();
DatabaseObject dbobj = null;
try
{
dbobj = SchemaManager.GetDatabaseObjectByKey(dbobjid);
}
catch
{
}
if (dbobj != null)
{
// Display details
DetailsPanel.DatabaseObjectID = dbobjid;
DetailsPanel.Visible = true;
SelectedSchemaObject = dbobjid;
}
}
