Path: csiph.com!usenet.pasdenom.info!gegeweb.org!de-l.enfer-du-nord.net!feeder2.enfer-du-nord.net!newsfeed.eweka.nl!eweka.nl!feeder3.eweka.nl!newsfeed.xs4all.nl!newsfeed1.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Newsgroups: comp.lang.python
Date: Sat, 22 Dec 2012 04:38:11 -0800 (PST)
In-Reply-To: <mailman.1194.1356176640.29569.python-list@python.org>
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=81.217.27.214; posting-account=cEKlTgoAAACa82UEsarDnR5Dm6ErawNg
References: <ab077ea4-2cfd-4769-afa7-b0cd0045e2d6@googlegroups.com> <mailman.1194.1356176640.29569.python-list@python.org>
User-Agent: G2/1.0
MIME-Version: 1.0
Subject: Re: [Help] [Newbie] Require help migrating from Perl to Python 2.7 (namespaces)
From: prilisauer@googlemail.com
To: comp.lang.python@googlegroups.com
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Cc: python-list@python.org
Precedence: list
Message-ID: <mailman.1196.1356179894.29569.python-list@python.org>
Lines: 170
NNTP-Posting-Host: 2001:888:2000:d::a6
Xref: csiph.com comp.lang.python:35358

Am Samstag, 22. Dezember 2012 12:43:54 UTC+1 schrieb Peter Otten:
>  wrote:
>=20
>=20
>=20
> > Hello, to all,
>=20
> >=20
>=20
> > I hope I can describe me problem correctly.
>=20
> >=20
>=20
> > I have written a Project split up to one Main.py and different modules
>=20
> > which are loaded using import and here is also my problem:
>=20
> >=20
>=20
> > 1. Main.py executes:
>=20
> > 2. Import modules
>=20
> > 3. One of the Modules is a SqliteDB datastore.
>=20
> > 4. A second module creates an IPC socket.
>=20
> > 5. Here is now my problem :
>=20
> >     The IPC Socket should run a sub which is stored ad SqliteDB and
>=20
> >     returns all Rows.
>=20
> >=20
>=20
> > Is there a elegant way to solve it? except a Queue. Is it possible to
>=20
> > import modules multiple?!=20
>=20
>=20
>=20
> If you import a module more than once code on the module level will be=20
>=20
> executed the first time only. Subsequent imports will find the ready-to-u=
se=20
>=20
> module object in a cache (sys.modules).
>=20
>=20
>=20
> > I'm unsure because the open DB file at another
>=20
> > module.
>=20
> >=20
>=20
> > How is this solved in bigger projects?
>=20
>=20
>=20
> If I'm understanding you correctly you have code on the module level that=
=20
>=20
> creates a socket or opens a database. Don't do that!
>=20
> Put the code into functions instead. That will give the flexibility you n=
eed=20
>=20
> for all sizes of projects. For instance
>=20
>=20
>=20
> socket_stuff.py
>=20
>=20
>=20
> def send_to_socket(rows):
>=20
>     socket =3D ... # open socket
>=20
>     for row in rows:
>=20
>         # do whatever it takes to serialize the row
>=20
>     socket.close()
>=20
>=20
>=20
> database_stuff.py
>=20
>=20
>=20
> def read_table(dbname, tablename):
>=20
>     if table not in allowed_table_names:
>=20
>         raise ValueError
>=20
>     db =3D sqlite3.connect(dbname)
>=20
>     cursor =3D db.cursor()
>=20
>     for row in cursor.execute("select * from %s" % tablename):
>=20
>         yield row
>=20
>     db.close()
>=20
>=20
>=20
>=20
>=20
> main.py
>=20
>=20
>=20
> import socket_stuff
>=20
> import database_stuff
>=20
>=20
>=20
> if __name__ =3D=3D "__main__":
>=20
>     socket_stuff.send_to_socket(
>=20
>         database_stuff.read_table("some_db", "some_table"))

Hello Thanks for that answer:
I think I have to write it a bit larger,

This isn't a real code, but it for better overview:
                        main.py
          /        /             \             \
-------------------------------------------------------------------
Datastore  |  ModbusClient  | DaliBusClient | Advanced Scheduler
--------------------------------------------------------------------


Main.py:
import Datastore
Datastore.startup()
....
(Everything should run in threads)=20

Datastore.py
# Opens a SQLite DB
# Contains Queries to serve data for other mods
# Central point for updating / Quering etc.

ModbusClient.py
# Opens TCP connection to Modbus Device
!!! Here it's interesting !!!
This module contains predefined Queries and functions
IF I START A FUNCTION a SQL should be executed in Datastore.py


DaliBusClient.py
#Lamps, etc. Functions.=20
# Stored Informations should be kept in Datastore
# Advanced scheduler


I don't know, Python allways looks for me like a one script "File". But the=
re are big projects. like the the "Model of an SQL Server", using coordinat=
ors no problems running threads and exchange Data through a Backbone. I hav=
e searched a lot, but I havent find anything to write the "core" splited up=
 into modules and geting over the scopes etc.

DO I have anything forgotten?! everything unclear?? :-P