Re: [Kexi] Postgresql and Kexi 2.2 import database working?
I think there is problem with reading the data, when the record has this entry, Mr. Bill O'Neilly WARNING: nonstandard use of \' in a string literal LINE 1: INSERT INTO customer VALUES (14,'Mr ','Bill','O\''Neill','2... ^ HINT: Use '' to write quotes in strings, or use the escape string syntax (E'...'). Noli ` transaction committed more than once kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() || cursor->storeCurrentRow(data) m_sql= "SELECT o_id, o_type, o_name, o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='barcode' AND o_type=1 LIMIT 1" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "barcode_pkey" for table "barcode" kexi(7247)/KexiDB KexiDB::Connection::querySingleString: Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() "SELECT o_id FROM kexi__objects WHERE o_type=1 AND lower(o_name)='barcode' LIMIT 1" kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() || cursor->storeCurrentRow(data) m_sql= "SELECT o_id, o_type, o_name, o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='customer' AND o_type=1 LIMIT 1" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "customer_pkey" for table "customer" kexi(7247)/KexiDB KexiDB::Connection::querySingleString: Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() "SELECT o_id FROM kexi__objects WHERE o_type=1 AND lower(o_name)='customer' LIMIT 1" kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() || cursor->storeCurrentRow(data) m_sql= "SELECT o_id, o_type, o_name, o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='item' AND o_type=1 LIMIT 1" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "item_pkey" for table "item" kexi(7247)/KexiDB KexiDB::Connection::querySingleString: Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() "SELECT o_id FROM kexi__objects WHERE o_type=1 AND lower(o_name)='item' LIMIT 1" kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() || cursor->storeCurrentRow(data) m_sql= "SELECT o_id, o_type, o_name, o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='orderinfo' AND o_type=1 LIMIT 1" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "orderinfo_pkey" for table "orderinfo" kexi(7247)/KexiDB KexiDB::Connection::querySingleString: Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() "SELECT o_id FROM kexi__objects WHERE o_type=1 AND lower(o_name)='orderinfo' LIMIT 1" kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() || cursor->storeCurrentRow(data) m_sql= "SELECT o_id, o_type, o_name, o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='orderline' AND o_type=1 LIMIT 1" kexi(7247)/KexiDB KexiDB::Connection::querySingleString: Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() "SELECT o_id FROM kexi__objects WHERE o_type=1 AND lower(o_name)='orderline' LIMIT 1" kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() || cursor->storeCurrentRow(data) m_sql= "SELECT o_id, o_type, o_name, o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='stock' AND o_type=1 LIMIT 1" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "stock_pkey" for table "stock" kexi(7247)/KexiDB KexiDB::Connection::querySingleString: Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() "SELECT o_id FROM kexi__objects WHERE o_type=1 AND lower(o_name)='stock' LIMIT 1" transaction committed more than once WARNING: nonstandard use of \' in a string literal LINE 1: INSERT INTO customer VALUES (14,'Mr ','Bill','O\''Neill','2... ^ HINT: Use '' to write quotes in strings, or use the escape string syntax (E'...'). ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Python Script and Kexi2.2
On 3 September 2010 10:32, Adam Pigg wrote: > Scripts should be available in any languages supported by Kross. > > On my system i have python and javascript/qtscript (qtscript is better!). > > I just choose to write in js in the examples because i dont know python :) > Of course, I misunderstood. So, there's a fresh example from Adam (but in Javascript): http://kde-files.org/content/show.php?content=129683 -- regards / pozdrawiam, Jaroslaw Staniek http://www.linkedin.com/in/jstaniek Kexi & KOffice (http://kexi-project.org, http://identi.ca/kexi, http://koffice.org) KDE Software Development Platform on MS Windows (http://windows.kde.org) ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Postgresql and Kexi 2.2 import database working?
Adam It does not work in my side. I just lost my sample database in the postgresql server when I tried creating first the same database in kexi and then tried to import the database. I am using ubuntu 10.04. I have been waiting for 15 minutes and nothing happened. n...@noli-laptop:~$ kexi kexi(7516)/kdecore (services) KMimeTypeFactory::parseMagic: Now parsing "/usr/share/mime/magic" kexi(7516)/kio (KDirModel) KDirModelPrivate::_k_slotDeleteItems: No node found for item that was just removed: KUrl("file:///home/noli/Documents/OtagoData") kexi(7516)/kio (KDirModel) KDirModelPrivate::_k_slotDeleteItems: No node found for item that was just removed: KUrl("file:///home/noli/Documents/OtagoData") kDebugStream called after destruction (from virtual KexiDB::AlterTableHandler::MoveFieldPositionAction::~MoveFieldPositionAction() file ../../../kexi/kexidb/alter.cpp line 717) 0xb6854fa0 kDebugStream called after destruction (from virtual KexiDB::AlterTableHandler::FieldActionBase::~FieldActionBase() file ../../../kexi/kexidb/alter.cpp line 105) 0xb6854fa0 kDebugStream called after destruction (from virtual KexiDB::AlterTableHandler::ActionBase::~ActionBase() file ../../../kexi/kexidb/alter.cpp line 57) 0xb6854fa0 kDebugStream called after destruction (from virtual KexiDB::AlterTableHandler::InsertFieldAction::~InsertFieldAction() file ../../../kexi/kexidb/alter.cpp line 571) 0xb6854f80 kDebugStream called after destruction (from virtual KexiDB::AlterTableHandler::FieldActionBase::~FieldActionBase() file ../../../kexi/kexidb/alter.cpp line 105) 0xb6854f80 kDebugStream called after destruction (from virtual KexiDB::AlterTableHandler::ActionBase::~ActionBase() file ../../../kexi/kexidb/alter.cpp line 57) 0xb6854f80 kDebugStream called after destruction (from virtual KexiDB::AlterTableHandler::RemoveFieldAction::~RemoveFieldAction() file ../../../kexi/kexidb/alter.cpp line 492) 0xb6854f68 kDebugStream called after destruction (from virtual KexiDB::AlterTableHandler::FieldActionBase::~FieldActionBase() file ../../../kexi/kexidb/alter.cpp line 105) 0xb6854f68 kDebugStream called after destruction (from virtual KexiDB::AlterTableHandler::ActionBase::~ActionBase() file ../../../kexi/kexidb/alter.cpp line 57) 0xb6854f68 kDebugStream called after destruction (from virtual KexiDB::AlterTableHandler::ChangeFieldPropertyAction::~ChangeFieldPropertyAction() file ../../../kexi/kexidb/alter.cpp line 209) 0xb6854f40 kDebugStream called after destruction (from virtual KexiDB::AlterTableHandler::FieldActionBase::~FieldActionBase() file ../../../kexi/kexidb/alter.cpp line 105) 0xb6854f40 kDebugStream called after destruction (from virtual KexiDB::AlterTableHandler::ActionBase::~ActionBase() file ../../../kexi/kexidb/alter.cpp line 57) 0xb6854f40 n...@noli-laptop:~$ Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Postgresql and Kexi 2.2 import database working?
Ive just tried by importing a reasonably large database from a postgres server into a new database on the same server. It worked a charm...there whas a long delay after pressing the last 'next' button while it copied all the data, but it ultimately finished ok. Let us know if you ahve further problems. Adam On Friday 03 September 2010 13:05:55 Noli Sicad wrote: > Here's the log. Noli > ~ > > n...@noli-laptop:~$ kexi > kexi(6542)/kdecore (services) KMimeTypeFactory::parseMagic: Now > parsing "/usr/share/mime/magic" > kexi(6542)/KexiDB (driver impl) KexiDB::pqxxSqlCursor::drv_open: > pqxxSqlCursor::drv_open:exception - "ERROR: relation "kexi__db" does > not exist > LINE 1: SELECT db_value FROM kexi__db WHERE db_property='kexidb_majo... > ^ > " > kexi(6542)/KexiDB KexiDB::Connection::querySingleString: > Connection::querySingleRecord(): !executeQuery() "SELECT db_value > FROM kexi__db WHERE db_property='kexidb_major_ver' LIMIT 1" > kexi(6542)/kio (KDirModel) KDirModelPrivate::_k_slotDeleteItems: No > node found for item that was just removed: > KUrl("file:///home/noli/Documents/OtagoData") > kexi(6542)/kio (KDirModel) KDirModelPrivate::_k_slotDeleteItems: No > node found for item that was just removed: > KUrl("file:///home/noli/Documents/OtagoData") > Closing connection while nontransaction still open > > On 9/3/10, Adam Pigg wrote: > > Have you any output at the console to aid in this? > > > > Noli Sicad wrote: > >> Hi, > >> > >> I am moving away from Sqlite3 still there is no support at this > >> moment. I am migrating to postgresql / PostGIS and trying to import > >> the data in Kexi2.2 > >> > >> > >> I am trying to import database from postgresql to Kexi 2.2 now. It is > >> connecting to the postgresql database but in the last stage of import > >> the database. It is stuck in "Importing" Form, the last stage next to > >> Finish. > >> > >> Now, is the Postgresql and Kexi 2,2 import database working? > >> > >> Thanks. > >> > >> Noli > > > > ___ > > Kexi mailing list > > Kexi@kde.org > > https://mail.kde.org/mailman/listinfo/kexi ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Postgresql and Kexi 2.2 import database working?
That looks like you are importing into a non-kexi database. Try: Create a blank database on the server using kexi Import from your other database into this one. Adam On Friday 03 September 2010 13:05:55 Noli Sicad wrote: > Here's the log. Noli > ~ > > n...@noli-laptop:~$ kexi > kexi(6542)/kdecore (services) KMimeTypeFactory::parseMagic: Now > parsing "/usr/share/mime/magic" > kexi(6542)/KexiDB (driver impl) KexiDB::pqxxSqlCursor::drv_open: > pqxxSqlCursor::drv_open:exception - "ERROR: relation "kexi__db" does > not exist > LINE 1: SELECT db_value FROM kexi__db WHERE db_property='kexidb_majo... > ^ > " > kexi(6542)/KexiDB KexiDB::Connection::querySingleString: > Connection::querySingleRecord(): !executeQuery() "SELECT db_value > FROM kexi__db WHERE db_property='kexidb_major_ver' LIMIT 1" > kexi(6542)/kio (KDirModel) KDirModelPrivate::_k_slotDeleteItems: No > node found for item that was just removed: > KUrl("file:///home/noli/Documents/OtagoData") > kexi(6542)/kio (KDirModel) KDirModelPrivate::_k_slotDeleteItems: No > node found for item that was just removed: > KUrl("file:///home/noli/Documents/OtagoData") > Closing connection while nontransaction still open > > On 9/3/10, Adam Pigg wrote: > > Have you any output at the console to aid in this? > > > > Noli Sicad wrote: > >> Hi, > >> > >> I am moving away from Sqlite3 still there is no support at this > >> moment. I am migrating to postgresql / PostGIS and trying to import > >> the data in Kexi2.2 > >> > >> > >> I am trying to import database from postgresql to Kexi 2.2 now. It is > >> connecting to the postgresql database but in the last stage of import > >> the database. It is stuck in "Importing" Form, the last stage next to > >> Finish. > >> > >> Now, is the Postgresql and Kexi 2,2 import database working? > >> > >> Thanks. > >> > >> Noli > > > > ___ > > Kexi mailing list > > Kexi@kde.org > > https://mail.kde.org/mailman/listinfo/kexi ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Postgresql and Kexi 2.2 import database working?
Here's the log. Noli ~ n...@noli-laptop:~$ kexi kexi(6542)/kdecore (services) KMimeTypeFactory::parseMagic: Now parsing "/usr/share/mime/magic" kexi(6542)/KexiDB (driver impl) KexiDB::pqxxSqlCursor::drv_open: pqxxSqlCursor::drv_open:exception - "ERROR: relation "kexi__db" does not exist LINE 1: SELECT db_value FROM kexi__db WHERE db_property='kexidb_majo... ^ " kexi(6542)/KexiDB KexiDB::Connection::querySingleString: Connection::querySingleRecord(): !executeQuery() "SELECT db_value FROM kexi__db WHERE db_property='kexidb_major_ver' LIMIT 1" kexi(6542)/kio (KDirModel) KDirModelPrivate::_k_slotDeleteItems: No node found for item that was just removed: KUrl("file:///home/noli/Documents/OtagoData") kexi(6542)/kio (KDirModel) KDirModelPrivate::_k_slotDeleteItems: No node found for item that was just removed: KUrl("file:///home/noli/Documents/OtagoData") Closing connection while nontransaction still open On 9/3/10, Adam Pigg wrote: > Have you any output at the console to aid in this? > > Noli Sicad wrote: > >> Hi, >> >> I am moving away from Sqlite3 still there is no support at this >> moment. I am migrating to postgresql / PostGIS and trying to import >> the data in Kexi2.2 >> >> >> I am trying to import database from postgresql to Kexi 2.2 now. It is >> connecting to the postgresql database but in the last stage of import >> the database. It is stuck in "Importing" Form, the last stage next to >> Finish. >> >> Now, is the Postgresql and Kexi 2,2 import database working? >> >> Thanks. >> >> Noli > > > ___ > Kexi mailing list > Kexi@kde.org > https://mail.kde.org/mailman/listinfo/kexi > ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Postgresql and Kexi 2.2 import database working?
Have you any output at the console to aid in this? Noli Sicad wrote: > Hi, > > I am moving away from Sqlite3 still there is no support at this > moment. I am migrating to postgresql / PostGIS and trying to import > the data in Kexi2.2 > > > I am trying to import database from postgresql to Kexi 2.2 now. It is > connecting to the postgresql database but in the last stage of import > the database. It is stuck in "Importing" Form, the last stage next to > Finish. > > Now, is the Postgresql and Kexi 2,2 import database working? > > Thanks. > > Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Postgresql and Kexi 2.2 import database working?
Hi, I am moving away from Sqlite3 still there is no support at this moment. I am migrating to postgresql / PostGIS and trying to import the data in Kexi2.2 I am trying to import database from postgresql to Kexi 2.2 now. It is connecting to the postgresql database but in the last stage of import the database. It is stuck in "Importing" Form, the last stage next to Finish. Now, is the Postgresql and Kexi 2,2 import database working? Thanks. Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Python Script and Kexi2.2
Hi Adam, Thanks for the example. Noli On 9/3/10, Adam Pigg wrote: > Yes, i wrote one last night! :) > > At the bottom of: > http://userbase.kde.org/Kexi#Documentation.2C_Tutorials_and_Samples > > is a link to > http://kde-files.org/content/show.php?content=129683 > > Adam > > On Friday 03 September 2010 09:50:07 Noli Sicad wrote: >> Hi Adam, >> >> Do you have any kexi2.2 example that uses javascript to share. >> >> I think Kexi2.2 needs examples. I wonder why there is no template >> available. I am using Ubuntu 10.04 >> >> Noli >> >> On 9/3/10, Adam Pigg wrote: >> > Scripts should be available in any languages supported by Kross. >> > >> > On my system i have python and javascript/qtscript (qtscript is >> > better!). >> > >> > I just choose to write in js in the examples because i dont know python >> > :) >> > >> > Adam >> > >> > Jaroslaw Staniek wrote: >> >> On 2 September 2010 04:56, Noli Sicad wrote: >> >>> Hi, >> >>> >> >>> I am searching the net for Python and Kexi2.2. It seems no entry. Is >> >>> python script working in Kexi2.2? >> >> >> >> No, this addition and scripts for other languages is planned to be >> >> available again in 2.4. >> > >> > ___ >> > Kexi mailing list >> > Kexi@kde.org >> > https://mail.kde.org/mailman/listinfo/kexi > ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Python Script and Kexi2.2
Yes, i wrote one last night! :) At the bottom of: http://userbase.kde.org/Kexi#Documentation.2C_Tutorials_and_Samples is a link to http://kde-files.org/content/show.php?content=129683 Adam On Friday 03 September 2010 09:50:07 Noli Sicad wrote: > Hi Adam, > > Do you have any kexi2.2 example that uses javascript to share. > > I think Kexi2.2 needs examples. I wonder why there is no template > available. I am using Ubuntu 10.04 > > Noli > > On 9/3/10, Adam Pigg wrote: > > Scripts should be available in any languages supported by Kross. > > > > On my system i have python and javascript/qtscript (qtscript is better!). > > > > I just choose to write in js in the examples because i dont know python > > :) > > > > Adam > > > > Jaroslaw Staniek wrote: > >> On 2 September 2010 04:56, Noli Sicad wrote: > >>> Hi, > >>> > >>> I am searching the net for Python and Kexi2.2. It seems no entry. Is > >>> python script working in Kexi2.2? > >> > >> No, this addition and scripts for other languages is planned to be > >> available again in 2.4. > > > > ___ > > Kexi mailing list > > Kexi@kde.org > > https://mail.kde.org/mailman/listinfo/kexi ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Python Script and Kexi2.2
Hi Adam, Do you have any kexi2.2 example that uses javascript to share. I think Kexi2.2 needs examples. I wonder why there is no template available. I am using Ubuntu 10.04 Noli On 9/3/10, Adam Pigg wrote: > Scripts should be available in any languages supported by Kross. > > On my system i have python and javascript/qtscript (qtscript is better!). > > I just choose to write in js in the examples because i dont know python :) > > Adam > > Jaroslaw Staniek wrote: > >> On 2 September 2010 04:56, Noli Sicad wrote: >>> Hi, >>> >>> I am searching the net for Python and Kexi2.2. It seems no entry. Is >>> python script working in Kexi2.2? >> >> No, this addition and scripts for other languages is planned to be >> available again in 2.4. >> > > > ___ > Kexi mailing list > Kexi@kde.org > https://mail.kde.org/mailman/listinfo/kexi > ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Simple Kexi2.2 Example Database with Python Script
Noli Sicad wrote: > Hi, > > I am trying to use Kexi2.2 as data input and result reporting for my > linear programming model. I use glpk/mathprog that uses odbc to > reading data as input and writing data for results. My linear > programming model uses sqlite/spatialite database / file. > > I manage to import my mdb database to Kexi and I can open it sqlite > and spatialite. Hopefully, I can data - tables / spatial data thru > linear programming model - scripting language -mathprog and still be > able to read back in Kexi. > > I am looking for a simple kexi2.2 database example that uses python > script. To see how python script works in Kexi. > > Where can I get the kexi database that is mentioned here? > http://www.kdedevelopers.org/node/3933 If you look at the bottom of http://userbase.kde.org/Kexi#Documentation.2C_Tutorials_and_Samples Ive made a simple example of reading in data via javascript. Hope it can be useful to you. > > It seems that there are very few documentation on Kexi2.2. > > Thanks in advance. > > Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Python Script and Kexi2.2
Scripts should be available in any languages supported by Kross. On my system i have python and javascript/qtscript (qtscript is better!). I just choose to write in js in the examples because i dont know python :) Adam Jaroslaw Staniek wrote: > On 2 September 2010 04:56, Noli Sicad wrote: >> Hi, >> >> I am searching the net for Python and Kexi2.2. It seems no entry. Is >> python script working in Kexi2.2? > > No, this addition and scripts for other languages is planned to be > available again in 2.4. > ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi