[OPEN-ILS-DEV] Open-ils-dev Digest, Vol 70, Issue 5

[darshan]

Hi All,

 

Thanks for the Help.

 

We have got  the database table named as "usr" but didn't find the actual
name of variable which we can use in template file that is
"hold_notification_template.example". 

Instead of that we found the columns that is  'day_phone', 'evening_phone',
'other_phone' which we cannot use as variable in template file to send
patron's phone number in mail. 

 

Please help us to retrieve actual variable name that can be used in template
file.

 

Thanks 

Darshan Khot

 

-----Original Message-----

From: David Busby [mailto:david.busby at edoceo.com]

Sent: 05 January 2012 14:28

To: Evergreen Development Discussion List

Cc: asoman at dreamsoftech.com

Subject: Re: [OPEN-ILS-DEV] Open-ils-dev Digest, Vol 70, Issue 4

 

Darshan,

  The tables in Evergreen are contained within a Schema in PostgreSQL, so
there are simply no tables in the public schema (that which you sent a
picture of).

 

  If you issue the command: \dn

  You will see a list of these schema name-spaces, mine looks like:

----

(postgres@[local]:5432) [evergreen] > \dn

       List of schemas

      Name       |   Owner

-----------------+------------

acq             | openils-su

action          | openils-su

action_trigger  | openils-su

actor           | openils-su

asset           | openils-su

auditor         | openils-su

authority       | openils-su

biblio          | openils-su

booking         | openils-su

config          | openils-su

container       | openils-su

evergreen       | openils-su

extend_reporter | openils-su

m_demo          | openils-su

metabib         | openils-su

migration_tools | openils-su

money           | openils-su

offline         | openils-su

permission      | openils-su

public          | postgres

query           | openils-su

reporter        | openils-su

search          | openils-su

serial          | openils-su

staging         | openils-su

stats           | openils-su

unapi           | openils-su

vandelay        | openils-su

(28 rows)

 

---

 

Then within each Schema is a set of tables, my current favourite thing to
play with is action_triggers, so lets look there:

---

(postgres@[local]:5432) [evergreen] > \dt action_trigger.*

                   List of relations

     Schema     |       Name       | Type  |   Owner

----------------+------------------+-------+------------

action_trigger | cleanup          | table | openils-su

action_trigger | collector        | table | openils-su

action_trigger | environment      | table | openils-su

action_trigger | event            | table | openils-su

action_trigger | event_definition | table | openils-su

action_trigger | event_output     | table | openils-su

action_trigger | event_params     | table | openils-su

action_trigger | hook             | table | openils-su

action_trigger | reactor          | table | openils-su

action_trigger | validator        | table | openils-su

(10 rows)

---

So, 10 tables in that schema.  Notice that tables are fully qualified, like
action_trigger.cleanup then a column would be action_trigger.cleanup.id.

 

--

David Busby

Managing Director

Edoceo, Inc.

http://edoceo.com/

206.282.6500

 

 

 

On Wed, Jan 4, 2012 at 11:37 PM, darshan <dkhot at dreamsoftech.com> wrote:

> Hi,

> 

> We even call database evergreen , then to No tables were found.  

> Please refer the Attachment and Guide us.

> 

> Thanks

> Darshan Khot

> ----------------------------------------------------------------------

> ------

> ----------------------------------------------------------------------

> ------

> ----------------------------------------------------------------------

> ------

> ---------------------------

> -----Original Message-----

> From: open-ils-dev-bounces at list.georgialibraries.org

> [mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of 

> open-ils-dev-request at list.georgialibraries.org

> Sent: Wednesday, January 04, 2012 10:30 PM

> To: open-ils-dev at list.georgialibraries.org

> Subject: Open-ils-dev Digest, Vol 70, Issue 3

> 

> Send Open-ils-dev mailing list submissions to

>        open-ils-dev at list.georgialibraries.org

> 

> To subscribe or unsubscribe via the World Wide Web, visit

>        

> http://libmail.georgialibraries.org/mailman/listinfo/open-ils-dev

> or, via email, send a message with subject or body 'help' to

>        open-ils-dev-request at list.georgialibraries.org

> 

> You can reach the person managing the list at

>        open-ils-dev-owner at list.georgialibraries.org

> 

> When replying, please edit your Subject line so it is more specific 

> than

> "Re: Contents of Open-ils-dev digest..."

> 

> 

> Today's Topics:

> 

>   1. Re: No tables in database (Jason Stephenson)

> 

> 

> ----------------------------------------------------------------------

> 

> Message: 1

> Date: Wed, 04 Jan 2012 08:56:32 -0500

> From: Jason Stephenson <jstephenson at mvlc.org>

> Subject: Re: [OPEN-ILS-DEV] No tables in database

> To: open-ils-dev at list.georgialibraries.org

> Message-ID: <20120104085632.24773ay15os2yjs4 at mail.mvlc.org>

> Content-Type: text/plain; charset=ISO-8859-1; DelSp="Yes";

>        format="flowed"

> 

> Quoting darshan <dkhot at dreamsoftech.com>:

> 

>> Hi,

>> 

>> I checked in database but I couldn't find table that you mention. In 

>> fact there was no single table in database. Please see attached 

>> screenshot and guide me if I am referring wrong database.

> 

> You are looking at the wrong database. When you run psql add -d 

> evergreen on the command line, like so:

> 

> psql -d evergreen

> 

> That should get you into the right database.

> 

> Jason

> 

> 

>> 

>> Thanks

>> Darshan

> 

> 

> 

> End of Open-ils-dev Digest, Vol 70, Issue 3

> *******************************************

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20120105/a886665c/attachment-0001.htm>