Cedric BRINER | 1 Sep 2005 12:19
Picon

Re: a beginning database

debian sarge

hi,

I'm sure that the egg stuff is a nice idea... but it does complicate
my installation : (

so what is the correct procedure to install this:
http://cheeseshop.python.org/packages/source/S/SQLObject/SQLObject-0.7b1.tar.gz

    > mkdir py
    > mkdir py/build
    > cd !$
    > wget http://cheeseshop.python.org/packages/source/S/SQLObject/SQLObject-0.7b1.tar.gz
    > tar -xzvf SQLObject-0.7b1.tar.gz
    > python setup.py build
    > python setup.py install --prefix /usr/local
    > cd /usr/local/bin
    > sqlobject-admin
    Traceback (most recent call last):
      File "/usr/local/bin/sqlobject-admin", line 3, in ?
        import pkg_resources
    ImportError: No module named pkg_resources
    Exit 1

    > ls -1 /usr/local/lib/python2.3/site-packages/
    FormEncode-0.2.1-py2.3.egg/
    SQLObject-0.7b1-py2.3.egg/
    cherrypy/
    setuptools-0.5a13-py2.3.egg/
(Continue reading)

sferriol | 1 Sep 2005 16:26
Picon
Picon
Favicon

error when installing

hello
i try to install sqlobject with a local prefix
python setup.py install --prefix my_dir

it returns:
Installing easy_install.py script to /my_dir/bin
error: /my_dir/bin/easy_install.py: No such file or directory

Attachment (smime.p7s): application/x-pkcs7-signature, 4039 bytes
sferriol | 1 Sep 2005 16:02
Picon
Picon
Favicon

about sqlobject website

hello
i don't find the license of sqlobject in the site
and
there are two 'wiki' items in the menu

sylvain
Attachment (smime.p7s): application/x-pkcs7-signature, 4039 bytes
Kevin Dangoor | 1 Sep 2005 19:51
Picon
Gravatar

Re: a beginning database

On 9/1/05, Cedric BRINER <work <at> infomaniak.ch> wrote:
> I'm sure that the egg stuff is a nice idea... but it does complicate
> my installation : (

It's a temporary complication, I think. Once it's the standard
distribution mechanism, it will be even easier than the current
mechanism.

> so what is the correct procedure to install this:
> http://cheeseshop.python.org/packages/source/S/SQLObject/SQLObject-0.7b1.tar.gz
> 
>     > mkdir py
>     > mkdir py/build
>     > cd !$
>     > wget http://cheeseshop.python.org/packages/source/S/SQLObject/SQLObject-0.7b1.tar.gz
>     > tar -xzvf SQLObject-0.7b1.tar.gz
>     > python setup.py build
>     > python setup.py install --prefix /usr/local

If you already had setuptools (or got it first), this would have been:
easy_install SQLObject

(or, if that would have gotten 0.6.1 because 0.7 is beta:
easy_install SQLObject==0.7b1
)

>     > cd /usr/local/bin
>     > sqlobject-admin
>     Traceback (most recent call last):
>       File "/usr/local/bin/sqlobject-admin", line 3, in ?
(Continue reading)

Kevin Dangoor | 1 Sep 2005 19:59
Picon
Gravatar

Re: error when installing

On 9/1/05, sferriol <sylvain.ferriol <at> imag.fr> wrote:
> hello
> i try to install sqlobject with a local prefix
> python setup.py install --prefix my_dir
> 
> it returns:
> Installing easy_install.py script to /my_dir/bin
> error: /my_dir/bin/easy_install.py: No such file or directory

does my_dir actually exist? I'm not sure if install will automatically
create the top level directory for you...

Kevin

-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
Oleg Broytmann | 1 Sep 2005 18:16
X-Face
Picon

Re: about sqlobject website

On Thu, Sep 01, 2005 at 04:02:13PM +0200, sferriol wrote:
> i don't find the license of sqlobject in the site

   http://sqlobject.org/docs/SQLObject.html#author-site-and-license

Oleg.
--

-- 
     Oleg Broytmann            http://phd.pp.ru/            phd <at> phd.pp.ru
           Programmers don't die, they just GOSUB without RETURN.

-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
Oleg Broytmann | 2 Sep 2005 16:28
X-Face
Picon

Re: connectionForURI documentation

On Fri, Sep 02, 2005 at 10:08:08AM -0400, Martin Blais wrote:
> Just a minor irritant that is growing everytime I have to look it up: 
> It would be nice if the documentation included the format of the URL
> string for connectionForURI.

   This is a pretty normal URI. Why do you need a special documentation for
it?

Oleg.
--

-- 
     Oleg Broytmann            http://phd.pp.ru/            phd <at> phd.pp.ru
           Programmers don't die, they just GOSUB without RETURN.

-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
Martin Blais | 2 Sep 2005 16:08
Picon

connectionForURI documentation

Just a minor irritant that is growing everytime I have to look it up: 
It would be nice if the documentation included the format of the URL
string for connectionForURI.

cheers,

-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
Randall Smith | 2 Sep 2005 23:45

Joining Multiple Tables

With this setup,

     Class A -> b_things(SQLMultipleJoin) -> Class B -> 
c_thing(SingleJoin) -> Class C

I'm trying to accomplish this.

     Select B.* FROM
     A INNER JOIN B ON A.id = B.A_id
     INNER JOIN C ON b.id = c.B_id

I have an instance of A.  My guess would be something like this:

     B_Results = A.b_things.filter(B.q.c_thing != None)

One problem is that c_thing is not accessible under B.q because it is a 
SingleJoin property.

I'm trying to avoid doing manual sql.  Any help or advice would be 
appreciated.

Randall

-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
Rene Dudfield | 2 Sep 2005 23:58
Picon
Gravatar

Re: connectionForURI documentation

On 9/3/05, Oleg Broytmann <phd <at> mail2.phd.pp.ru> wrote:
> On Fri, Sep 02, 2005 at 10:08:08AM -0400, Martin Blais wrote:
> > Just a minor irritant that is growing everytime I have to look it up:
> > It would be nice if the documentation included the format of the URL
> > string for connectionForURI.
> 
>    This is a pretty normal URI. Why do you need a special documentation for
> it?
> 

Because people do not know what to put in them.  Like is it user,
username, host, hostname, what are separating the key/values.

The non-postgresql ones aren't filled in because I don't know how to
do non-postgresql ones.

connectionForURI examples:

#Postgresql
connection_uri = "postgres://username <at> hostname/databasename"
connection_uri = "postgres://joe <at> localhost/mybadassdb"

#Mysql 
connection_uri = ""

#Sqlite
connection_uri = ""

#Sqlite(memory database)
connection_uri = ""
(Continue reading)


Gmane