public void GetFieldTypes()
{
var ana = new SqlAnalyzer(Config.TestDBConnectionString);
var fields = ana.GetFieldTypes("Person");
Assert.AreEqual("([Age,int NULL],[FirstName,nvarchar(50) NULL],[LastName,nvarchar(50) NULL],[PersonId,int NOT NULL])",
fields.Print());
}
public void GetFieldTypesFromView()
{
var ana = new SqlAnalyzer(connStr);
var fields = ana.GetFieldTypes("ID_NUMView");
Assert.AreEqual("([Age,int NULL],[FirstName,nvarchar(50) NULL],[ID_NUM,int NOT NULL],[LastName,nvarchar(50) NULL],[PersonId,int NOT NULL])",
fields.Print());
}
public static ModifiableSqlDB ModifiableSql2005(string connString, ITypedDBAnalyzer taxonomy = null)
{
var analyzer = new SqlAnalyzer(connString);
var modifier = new SqlModifier(connString, analyzer, taxonomy);
var db = new SqlDB(connString, analyzer, false);
return new ModifiableSqlDB(db, modifier);
}
public AbstractSqlReadWrite(string connectionString, SqlAnalyzer analyzer, bool strictTables = true)
{
SqlAnalyzer = analyzer;
ConnectionString = connectionString;
StrictTables = strictTables;
}
public MySqlModifier(string connectionString, SqlAnalyzer analyzer, ITypedDBAnalyzer taxonomy = null)
: base(connectionString, analyzer, taxonomy)
{
}
public MySqlDB(string connectionString, SqlAnalyzer analyzer, bool strictTables = true)
: base(connectionString, analyzer, strictTables)
{ }
public void TableExistsFindsViews()
{
var ana = new SqlAnalyzer(connStr);
Assert.True(ana.TableExists("ID_NUMView"));
}
public void TableExists()
{
var ana = new SqlAnalyzer(connStr);
Assert.True(ana.TableExists("Person"));
}
public void GetFieldsFromView()
{
var ana = new SqlAnalyzer(connStr);
var fields = ana.GetFields("ID_NUMView");
Assert.AreEqual("(ID_NUM,PersonId,FirstName,LastName,Age)", fields.Print());
}
public void GetFields()
{
var ana = new SqlAnalyzer(connStr);
var fields = ana.GetFields("Person");
Assert.AreEqual("(PersonId,FirstName,LastName,Age)", fields.Print());
}
public SqlModifier(string connectionString, SqlAnalyzer analyzer, ITypedDBAnalyzer taxonomy = null)
{
SqlAnalyzer = analyzer;
_connectionString = connectionString;
Taxonomy = taxonomy;
}
public void TableExistsFindsViews()
{
var ana = new SqlAnalyzer(Config.TestDBConnectionString);
Assert.True(ana.TableExists("ID_NUMView"));
}
public bool TableExists(string table)
{
var ana = new SqlAnalyzer(Config.TestDBConnectionString);
return ana.TableExists(table);
}
public string GetPrimaryKeys(string table)
{
var ana = new SqlAnalyzer(Config.TestDBConnectionString);
return ana.GetPrimaryKeys(table).Print();
}
public string GetFields(string table)
{
var ana = new SqlAnalyzer(Config.TestDBConnectionString);
var fields = ana.GetFields(table);
return fields.Print();
}
public string GetAutoNumberKey(string table)
{
var ana = new SqlAnalyzer(Config.TestDBConnectionString);
return ana.GetAutoNumberKey(table);
}