Re: [SQLObject] sqlobject - python question/issue

2008-01-03 Thread bruce
Sent: Thursday, January 03, 2008 12:57 AM To: Jeff Younker Cc: sqlobject-discuss@lists.sourceforge.net Subject: Re: [SQLObject] sqlobject - python question/issue > It is good to know you solved your task. The only thing I do not > understand is why do you create tables using SQL commands.

Re: [SQLObject] sqlobject - python question/issue

2008-01-03 Thread Petr Jakeš
> > > It is good to know you solved your task. The only thing I do not > > understand is why do you create tables using SQL commands. Thanks to > > the great work of the people around SQLobjects it just a piece of > > cake to create your any table using SQLobject: > > I can't speak for him, but I c

Re: [SQLObject] sqlobject - python question/issue

2008-01-02 Thread Jeff Younker
> It is good to know you solved your task. The only thing I do not > understand is why do you create tables using SQL commands. Thanks to > the great work of the people around SQLobjects it just a piece of > cake to create your any table using SQLobject: I can't speak for him, but I can spe

Re: [SQLObject] sqlobject - python question/issue

2007-12-30 Thread Petr Jakeš
> > hi petr... > > wanted to say thanks for your assistance/pointers... It is good to know you have sucseeded. :-) > > i managed to create a quick test that illustrates a method of using a > string "id" for a tbl, as opposed to the "auto generated" int that is > normally required. > > i'm inclu

Re: [SQLObject] sqlobject - python question/issue

2007-12-30 Thread bruce
ultiple lines... ### in order to print the tmp array needs to be set to a ### valid array ndx... or you can simply use some kind of ### a loop!!! (this is just a test!!!) ### #qq=tmp2[4] print qq.id, "-- ", qq.aa print "mm \n" -Original Message----- From: [EMAIL

Re: [SQLObject] sqlobject - python question/issue

2007-12-30 Thread Petr Jakeš
> > Thanks for the replies.. > > In my case, the ID is used to store a generated uuid, as a completely > unique string. The overall process, is that I have multiple systems, and > they each run a local process, with a local db/tbl structure.. I then > reconcile all the processes on a centralized my

Re: [SQLObject] sqlobject - python question/issue

2007-12-30 Thread bruce
ists.sourceforge.net Subject: Re: [SQLObject] sqlobject - python question/issue One more thing. If it is possible I strongly recommend to use ID which has "no meaning" and the best choice is an integer of course!!! (Try to find somes articles about IDs etc. on the web) So using autom

Re: [SQLObject] sqlobject - python question/issue

2007-12-30 Thread Petr Jakeš
One more thing. If it is possible I strongly recommend to use ID which has "no meaning" and the best choice is an integer of course!!! (Try to find somes articles about IDs etc. on the web) So using automaticaly generated IDs (it does not matter if it is generated by your code or by SQLobject) is

Re: [SQLObject] sqlobject - python question/issue

2007-12-30 Thread Petr Jakeš
> > Forgive me for a basic/simple question. If I already have a mysql db/tbl > schema, so I've already created my test mysql db/tbls... > > How can i simply read the tbl, and then insert a test row/value with a tbl > that has an id of a varchar? > > sample mysql db > > use test; //test db name > >

Re: [SQLObject] sqlobject - python question/issue

2007-12-30 Thread bruce
ysql command line. thanks for your help!!! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Petr Jakeš Sent: Sunday, December 30, 2007 11:28 AM To: bruce Cc: sqlobject-discuss@lists.sourceforge.net Subject: Re: [SQLObject] sqlobject - python question/issue Sorry for sm

Re: [SQLObject] sqlobject - python question/issue

2007-12-30 Thread Petr Jakeš
Sorry for small mistake in my previous posting. You can "rem" following row in teh code as well. #idName = "PO_NUMBER" Petr Jakes - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visua

Re: [SQLObject] sqlobject - python question/issue

2007-12-30 Thread Petr Jakeš
> > could somone perhaps point me to either a code chunk that i can run as a > test to see what i'm missing! or could someone point me to additional docs > on this.. Hi, Tested on Win XP, Python 2.5.1 8<-- #!/usr/bin/env python # -*- coding: cp1250 -*- import o

[SQLObject] sqlobject - python question/issue

2007-12-30 Thread bruce
hi... i'm completely new to sqlobject, and not much further along regarding python! i'm trying to figure out how to create test tbl, that uses an id as a string. based on the docs that i've seen, sqlobject, uses an initial id that's an "auto-gened" int. the docs also imply/state that by using my