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;
}));
}
