I collect device ON/OFF events in a timeseries table. Following is a sample data. time_stamp state 2023-10-04 10:05:53 0 2023-10-04 10:15:58 1 2023-10-04 10:30:59 0 2023-10-04 10:40:00 1 2023-10-04 10:55:01 0 2023-10-04 11:05:03 1 2023-10-04 11:35:36 0 2023-10-04 11:40:39 1…
I can restore a whole db using shell commands like sudo -u postgres psql -c "DROP DATABASE mynewdbname with (FORCE);" sudo -u postgres psql -c "CREATE DATABASE mynewdbname;" sudo -u postgres pg_restore -d mynewdbname /home/user/restore_20230824.sql -v Than I need to…
I am having issue with ALIAS variable "distance" in my PSQL query. (*please ignore that I am using voutecount as distance) SELECT rentalid, createdDate, votecount AS distance FROM rental WHERE longitude=? AND latitude=? HAVING distance < 25 ORDER BY distance…
I have this table CREATE TABLE IF NOT EXISTS public.campaign_result ( id integer NOT NULL DEFAULT nextval('campaign_result_id_seq'::regclass), state result_state NOT NULL DEFAULT 'processing'::result_state, data json NOT NULL, response json, act result_action NOT NULL DEFAULT 'none'::result_action, message character varying COLLATE pg_catalog."default",…
I am trying to construct a SQL query that returns all the rows (id's) that have tag: 3 AND tag: 4 - in this case it is the single row for 564800, however I can't seem to figure out how…
I'm trying to group the rows of a table based on the time difference between them. If the records differ by less than 30 days (time interval), they must be grouped together; otherwise, they are considered separate events. The start…
I need to import the schema into the db in the container and, I already had this whole thing going, imported the db schema, made sure the app is up and running and made a commit and had started working…
I'm trying to "copy/paste" rows of a table with bigserial id column, without listing all columns names in the query. There is a related post https://stackoverflow.com/a/15344327, which does not work with psql. The isses is that psql does not trigger…
/home/aam/exp/server/node_modules/sequelize/lib/instance-validator.js:50 throw new sequelizeError.ValidationError(null, this.errors); ^ ValidationError [SequelizeValidationError]: notNull Violation: brand.name cannot be null at InstanceValidator._validate (/home/aam/exp/server/node_modules/sequelize/lib/instance-validator.js:50:13) at async InstanceValidator._validateAndRunHooks (/home/aam/exp/server/node_modules/sequelize/lib/instance-validator.js:60:7) at async InstanceValidator.validate (/home/aam/exp/server/node_modules/sequelize/lib/instance-validator.js:54:12) at async model.save (/home/aam/exp/server/node_modules/sequelize/lib/model.js:2426:7) at async brand.create (/home/aam/exp/server/node_modules/sequelize/lib/model.js:1362:12) at async create (/home/aam/exp/server/controllers/brandController.js:7:21) { errors: […
I have a query: SELECT … FROM … WHERE project = 123 AND ( file = file1 and fieldidx = idx1 OR file = file2 and fieldidx = idx2 OR …) … I want to create the where clause in…