SQLAlchemy not connecting (first time user)












0















I am new to SQLAlchemy. I believe that I installed SQLAlchemy correctly since I just needed to do three simple installations. However, once I tried to connect to sqlite, which is said to not need complicated credentials, I wanted to print out the tables. However, I kept getting empty results. And I was just following a simple tutorial from a guy. Also, I did try to connect to other sqlite databases but I kept getting empty tables. May I get some help? I just wanna be a nerd and enjoy databases :/



!pip install conda

!pip install bz2file

!pip install SQLAlchemy

**Getting Libraries Ready**

import sqlalchemy as db

**Create engine**

from sqlalchemy import create_engine

engine = db.create_engine('sqlite:///Chinook_Sqlite.sqlite')

**Save the table names to a list: table_names**

table_names = engine.table_names()

**Print the table names to the shell**

print(table_names)









share|improve this question





























    0















    I am new to SQLAlchemy. I believe that I installed SQLAlchemy correctly since I just needed to do three simple installations. However, once I tried to connect to sqlite, which is said to not need complicated credentials, I wanted to print out the tables. However, I kept getting empty results. And I was just following a simple tutorial from a guy. Also, I did try to connect to other sqlite databases but I kept getting empty tables. May I get some help? I just wanna be a nerd and enjoy databases :/



    !pip install conda

    !pip install bz2file

    !pip install SQLAlchemy

    **Getting Libraries Ready**

    import sqlalchemy as db

    **Create engine**

    from sqlalchemy import create_engine

    engine = db.create_engine('sqlite:///Chinook_Sqlite.sqlite')

    **Save the table names to a list: table_names**

    table_names = engine.table_names()

    **Print the table names to the shell**

    print(table_names)









    share|improve this question



























      0












      0








      0








      I am new to SQLAlchemy. I believe that I installed SQLAlchemy correctly since I just needed to do three simple installations. However, once I tried to connect to sqlite, which is said to not need complicated credentials, I wanted to print out the tables. However, I kept getting empty results. And I was just following a simple tutorial from a guy. Also, I did try to connect to other sqlite databases but I kept getting empty tables. May I get some help? I just wanna be a nerd and enjoy databases :/



      !pip install conda

      !pip install bz2file

      !pip install SQLAlchemy

      **Getting Libraries Ready**

      import sqlalchemy as db

      **Create engine**

      from sqlalchemy import create_engine

      engine = db.create_engine('sqlite:///Chinook_Sqlite.sqlite')

      **Save the table names to a list: table_names**

      table_names = engine.table_names()

      **Print the table names to the shell**

      print(table_names)









      share|improve this question
















      I am new to SQLAlchemy. I believe that I installed SQLAlchemy correctly since I just needed to do three simple installations. However, once I tried to connect to sqlite, which is said to not need complicated credentials, I wanted to print out the tables. However, I kept getting empty results. And I was just following a simple tutorial from a guy. Also, I did try to connect to other sqlite databases but I kept getting empty tables. May I get some help? I just wanna be a nerd and enjoy databases :/



      !pip install conda

      !pip install bz2file

      !pip install SQLAlchemy

      **Getting Libraries Ready**

      import sqlalchemy as db

      **Create engine**

      from sqlalchemy import create_engine

      engine = db.create_engine('sqlite:///Chinook_Sqlite.sqlite')

      **Save the table names to a list: table_names**

      table_names = engine.table_names()

      **Print the table names to the shell**

      print(table_names)






      database sql sqlite






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Dec 22 '18 at 22:38









      DavidPostill

      104k25226260




      104k25226260










      asked Dec 22 '18 at 22:00









      ShadowxXxShadowxXx

      11




      11






















          0






          active

          oldest

          votes











          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "3"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1387015%2fsqlalchemy-not-connecting-first-time-user%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes
















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Super User!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1387015%2fsqlalchemy-not-connecting-first-time-user%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Paul Cézanne

          UIScrollView CustomStickyHeader Resize height generates problems when scroll is too fast

          Angular material date-picker (MatDatepicker) auto completes the date on focus out