9 votes

Fortnightly Programming Q&A Thread

General Programming Q&A thread! Ask any questions about programming, answer the questions of other users, or post suggestions for future threads.

Don't forget to format your code using the triple backticks or tildes:

Here is my schema:

```sql
CREATE TABLE article_to_warehouse (
  article_id   INTEGER
, warehouse_id INTEGER
)
;
```

How do I add a `UNIQUE` constraint?

7 comments

  1. [2]
    DougM
    Link
    Kind of a different question, but my internship for the upcoming summer was rescinded because of COVID-19. I'm now doing an unpaid internship for a startup here in Denver but I'm really just cheap...

    Kind of a different question, but my internship for the upcoming summer was rescinded because of COVID-19. I'm now doing an unpaid internship for a startup here in Denver but I'm really just cheap labor as I'm the only "software engineer."

    I place that in quotations because it's a company running shopify for their product so I'm really just installing plugins before they launch next week.

    I am searching up and down for an actual internship, I'd even take an unpaid one doing actual programming at this point, but can't find anything.

    Is it better for me to just stick this one out and keep installing plugins for them at no pay or should I say no to it and just work a side project instead? I'm being told two different things from Reddit (shocking) and not sure if having that internship is do or die for my job hunt following the upcomming semester.

    6 votes
    1. joplin
      Link Parent
      The answer is going to come down to who you apply to and what their preferences are. To me, as someone who has input to the hiring process at my company, I'd prefer to see in order of importance:...

      The answer is going to come down to who you apply to and what their preferences are. To me, as someone who has input to the hiring process at my company, I'd prefer to see in order of importance:

      1. Relevant work experience at an actual company (I don't need to know whether it was paid or not)
      2. Relevant experience on a side project, even better if I can actually look at the source on github/gitlab/whatever
      3. Unrelated experience at an actual company showing you can at least deal with working in a company structure

      Whatever you decide, just be sure to tailor your resume to the company you're applying to if you want to increase your chances.

      3 votes
  2. [2]
    Comment deleted by author
    Link
    1. timo
      Link Parent
      At one point do you feel the need for the const.py file? Maybe PyCharm can help you with that. You might write out const.my_new_const and let PyCharm create it via a shortcut.

      At one point do you feel the need for the const.py file? Maybe PyCharm can help you with that. You might write out const.my_new_const and let PyCharm create it via a shortcut.

      2 votes
  3. [4]
    mercury
    Link
    Is it possible to import a python file that is present in a parent directory?

    Is it possible to import a python file that is present in a parent directory?

    4 votes
    1. [2]
      gpl
      Link Parent
      You’ll have to add the directory containing the file to your python path, either permanently in your .bashrc or at runtime in your imports.

      You’ll have to add the directory containing the file to your python path, either permanently in your .bashrc or at runtime in your imports.

      3 votes
      1. mercury
        Link Parent
        Yeah. I thought this must be a frequent enough task for python to support using '../' for module imports.

        Yeah. I thought this must be a frequent enough task for python to support using '../' for module imports.

        1 vote
    2. pocketry
      Link Parent
      I've been struggling with this a lot recently too. I think my fault is that I run all my python scripts as individual files. That means, I'm not really using the module concept of my parent...

      I've been struggling with this a lot recently too. I think my fault is that I run all my python scripts as individual files. That means, I'm not really using the module concept of my parent directory. I've been thinking about creating a main.py file in the root directory that transforms all my little scripts into commands for an internal CLI. This doesn't help my desire to reuse code in jupyter notebooks. We'll see if I ever get around to it though.

      2 votes