[Zope] a whole lot of db related Q's

[Matthew Scott]

Re. migrating from xbase databases to postgresql -- while not a
Zope/Python solution, I know PHP has functionality to read xbase files,
and I'm sure Perl has a similar module.  They can both interface with
PostgreSQL too, of course, so you could write your conversion utility in
that.

--
._-+$=%##########%=$+-_.
|#  Matthew R. Scott  #|
|#  gldnspud@lab.net  #|
`~-+$=%##########%=$+-~'


> -----Original Message-----
> From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of
> Raymund Ramos
> Sent: Thursday, February 24, 2000 1:24 PM
> To: zope@zope.org
> Subject: [Zope] a whole lot of db related Q's
>
>
>
> I installed python 1.5.2 with RPMs and installed
> a Zope 2.1.2 source package.
>
> However, I get this with databases I've done using
> External Methods and shelve [which seems to make
> bsd dbm files]:
>
> Zope Error
> Zope has encountered an error while publishing this resource.
>
> Error Type: error
> Error Value: db type could not be determined
> -----
> How do I fix this without recompiling whole packages?
>
> So since that stuff doesn't work, I've moved to trying
> to use ZSQL methods.
>
> Given a ZSQL method viewbytitle, args: title (subject is a property)
> with a query:
> select *
> from metadb
> where title = <dtml-sqlvar title type=string> and subj like
> '%<dtml-var
> subject>%'
>
> Can I do something like
> <dtml-let x=viewbytitle(title='WorldCat')>
> <dtml-var "x.url">
> </dtml-let>
> ?
>
> Is this possible using DTML/ZSQLMethods or do I need
> to do an External Method?
>
> Last Q, does anyone know of good tools that will move
> PC databases (FM Pro, dBase) into PostgreSQL easily?
> I've been saving the databases in tab-delim format and then
> using python scripts to import them into pgsql, with all
> of the quoting problems.
>
> thanks.
>
> -ray
>
>
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )
>