[Monetdb-developers] Simple bat operations
Hello, sorry for asking so many dumb questions, but I don't seem to be able to find the answers in the docs. I try to create and persist a bat: (mclient -d demo -l mal) n := bat.new(:oid,:str); bat.setName(n, "person_name"); bat.setPersistent(n, true); bat.append(n, "John", true); bat.append(n, "James", true); bat.save(n); But this doesn't seem to be sufficient. Or at least I then don't know how to load this bat the next time I start mclient. Is there a file (one of the tests or sth.) which contains such basic tests? I tried to find-grep over them, but didn't succeed in finding what I was looking for. Thanks you for your patience. Kambiz
On Thu, Oct 11, 2007 at 08:00:36AM +0200, darabi@web.de wrote:
Hello,
sorry for asking so many dumb questions, but I don't seem to be able to find the answers in the docs.
I try to create and persist a bat:
(mclient -d demo -l mal)
n := bat.new(:oid,:str); bat.setName(n, "person_name"); bat.setPersistent(n, true);
bat.append(n, "John", true); bat.append(n, "James", true);
replace this save
bat.save(n); by
transaction.commit(); Niels (ps later you probably want to switch to subcommit, ie only commit those bat that changed, for this see the documenation in the transaction module (src/modules/mal/transaction.mx)
But this doesn't seem to be sufficient.
Or at least I then don't know how to load this bat the next time I start mclient.
Is there a file (one of the tests or sth.) which contains such basic tests? I tried to find-grep over them, but didn't succeed in finding what I was looking for.
Thanks you for your patience.
Kambiz
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl
Niels, thank you very much for your help. How can I access this bat, when I start a new session? bat.load("person_name"); doesn't seem to work. io.print(n): ERROR = !TypeException:user.main[1]:'n' may not be used before being initialized Thanks Kambiz ----- Original Message ----- From: "Niels Nes" To: darabi@web.de Cc: monetdb-developers@lists.sourceforge.net Sent: Donnerstag, 11. Oktober 2007 9.38 Uhr (GMT+0100) Europe/Berlin Subject: Re: [Monetdb-developers] Simple bat operations On Thu, Oct 11, 2007 at 08:00:36AM +0200, darabi... wrote:
Hello,
sorry for asking so many dumb questions, but I don't seem to be able to find the answers in the docs.
I try to create and persist a bat:
(mclient -d demo -l mal)
n := bat.new(:oid,:str); bat.setName(n, "person_name"); bat.setPersistent(n, true);
bat.append(n, "John", true); bat.append(n, "James", true);
replace this save
bat.save(n); by
transaction.commit(); Niels (ps later you probably want to switch to subcommit, ie only commit those bat that changed, for this see the documenation in the transaction module (src/modules/mal/transaction.mx)
But this doesn't seem to be sufficient.
Or at least I then don't know how to load this bat the next time I start mclient.
Is there a file (one of the tests or sth.) which contains such basic tests? I tried to find-grep over them, but didn't succeed in finding what I was looking for.
In the meantime, I have also tried all the bbp functions which
I could think of:
bbp.find
bbp.bind
bbp.take
But none of them gives me a bat which I can use. Strangely, none of
them says anything about whether the function call succeeded
or not.
Kambiz
----- Original Message -----
From: darabi@web.de
To: monetdb-developers@lists.sourceforge.net
Cc: "Niels Nes"
Hello,
sorry for asking so many dumb questions, but I don't seem to be able to find the answers in the docs.
I try to create and persist a bat:
(mclient -d demo -l mal)
n := bat.new(:oid,:str); bat.setName(n, "person_name"); bat.setPersistent(n, true);
bat.append(n, "John", true); bat.append(n, "James", true);
replace this save
bat.save(n); by
transaction.commit(); Niels (ps later you probably want to switch to subcommit, ie only commit those bat that changed, for this see the documenation in the transaction module (src/modules/mal/transaction.mx)
But this doesn't seem to be sufficient.
Or at least I then don't know how to load this bat the next time I start mclient.
Is there a file (one of the tests or sth.) which contains such basic tests? I tried to find-grep over them, but didn't succeed in finding what I was looking for.
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
participants (2)
-
darabi@web.de
-
Niels Nes