public TableList GetTables(ConnectionInfo connection, string database) { var request = new GetTablesRequest { Connection = connection, Database = database }; var response = _databaseRepository.GetTableList(request); return(response); }
public void TestGetTables() { var localName = "TablesGet.docx"; var remoteName = "TestGetTables.docx"; var fullName = Path.Combine(this.dataFolder, remoteName); this.StorageApi.PutCreate(fullName, null, null, File.ReadAllBytes(BaseTestContext.GetDataDir(this.tableFolder) + localName)); var request = new GetTablesRequest(remoteName, this.dataFolder); var actual = this.WordsApi.GetTables(request); Assert.AreEqual(200, actual.Code); }
public void TestGetTablesWithoutNodePath() { string remoteFileName = "TestGetTablesWithoutNodePath.docx"; this.UploadFileToStorage( remoteDataFolder + "/" + remoteFileName, null, null, File.ReadAllBytes(LocalTestDataFolder + localFile) ); var request = new GetTablesRequest( name: remoteFileName, folder: remoteDataFolder ); var actual = this.WordsApi.GetTables(request); Assert.NotNull(actual.Tables); Assert.NotNull(actual.Tables.TableLinkList); Assert.AreEqual(5, actual.Tables.TableLinkList.Count); Assert.AreEqual("0.0.1", actual.Tables.TableLinkList[0].NodeId); }
public TableList GetTableList(GetTablesRequest request) { const string query = "SELECT table_name from INFORMATION_SCHEMA.tables;"; request.Connection.Database = request.Database; var dbRequest = new CommonDbRequest { Connection = ResolveConnectionWithCache(request.Connection), CommandText = query }; return(SqlHelper.DoQueryOperation <CommonDbRequest, TableList>(dbRequest, (req, response, reader) => { var tableList = new List <string>(); while (reader.Read()) { var name = reader.GetValue(0).ToString(); tableList.Add(name); } response.Tables = tableList; })); }