Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Create Invoices Table #8

Open
5 tasks done
theNatePi opened this issue Nov 20, 2024 · 0 comments · May be fixed by #17
Open
5 tasks done

Create Invoices Table #8

theNatePi opened this issue Nov 20, 2024 · 0 comments · May be fixed by #17
Assignees

Comments

@theNatePi
Copy link
Collaborator

theNatePi commented Nov 20, 2024

Welcome to your first sprint task!

Setup

  1. Clone this repository to your local machine
  2. On the right side of this issue, create a new branch
    • Check the right side of the GitHub UI
  3. Use the commands provided to switch to that branch before you begin working
    • The commands will pop up once you make the branch
       

IMPORTANT

  • We are using Yarn. NEVER npm install, always use Yarn
  • BEFORE you commit, use git add <names of files>. ONLY add files you modified, including the yarn.lock if you added new modules
  • BEFORE you commit, use git status. Ensure files you changed are in green, irrelevant files are in red
  • Make sure you always push to your new branch, never push to main
  • See the bottom of this doc for resources on Git if you are lost, and feel free to reach out to Nate and Jessie at any time!
     
    NOTE:
    We are using PostgreSQL, not just SQL. Be sure to include Postgres when searching for documentation.
    For time/datetime types, see this documentation: link

Task

  1. Implement the invoices table (found in the DB model linked below)
    • A template has been created for you on this website
    • This template will let you implement and test your invoices table
  2. When done on the DB Fiddle, create a new file called invoices.sql in /lpa/server/db/schema/
    • Do this locally in VS code or your files, do not do this on the GitHub website
    • The GitHub desktop client is not recommended, it is a good skill to learn the command line!
  3. Put the create statement for invoices table in that file. DO NOT put any of the other template SQL or comments
  4. Commit and push these changes to GitHub
  5. Create a PR describing the changes you made
     

Pre-submit checklist

 

  • The invoices table on DB fiddle runs without errors
  • The provided insert statements run
  • I have written more insert statements to test unique constraints and defaults
  • Changes are committed to a new branch for this issue (don't commit to MAIN!!)
  • These changes are pushed to the remote repo
     
    Now, create the PR!

Please complete before November 30th
 

Resources

@brelieu05 brelieu05 linked a pull request Nov 26, 2024 that will close this issue
@brelieu05 brelieu05 linked a pull request Nov 26, 2024 that will close this issue
@brelieu05 brelieu05 reopened this Nov 26, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants