How can I access the data of a property that's in another table? (postgres, express)

See also questions close to this topic

• Sum Time columns in SQL

  I'm writing a query to calculate when the students check-in and check-out and how much time they spend at the GYM. I have a Checking Field that contains the check-in time and a check-out field that contains the check-out, and a Duration.

  Check In        Check Out      Duration
  ----------------------------------------
  12:30:00        1:30:00         1:00:00
  

  How can I calculate check-in and check-out to obtain a duration like in the example?

  
• postgresql put sum of values in each row as a new column

  I am trying to write a query that will select all matching id's from table A and Table B and if they match, add up "number of sold", then put this total sum of number of sold in a new column

  Table A
  id   Title   Subject
  ...  ...     ...
  
  Table B 
  id   TableA_ID   NumberSold
  ...  ...         ...
  

  what I have so far is

  SELECT m.id, m.title from A as m JOIN (
      SELECT TableA_ID, SUM(NumberSold)
        FROM reservations
      GROUP BY movie_id
  ) AS r ON m.id = r.movie_id
  

  this returns

  id   title
  ...  ...
  

  from both tables but I need to add the SUM(NumberSold) part as a new column, so it should be like this

  id   title  NumberSold
  ...  ...    ...
  
• Is there a way to use SQL query to rename a column in a partitioned table in BigQuery that would preserve the partitioning?

  I'm trying to rename a column in a partitioned table in BigQuery. Google BigQuery docs suggest I use this SQL query

  #standardSQL
     SELECT
       * EXCEPT(column_one, column_two),
       column_one AS newcolumn_one, column_two AS newcolumn_two
     FROM
       mydataset.mytable
  

  However, when I run it and save the result in a table, it is no longer partitioned. Is there any way to rename a column using SQL that would preserve it?
• console.log prints "a" before class object [flow]

  Foo.js:

  export class Foo {
    name: string;
  
    constructor(name: string) {
      this.name = name;
    }
  }
  

  In a test file, I do a simple console.log(new Foo("test")); and it outputs: a { name: 'test' }

  I'm guessing the a may indicate the any type (I do have flow installed), but I'm not sure.

  Using:

  • Node v10.15.0
  • flow-bin ^0.90.0
  • babel v6
• How do I get the Discord "message" object?

  I'm attempting to set up a Discord bot using node.js and discord.js. I have been trying to find a way to get all of the roles in the server, and all I've found is this: message.guild.roles.find(role => role.name === "Moderators"); I, however, have no clue where the "message" object is coming from.

  I've seen examples that look like this:

  const client = new Discord.Client()
  client.on('message', message => {
    if (message.content === 'ping') {
      message.reply('pong');
    }
  });
  

  But when I try to use that, the command line spits out an error: "(node:8080) UnhandledPromiseRejectionWarning: Error: An invalid token was provided."

  The only thing I could get to work was this:

  var logger = require("winston");
  var auth = require("./auth.json");
  // Configure logger settings
  logger.remove(logger.transports.Console);
  logger.add(new logger.transports.Console, {
    colorize: true
  });
  logger.level = "debug";
  // Initialize Discord Bot
  var bot = new Discord.Client({
    token: auth.token,
    autorun: true
  });
  bot.on("ready", function (evt) {
    logger.info("Connected");
    logger.info("Logged in as: ");
    logger.info(bot.username + " - (" + bot.id + ")");
  });
  
  bot.on("message", function (user, userID, channelID, message, evt) {
    // code
  });
  

  The thing is, "message" in "bot.on" is a string, not an object. I've tried replacing "bot.on" with this:

  bot.on("message", message => {
    console.log(message);
  });
  

  But the console log just prints out the user's name, not an object.

  Any help is appreciated.

  Edit: In case it helps, I was using this tutorial: https://www.digitaltrends.com/gaming/how-to-make-a-discord-bot/
• File not found - http://localhost/path-file-script-or-image

  When I visit my node application running on my raspberry pi at 10.0.my.ip.address the app loads but get 404 multiple files not found. The src to my files, scripts and images look similar to this

  <link rel="stylesheet" href="http://localhost/Ziroid_Functions/Clovis_App/public/clovisapp.css">
  
  <img src="http://localhost/Ziroid_Functions/Clovis_App/public/img/doubleUp.png" alt="Smiley face" >
  
  <script type="text/javascript" src="http://localhost/Ziroid_Functions/Clovis_App/public/js/radar.js"></script>
  

  Whats weird is that these lines on code worked yesterday. I added a few more src links which got errors. I restarted my apache server on desktop top then all the sudden my desktop started getting errors with all src links being localhost/some-address.

  I tried loading application on my other computer and all the scirpts,images and links load fine.

  What might the problem be and how do I fix this?
• Can you access postgreSQL from Excel using psqlODBC on a Mac?

  I spent the whole afternoon trying to get the psqlODBC driver to work with Excel (Mac Version) with no luck. The connection tests OK in Excel but the query does not get executed. No error message, just no response at all.

  What I have:

  1. Installed psqlODBC 10.02 via Stack Builder.
  2. Created new versions of /Library/ODBC/odbcinst.ini and /Library/ODBC/odbc.ini
  3. In Excel the connection tests OK, and states that it is ready to be used.
  4. When I create a query and press 'run', nothing happens.

  odbcinst.ini:

  [ODBC Drivers]
  psqlODBC=Installed
  
  [psqlODBC]
  Description=PostgreSQL ODBC driver
  Driver=/Library/PostgreSQL/psqlODBC/lib/psqlodbcw.so
  

  odbc.ini:

  [ODBC]
  InstallDir = /Library/PostgreSQL/psqlODBC/lib
  
  [ODBC Data Sources]
  Stocks        = PostgreSQL
  
  [Stocks]
  Driver        = /Library/PostgreSQL/psqlODBC/lib/psqlodbcw.so
  Servername    = localhost
  Port          = 5432
  Database      = stocks
  Username      = dba
  

  I have not been able to locate a list of commonly used parameters for the .ini files, so if anyone knows of one, please post it.

  Thanks.
• How do I set Google Cloud SQL - PostgreSQL timezone to UTC

  I see Cloud SQL - MySQL has a Database Flag to set the default_time_zone. I cannot however, find how to do the same for Cloud SQL - PostgreSQL. I need my time zone to be UTC.
• Does Passport-local expect me to send username and password in query params?

  I'm using Passportjs for user authentication and I'm using passport-local's LocalStrategy. It seems to expect to read username and password as query params. I thought that this isn't super safe and that sensitive information should be sent in request body. Is this true? And is there another way to configure passport-local to read from request body instead?
• Is there a way to make different bundles depending on the type of session logged?

  First, i have to say that i'm a novice in node and webpack and I'm looking for opinions and advices, not correct some particular code. So if you are patient with me i going to thank you very much. You see, i have to develop a web application in which there are different types of session and every one of them needs different modules of vue and some of them are shared (mine and third parties). I want to standarize my project but i just found information for single web applications, and yes, i'm looking for that but depending on the current session logged and a login page.

  The project is middle developed in vanilla PHP 7, PostgreSQL as DBMS and Vue - Vuetify as a framework for javascript. I did some kind of frankenstein to compress the files needed to each session but i'm not confident that it is the better solution because each time the page is loaded, PHP has to compress the files. So now I want to try again with webpack. The problem is that I have seen in many places that webpack sumarizes the entire project in only one bundle and I don't want that.

  I have to say also that i use CDN vue and vuetify so all vuetify's unwanted components are loaded.

  Just for demostration this is my tree

  api/                 # db connection, auth and ajax queries
  src/                 # resources like images and some global css
  views/               # here i have all the vue components and main pages depending on session
  views/?/components/  # normal components (.js) All of them starts with Vue.component('name',{...})
  views/?/routes/      # routed components (.js) All of them start with {...} (Vue-Router)
  views/?/main.php     # Here I define the components and routes needed and I query the database some initial things.
  views/?/main.js      # Vue-component that is loaded later
  
  general_template.php # has the skeleton of all main.php, so each main.php when they are ready, load it at the end.
  index.php            # check if session is active so can show a main page for each type of user.
  

  Can you guide me which technologies i have to use in node? and how should i organize my files? Feel free to disorganize the entire tree if you think it is like an spagetti. Thank you beforehand.
• Can't Reload or manually type a page route with react-router & express

  I'm setting up a single-page App with React router using Express router on the server side (for serving the first index page with the react router and then standing by for API requests). Currently I only have 2 routes: '/' and '/history'

  -clicking on "history" link from the home page gets me there without any problems.

  -Manually typing "/history" route makes the browser stay on loading forever.

  -Reloading the page while being on "/history" makes the browser stay on loading forever.

  how can i go about solving this?

  I tried rearranging the routes on express, After this I tried setting the app.all('*') method to handle all requests. Finally I tried changing app.all with app.get...,but neither of these help me.

  my index.js (for express router):

      /*Express Server*/
      const express = require('express');
      const app = express();
      const morgan = require('morgan');
      const path = require('path');
      const bodyParser = require('body-parser');
  
      const { mongoose } = require('./database');
  
      //settings
      app.set('port', process.env.PORT || 3000);
  
      //middleware
      app.use(morgan('dev'));
      app.use(bodyParser.urlencoded({ extended: true }));
      app.use(bodyParser.json());
  
      //routes
      app.use('/api/month',require('./routes/monthly.routes'));
  
      app.use('/history',require('./routes/history.routes'));
  
      //static files
      app.use(express.static(path.join(__dirname, 'public')))
  
      app.get(async (req,res)=>{
          await res.sendFile(path.join(__dirname, '/public/index'), (err)=> {
          if (err) {
            res.status(500).send(err)
          }
      })
      });
  
      //Start server
      app.listen(app.get('port'), ()=>{
          console.log(`Server listening on ${app.get('port')}`);
      });
  

  router part of my app.js (for react router):

      import React, { Component } from 'react';
      import ReactDom from 'react-dom';
      import { BrowserRouter, Route, Switch } from 'react-router-dom';
      import Axios from 'axios';
  
      import Home from './Home'
      import Latest from './Latest'
  
      class App extends Component {
          constructor(props) {
              super(props);
              this.state = {
                  RecentExpenses: [],
                  monthState: null,
                  Total: 0,
                  Today: null
              }
          };
  
          render() {
              return (
                      <BrowserRouter>
                          <Switch>
                              <Route exact path='/' render={(props) => <Home {...props} Today={this.state.Today} Total={this.state.Total} RecentExpenses={this.state.RecentExpenses} />}  />
                              <Route exact path='/history' render={(props) => <Latest {...props} Recent={this.state.RecentExpenses} month={this.state.monthState} />} />
                          </Switch>
                      </BrowserRouter>
              )
          }
      }
  
      ReactDom.render(<App/>, document.getElementById('app'));
  

  What I expect is to always receive the same file from the server, so react router can take on as the navigation router. but it stays loading forever with this being thrown into the node console:

  (node:8756) UnhandledPromiseRejectionWarning: Error: Cannot find module 'html'
  at Function.Module._resolveFilename (internal/modules/cjs/loader.js:571:15)
  at Function.Module._load (internal/modules/cjs/loader.js:497:25)
  at Module.require (internal/modules/cjs/loader.js:626:17)
  at require (internal/modules/cjs/helpers.js:20:18)