Skip to content
This repository has been archived by the owner on Jan 14, 2021. It is now read-only.

Some models return undefined from findMany({}) after introspection #530

Closed
Jolg42 opened this issue Feb 26, 2020 · 7 comments
Closed

Some models return undefined from findMany({}) after introspection #530

Jolg42 opened this issue Feb 26, 2020 · 7 comments
Assignees
Labels
bug/2-confirmed We have confirmed that this is a bug. kind/bug A reported bug. topic: query-generator
Milestone

Comments

@Jolg42
Copy link
Member

Jolg42 commented Feb 26, 2020

Schemas

  • mariadb/magento
  • mysql_public/magento
  • mysql_public/kanboard
  • postgresql_public/basic-blog
  • prisma1/graphql-prisma-typescript@dev
  • ...
@Jolg42 Jolg42 added bug/2-confirmed We have confirmed that this is a bug. kind/bug A reported bug. labels Feb 26, 2020
@Jolg42 Jolg42 added this to the Preview 23 milestone Feb 26, 2020
@Jolg42 Jolg42 self-assigned this Feb 26, 2020
@Jolg42
Copy link
Member Author

Jolg42 commented Feb 26, 2020

postgresql_public/basic-blog (same for mysql_public/kanboard & prisma1/graphql-prisma-typescript@dev)

Command
env PRISMA_DML_PATH=postgresql_public/basic-blog/schema.prisma ./postgresql_public/basic-blog/runtime/query-engine-darwin

Error from http://localhost:4466/ playground console

{…}
​
locations: Array [ {…} ]
​
message: "Syntax Error GraphQL request (129:1) Expected Name, found }\n\n128: \n129: }\n     ^\n130: \n"
​
nodes: undefined
​
originalError: undefined
​
path: undefined
​
positions: Array [ 2605 ]
​
source: {…}
​​
body: "input postsWhereInput {\n  AND: [postsWhereInput!]\n  OR: [postsWhereInput!]\n  NOT: [postsWhereInput!]\n  id: Int\n  id_not: Int\n  id_in: [Int!]\n  id_not_in: [Int!]\n  id_lt: Int\n  id_lte: Int\n  id_gt: Int\n  id_gte: Int\n  title: String\n  title_not: String\n  title_in: [String!]\n  title_not_in: [String!]\n  title_lt: String\n  title_lte: String\n  title_gt: String\n  title_gte: String\n  title_contains: String\n  title_not_contains: String\n  title_starts_with: String\n  title_not_starts_with: String\n  title_ends_with: String\n  title_not_ends_with: String\n  blog_id: blogsWhereInput\n}\n\ninput blogsWhereInput {\n  AND: [blogsWhereInput!]\n  OR: [blogsWhereInput!]\n  NOT: [blogsWhereInput!]\n  id: Int\n  id_not: Int\n  id_in: [Int!]\n  id_not_in: [Int!]\n  id_lt: Int\n  id_lte: Int\n  id_gt: Int\n  id_gte: Int\n  name: String\n  name_not: String\n  name_in: [String!]\n  name_not_in: [String!]\n  name_lt: String\n  name_lte: String\n  name_gt: String\n  name_gte: String\n  name_contains: String\n  name_not_contains: String\n  …"
​​
locationOffset: Object { line: 1, column: 1 }
​​
name: "GraphQL request"
​​
<prototype>: Object { … }
​
stack: "r@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:382302\nr@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:985803\nee@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:503991\na@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:496395\nq@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:502936\nie@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:504472\nV@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:502780\nN@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:500878\nu@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:496931\ns@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:496533\nr@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:496025\nc@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:699821\nE</n.prototype.componentDidMount@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:1552543\nfr@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:913976\npr@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:910560\nur@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:910017\nsr@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:909843\nir@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:909213\nZn@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:908583\nxr@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:915898\nEr@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:916125\n_r.prototype.render@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:943042\nFr/<@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:917684\nyr@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:915315\nFr@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:917619\nrender@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:943884\ninit/</<@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:2144881\nr@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:2144196\nn/<@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:2143500\na@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:2143266\npromise callback*u@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:2143400\ni/<@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:2143411\ni@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:2143210\ninit@https://cdn.jsdelivr.net/npm/graphql-playground-react@1.7.22-test/build/static/js/middleware.js:1:2144659\n@http://localhost:4466/:57:25\nEventListener.handleEvent*@http://localhost:4466/:56:12\n"
​
<prototype>: Object { stack: "", … }
react-dom.production.min.js:187:139
uncaught exception: Object
Error: {
  "errors": [
    {
      "error": "Unsupported feature: Fragment spread. Fragment 'FullType', at position 13:10.",
      "user_facing_error": {
        "is_panic": false,
        "message": "Unsupported feature: Fragment spread. Fragment 'FullType', at position 13:10.",
        "backtrace": null
      }
    }
  ]
} SchemaFetcher.ts:127:18

@Jolg42
Copy link
Member Author

Jolg42 commented Feb 26, 2020

mysql_public/magento (same for mariadb/magento)
env PRISMA_DML_PATH=mysql_public/magento/schema.prisma ./mysql_public/magento/runtime/query-engine-darwin

Error in stderr after opening http://localhost:4466/ playground console

thread 'tokio-runtime-worker' has overflowed its stack
fatal runtime error: stack overflow
fish: 'env PRISMA_DML_PATH=mysql_publi…' terminated by signal SIGABRT (Abort)

@Jolg42
Copy link
Member Author

Jolg42 commented Feb 26, 2020

They have a common error from TypeScript
Command env DEBUG="*" ts-node query.ts mysql_public/magento

  engine {
  engine   error: TypeError: e.map is not a function
  engine       at /Users/j42/Dev/introspection-engine-output/clients/mysql_public/magento/runtime/index.js:1:16638
  engine       at processTicksAndRejections (internal/process/task_queues.js:94:5)
  engine       at Dataloader.loader (/Users/j42/Dev/introspection-engine-output/clients/mysql_public/magento/index.js:57:23)
  engine } +66ms
  prisma-client TypeError: e.map is not a function
  prisma-client     at /Users/j42/Dev/introspection-engine-output/clients/mysql_public/magento/runtime/index.js:1:16638
  prisma-client     at processTicksAndRejections (internal/process/task_queues.js:94:5)
  prisma-client     at Dataloader.loader (/Users/j42/Dev/introspection-engine-output/clients/mysql_public/magento/index.js:57:23) +67ms

Original code

batch: queries.map(query => ({ query, variables })),

@Jolg42
Copy link
Member Author

Jolg42 commented Feb 26, 2020

@timsuchanek the queries (the "e" in "e.map") look like this for mysql_public/magento

{
  e: [
    'query {\n' +
      '  findManyadminnotification_inbox {\n' +
      '    date_added\n' +
      '    description\n' +
      '    is_read\n' +
      '    is_remove\n' +
      '    notification_id\n' +
      '    severity\n' +
      '    title\n' +
      '    url\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManyadmin_passwords {\n' +
      '    expires\n' +
      '    last_updated\n' +
      '    password_hash\n' +
      '    password_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManyadmin_system_messages {\n' +
      '    created_at\n' +
      '    identity\n' +
      '    severity\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManyadmin_user {\n' +
      '    created\n' +
      '    email\n' +
      '    extra\n' +
      '    failures_num\n' +
      '    firstname\n' +
      '    first_failure\n' +
      '    interface_locale\n' +
      '    is_active\n' +
      '    lastname\n' +
      '    lock_expires\n' +
      '    logdate\n' +
      '    lognum\n' +
      '    modified\n' +
      '    password\n' +
      '    refresh_token\n' +
      '    reload_acl_flag\n' +
      '    rp_token\n' +
      '    rp_token_created_at\n' +
      '    username\n' +
      '    user_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManyadmin_user_session {\n' +
      '    created_at\n' +
      '    id\n' +
      '    ip\n' +
      '    session_id\n' +
      '    status\n' +
      '    updated_at\n' +
      '  }\n' +
      '}',
    'query {\n  findManyamazon_customer {\n    amazon_id\n    entity_id\n  }\n}',
    'query {\n' +
      '  findManyamazon_pending_authorization {\n' +
      '    authorization_id\n' +
      '    capture\n' +
      '    capture_id\n' +
      '    created_at\n' +
      '    entity_id\n' +
      '    order_id\n' +
      '    payment_id\n' +
      '    processed\n' +
      '    updated_at\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManyamazon_pending_capture {\n' +
      '    capture_id\n' +
      '    created_at\n' +
      '    entity_id\n' +
      '    order_id\n' +
      '    payment_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManyamazon_pending_refund {\n' +
      '    created_at\n' +
      '    entity_id\n' +
      '    order_id\n' +
      '    payment_id\n' +
      '    refund_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManyamazon_quote {\n' +
      '    amazon_order_reference_id\n' +
      '    confirmed\n' +
      '    entity_id\n' +
      '    sandbox_simulation_reference\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManyamazon_sales_order {\n' +
      '    amazon_order_reference_id\n' +
      '    entity_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManyauthorization_role {\n' +
      '    parent_id\n' +
      '    role_id\n' +
      '    role_name\n' +
      '    role_type\n' +
      '    sort_order\n' +
      '    tree_level\n' +
      '    user_id\n' +
      '    user_type\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManyauthorization_rule {\n' +
      '    permission\n' +
      '    privileges\n' +
      '    resource_id\n' +
      '    rule_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycache {\n' +
      '    create_time\n' +
      '    data\n' +
      '    expire_time\n' +
      '    id\n' +
      '    update_time\n' +
      '  }\n' +
      '}',
    'query {\n  findManycache_tag {\n    cache_id\n    tag\n  }\n}',
    'query {\n' +
      '  findManycaptcha_log {\n' +
      '    count\n' +
      '    type\n' +
      '    updated_at\n' +
      '    value\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycataloginventory_stock {\n' +
      '    stock_id\n' +
      '    stock_name\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycataloginventory_stock_item {\n' +
      '    backorders\n' +
      '    enable_qty_increments\n' +
      '    is_decimal_divided\n' +
      '    is_in_stock\n' +
      '    is_qty_decimal\n' +
      '    item_id\n' +
      '    low_stock_date\n' +
      '    manage_stock\n' +
      '    max_sale_qty\n' +
      '    min_qty\n' +
      '    min_sale_qty\n' +
      '    notify_stock_qty\n' +
      '    qty\n' +
      '    qty_increments\n' +
      '    stock_status_changed_auto\n' +
      '    use_config_backorders\n' +
      '    use_config_enable_qty_inc\n' +
      '    use_config_manage_stock\n' +
      '    use_config_max_sale_qty\n' +
      '    use_config_min_qty\n' +
      '    use_config_min_sale_qty\n' +
      '    use_config_notify_stock_qty\n' +
      '    use_config_qty_increments\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycataloginventory_stock_status {\n' +
      '    product_id\n' +
      '    qty\n' +
      '    stock_id\n' +
      '    stock_status\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycataloginventory_stock_status_idx {\n' +
      '    product_id\n' +
      '    qty\n' +
      '    stock_id\n' +
      '    stock_status\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycataloginventory_stock_status_replica {\n' +
      '    product_id\n' +
      '    qty\n' +
      '    stock_id\n' +
      '    stock_status\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycataloginventory_stock_status_tmp {\n' +
      '    product_id\n' +
      '    qty\n' +
      '    stock_id\n' +
      '    stock_status\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalogrule {\n' +
      '    actions_serialized\n' +
      '    conditions_serialized\n' +
      '    description\n' +
      '    discount_amount\n' +
      '    from_date\n' +
      '    is_active\n' +
      '    name\n' +
      '    rule_id\n' +
      '    simple_action\n' +
      '    sort_order\n' +
      '    stop_rules_processing\n' +
      '    to_date\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalogrule_customer_group {\n' +
      '    customer_group_id\n' +
      '    rule_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalogrule_group_website {\n' +
      '    customer_group_id\n' +
      '    rule_id\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalogrule_group_website_replica {\n' +
      '    customer_group_id\n' +
      '    rule_id\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalogrule_product {\n' +
      '    action_amount\n' +
      '    action_operator\n' +
      '    action_stop\n' +
      '    customer_group_id\n' +
      '    from_time\n' +
      '    product_id\n' +
      '    rule_id\n' +
      '    rule_product_id\n' +
      '    sort_order\n' +
      '    to_time\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalogrule_product_price {\n' +
      '    customer_group_id\n' +
      '    earliest_end_date\n' +
      '    latest_start_date\n' +
      '    product_id\n' +
      '    rule_date\n' +
      '    rule_price\n' +
      '    rule_product_price_id\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalogrule_product_price_replica {\n' +
      '    customer_group_id\n' +
      '    earliest_end_date\n' +
      '    latest_start_date\n' +
      '    product_id\n' +
      '    rule_date\n' +
      '    rule_price\n' +
      '    rule_product_price_id\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalogrule_product_replica {\n' +
      '    action_amount\n' +
      '    action_operator\n' +
      '    action_stop\n' +
      '    customer_group_id\n' +
      '    from_time\n' +
      '    product_id\n' +
      '    rule_id\n' +
      '    rule_product_id\n' +
      '    sort_order\n' +
      '    to_time\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n  findManycatalogrule_website {\n    rule_id\n    website_id\n  }\n}',
    'query {\n' +
      '  findManycatalogsearch_fulltext_scope1 {\n' +
      '    attribute_id\n' +
      '    data_index\n' +
      '    entity_id\n' +
      '  }\n' +
      '}',
    'query {\n  findManycatalogsearch_recommendations {\n    id\n  }\n}',
    'query {\n' +
      '  findManycatalog_category_entity {\n' +
      '    attribute_set_id\n' +
      '    children_count\n' +
      '    created_at\n' +
      '    entity_id\n' +
      '    level\n' +
      '    parent_id\n' +
      '    path\n' +
      '    position\n' +
      '    updated_at\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_category_entity_datetime {\n' +
      '    value\n' +
      '    value_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_category_entity_decimal {\n' +
      '    value\n' +
      '    value_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_category_entity_int {\n' +
      '    value\n' +
      '    value_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_category_entity_text {\n' +
      '    value\n' +
      '    value_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_category_entity_varchar {\n' +
      '    value\n' +
      '    value_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_category_product {\n' +
      '    entity_id\n' +
      '    position\n' +
      '    category_id\n' +
      '    product_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_category_product_index {\n' +
      '    category_id\n' +
      '    is_parent\n' +
      '    position\n' +
      '    product_id\n' +
      '    store_id\n' +
      '    visibility\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_category_product_index_replica {\n' +
      '    category_id\n' +
      '    is_parent\n' +
      '    position\n' +
      '    product_id\n' +
      '    store_id\n' +
      '    visibility\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_category_product_index_store1 {\n' +
      '    category_id\n' +
      '    is_parent\n' +
      '    position\n' +
      '    product_id\n' +
      '    store_id\n' +
      '    visibility\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_category_product_index_store1_replica {\n' +
      '    category_id\n' +
      '    is_parent\n' +
      '    position\n' +
      '    product_id\n' +
      '    store_id\n' +
      '    visibility\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_category_product_index_tmp {\n' +
      '    category_id\n' +
      '    is_parent\n' +
      '    position\n' +
      '    product_id\n' +
      '    store_id\n' +
      '    visibility\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_compare_item {\n' +
      '    catalog_compare_item_id\n' +
      '    visitor_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_eav_attribute {\n' +
      '    additional_data\n' +
      '    apply_to\n' +
      '    frontend_input_renderer\n' +
      '    is_comparable\n' +
      '    is_filterable\n' +
      '    is_filterable_in_grid\n' +
      '    is_filterable_in_search\n' +
      '    is_global\n' +
      '    is_html_allowed_on_front\n' +
      '    is_required_in_admin_store\n' +
      '    is_searchable\n' +
      '    is_used_for_price_rules\n' +
      '    is_used_for_promo_rules\n' +
      '    is_used_in_grid\n' +
      '    is_visible\n' +
      '    is_visible_in_advanced_search\n' +
      '    is_visible_in_grid\n' +
      '    is_visible_on_front\n' +
      '    is_wysiwyg_enabled\n' +
      '    position\n' +
      '    search_weight\n' +
      '    used_for_sort_by\n' +
      '    used_in_product_listing\n' +
      '    attribute_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_bundle_option {\n' +
      '    option_id\n' +
      '    position\n' +
      '    required\n' +
      '    type\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_bundle_option_value {\n' +
      '    parent_product_id\n' +
      '    store_id\n' +
      '    title\n' +
      '    value_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_bundle_price_index {\n' +
      '    max_price\n' +
      '    min_price\n' +
      '    customer_group_id\n' +
      '    entity_id\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_bundle_selection {\n' +
      '    is_default\n' +
      '    parent_product_id\n' +
      '    position\n' +
      '    selection_can_change_qty\n' +
      '    selection_id\n' +
      '    selection_price_type\n' +
      '    selection_price_value\n' +
      '    selection_qty\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_bundle_selection_price {\n' +
      '    parent_product_id\n' +
      '    selection_price_type\n' +
      '    selection_price_value\n' +
      '    selection_id\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_bundle_stock_index {\n' +
      '    entity_id\n' +
      '    option_id\n' +
      '    stock_id\n' +
      '    stock_status\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_entity {\n' +
      '    attribute_set_id\n' +
      '    created_at\n' +
      '    entity_id\n' +
      '    has_options\n' +
      '    required_options\n' +
      '    sku\n' +
      '    type_id\n' +
      '    updated_at\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_entity_datetime {\n' +
      '    value\n' +
      '    value_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_entity_decimal {\n' +
      '    value\n' +
      '    value_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_entity_gallery {\n' +
      '    position\n' +
      '    value\n' +
      '    value_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_entity_int {\n' +
      '    value\n' +
      '    value_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_entity_media_gallery {\n' +
      '    disabled\n' +
      '    media_type\n' +
      '    value\n' +
      '    value_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_entity_media_gallery_value {\n' +
      '    disabled\n' +
      '    label\n' +
      '    position\n' +
      '    record_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_entity_media_gallery_value_to_entity {\n' +
      '\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_entity_media_gallery_value_video {\n' +
      '    description\n' +
      '    metadata\n' +
      '    provider\n' +
      '    title\n' +
      '    url\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_entity_text {\n' +
      '    value\n' +
      '    value_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_entity_tier_price {\n' +
      '    all_groups\n' +
      '    percentage_value\n' +
      '    qty\n' +
      '    value\n' +
      '    value_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_entity_varchar {\n' +
      '    value\n' +
      '    value_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_frontend_action {\n' +
      '    action_id\n' +
      '    added_at\n' +
      '    type_id\n' +
      '    visitor_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_eav {\n' +
      '    attribute_id\n' +
      '    entity_id\n' +
      '    source_id\n' +
      '    store_id\n' +
      '    value\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_eav_decimal {\n' +
      '    attribute_id\n' +
      '    entity_id\n' +
      '    source_id\n' +
      '    store_id\n' +
      '    value\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_eav_decimal_idx {\n' +
      '    attribute_id\n' +
      '    entity_id\n' +
      '    source_id\n' +
      '    store_id\n' +
      '    value\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_eav_decimal_replica {\n' +
      '    attribute_id\n' +
      '    entity_id\n' +
      '    source_id\n' +
      '    store_id\n' +
      '    value\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_eav_decimal_tmp {\n' +
      '    attribute_id\n' +
      '    entity_id\n' +
      '    source_id\n' +
      '    store_id\n' +
      '    value\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_eav_idx {\n' +
      '    attribute_id\n' +
      '    entity_id\n' +
      '    source_id\n' +
      '    store_id\n' +
      '    value\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_eav_replica {\n' +
      '    attribute_id\n' +
      '    entity_id\n' +
      '    source_id\n' +
      '    store_id\n' +
      '    value\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_eav_tmp {\n' +
      '    attribute_id\n' +
      '    entity_id\n' +
      '    source_id\n' +
      '    store_id\n' +
      '    value\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_price {\n' +
      '    customer_group_id\n' +
      '    entity_id\n' +
      '    final_price\n' +
      '    max_price\n' +
      '    min_price\n' +
      '    price\n' +
      '    tax_class_id\n' +
      '    tier_price\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_price_bundle_idx {\n' +
      '    base_tier\n' +
      '    customer_group_id\n' +
      '    entity_id\n' +
      '    max_price\n' +
      '    min_price\n' +
      '    orig_price\n' +
      '    price\n' +
      '    price_type\n' +
      '    special_price\n' +
      '    tax_class_id\n' +
      '    tier_percent\n' +
      '    tier_price\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_price_bundle_opt_idx {\n' +
      '    alt_price\n' +
      '    alt_tier_price\n' +
      '    customer_group_id\n' +
      '    entity_id\n' +
      '    max_price\n' +
      '    min_price\n' +
      '    option_id\n' +
      '    tier_price\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_price_bundle_opt_tmp {\n' +
      '    alt_price\n' +
      '    alt_tier_price\n' +
      '    customer_group_id\n' +
      '    entity_id\n' +
      '    max_price\n' +
      '    min_price\n' +
      '    option_id\n' +
      '    tier_price\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_price_bundle_sel_idx {\n' +
      '    customer_group_id\n' +
      '    entity_id\n' +
      '    group_type\n' +
      '    is_required\n' +
      '    option_id\n' +
      '    price\n' +
      '    selection_id\n' +
      '    tier_price\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_price_bundle_sel_tmp {\n' +
      '    customer_group_id\n' +
      '    entity_id\n' +
      '    group_type\n' +
      '    is_required\n' +
      '    option_id\n' +
      '    price\n' +
      '    selection_id\n' +
      '    tier_price\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_price_bundle_tmp {\n' +
      '    base_tier\n' +
      '    customer_group_id\n' +
      '    entity_id\n' +
      '    max_price\n' +
      '    min_price\n' +
      '    orig_price\n' +
      '    price\n' +
      '    price_type\n' +
      '    special_price\n' +
      '    tax_class_id\n' +
      '    tier_percent\n' +
      '    tier_price\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_price_cfg_opt_agr_idx {\n' +
      '    child_id\n' +
      '    customer_group_id\n' +
      '    parent_id\n' +
      '    price\n' +
      '    tier_price\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_price_cfg_opt_agr_tmp {\n' +
      '    child_id\n' +
      '    customer_group_id\n' +
      '    parent_id\n' +
      '    price\n' +
      '    tier_price\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_price_cfg_opt_idx {\n' +
      '    customer_group_id\n' +
      '    entity_id\n' +
      '    max_price\n' +
      '    min_price\n' +
      '    tier_price\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_price_cfg_opt_tmp {\n' +
      '    customer_group_id\n' +
      '    entity_id\n' +
      '    max_price\n' +
      '    min_price\n' +
      '    tier_price\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_price_downlod_idx {\n' +
      '    customer_group_id\n' +
      '    entity_id\n' +
      '    max_price\n' +
      '    min_price\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_price_downlod_tmp {\n' +
      '    customer_group_id\n' +
      '    entity_id\n' +
      '    max_price\n' +
      '    min_price\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_price_final_idx {\n' +
      '    base_tier\n' +
      '    customer_group_id\n' +
      '    entity_id\n' +
      '    max_price\n' +
      '    min_price\n' +
      '    orig_price\n' +
      '    price\n' +
      '    tax_class_id\n' +
      '    tier_price\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_price_final_tmp {\n' +
      '    base_tier\n' +
      '    customer_group_id\n' +
      '    entity_id\n' +
      '    max_price\n' +
      '    min_price\n' +
      '    orig_price\n' +
      '    price\n' +
      '    tax_class_id\n' +
      '    tier_price\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_price_idx {\n' +
      '    customer_group_id\n' +
      '    entity_id\n' +
      '    final_price\n' +
      '    max_price\n' +
      '    min_price\n' +
      '    price\n' +
      '    tax_class_id\n' +
      '    tier_price\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_price_opt_agr_idx {\n' +
      '    customer_group_id\n' +
      '    entity_id\n' +
      '    max_price\n' +
      '    min_price\n' +
      '    option_id\n' +
      '    tier_price\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_price_opt_agr_tmp {\n' +
      '    customer_group_id\n' +
      '    entity_id\n' +
      '    max_price\n' +
      '    min_price\n' +
      '    option_id\n' +
      '    tier_price\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_price_opt_idx {\n' +
      '    customer_group_id\n' +
      '    entity_id\n' +
      '    max_price\n' +
      '    min_price\n' +
      '    tier_price\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_price_opt_tmp {\n' +
      '    customer_group_id\n' +
      '    entity_id\n' +
      '    max_price\n' +
      '    min_price\n' +
      '    tier_price\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_price_replica {\n' +
      '    customer_group_id\n' +
      '    entity_id\n' +
      '    final_price\n' +
      '    max_price\n' +
      '    min_price\n' +
      '    price\n' +
      '    tax_class_id\n' +
      '    tier_price\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_price_tmp {\n' +
      '    customer_group_id\n' +
      '    entity_id\n' +
      '    final_price\n' +
      '    max_price\n' +
      '    min_price\n' +
      '    price\n' +
      '    tax_class_id\n' +
      '    tier_price\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_tier_price {\n' +
      '    min_price\n' +
      '    customer_group_id\n' +
      '    entity_id\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n' +
      '  findManycatalog_product_index_website {\n' +
      '    default_store_id\n' +
      '    rate\n' +
      '    website_date\n' +
      '    website_id\n' +
      '  }\n' +
      '}',
    'query {\n  findManycatalog_product_link {\n    link_id\n  }\n}',
    'query {\n' +
      '  findManycatalog_product_link_attribute {\n' +
      '    data_type\n' +
      '    product_link_attribute_code\n' +
      '    product_link_attribute_id\n' +
      '  }\n' +
      '}',
    ... 287 more items
  ]
}

@Jolg42
Copy link
Member Author

Jolg42 commented Feb 26, 2020

And like this for postgresql_public/basic-blog

{
  e: [
    'query {\n  findManyauthors {\n    id\n    name\n  }\n}',
    'query {\n  findManyauthors_blogs {\n\n  }\n}',
    'query {\n  findManyblogs {\n    id\n    name\n    viewcount\n  }\n}',
    'query {\n  findManyposts {\n    id\n    tags\n    title\n  }\n}'
  ]
}

@janpio
Copy link
Member

janpio commented Mar 12, 2020

Does this affect all queries for these databases or only some specific models @Jolg42?

@timsuchanek
Copy link
Contributor

@janpio I tried it out with magento, only a few models are affected by that.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug/2-confirmed We have confirmed that this is a bug. kind/bug A reported bug. topic: query-generator
Projects
None yet
Development

No branches or pull requests

4 participants