Re: Patch for acinclude.m4

On July 21, 2005 04:21 am, Christian Stimming wrote: > Chris Shoemaker schrieb: > > On Wed, Jul 20, 2005 at 10:28:14PM -0400, Phil Longstaff wrote: > > Thanks, Phil, for your better patch about the GNOME2_PATH -- obviously I > hadn't thought this through. So your change sho

G2 bug

There is a bug in G2 when the "create saved transactions since last" dialog opens. The dialog grows vertically constantly at about 8-9 Hz (small jumps per sec). I took a quick look but haven't yet found where this would happen. Phil ___ gnucash-devel

Re: A couple of questions

* GDA. Maybe Phil wants some help? I'd be happy for some help. The GDA project will replace the old postgresql backend with a GDA (Gnome Data Access) backend. GDA provides a GObject-based interface to any db provider. If you want to help, just e-mail me and I'll let you know how to get

Re: A couple of questions

Phil, the latest code in gda-dev branch is not compiling. Here is the error I got: Yes, I know. For various reasons, I have been unable to fix that until now. I will commit a fix later today. Phil ___ gnucash-devel mailing list gnucash-devel@gn

Merging trunk changes into branches

Are there any guidelines on merging changes in trunk into a branch or changes from another branch into a branch? Merging from the trunk would allow me to keep up with bug fixes and other changes and make the future merge back into the trunk easier. Merging in other branches could make my job e

GDA status

I hit a number of roadblocks. 1) My development machine died 2) After I replaced it, I got myself locked out of gnucash subversion 3) I "upgraded" to libgda 2.99.5 which introduced a show-stopper bug. I'm now back to 2.99.3 (2.99.4 was very short-lived) and will be able to continue work. Phil _

PATCH: fix KVP bug/allow gnc_numeric to be a GBoxed value

The attached patch does two things: 1) Fixes a KVP bug where kvp_frame_add_value_nc() wouldn't properly create a frame which didn't previously exist. The problem was that by the time the routine realized it needed to create the path, the variable holding the path had been overwritten. 2) Add

PATCH: convert some routines to take const object pointers

The attached patch modifies some getter routine signatures to convert object pointers to const object pointers. Phil diffs Description: 2814508393-diffs ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinf

GDA: Recent SX changes in trunk/GObject questions

I've merged up-to-date trunk into the gda branch (though it's not completely committed). Scheduled transaction structure has changed. In addition, account groups have been replaced by root accounts. My plan is to have a book table with a record with (currently) two fields. The first is the r

PATCH: add begin/edit edit when reading price quotes

This patch adds a begin_edit/commit_edit pair when retrieving price quotes. Phil diff Description: 640906974-diff ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel

First pass at "save as" functionality for GDA backends

I've just committed the first pass at the "save as" functionality for GDA backends. I am concentrating on the backend at this point, not on proper integration into menus and the "save as" dialog. Under "Save" and "Save as" in the file menu, I've added "Save as GDA". You need to have "gnucash"

Re: MySQL

Hi William, I have an official project underway to develop a backend for GnuCash using GDA (Gnome Data Access?) which allows different databases to be used, MySQL among them. Progress has been slow, mainly because of my work and home commitments (my family just moved about 2 weeks ago). I pla

Re: r16543 - gnucash/branches/gda-dev/src - Make GDA backend (sqlite) the default if file: or no access method is

Derek Atkins wrote: Phil Longstaff [1]<[EMAIL PROTECTED]> writes: Log: Make GDA backend (sqlite) the default if file: or no access method is supplied. The XML backend is still available if the file is not an sqlite file or if xml: is the access method. Have you verified that y

Re: r16543 - gnucash/branches/gda-dev/src - Make GDA backend (sqlite) the default if file: or no access method is

Derek Atkins wrote: Phil Longstaff [1]<[EMAIL PROTECTED]> writes: The UI doesn't support xml: (or any access method) but it can be entered from the command line i.e. gnucash xml:... Yeah, we should probably fix this.. Or add other "File -> Open" methods to

Re: r16543 - gnucash/branches/gda-dev/src - Make GDA backend (sqlite) the default if file: or no access method is

Josh Sled wrote: > This inverse quoting style is really hard to follow. :/ I think I accidentally sent the e-mail in html format and this is what thunderbird did to it. Phil ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnuca

Re: Problems downloading stock quotes [RESOLVED] possible security issue

What quote source do you use? I know that F::Q reads the html from your quote source and parses the html to find the quote. Perhaps it is downloading the advertising from that site as well. Phil Richard Geddes wrote: Derek, I finally resolved my problem... took a little head

Re: r16612 - gnucash/branches/gda-dev - 1) Merge with trunk up to 16597

Andreas Köhler wrote: Hi Phil, Am Sonntag, den 02.12.2007, 16:29 -0500 schrieb Phil Longstaff: Author: plongstaff Date: 2007-12-02 16:29:35 -0500 (Sun, 02 Dec 2007) Trac: [1]http://svn.gnucash.org/trac/changeset/16612 Log: 1) Merge with trunk up to 16597 2) When inserting into a table

Re: r16628 - gnucash/branches/gda-dev/src/backend/gda - Don't crash when loading null date

Derek Atkins wrote: Phil Longstaff [1]<[EMAIL PROTECTED]> writes: if( gda_value_is_null( val ) ) { -(*setter)( pObject, NULL ); + date = g_date_new_dmy( 1, 1, 1970 ); +(*setter)( pObject, date ); Don't you need to free the date? Yes, I

Thoughts on architecture for the GDA backend

Except for a number of bugs (and a lot of testing, and a load/save UI), the GDA backend basically works for the objects outside of the business objects. I also want to add an audit trail for changes and version support to detect when a db needs to be updated to a newer version. Some thoughts:

Re: Thoughts on architecture for the GDA backend

Derek Atkins wrote: Hi, Phil Longstaff [1]<[EMAIL PROTECTED]> writes: Except for a number of bugs (and a lot of testing, and a load/save UI), the GDA backend basically works for the objects outside of the business objects. I also want to add an audit trail for changes and version s

Re: Thoughts on architecture for the GDA backend

OK. Let me try this again. I'll send as a plain text e-mail instead of HTML and see if that fixes the formatting problem. Derek Atkins wrote: > Hi, > > Phil Longstaff <[EMAIL PROTECTED]> writes: > > >> Except for a number of bugs (and a lot of testing,

Object fields vs slots

What is the rationale uses to decide whether to make an object attribute a field in a structure vs a slot? An Account has the hidden, tax-related and placeholder attributes which are slots rather than fields in the Account structure. What is the reason for that decision? I know slots are use

Timespecs & GDates

Two questions: 1) Can anyone tell me why gnc_price_set_time() takes a Timespec passed by value but the routines in Transaction.h which take Timespecs are passed by reference? It would simplify the gda backend if they were always passed the same way (either by value or by reference, but not bot

Re: r16612 - gnucash/branches/gda-dev - 1) Merge with trunk up to 16597

Andreas Köhler wrote: > Hi Phil, > > Am Sonntag, den 02.12.2007, 16:29 -0500 schrieb Phil Longstaff: > >> Author: plongstaff >> Date: 2007-12-02 16:29:35 -0500 (Sun, 02 Dec 2007) >> Trac: http://svn.gnucash.org/trac/changeset/16612 >> Log: >> 1) Merge w

Re: Timespecs & GDates

Derek Atkins wrote: > Phil Longstaff <[EMAIL PROTECTED]> writes: > > >> Two questions: >> >> 1) Can anyone tell me why gnc_price_set_time() takes a Timespec passed >> by value but the routines in Transaction.h which take Timespecs are >> passed by

Re: r16612 - gnucash/branches/gda-dev - 1) Merge with trunk up to 16597

Derek Atkins wrote: > Phil Longstaff <[EMAIL PROTECTED]> writes: > > >> OK. If you can create a new branch for me, I will move my work over to it. >> > > Done. /branches/gda-dev2 > Please check that I have access. Phil _

Re: r16612 - gnucash/branches/gda-dev - 1) Merge with trunk up to 16597

Derek Atkins wrote: > Quoting Phil Longstaff <[EMAIL PROTECTED]>: > >> Derek Atkins wrote: >>> Phil Longstaff <[EMAIL PROTECTED]> writes: >>> >>> >>>> OK. If you can create a new branch for me, I will move my work >>>> ov

Re: r16612 - gnucash/branches/gda-dev - 1) Merge with trunk up to 16597

Derek Atkins wrote: > Quoting Phil Longstaff <[EMAIL PROTECTED]>: > >>>> Please check that I have access. >>> >>> You should. Have you tried it and access was denied? >> I'm getting: >> >> svn: Commit failed (details follow):

Re: RFC: A "book-close dialog" to help auto-zeroize all Inc/Exp accounts

Derek Atkins wrote: > Hi, > > I decided to spend some time this weekend on a simple dialog to > help you zero-ize your income and expense accounts. I've come > up with a dialog that effective looks like this (please excuse the > ASCII Art but I don't want to have to write the code to actually > fi

Status of GDA backend

I've just checked in the last of the code for the gda backend business objects. The status is: - The code compiles, and on startup, creates the tables - I am using sqlite as my test db. Later, testing will involve other test dbs (mysql but probably not postgresql) - I have done very basic test

Tax tables

With the gda backend, if I open the tax table editor and create a tax table, the tax table is not committed. Is this expected? I assume with the xml backend, it would have been included in the save. Phil ___ gnucash-devel mailing list gnucash-devel@g

Re: Tax tables

Derek Atkins wrote: > Quoting Phil Longstaff <[EMAIL PROTECTED]>: > >> With the gda backend, if I open the tax table editor and create a tax >> table, the tax table is not committed. Is this expected? I assume with >> the xml backend, it would have been included in

Commit access for trunk

Do I have commit access for trunk? For changes which would make the gda backend easier (e.g. further work on converting engine objects to be GObject based), I would prefer to make the change in the trunk and then merge into the GDA branch. If I don't have access, may I have it? Phil

Patch: define properties for gnc_commodity

The attached patch (from svn diff) adds GObject property definitions to the gnc_commodity object. Phil Index: src/engine/gnc-commodity.c === --- src/engine/gnc-commodity.c (revision 16730) +++ src/engine/gnc-commodity.c (working cop

Re: Commit access for trunk

Derek Atkins wrote: > Hi, > > Phil Longstaff <[EMAIL PROTECTED]> writes: > > >> Do I have commit access for trunk? For changes which would make the >> gda backend easier (e.g. further work on converting engine objects to be >> GObject based), I would

Question about business module

I have a question about the tax tables in the business module. struct _book_info contains a GList* tables to contain a list of the tax tables. Items are added and removed from the list, and the list is freed, but I don't see where the list is created. _GncTaxTableCreate() creates the _book_i

Re: Commit access for trunk

Derek Atkins wrote: > Hi, > > Phil Longstaff <[EMAIL PROTECTED]> writes: > > >> Do I have commit access for trunk? For changes which would make the >> gda backend easier (e.g. further work on converting engine objects to be >> GObject based), I would

Re: Commit access for trunk

Derek Atkins wrote: > Quoting Phil Longstaff <[EMAIL PROTECTED]>: > >> Derek Atkins wrote: >>> Hi, >>> >>> Phil Longstaff <[EMAIL PROTECTED]> writes: >>> >>> >>>> Do I have commit access for trunk? For changes whic

UI to access db

Well, I guess it's time to tackle the db selection/UI issues. The gda backend accepts URLs: - gda://: - gda://@ where is the provider name ("sqlite", "mysql" or "pgsql"). If the first form is used, for mysql and pgsql, the dbname is the name of the database, while for sqlite, the dbna

Looking for GDA backend testers

A couple of people have e-mailed me asking if they can test the GDA backend. I think I'm ready for this. Build requirements. I build with libgda 3.0.0 (http://www.gnome-db.org/). It doesn't matter where you put it, but it must be available to pkg-config. If you build with --enable-debug, al

Re: Looking for GDA backend testers

Derek Atkins wrote: > Quoting Phil Longstaff <[EMAIL PROTECTED]>: > >> A couple of people have e-mailed me asking if they can test the GDA >> backend. I think I'm ready for this. >> >> Build requirements. I build with libgda 3.0.0 > > That&

Re: GDA testing

Mark Johnson wrote: > Using: SVN 16836 gda-dev2 branch. > Postgresql 8.2.6 > > 1. start gnucash with --nofile option > 2. open read-only copy of existing xml file. > I assume you mean this was with the "Open file" dialog. Hmmm... I'll look at this (see below). > 3. At this point, the account

Re: GDA testing

Phil Longstaff wrote: > Mark Johnson wrote: > >> Using: SVN 16836 gda-dev2 branch. >> Postgresql 8.2.6 >> >> 1. start gnucash with --nofile option >> 2. open read-only copy of existing xml file. >> >> > I assume you mean this was wit

Re: GDA testing

Mark Johnson wrote: > Mark Johnson wrote: >> In response to your latest e-mail, here is the excerpt from >> /tmp/gnucash.trace: >> * 22:17:29 INFO [gnc_commodity_table_insert] insert >> 0x8452c70 VND into nsp=0x8260fa0 CURRENCY >> * 22:17:29 INFO [gnc_commodity_table_insert] insert >> 0x8452

Re: GDA testing

Mark Johnson wrote: > I have upgraded gnucash to svn 16866, gda-dev2 branch. I remade a > blank db for gnucash in Postgesql and removed the sqlite .db file that > had been created before. > > As before, I started gnucash with the --nofile option. > > Simply opening my old xml file has recreated

Re: GDA referential integrity

Mark Johnson wrote: > Having successfully loaded my xml file into gnucash-gda, I saved it to a > new postgresql database. As Phil mentioned, the performance was poor. > I have several years of data, and it took hours to save. The save > completed sometime during the night, so I don't know exa

Re: bus error on gda branch loading file

David Reiser wrote: > If I start gda-dev2 branch with --nofile, it launches fine, but trying > to open my file leads to a bus error. > > The top of the stack trace is: > > Thread 0 Crashed: > 0 libgncmod-backend-gda.so 0x02af4eb4 gnc_gda_session_begin + > 1296 (gnc-backend-gda.c:246)

Re: PATCH: (gda-dev2): windows changes (sqlite only)

Nathan Buchanan wrote: > ...as I was saying, the attached patch...*ducks* > > On Jan 20, 2008 1:25 AM, Nathan Buchanan <[EMAIL PROTECTED] > > wrote: > > HI Phil, Andreas! > > I'm attaching a patch that gets gda setup for windows. This patch > only deals with s

Re: PATCH: (gda-dev2): deal with windows paths

Nathan Buchanan wrote: > Hi Phil! > > Please find attached a patch that allows the gda backend to work with > windows paths of the form c:\path\to\file.db > > Previously the code in gnc-backend-gda.c tried to eliminate file:// > prefixes by looking for a colon and then removing everything before

Re: GDA: PostgreSQL empty slots table

Mark Johnson wrote: > The slots table includes an id field which is "auto_increment". > PostgreSQL does not implement that keyword. Instead, it appears to > accept it, but ignore it when creating the table. (This may actually be > libgda's PostgreSQL provider doing that.) Gnucash-gda relies

Re: GDA: PostgreSQL empty slots table

Mark Johnson wrote: > Phil Longstaff wrote: >> Mark Johnson wrote: >>> The slots table includes an id field which is "auto_increment". >>> PostgreSQL does not implement that keyword. Instead, it appears to >>> accept it, but ignore it when c

Re: GDA: PostgreSQL empty slots table

Mark Johnson wrote: > Phil Longstaff wrote: >> >> I just saw an e-mail on the libgda mailing list which said that >> GdaQuery might be deprecated in the 4.0 series. > I just saw that too. It is disappointing. You have put in a lot of > work using the GdaQuery. >

Re: GDA: empty PostgreSQL table failed workaround

Mark Johnson wrote: > Previously, I had suggested a workaround for the empty PostgreSQL slots > table problem. > > I have now tried the work-around for the empty slots table problem with > PostgreSQL. The type SERIAL is simply a convenience, and not a real > type. I had hoped the convenience e

Re: GDA: empty PostgreSQL table failed workaround

Derek Atkins wrote: > Hi, > > Phil Longstaff <[EMAIL PROTECTED]> writes: > > >> Saving to the db deletes all tables and then recreates them. It >> therefore deleted the slot_id without the default value. It wouldn't >> have touched the sequence

Re: gda crash in load_owner() with PostgreSQL backend

Graham Menhennitt wrote: > G'day all, > > I've successfully built the gda branch version 16939 from SVN. I can run > it with a normal gnucash data file as the command line parameter and > then save to a PostgreSQL DSN using the File->Database Connection menu > item. By looking in the DB using psql,

Re: GDA save missing records

Derek Atkins wrote: > Mark Johnson <[EMAIL PROTECTED]> writes: > > >> Mark Johnson wrote: >> >>> This appears to be separate from the SERIAL problem of libgda's >>> PostgreSQL provider as PostgreSQL has the highest number of splits. >>> (Most complete? Are there duplicates?) >>> >>> >>>

GDA: Tables for things which are not objects

There are currently 3 tables which handle things which are not objects: 1) slots 2) recurrences 3) tax table entries One thing that the slot_id field provided was an ordering of the slots for a specific object. For slots, the order isn't important. Is there a reason that that recurrences or t

GDA: string lengths (was Re: GDA save missing records)

Graham Leggett wrote: > Keith Bellairs wrote: > >> Speaking as a user and not someone busting his butt on this, I hate >> the idea of "unlimited" everything when we go to a DB. Most of our >> databases have a mechanism (BLOB/CLOB) to store really big things, >> usually at the cost of indexing or

Re: GDA Missing records in SQLite

Graham Menhennitt wrote: > Mark Johnson wrote: > >> PostgreSQL gives a warning for '', but accepts it; it prefers \'. MySql >> takes the ''; I'm not sure about \'. Obviously SQLite won't take the \'. >> >> However, the real problem is that it is not gnucash-gda code which is >> doing the esc

Re: GDA Missing records in SQLite

Graham Menhennitt wrote: > Mark Johnson wrote: > >> PostgreSQL gives a warning for '', but accepts it; it prefers \'. MySql >> takes the ''; I'm not sure about \'. Obviously SQLite won't take the \'. >> >> However, the real problem is that it is not gnucash-gda code which is >> doing the esc

Re: GDA Missing records in SQLite

Graham Leggett wrote: > Phil Longstaff wrote: > >> The providers allow it, GDA allows it, but not all of the GDA >> providers use the facilities. I couldn't find any sqlite3_bind_xxx() >> calls in the GDA sqlite provider, for example. >> >> I agree th

Re: GDA Missing records in SQLite

Graham Leggett wrote: > Phil Longstaff wrote: > >> There is a function to query the backend to see what features it >> supports, but prepared statements is not in that list. Also, if we >> require prepared statements, that might cut out the sqlite backend >> be

Patch to change string escaping so SQLite will work

I've attached a patch to change the default string escape for a single-quote char from backslash single-quote (\') to single-quote single-quote ('') so that SQLite will accept it. A better solution in the long run is the modify the SQLite provider to use prepared statements. The patch affect

Re: [PATCH] windows gda dist fixes

Andreas Köhler wrote: > Hi Nathan, > > On Mi, 2008-03-05 at 15:08 -0500, Nathan Buchanan wrote: >> Hi Phil! > > sorry for interfering :-) No problem. Thanks for committing it. Phil ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lis

Re: GDA spurious save dialog

Mark Johnson wrote: > I see from the ChangeLogs and message traffic that the issues arising > from the missing SQL records have been dealt with. > > I have patched and compiled libgda 3.0.2 with the following two patches: > 1. Escaping of single quotes in strings is corrected. > 2. the patch for t

GDA: Transactions (was Re: Managing large files)

Derek Atkins wrote: > GnuCash itself wont use an RDBMS as a real DB, but rather it'll just > use it as a data store, just like any other data store. IOW, GnuCash > will still want to load all the records into memory every time. This > is just the way GnuCash/QOF currently works, so comparing it

Re: GDA: Transactions (was Re: Managing large files)

Andrew Sackville-West wrote: > On Sun, Mar 09, 2008 at 06:35:01PM -0400, Phil Longstaff wrote: >> Derek Atkins wrote: >> >>> GnuCash itself wont use an RDBMS as a real DB, but rather it'll just >>> use it as a data store, just like any other data store. IO

Re: GDA missing records retest (long)

Mark Johnson wrote: > Now that I've managed to get the data saved to the DBs and the gnucash's > exitted, it is time to check the data in the DBs. > > As a check on the DB data, I created an awk script to count the numbers > of accounts, transactions, and splits in the xml data file. Here is th

GDA: Question about some engine transaction functions

src/engine/Transaction.c has the following functions: static void qofTransSetNum (Transaction *trans, const char *xnum) { if (!qof_begin_edit(&trans->inst)) return; xaccTransSetNum(trans, xnum); qof_commit_edit(&trans->inst); } void xaccTransSetNum (Transaction *tr

Re: GDA: Question about some engine transaction functions

Derek Atkins wrote: > Phil Longstaff <[EMAIL PROTECTED]> writes: > >> src/engine/Transaction.c has the following functions: >> >> static void >> qofTransSetNum (Transaction *trans, const char *xnum) >> { >> if (!qof_begin_edit(&trans-&g

Re: funny dates in register running gda-dev2 branch built from SVN r17061

Hi Karim, I know there is something wrong with how dates are read from the db. I'll fix that next. Phil Karim B wrote: > I just built the gda-dev2 branch on a windows XP system. I installed it > on my test system and started it with the following command line: > > "c:\Program Files\gnucash\bi

Re: GDA missing records retest (long)

Mark Johnson wrote: > While looking at the PostgreSQL error log, I also noted the following error: > ERROR: relation "books" does not exist > STATEMENT: INSERT INTO books (guid, root_account_guid, > root_template_guid) VALUES ('be5d5b80c1a8f36ec33139cb27440ca7', > '8f436420bffa2ba45515192c895b0

Re: GDA missing records retest (long)

Mark Johnson wrote: > Now, the libgda project is busy on version 4, which no longer contains > the GdaQuery object. I don't expect much bug fixing of version 3, but > it would be very much needed for gnucash. I do not think that version 3 > is ready for prime time, given the number of bugs this p

GDA: Porting to libgda 4

The writing seems to be on the wall for the rev3 branch of libgda. Their response to a bug report I filed against rev3 was that they weren't going to be maintaining it but that I should shift to libgda rev4. I'm doing that now, when I can fit in time around my day job. I hope to have the port don

GDA: Status

I've spent the past few weeks trying to port to libgda V4. On the libgda mailing list, I was told that a bug I reported against V3 would not be fixed because effort was going into V4. I also wanted to work with V4 to help find any problems as soon as possible. Well, V4 basically works with the s

Re: GDA: Status

Derek Atkins wrote: > Daniel, > > My major concern here is that a year ago you were rallying for > GDA and GdaQuery. Phil threw out a bunch of his work to target > GDA-3 with GdaQuery. Now here we are, 6 or 9 months later, and > the GDA team has moved on to GDA-4 already and are dropping GdaQuer

Re: [gnome-db] V3 vs V4

Vivien Malerba wrote: > On Sat, May 31, 2008 at 8:21 PM, Phil Longstaff <[EMAIL PROTECTED]> wrote: >> For the past few weeks, I've ported my code from V3 to V4. My findings: >> >> 1) the sqlite provider for V4 seems to be in pretty good shape. I've >&g

Re: GDA: Status

Derek Atkins wrote: > Phil Longstaff <[EMAIL PROTECTED]> writes: > >>> Or would it be more expedient to pick a technology that has a proven >>> track record, proven stability, is NOT a moving target, and is >>> already available in most distributions? >&

Re: GDA: Status

Derek Atkins wrote: >> 2. Use GDA V4. We will probably send time fixing bugs here, but we are almost >> guaranteed that a release will happen. The advantages of this approach is >> that >> we will be current with the new GDA and releases will be done for us (or in >> conjunction with us - dependin

Re: GDA: Status

Derek Atkins wrote: > Phil Longstaff <[EMAIL PROTECTED]> writes: > > My appologies for sounding like a broken record, but if you look at > MythTV they show how to support both MySQL and PG in an automated > fashion. At least I'm pretty sure they can create and update ta

Re: GDA: Status

Derek Atkins wrote: to switch. >>> Do you want to do this in the gda-dev or would you like a new branch >>> to work from? Branches are cheap. >> At this point, I'll work in gda-dev. > > Okay. I was just thinking that maybe "dbi-dev" would be a more > appropriate name. But up to you. What

SQL backend status

I've just committed a large change which: 1) splits the GDA backend into pieces, a generic SQL piece and a GDA specific piece 2) added a libdbi-specific piece which uses the same generic SQL piece (sqlite3 only) I've currently disabled the gda-specific backend and have just the libdbi-specific

Job object and QOF registration

Many if not all of the business objects have an "active" flag. Most of these use QOF_PARAM_ACTIVE in the QOF object registration. The job object has rows in the registration, once for QOF_PARAM_ACTIVE which registers the getter but not the setter, and once for JOB_ACTIVE, which registers both.

XML file backend

The xml file backend has 2 functions to handle a commodity reference. The first, dom_tree_to_commodity_ref_no_engine(), gets the two pieces of the reference (space and id) and creates a new gnc_commodity from them. The second, dom_tree_to_commodity_ref(), calls dom_tree_to_commodity_ref_no_en

DBI/SQL backend

I think the DBI/SQL backend is ready to try. It is in the gda-dev2 branch. The GDA backend has been disabled and a DBI backend is enabled. It assumes that the include files are in /usr/include/dbi/dbi.h and the driver files are in /usr/lib/dbd. The only driver that the DBI backend supports is s

Re: DBI/SQL backend

11, 2008 at 8:58 PM, Phil Longstaff <[EMAIL PROTECTED]> > wrote: > > >> I think the DBI/SQL backend is ready to try. It is in the gda-dev2 >> branch. The GDA backend has been disabled and a DBI backend is enabled. >> It assumes that the include files are in /usr

Re: DBI/SQL backend

David Reiser wrote: > > On Jun 11, 2008, at 8:58 PM, Phil Longstaff wrote: > >> I think the DBI/SQL backend is ready to try. It is in the gda-dev2 >> branch. The GDA backend has been disabled and a DBI backend is enabled. >> It assumes that the include files are in

Re: DBI/SQL backend

Derek Atkins wrote: > David Reiser <[EMAIL PROTECTED]> writes: > with --enable-error-on-warning set, I get: cc1: warnings being treated as errors gnc-backend-util-sql.c: In function ‘gnc_sql_get_sql_value’: gnc-backend-util-sql.c:1411: warning: format ‘%d’ expects type ‘in

Re: DBI/SQL backend

David Reiser wrote: > > On Jun 12, 2008, at 11:19 AM, Phil Longstaff wrote: > >> Derek Atkins wrote: >>> David Reiser <[EMAIL PROTECTED]> writes: >>> >>>>>> with --enable-error-on-warning set, I get: >>>>>> >>>

Re: DBI/SQL backend save as failure

David Reiser wrote: > Using r17230 (+ a GType fix in gnc-backend-dbi.c), gnucash builds, > launches, and opens the data file (xml). Save As results in the > following in the terminal window: > > dyld: lazy symbol binding failed: Symbol not found: _gnc_sql_init >Referenced from: /opt/gnucas

Re: DBI/SQL backend save as failure

Well, the SQL stuff isn't really a module, it is a library, so I'll convert it to a library. Phil - Original Message From: David Reiser <[EMAIL PROTECTED]> To: Phil Longstaff <[EMAIL PROTECTED]> Cc: GnuCash development list Sent: Saturday, June 14, 2008 8:28:

Re: DBI/SQL backend

Nathan Buchanan wrote: > > On Wed, Jun 11, 2008 at 8:58 PM, Phil Longstaff <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> wrote: > > I think the DBI/SQL backend is ready to try. It is in the gda-dev2 > branch. The GDA backend has been disabled and a DBI

Re: DBI/SQL backend

Nathan Buchanan wrote: > > On Wed, Jun 11, 2008 at 8:58 PM, Phil Longstaff <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> wrote: > > I think the DBI/SQL backend is ready to try. It is in the gda-dev2 > branch. The GDA backend has been disabled and a DBI

Re: DBI/SQL backend

David Reiser wrote: > > On Jun 16, 2008, at 6:58 PM, Phil Longstaff wrote: > >> Nathan Buchanan wrote: >>> >>> On Wed, Jun 11, 2008 at 8:58 PM, Phil Longstaff <[EMAIL PROTECTED] >>> <mailto:[EMAIL PROTECTED]>> wrote: >>> >>>

Re: DBI/SQL backend

David Reiser wrote: > > On Jun 22, 2008, at 4:49 PM, Phil Longstaff wrote: > >> David Reiser wrote: >>> >>> ... >> What files are in /sw/lib/dbd? >> >> Phil >> > libdbdsqlite.alibdbdsqlite.lalibdbdsqlite.so Ah. Libdbi makes

Transactions and splits in the SQL backends

I am running into some difficulties in the SQL/DBI backend related to transactions and splits. There are two specific issues which I am trying to balance correctly: 1) If transactions and splits are not marked clean in the "correct" places, the '*' appears beside the file name and the user is ask

Re: Feature proposal: Windows - assigning GnuCash to file name extension?

The .db requirement is a result of libgda. libdbi doesn't have that requirement. Phil P.S. Derek, do you have any comment on my recent posting re transactions and splits. Derek Atkins wrote: > "Nathan Buchanan" <[EMAIL PROTECTED]> writes: > >>> Hi, >>> >>> is it possible to automatically assig

SQL backend and dirty books

I've investigated my transaction/split issue further and it appears as though the problem is in how qof determines that the books are dirty. There is an alt_dirty_mode flag in qof and the gc engine sets it to TRUE. When this flag is set, *after* the backend is called during the second part of a

Re: SQL backend and dirty books

o be kept in sync (suggest alternate routine names if you want). Phil - Original Message ---- From: Derek Atkins <[EMAIL PROTECTED]> To: Phil Longstaff <[EMAIL PROTECTED]> Cc: GnuCash development list Sent: Friday, July 11, 2008 9:43:42 PM Subject: Re: SQL backend and dir

DBI backend now supports mysql and postgresql

As of rev 17323, the gda-dev2 backend supports mysql and postgresql databases again. Despite the name, it uses the DBI library (http://libdbi.sourceforge.net). In the file menu, the 'Database Connection' menu entry allows you to save to or load from one of these databases. This entry brings u

<    2   3   4   5   6   7   8   9   >