Tag: postgresql
-
Error in .net core with postgreSQL and graphQL to get json column for all records
0 I am using .NET Core 7.0 with PostgreSQL and graphQL. I am getting an error when I try to get all records from the database using the below code. When I try to get a single record then it is working fine. Error: The source ‘IQueryable’ doesn’t implement ‘IAsyncEnumerable<Vcp.Doctors.Gql.Models.ProviderInformation>’. Only sources that implement ‘IAsyncEnumerable’…
-
Postgraphile cannot query SQL function
0 I have a SQL function that I am unable to query with Postgraphile. I am getting Cannot query field "get_eligible_shifts" on type "Query"." I noticed that in the PostGraphiQL the function does not appear. Why would I not be able to query on my SQL function? Postgraphile query { get_eligible_shifts( args: {workerId: 1} )…
-
Is GraphQL API suitable for supermarket POS(Point-Of-Sales) application?
0 I am developing a smart POS application that serves as an integrated software solution that facilitates efficient and modern point-of-sale operations for supermarkets. This system has the following functionalities. Sales processing and transaction management Inventory management Employee management Report and Analytics E-commerce integration Multi-Store support Customer management I chose ReactJS for the front-end, Springboot…
-
Golang,gorm, postgress: invalid input is inserted
0 when i perform request using https://localhost:8080/graphql end point I cant create user using mutation **the whole code:** package main import ( "fmt" "log" "net/http" "time" "github.com/graphql-go/graphql" "github.com/graphql-go/handler" "github.com/kaleabbyh/foodrecipie/config" _ "github.com/lib/pq" ) ** Note: the table users is succesfullly migrated using separate migration code having ‘User’ attributes** type User struct { ID int `gorm:"type:int;primary_key;identity(100,1)"` Name…
-
How to map to timestamp when return data from database using nestjs and graphql
0 I use nestjs and graphql save data into postgres. When i save data it save success on my database. Here dto input @InputType() export class CreateShop { //some field @Field(() => String, { name: ‘opening_time’ }) openingTime?: Timestamp; @Field(() => String, { name: ‘closing_time’ }) closingTime?: Timestamp; } My data save success on database…
-
TypeORM Entity Association Returns Null for Related Fields in GraphQL Nexus Schema
0 I’m currently building a GraphQL API using TypeORM and Nexus Schema. I’ve defined several entities with associations between them, such as Product, Brand, and User. The problem I’m facing is that when I query the Product entity using GraphQL, the related fields like category_id and brand_id are returning null values even though there is…
