public Sql8rServer GetServer()
{
var s = new Sql8rServer(_settings);
string dbConn = ConnectionString;
setServerInfo(ref s, dbConn);
OdbcConnection cn = new OdbcConnection(dbConn);
cn.Open();
// DataTable schema = cn.GetSchema(); // collectionName, nbrOfRestriction, nbrOfIden
// foreach (DataRow row in schema.Rows)
// {
// string collection = row["CollectionName"].ToString();
// "MetaDataCollections" "DataSourceInformation"
// "DataTypes" "Restrictions" "ReservedWords"
// "Columns" "Indexes" "Procedures" "ProcedureColumns"
// "ProcedureParameters" "Tables"
// }
Sql8rDatabase db = new Sql8rDatabase("main", 0);
s.Databases.Add(db);
DataTable dtColumns = cn.GetSchema("Columns");
DataTable dtTables = cn.GetSchema("Tables"); // collectionName, nbrOfRestriction, nbrOfIden
foreach (DataRow row in dtTables.Rows)
{
string tCategory = row["TABLE_CAT"].ToString();
string tSchema = row["TABLE_SCHEM"].ToString();
string tName = row["TABLE_NAME"].ToString();
bool tIsSystem = row["TABLE_TYPE"].ToString().ToString().Equals("SYSTEM TABLE", StringComparison.InvariantCultureIgnoreCase) ? true : false;
string tRemarks = row["REMARKS"].ToString();
Sql8rTable t = new Sql8rTable(tName, tSchema, tIsSystem, 0);
int id = 0;
foreach (DataRow column in dtColumns.Select(string.Format("TABLE_NAME = '{0}'", t.Name)))
{
string taSchema = column["TABLE_SCHEM"].ToString();
string taName = column["TABLE_NAME"].ToString();
string cName = column["COLUMN_NAME"].ToString();
string cDataType = column["DATA_TYPE"].ToString();
string cTypeName = column["TYPE_NAME"].ToString();
int cSize = int.Parse(column["COLUMN_SIZE"].ToString());
Sql8rColumn c = new Sql8rColumn(cName, false, cTypeName, cSize, id++);
t.Columns.Add(c.ObjectId, c);
}
db.Tables.Add(t);
}
return(s);
}
public Query GetAlterColumnQuery(Sql8rServer server, Sql8rDatabase database, Sql8rTable table, Sql8rColumn column)
{
throw new System.NotImplementedException();
}
public Query GetAddIndexQuery(Sql8rServer server, Sql8rDatabase database, Sql8rTable table)
{
throw new System.NotImplementedException();
}
public Query GetExecuteFunctionQuery(Sql8rServer server, Sql8rDatabase database, Sql8rFunction function)
{
throw new NotImplementedException();
}
public Query GetExecuteProcedureQuery(Sql8rServer server, Sql8rDatabase database, Sql8rProcedure procedure)
{
throw new NotImplementedException();
}
public Query GetTableQuery(Sql8rServer server, Sql8rDatabase database, Sql8rTable table)
{
throw new NotImplementedException();
}
public Query GetViewQuery(Sql8rServer server, Sql8rDatabase database, Sql8rView view)
{
throw new NotImplementedException();
}
public Query GetTableQuery(Sql8rServer server, Sql8rDatabase database, Sql8rTable table)
{
var smo = new SmoDatabaseHandler(_settings);
return(smo.GetTableQuery(server, database, table));
}
public IList <SearchHit> SearchAllViews(Sql8rServer s, Sql8rDatabase db, string criteria, bool exactMatch, bool caseSensitive, bool includeSystemObjects)
{
return(GetViewSearchResults(s, db, criteria, exactMatch, caseSensitive, includeSystemObjects));
}
public Query GetReorganizeIndexQuery(Sql8rServer server, Sql8rDatabase database, Sql8rTable table, Sql8rIndex index)
{
throw new NotImplementedException();
}
