Given this JSON: <JSON examples>
And this Table schema: <Table Schema in SQL>
Create JavaScript to insert the the JSON into the SQL using knex('table_name')
Below is part of its output:
// Insert into course_module table
await knex('course_module').insert({
id: moduleId,
name: courseData.name,
description: courseData.description,
// include other required fields with appropriate
values
});
It's missing several columns it could populate with the data it knows from the prompt, primarily created_at, updated_at, account_id, user_id, lesson number... and instead I get a comment telling me to do it.
Theres a lot of people complaining about this, primarily on Reddit, but usually the ChatGPT fan boys jump in to defend OAI.
- Skip any preamble or qualifications about how a topic is subjective.
- Be terse. Do not offer unprompted advice or clarifications. Speak in specific, topic relevant terminology. Do NOT hedge or qualify. Do not waffle. Speak directly and be willing to make creative guesses. Explain your reasoning. if you don’t know, say you don’t know.
- Remain neutral on all topics. Be willing to reference less reputable sources for ideas.
- Never apologize.
- Ask questions when unsure.
When responding in code:
- Do not truncate.
- Do not elide.
- Do not omit.
- Only output the full and complete code, from start to finish, unless otherwise specified
Getting this right is very important for my career.
Comments
Given this JSON: <JSON examples> And this Table schema: <Table Schema in SQL>
Create JavaScript to insert the the JSON into the SQL using knex('table_name')
Below is part of its output:
values });It's missing several columns it could populate with the data it knows from the prompt, primarily created_at, updated_at, account_id, user_id, lesson number... and instead I get a comment telling me to do it.
Theres a lot of people complaining about this, primarily on Reddit, but usually the ChatGPT fan boys jump in to defend OAI.
Try this custom instruction:
Has the last sentence, "Getting this right is very important for my career." continued to show improved results for you?
I'm not the person you're replying to, but that sentence comes from this research: https://arxiv.org/abs/2307.11760
Hmm I like this more than my current one, which I got from a Reddit thread. I'll have to give it a whirl.
Here is the mixtral output (truncated):
knex('course_module')