/// <summary>
/// Dumps data schema to specified writer
/// </summary>
/// <param name="connection"></param>
/// <param name="writer"></param>
public static void DumpDataSchema(DbConnection connection, StreamWriter writer)
{
string key = "debug_key";
if (writer != null)
{
Debug.Listeners.Add(new TextWriterTraceListener(writer.BaseStream, key));
}
DbUtilities.DumpDataSchema(connection);
if (writer != null)
{
Debug.Listeners.Remove(key);
}
}
/// <summary>
/// Tests connection to the selected database
/// </summary>
public static bool TestConnection(string dbName, bool silentMode)
{
IDataProvider provider = DbUtilities.GetDataProvider(dbName);
if (provider == null)
{
return(false);
}
bool result = false;
DbConnection conn = provider.CreateConnection(dbName);
try
{
conn.Open();
Application.DoEvents();
if (conn.State == ConnectionState.Open)
{
if (!silentMode)
{
MessageBox.Show("Connection is successful.", "MapWinGIS",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
result = true;
}
else
{
if (!silentMode)
{
MessageBox.Show("Connection failed.", "MapWinGIS",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
finally
{
conn.Close();
}
return(result);
}
/// <summary>
/// Creates a table based upon fileds of specified shapefile
/// </summary>
public bool CreateTable(MapWinGIS.Shapefile sf, string tableName)
{
this.CheckConnection();
DbCommand command = m_connection.CreateCommand();
string sql = " ([Geometry] " + m_provider.GetBinaryTypeName() + ", ";
int count = sf.NumFields;
for (int i = 0; i < count; i++)
{
MapWinGIS.Field field = sf.get_Field(i);
string s = "[" + field.Name + "] ";
switch (field.Type)
{
case MapWinGIS.FieldType.DOUBLE_FIELD:
s += m_provider.GetDoubleTypeName();
break;
case MapWinGIS.FieldType.INTEGER_FIELD:
s += m_provider.GetIntergerTypeName();
break;
case MapWinGIS.FieldType.STRING_FIELD:
bool fixedLength = true;
string name = m_provider.GetStringTypeName(out fixedLength);
s += fixedLength ? name + "(" + field.Width.ToString() + ")" : name;
break;
default:
continue;
}
sql += s;
sql += i < count - 1 ? ", " : ")";
}
command.CommandText = "CREATE TABLE [" + tableName + "]" + sql;
command.ExecuteNonQuery();
return(DbUtilities.TableExists(m_connection, tableName));
}
/// <summary>
/// Refresh tables list in the selected database
/// </summary>
private void RefreshTables()
{
this.listView1.Items.Clear();
IDataProvider provider = DbUtilities.GetDataProvider(this.txtFilename.Text);
if (provider != null)
{
DbConnection connection = provider.CreateConnection(this.txtFilename.Text);
connection.Open();
try
{
List <TableInfo> list = DbUtilities.GetTableList(connection);
foreach (TableInfo tbl in list)
{
this.listView1.Items.Add(tbl.Name);
}
}
finally
{
connection.Close();
}
}
}
/// <summary>
/// Tests database connection
/// </summary>
private void btnTest_Click(object sender, EventArgs e)
{
DbUtilities.TestConnection(this.txtFilename.Text, false);
}
/// <summary>
/// Returns the list of tables which hold geometry
/// </summary>
/// <returns>List of table names</returns>
public List <string> GetSpatialTables()
{
this.CheckConnection();
return(DbUtilities.GetTablesByField(m_connection, "Geometry", "blob"));
}