Bootstrap
登录 注册

GraphQl Count聚合条目

angularsqlitegraphqlapollo
发布时间：2020-07-07 17:39

我正在尝试使用GraphQl对表中的条目数进行计数，我的解析器有问题，我很茫然。当我记录rows [0]时，该计数有效，但使用graphiql时无法访问它，条目为空。 enter image description here

我的类型：

const TableCount = new graphql.GraphQLObjectType({
    name: "Count",
    fields: {
        entries: { type: graphql.GraphQLInt }
       
    }
});

我的查询：

var queryType = new graphql.GraphQLObjectType({
    name: 'Query',
    fields: {
        tableCount:{
            type: TableCount,
            resolve: (source, args)=>{
                return new Promise((resolve, reject)=>{
                    database.all("Select COUNT(*) from projects", function(err, rows){
                        if(err){
                            reject(err)
                        }resolve(rows[0])
                        console.log(rows[0])
                        
                    })
                })
            }
        },
回答1

好吧，对于在同一教程中可能犯同样错误的人，我意识到了我的错误。
Resolove需要这样

let
    Source = Web.BrowserContents("https://www.reclameaqui.com.br/empresa/nestle/lista-reclamacoes/"),
    #"Split Text" = Text.Split(Source, "#(lf)"),
    #"Converted to Table" = Table.FromList(#"Split Text", Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Filtered Rows" = Table.SelectRows(#"Converted to Table", each Text.Contains([Column1], "hourAgo")),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Filtered Rows", "Column1", Splitter.SplitTextByDelimiter("</span>", QuoteStyle.Csv), {"Column1.1", "Column1.2", "Column1.3", "Column1.4", "Column1.5", "Column1.6", "Column1.7", "Column1.8", "Column1.9", "Column1.10", "Column1.11"}),
    #"Removed Other Columns" = Table.SelectColumns(#"Split Column by Delimiter",{"Column1.4", "Column1.7"}),
    #"Extracted Text After Delimiter" = Table.TransformColumns(#"Removed Other Columns", {{"Column1.4", each Text.BetweenDelimiters(_, "title=", ">"), type text}, {"Column1.7", each Text.Trim(Text.AfterDelimiter(_, ">")), type text}})
in
    #"Extracted Text After Delimiter"
angular 相关推荐
sqlite 相关推荐
graphql 相关推荐
apollo 相关推荐