Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>This problem has no solution if you strictly want this script "to be called from another program. by issuing 'python script.py' on command line". If you want to do the "heavy import" only once, you have to start python script only once. Think about starting a daemon, which will start once and then process calls from other program. This way all initialization has to be done only one time and next calls will be fast. And if you split your python code into two parts (first part for daemon, second for daemon client), you'll be able to call 'python client.py' from another program, but actual computation will be performed by daemon, which is started just one time.</p> <p>As example:</p> <p><strong>daemon.py</strong></p> <pre><code>import socket #import arcpy def actual_work(): #val = arcpy.GetCellValue_management("D:\dem-merged\lidar_wsg84", "-95.090174910630012 29.973962146120652", "") #return str(val) return 'dummy_reply' def main(): sock = socket.socket( socket.AF_INET, socket.SOCK_DGRAM ) try: sock.bind( ('127.0.0.1', 6666) ) while True: data, addr = sock.recvfrom( 4096 ) reply = actual_work() sock.sendto(reply, addr) except KeyboardInterrupt: pass finally: sock.close() if __name__ == '__main__': main() </code></pre> <p><strong>client.py</strong></p> <pre><code>import socket import sys def main(): sock = socket.socket( socket.AF_INET, socket.SOCK_DGRAM ) sock.settimeout(1) try: sock.sendto('', ('127.0.0.1', 6666)) reply, _ = sock.recvfrom(4096) print reply except socket.timeout: sys.exit(1) finally: sock.close() if __name__ == '__main__': main() </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POExecute python code without invoking import statement each time
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USAlex Laskin
    1. USAlex Laskin
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POExecute python code without invoking import statement each time
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COCompare fastcgi, spamassassin's spamd, or emacsclient. Perhaps Pyro could help do the separation.
      singulars
      1. PO
      1. USYann Vernier
    2. COPyro looks nice, but I think it is an overkill. Plain UDP sockets is a simplest way to get short text data from daemon on localhost.
      singulars
      1. PO
      1. USAlex Laskin
    3. COThanks Alex. That worked!
      singulars
      1. PO
      1. USShaunak
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload