Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
sphinx-users
Home
+ new post
About this group
Join this group
rdbms and sphnix
Options
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
   8 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Rita Morgan  
View profile  
 More options Mar 2 2012, 11:26 pm
From: Rita Morgan <rmorgan...@gmail.com>
Date: Fri, 2 Mar 2012 20:26:18 -0800 (PST)
Local: Fri, Mar 2 2012 11:26 pm
Subject: rdbms and sphnix
Print | Individual message | Show original | Report this message | Find messages by this author
I have been using sphinx and been liking it a lot. I have several
hundred database queries on oracle and sqlite and I would like to
integrate them into my sphnix document. Basically, a lot of select (*)
from table where field=¨bar¨; I would like to place the output in a
table but not sure what is the best way to do this. Can someone
recommend a proper way or efficient way of doing this?

tia


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
togakushi  
View profile  
 More options Mar 3 2012, 7:29 am
From: togakushi <nina.togaku...@gmail.com>
Date: Sat, 3 Mar 2012 04:29:21 -0800 (PST)
Local: Sat, Mar 3 2012 7:29 am
Subject: Re: rdbms and sphnix
Print | Individual message | Show original | Report this message | Find messages by this author

 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Rita  
View profile  
 More options Mar 3 2012, 7:44 am
From: Rita <rmorgan...@gmail.com>
Date: Sat, 3 Mar 2012 07:44:22 -0500
Local: Sat, Mar 3 2012 7:44 am
Subject: Re: [sphinx-dev] Re: rdbms and sphnix
Print | Individual message | Show original | Report this message | Find messages by this author

Thanks for your response! Is there a more generic solution? what if i don't
use sqlite

--
--- Get your facts first, then you can distort them as you please.--

 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
werner  
View profile  
 More options Mar 3 2012, 8:06 am
From: werner <wbru...@free.fr>
Date: Sat, 03 Mar 2012 14:06:27 +0100
Local: Sat, Mar 3 2012 8:06 am
Subject: Re: [sphinx-dev] Re: rdbms and sphnix
Print | Individual message | Show original | Report this message | Find messages by this author

On 03/03/2012 13:44, Rita wrote:

> Thanks for your response! Is there a more generic solution? what if i
> don't use sqlite

Have not usee it but as it supports all SQLAlchemy supported db's you
have quite a selection:

http://sqlalchemy.readthedocs.org/en/latest/core/engines.html

Werner


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Rita  
View profile  
 More options Mar 3 2012, 8:32 am
From: Rita <rmorgan...@gmail.com>
Date: Sat, 3 Mar 2012 08:32:22 -0500
Local: Sat, Mar 3 2012 8:32 am
Subject: Re: [sphinx-dev] Re: rdbms and sphnix
Print | Individual message | Show original | Report this message | Find messages by this author

Ok. thanks

I installed it and have it configured (i think properly). I am able to
query the database and the module is loading.

here is a problem I keep getting,
$ make html
sphinx-build -b html -d build/doctrees   source build/html
Running Sphinx v1.0.1
Initializing SQLTable
loading pickled environment... done
building [html]: targets for 1 source files that are out of date
updating environment: 0 added, 1 changed, 0 removed
reading sources... [100%] index

/home/user/Python/test1/source/index.rst:22: (ERROR/3) Error in "sqltable"
directive:
invalid option block.

.. sqltable::
   :sqltable_connection_string: sqlite:///sampledata.db
   select name from users

looking for now-outdated files... none found
pickling environment... done
checking consistency... done
preparing documents... done
writing output... [100%] index

writing additional files... (0 module code pages) genindex search
copying static files... done
dumping search index... done
dumping object inventory... done
build succeeded, 1 warning.

Build finished. The HTML pages are in build/html.

--
--- Get your facts first, then you can distort them as you please.--

 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
werner  
View profile  
 More options Mar 3 2012, 8:46 am
From: werner <wbru...@free.fr>
Date: Sat, 03 Mar 2012 14:46:57 +0100
Local: Sat, Mar 3 2012 8:46 am
Subject: Re: [sphinx-dev] Re: rdbms and sphnix
Print | Individual message | Show original | Report this message | Find messages by this author
Hi Rita,

On 03/03/2012 14:32, Rita wrote:

> Ok. thanks

...
> .. sqltable::
>    :sqltable_connection_string: sqlite:///sampledata.db
>    select name from users

I think you need a blank line between the select and the :sqltable.... line

Werner


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Rita  
View profile  
 More options Mar 3 2012, 8:55 am
From: Rita <rmorgan...@gmail.com>
Date: Sat, 3 Mar 2012 08:55:31 -0500
Local: Sat, Mar 3 2012 8:55 am
Subject: Re: [sphinx-dev] Re: rdbms and sphnix
Print | Individual message | Show original | Report this message | Find messages by this author

you are right. I got a bit further now.

updating environment: 0 added, 1 changed, 0 removed
Connecting to sqlite:///sampledata.db

Running query u"select name as 'Name', email as 'E-mail' from users\norder
by Name asc"

Exception occurred:
  File
"/usr/local/lib/python2.7/dist-packages/sphinxcontrib_sqltable-1.0-py2.7.eg g/sphinxcontrib/sqltable.py",
line 95, in run
    self.add_name(table_node)
AttributeError: 'SQLTable' object has no attribute 'add_name'

--
--- Get your facts first, then you can distort them as you please.--

 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
werner  
View profile  
 More options Mar 3 2012, 10:36 am
From: werner <wbru...@free.fr>
Date: Sat, 03 Mar 2012 16:36:48 +0100
Local: Sat, Mar 3 2012 10:36 am
Subject: Re: [sphinx-dev] Re: rdbms and sphnix
Print | Individual message | Show original | Report this message | Find messages by this author
On 03/03/2012 14:55, Rita wrote:
> you are right. I got a bit further now.

> updating environment: 0 added, 1 changed, 0 removed
> Connecting to sqlite:///sampledata.db
> Running query u"select name as 'Name', email as 'E-mail' from
> users\norder by Name asc"

> Exception occurred:
>   File
> "/usr/local/lib/python2.7/dist-packages/sphinxcontrib_sqltable-1.0-py2.7.eg g/sphinxcontrib/sqltable.py",
> line 95, in run
>     self.add_name(table_node)
> AttributeError: 'SQLTable' object has no attribute 'add_name'

No idea on this one, maybe file an issue:
https://bitbucket.org/birkenfeld/sphinx-contrib/issues

Werner


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2013 Google