/// <summary> /// Helper function for testing the shapefile importer /// </summary> /// <param name="filename"></param> /// <param name="tableName"></param> /// <returns></returns> public static bool OpenShapefile(string filename, string tableName) { string databaseFileName = Path.Combine(Path.GetDirectoryName(filename), "shape.dat"); var client = new SqliteDataClient(databaseFileName); using (DbConnection conn = client.GetConnection()) { return(ShapefileHelper.ImportShapefile(conn, client, filename, tableName, -1)); } }
/// <summary> /// Helper function for checking structure of existing Db /// </summary> /// <param name="client"></param> /// <returns></returns> public static DataTable GetSchema(SqliteDataClient client) { if (client == null) { return(null); } using (DbConnection conn = client.GetConnection()) { //var dt = conn.GetSchema(); return(conn.GetSchema("Tables")); } }
public void TestSqliteGeneration() { var columns = new List <FixedWidthField>(new FixedWidthField[] { new FixedWidthField("FILEID", "File Identification", 6, 1), new FixedWidthField("WideText", "State Postal Abbreviation", 200, 7), new FixedWidthField("Numeric", "State Postal Abbreviation", 200, 7, FixedWidthTypes.INT), }); string sql = SqliteDataClient.GenerateTableSQLFromFields("test", columns); string expectedSql = "CREATE TABLE \"test\" ( ixid INTEGER NOT NULL PRIMARY KEY, FILEID TEXT(6), WideText TEXT(200), Numeric INTEGER(200) ); "; _log.Debug("Test generated " + sql); Assert.AreEqual(expectedSql, sql); }
/// <summary> /// Helper function for testing the shapefile importer /// </summary> /// <param name="filename"></param> /// <param name="tableName"></param> /// <returns></returns> public static bool OpenShapefile(string filename, string tableName) { string databaseFileName = Path.Combine(Path.GetDirectoryName(filename), "shape.dat"); var client = new SqliteDataClient(databaseFileName); using (DbConnection conn = client.GetConnection()) { return ShapefileHelper.ImportShapefile(conn, client, filename, tableName, -1); } }
/// <summary> /// Helper function for checking structure of existing Db /// </summary> /// <param name="client"></param> /// <returns></returns> public static DataTable GetSchema(SqliteDataClient client) { if (client == null) return null; using (DbConnection conn = client.GetConnection()) { //var dt = conn.GetSchema(); return conn.GetSchema("Tables"); } }