public IEnumerable <Category> QueryCategories(TextContent content)
{
List <Category> list = new List <Category>();
MySqlConnection connection;
using (var dataReader = MysqlHelper.ExecuteReader(content.GetRepository(),
dbCommands.QueryCategories(content), out connection))
{
try
{
while (dataReader.Read())
{
Category category = new Category()
{
CategoryFolder = dataReader.GetString(dataReader.GetOrdinal("CategoryFolder")),
CategoryUUID = dataReader.GetString(dataReader.GetOrdinal("CategoryUUID")),
ContentUUID = dataReader.GetString(dataReader.GetOrdinal("UUID")),
};
list.Add(category);
}
}
finally
{
dataReader.Close();
connection.Close();
}
}
return(list);
}
public IEnumerable <IDictionary <string, object> > ExportSchemaData(Schema schema)
{
string sql = string.Format("SELECT * FROM `{0}` ", schema.GetTableName());
List <TextContent> list = new List <TextContent>();
MySqlConnection connection;
using (var reader = MysqlHelper.ExecuteReader(schema.Repository, new MySqlCommand()
{
CommandText = sql
}, out connection))
{
while (reader.Read())
{
list.Add(reader.ToContent <TextContent>(new TextContent()));
}
connection.Close();
}
return(list);
}
public IEnumerable <Category> ExportCategoryData(Repository repository)
{
string sql = string.Format("SELECT UUID,CategoryFolder,CategoryUUID FROM `{0}` ", repository.GetCategoryTableName());
List <Category> list = new List <Category>();
MySqlConnection connection;
using (var reader = MysqlHelper.ExecuteReader(repository, new MySqlCommand()
{
CommandText = sql
}, out connection))
{
while (reader.Read())
{
Category category = new Category();
category.ContentUUID = reader.GetString(0);
category.CategoryFolder = reader.GetString(1);
category.CategoryUUID = reader.GetString(2);
list.Add(category);
}
connection.Close();
}
return(list);
}
