Hi
I am about to publish a Gui front end to sqlite3



There are a lot of firsts here. This is my first Python program, my first gtk
my first debian package etc.

Any help apreciated.

I have a problem with the packaging.


I have a sources structure as below:-

~/sources/usr/bin/datable
~/sources/usr/share/applications/hildon/datables.desktop
~/sources/usr/share/pixmaps/datables.png ( 26X26 icon )

contents of .desktop

[Desktop Entry]
Encoding=UTF-8
Version=0.0.1
Type=Application
Name=datable
Exec=/usr/bin/datable
Icon=datable
X-Window-Icon=datable
X-Window-Icon-Dimmed=datable
X-Osso-Service=datable
X-Osso-Type=application/x-executable

used pypackager to create .deb

installed through 'application manager' puts datables with icon into extras
menu and datables executable into /usr/bin. The png is in the pixmaps folder.

When selected from menu I get 'datable - loading' and then nothing.

EDIT: Missed a bit.

when run from the command line the prog runs fine with no errors.

when run on my Linux box ( without the hildon bits ) xprop reports
WM_CLASS(STRING) = "datable", "Datable" --- Which one is right ?
Does it matter ?

Any suggestions welcome

Thanks Rick

you need a .service file

EDIT: it's also possible you have a runtime error: have you tried running your app from the command line?

Cripes

Thanks for the reply.
I had edited my original post with extra info while you were answering. It works fine from the command line.

I've looked up .service files and added the following in /usr/share/dbus-1/services/datable.service

[D-BUS Service]
Name=datable
Exec=/usr/bin/datable

and restarted - still no joy any suggestions gratefully recieved.

Thanks Rick

Try with:
[D-BUS Service]
Name=com.nokia.datable
Exec=/usr/bin/datable

Moreover, you need initialize the osso service in your python app:

import osso
context = osso.Context("datable", "0.0.1", False)

Thanks guys.

The combination now runs. I will be publishing in the garage shortly.

Thanks again for your help - Please try the prog out when published

Rick

post again when its ready.

btw, you don't have to use com.nokia as the domain prefix, you just have to use some domain prefix otherwise libosso will prepend com.nokia. Also I don't think that you actually need to import the osso module unless you actually want to make or receive osso dbus calls (for e.g. file manager will pass a mime_open dbus message when you double click on a file to an apps that has a compatible mime type association -- in your case you could set up a mimetype assocation to sqlite3 compatible databases)

Will this be running under 2008OS? If so, will it include an install of sqlite3? I and several others have been unable to locate sqlite version 3 - all we've managed so far is 2.8.17

So the GUI is kind of a moot point without the db

dpkg -l | grep sqli
ii libsqlite3-0 3.4.1-1osso3 SQLite 3 shared library


sqlite3 is installed by default
Or did I misunderstand the question?

and there are already a lot of default installed package using this lib:

apt-cache rdepends libsqlite3-0
libsqlite3-0
Reverse Depends:
libimlogger0
libmetalayer0
osso-chat-ui
osso-software-version
osso-mission-control
pidgin
osso-software-version
osso-imlogviewer
osso-mission-control
osso-imlogviewer
mapper
libsqlite3-dev
rapier
liblightmediascanner0
libgda3-sqlite
libgda3-virtual
libgda3-report
libgda3-sqlite
libgda3-virtual
libgda3-report
python2.5-lightmediascanner
pidgin
python2.5
maemo-mapper
maemopadplus
maemoscrobbler
gcompris

And here is a command line tool

Bizshop
The thread title is probably misleading what is actually used here is pysqlite3 - part of the python 2.5 install. The program is for all architectures and is available at :

https://garage.maemo.org/frs/downloa...-0.0.4.all.deb

see also the Announce thread :

http://www.internettablettalk.com/fo...ad.php?t=15594

The app will open ( and or create ) all sqlite3 dbs.

Rick