SQL package

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Juan
    #1

    SQL package

    Hi

    I am trying to write a little a script that can be configurable. This
    script should access to a database, that can be of any type (MySQL,
    Postgres, SQLite, MS, etc).It has only to perform 2 or 3 simple plain
    SQL queries. Hi have tested SQLAlchemy, and it is great, but too much
    for my requirements, and I don't have any object relation with the
    database tables. All I need is to access any database type in the same
    way (mysql://user:pass@local host/database, pgsqll://user:pass@local host/database,
    ....) and run some basic queries. I have searched for this, but I have
    not found any solution. Could you help me please?

    If not, how can I run a simple query in SQLAlchemy? And iter the
    results? I have tried this without success:

    engine = create_engine(' postgres://user:pass@local host/database',
    echo=True)
    results = engine.execute( "SELECT * FROM TABLE")
    for result in results:
    print result
    Tags: None
    • Diez B. Roggisch
      #2
      Re: SQL package

      Juan schrieb:
      Hi
      >
      I am trying to write a little a script that can be configurable. This
      script should access to a database, that can be of any type (MySQL,
      Postgres, SQLite, MS, etc).It has only to perform 2 or 3 simple plain
      SQL queries. Hi have tested SQLAlchemy, and it is great, but too much
      for my requirements, and I don't have any object relation with the
      database tables. All I need is to access any database type in the same
      way (mysql://user:pass@local host/database, pgsqll://user:pass@local host/database,
      ...) and run some basic queries. I have searched for this, but I have
      not found any solution. Could you help me please?
      >
      If not, how can I run a simple query in SQLAlchemy? And iter the
      results? I have tried this without success:
      >
      engine = create_engine(' postgres://user:pass@local host/database',
      echo=True)
      results = engine.execute( "SELECT * FROM TABLE")
      for result in results:
      print result
      Please read the documentation of sqlalchemy:

      http://www.sqlalchemy.org/docs/05/sqlexpression.html


      There is a very comprehensive example on that site what you should be
      able to follow.

      Diez

        Comment

        • Diez B. Roggisch
          #3
          Re: SQL package

          Juan schrieb:
          Hi
          >
          I am trying to write a little a script that can be configurable. This
          script should access to a database, that can be of any type (MySQL,
          Postgres, SQLite, MS, etc).It has only to perform 2 or 3 simple plain
          SQL queries. Hi have tested SQLAlchemy, and it is great, but too much
          for my requirements, and I don't have any object relation with the
          database tables. All I need is to access any database type in the same
          way (mysql://user:pass@local host/database, pgsqll://user:pass@local host/database,
          ...) and run some basic queries. I have searched for this, but I have
          not found any solution. Could you help me please?
          >
          If not, how can I run a simple query in SQLAlchemy? And iter the
          results? I have tried this without success:
          >
          engine = create_engine(' postgres://user:pass@local host/database',
          echo=True)
          results = engine.execute( "SELECT * FROM TABLE")
          for result in results:
          print result
          sqlalchemy is the way to go, and you should consider actually reading
          the documentation - the above clearly shows that you didn't.

          http://www.sqlalchemy.org/docs/05/sqlexpression.html


          Here you can see what is needed:

            Comment

            Previous template Next
            Working...