Simplifying timestamps

[oliverjam]

week3-aaae/database/model.js

Lines 43 to 46 in 33325a1

	function createPost(id, textContent) {
	const INSERT_POST = `INSERT INTO posts (user_id, text_content, created_at) VALUES ($1, $2, (SELECT CURRENT_TIMESTAMP))`;
	return db.query(INSERT_POST, [id, textContent]);
	}

Good idea to put a created_at column in your posts table. You will usually regret not doing this later on 😅

You could avoid the need to specify the timestamp manually on each insert by using a SQL "default" when you set the table up:

CREATE TABLE posts (
    id SERIAL PRIMARY KEY,
    user_id INTEGER REFERENCES users(id) ON DELETE CASCADE,
    text_content TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

Then you just don't specify that column on insert—Postgres will automatically use the default value.

(If you really want to type less apparently now() will give the same result as current_timestamp