dabodemo Commit
Revision 531
Date: 2007-08-13 11:04:01 -0700 (Mon, 13 Aug 2007)
Author: Paul
Trac: http://svn.dabodev.com/trac/dabodemo/changeset/531
Changed:
A trunk/tutorial/dbEditableGrid.py
Log:
John's comments made me wonder if Dabo is working correctly or not. This
proves that it is, I believe. :)
Diff:
Added: trunk/tutorial/dbEditableGrid.py
===================================================================
--- trunk/tutorial/dbEditableGrid.py (rev 0)
+++ trunk/tutorial/dbEditableGrid.py 2007-08-13 18:04:01 UTC (rev 531)
@@ -0,0 +1,41 @@
+import dabo
+dabo.ui.loadUI("wx")
+
+# create our db and a test table:
+con = dabo.db.dConnection(DbType="sqlite", Database=":memory:")
+cur = con.getDaboCursor()
+cur.execute("create table customers (id INTEGER PRIMARY KEY, name CHAR, valid
INT)")
+cur.execute("insert into customers (name, valid) values ('Paul', 0)")
+cur.execute("insert into customers (name, valid) values ('John', 1)")
+cur.flush()
+
+# define a biz:
+biz = dabo.biz.dBizobj(con)
+biz.DataSource = "customers"
+biz.KeyField = "id"
+biz.UserSQL = "select id, name, valid from customers"
+biz.DataStructure = (
+ # (field_alias, field_type, pk, table_name, field_name,
field_scale)
+ ("id", "C", True, "customers", "id"),
+ ("name", "C", False, "customers", "name"),
+ ("valid", "B", False, "customers", "valid"))
+
+biz.requery()
+
+# show in a grid:
+app = dabo.dApp(MainFormClass=None)
+app.setup()
+frm = dabo.ui.dForm()
+grd = dabo.ui.dGrid(frm, DataSource=biz, Editable=True)
+grd.addColumn(DataField="id", Caption="Id")
+grd.addColumn(DataField="name", Caption="Name", Editable=True)
+grd.addColumn(DataField="valid", Caption="Valid", DataType="bool",
Editable=True)
+frm.Sizer.append1x(grd)
+
+def butGetDS_hit(evt):
+ print grd.DataSet
+butGetDS = dabo.ui.dButton(frm, Caption="Print DataSet", OnHit=butGetDS_hit)
+frm.Sizer.append(butGetDS)
+
+frm.show()
+app.start()
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/dabo-dev/[EMAIL PROTECTED]
