Related questions

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

2018-01-11 21:02 tjrules imported from Stackoverflow

I'm creating a blog app. A user signs in and they can create a new post. To do this the data is being sent to the controller like so:

//blog-controller.js

blogController.create = (req, res) => {
  Blog.create({
      title: req.body.title,
      content: req.body.content,
      author_id: req.body.author_id,
      // user_id: req.body.user.id //added user_id object 
    })
    .then(blog => {
      res.redirect(`/blog/${blog.id}`)
    }).catch(err => {
      console.log(err)
      res.status(400).json(err);
    });
};

I would like to assign the author of the blogpost to be the user that is currently signed in, the info that is created from my users controller: 

//users-controller.js
usersController.create = (req, res) => {
   User.create({
    username: req.body.username,
    email: req.body.email,
    password_digest: hash,
  })

How can I set the info of the user.username to the blog.author_id? (i.e. from two different tables)

Thanks in advance!

See also questions close to this topic

  • How to check varchar variable if its Numeric or not in CASE When statement

    I have complex query where i am having a varchar variable. I need to perform various operation on it based on the datatype of data i receive in that variable.

    If varchar variable contains numeric value then i need to convert it to numeric datatype so i can perform > < operation on it.

    It all works fine except below part

        Declare @testVal as varchar(50)='ok'
select CASE WHEN IsNUMERIC(@testVal)=1 THEN Cast(@testVal as numeric) ELSE 'n' End

    Above query gives me error "Error converting data type varchar to numeric."

    I can't use try_convert and advanced functions like that as i am using older version of SQL.

  • Identify each hour between start and end time

    Not really sure how to describe this, but I'll give it a shot.

    Background

    I need to backfill some historical manufacturing data into a data warehouse, and will be recording this per hour for each of the production lines. This will be a one-time activity, rather than an ongoing process.

    Desired Result

    I need to create a table variable which contains the breakdown of each hour, ie

    Row ID | Start Time
1      | 2018-01-01 00:00:00
2      | 2018-01-01 01:00:00
...etc...
nn     | 2018-10-12 10:00:00

    If I can get the hours out for between two points in time into a table (which I have defined), then I can run the relevant routines to backfill the data. I'm sure this is fairly simple to achieve - can anyone give me any pointers please?

    Thanks in advance.

  • Error when exporting data from SQL output to csv

    I have a SQL that has one of the columns that stores value that begins with a hyphen '-'. When I tried to export it to csv I get an Invalid Name error. When I view it in the SQL editor it shows correctly (Sample : -Coke).

    Is there anyway I could have this value saved successfully in the csv file ?

    Given below is a sample view of the data

    Name
-Coke
-Pepsi

    Sample SQL I used:

    SELECT name FROM sales WHERE name like '-%';

    I am using a Redshift DB.

  • Is there any JS smart json schema validator, like Joi maybe, but with dynamic custom errors?

    I want to easily validate user's input.

    When I ask the first name of the user (for example), it can take tons of lines of code in order to really make it good validated.

    I want something that I can use in front end and either in back end - without changing the validation structure.

    I need the ability to throw custom detailed errors, something like this:

    let schema = Joi.object.keys({
  first_name: Joi.string("Required to be a string")
  .noNumbers("Should not contain numbers")
  .minlenth(2, "At least 2 chars")
  .maxlength(10, "Maximum 10 chars")
  .required("Required field"),
  last_name: Joi.string("Required to be a string")
  .noNumbers("Should not contain numbers")
  .minlenth(2, "At least 2 chars")
  .maxlength(10, "Maximum 10 chars")
  .required("Required field"),
});

    Unfortunately the above does not work - since Joi does not work like this.

    Maybe is there a good JSON schema validator to easily and efficiently validate the user's input without wasting time - and yet keep it clear for the user?

  • Is it possible to trigger smart contract automatically in Hyperledger fabric?

    I have a chaincode smart contract which needs to be triggered by itself on certain conditions, for example if any of the status is equal to something.

    Currently I have written a cron job in nodejs to trigger that smart contract via node api, not sure whether this is the right approach.

    Did any one explored this option, would be really helpful.

    Thanks :)

  • how to set the default node version?? After restarting server 
    $ nvm ls:

     .nvm
 v0.11.12
 v0.11.13

    I have to keep hitting nvm use v.0.11.13 in every session:

         .nvm
 v0.11.12

    -> v0.11.13 I've tried both the brew install, as well as the official installation script.

  • Naming convention for many to many join table in Spring Boot/Hibernate/JPA - Postgres

    I have two tables with named as

    • Stocks and Categories

    . What will be the suitable name for the join table name as can we define as stocks_categories? Kindly appreciate your suggestions.

  • Nhibernate is supported with .net core 2.1?

    nhibernate is supported with .net core 2.1?

    I try to find tutorial with nhibernate, .net core 2.1 (or 2.0 if 2.1 not work with hib) and postgresql.

  • PocoDataPostgreSQL in docs

    I saw latest version of Poco library in github contains PocoDataPostgreSQL, but I have not seen documentation about that in https://pocoproject.org/docs/. Will it be included in docs?

  • Is node.js good for an application like timedoctor?

    We are planning to build an application like timedoctor(https://www.timedoctor.com and were planning to use node for the backend and Angular for the frontend. But after some discussions, it was not clear whether the node is a good candidate as a backend server for such an application. We are planning to build it as a multitenant application. We are also considering Django as the backend application.So, does node is competitive with OOPs and ORM features in Django? Any performance benefit for using node instead of Django here?

    If Django have more advantages, what about using node app only as the receiving API server for image uploads (screenshots from agents running on employee PCs). Node, single-threaded event-loop and internal worker threads give a good throughput for concurrent image uploads? Or image uploads are event-loop blocking events and its a bad idea?

  • Torrent Tracking Help Needed Node.js

    I have been working with a client based project on Node.js, the customer requires the tool which can retrieve the torrent downloader IP information, like this tool.

    What this tool does is simple, it will give you torrent file to download, once you run it on Utorrent and BitTorrent client, it will quickly grab the downloader IP address and displayed.

    Can anyone help me to understand the logic behind it? It has been 4 days working really hard to figure that out but won't work.

  • How to save object in mongoose

    I want to use object to combine admins, but I cant figure out. Here is the schema and code

    UserSchema = new mongoose.Schema({
  name: { type:String },
  owner : {
    Admin       : mongoose.Schema.Types.ObjectId
    }
});

    And saving function:

    user.name = 'nerkn';
user.owner={ Admin     :new ObjectId(Adminid)} // this is from another user


el  = req.db.model('Users')(user)
el.save((err)=>{console.log(err)})
console.log('el', el)

    when I check name is saved but owner.Admin is not.