Re: [Owfs-developers] FYA, python loading data into a db with owserver

2006-12-18 Thread Chris Lyon
It also requires a zones table: > CREATE TABLE zones ( > idSERIAL NOT NULL UNIQUE, > modified_at TIMESTAMP NOT NULL DEFAULT(CURRENT_TIMESTAMP), > name TEXT NOT NULL UNIQUE, > description TEXT, > PRIMARY KEY (id) I've got it runnin

Re: [Owfs-developers] FYA, python loading data into a db with owserver

2006-12-17 Thread Paul Alfille
You're added! See http://www.owfs.org/index.php?page=postgres-and-python-by-jerry-scharf Paul Alfille On 12/17/06, Jerry Scharf <[EMAIL PROTECTED]> wrote: Jerry Scharf wrote: > Paul Alfille wrote: > >> Shall I put the whole thing (your program, explantation, and schema) >> on the website? >>

Re: [Owfs-developers] FYA, python loading data into a db with owserver

2006-12-17 Thread Jerry Scharf
Jerry Scharf wrote: > Paul Alfille wrote: > >> Shall I put the whole thing (your program, explantation, and schema) >> on the website? >> >> Paul Alfille >> Here's the schema for the program in a form to be fed into psql. All the tables are defined to the Ruby on Rails style to allow RoR

Re: [Owfs-developers] FYA, python loading data into a db with owserver

2006-12-17 Thread Jerry Scharf
Paul Alfille wrote: > Shall I put the whole thing (your program, explantation, and schema) > on the website? > > Paul Alfille If you think my code is worth that, I am fine with it. The problem is the schema. I can pull the parts of the schema that are of interest and send those out, but there w

Re: [Owfs-developers] FYA, python loading data into a db with owserver

2006-12-17 Thread Paul Alfille
Shall I put the whole thing (your program, explantation, and schema) on the website? Paul Alfille On 12/17/06, Chris Lyon <[EMAIL PROTECTED]> wrote: > I won't include the schema, as it is much more complex that this part > shows. I use Postgres as my dbms and love that as well. I hate python >

Re: [Owfs-developers] FYA, python loading data into a db with owserver

2006-12-17 Thread Chris Lyon
> > I won't include the schema, as it is much more complex that this part > shows. I use Postgres as my dbms and love that as well. I hate python > less than other languages and Linux less than windows. > > enjoy, > jerry > There are people who would LOVE to see the schema. Can we chat sepa

[Owfs-developers] FYA, python loading data into a db with owserver

2006-12-17 Thread Jerry Scharf
I am not a brilliant coder, but someone had been asking for an example of how to load 1-wire data into a database. So I am including this diddy which does it in python. I am using Peter's fine owpython interface and owserver. owserver is great for this, since it allows me to have owfs around at