Hello! How to disable version field: http://www.webtoolkit.eu/wt/doc/tutorial/dbo.html#customizing Have you followed this instruction?
Show current tables structure (output of ".tables" in sqlite3 interactive mode), please. Could you attach the code (causing Segmentation fault)? On Thu, May 31, 2012 at 9:39 AM, Joel <[email protected]> wrote: > Hello, > > Nageaev, thank you very much for taking the time to make a compilable and > working version of my application. I > > I just have a quick follow up question based on the changes. > > When I compile my program I get the following error: > > what(): Sqlite3: insert into "p1copy" ("version", > "Config_IDs_Rams_Ram1AID", "Config_IDs_Rams_Ram1BID", > "Config_IDs_Rams_Ram2AID", "Config_IDs_Rams_Ram2BID") values (?, ?, ?, ?, > ?): table p1copy has no column named version > > Now I know this is a sqlite3 error that has occured because of the version > field and when I suppress the version field I get a Segmentation fault. > > Thanks again for your response. > Joel > > > > On 12-05-30 12:22 AM, Nagaev Boris wrote: > > Hello! > > Changes: > > 1. WItemDelegate is not a widget. It should be set to view by > view->setItemDelegateForColumn() (or setItemDelegate if you want it > for all the columns) > > 2. Function create_database should call session.createTables() to create > tables. > > 3. Fields in Panel1 were mixed up (Config_Cal_Position_THClosedB wa > mapped twice and Config_Cal_Position_THClosedB was mapped to > "Config_Cal_Position_THClosedb" (last letter "b", not "B"). > > 4. To make this work, I removed Instructions table and create Panel2 > class -- a copy of Panel1. Fields of Instructions differ from fields > of Panel1, so entry of Panel1 can't be saved to Instructions directly > (column to column): some domain specific transformation is needed > (change code of writeMod::setModelData to apply custom transformation > from one table to another). > > 5. When declaring methods in C++ inside class (event if they are > overloaded from ancestor class), do not mention class name. I mean, it > should be "setModelData" instead of "WItemDelegate::setModelData". > > 6. Every function or method should have return type (except > constructor and destructor). So it should be "void setModelData" > > 7. I have added constructor to writeMod class. It takes a pointer to > another model (writable) and save it as a field. Then in > setModelData() method this saved pointer would be used to save data > to. > > 8. Each operation with database should be done under active > transaction (see create_database()) > > > Compilable and working version is attached. > > One entry of Panel1 is created from the beginning. Whenever it is > edited in the view, modified version of it is stored to "p2" table. > This code can be changed to implement "Instructions" logic. > > On Wed, May 30, 2012 at 3:45 AM, Joel <[email protected]> wrote: > > Hello, > > Thank you for your reply Nagaev, I very much appreciate it. > > I have created two models for each one of my tables, and the read-only table > is set with view->setModel. I am having an issue with your third step > > > 3. Inherit from WItemDelegate, overload method > WItemDelegate::setModelData with custom function, saving data to > another model (instructions table). > > I am using the WItemDelegate class and following the example of how to deal > with a specialized editor and I have implemented the following in my code: > > > class mainWindow : public WContainerWidget > > { > public: > > mainWindow (dbo::Session& session, WContainerWidget *parent=0) > > > : WContainerWidget (parent) > > { > > > dbo::QueryModel< dbo::ptr<Panel1> > *model = new dbo::QueryModel< > dbo::ptr<Panel1> >(); > > model->setQuery(session.find<Panel1>()); > > model->addColumn("Config_Cal_Position_THClosedB",ItemIsEditable); > > model->addColumn("Config_IDs_Rams_Ram1AID",ItemIsEditable); > > > > WTableView *view = new WTableView (this); > > view->resize(800, 300); > > view->setSelectionMode(SingleSelection); > > view->setModel(model); > > } > > }; > > class writeMod : public WItemDelegate > > { > > public: > > WItemDelegate::setModelData(const boost::any& editState, > Wt::WAbstractItemModel *model, const Wt::WModelIndex& index) const > > { > > model ->setData(index, editState, EditRole); > > } > > }; > > > > > I am getting the following error > > make[2]: Entering directory `/home/joel/moxa/awesomesauce/src' > > arm-linux-g++ -DHAVE_CONFIG_H -I. -I.. > -I/home/joel/moxa/witty_dist/usr/include > -I/home/joel/moxa/boost_dist/include -I/usr/local/arm-linux/include/ > -mcpu=arm920t -MT awesomesauce.o -MD -MP -MF .deps/awesomesauce.Tpo -c -o > awesomesauce.o awesomesauce.cpp > > awesomesauce.cpp:193: error: ISO C++ forbids declaration of ‘setModelData’ > with no type > > awesomesauce.cpp:193: error: cannot define member function > ‘Wt::WItemDelegate::setModelData’ within ‘writeMod’ > > awesomesauce.cpp: In constructor ‘MyApplication::MyApplication(const > Wt::WEnvironment&)’: > > awesomesauce.cpp:218: error: no matching function for call to > ‘writeMod::writeMod(Wt::Dbo::Session&, Wt::WContainerWidget*)’ > > awesomesauce.cpp:191: note: candidates are: writeMod::writeMod() > > awesomesauce.cpp:191: note: writeMod::writeMod(const > writeMod&) > > make[2]: *** [awesomesauce.o] Error 1 > > make[2]: Leaving directory `/home/joel/moxa/awesomesauce/src' > > make[1]: *** [all-recursive] Error 1 > > make[1]: Leaving directory `/home/joel/moxa/awesomesauce' > > make: *** [all] Error 2 > > > > > I am new to c++ and web development so I know these errors probably seem > basic, I have tried to use WItemDelegate in a number of different ways but I > cannot get my code to compile. I tried using my WItemDelegate::setModelData > statment within the mainWindow class, but I got a compiler error telling me > that I cannot use this expression with the class, that is why I created a > new class writeMod. > > I am going to continue to try and figure out what is going on, but if > someone has any ideas I would be very grateful. > > Thanks, > Joel > > > > > > > On 12-05-29 02:51 AM, Nagaev Boris wrote: > > Hello, > > I think, this should help: > > 1. Create two models, first is targeted to read-only table, second to > instructions table. > 2. Set one model (read-only table) with view->setModel > 3. Inherit from WItemDelegate, overload method > WItemDelegate::setModelData with custom function, saving data to > another model (instructions table). > 4. Set this item delegate using view->setItemDelegateForColumn for all > editable columns > > Probably, you have to create two classes (one class per table) and to > map them both (Dbo::Session::mapClass). > To avoid code duplication, you can create one base class with all > needed fields, and inherit from them two empty classes. > > On Tue, May 29, 2012 at 2:28 AM, Joel<[email protected]> wrote: > > Hello, > > I am working on an application which queries a sqlite3 database and adds > columns to a WTableView so that they can be displayed on a web browser. > The > data that is displayed on the web browser is editable but I do not want > to > write the edited result to the same table which it was queried from. > > class mainWindow : public WContainerWidget > { > public: > mainWindow (dbo::Session& session, WContainerWidget *parent=0) > > : WContainerWidget (parent) > { > > dbo::QueryModel< dbo::ptr<Panel1> > *model = new dbo::QueryModel< > dbo::ptr<Panel1> >(); > model->setQuery(session.find<Panel1>()); > model->addColumn("Config_Cal_Position_THClosedB",ItemIsEditable); > model->addColumn("Config_IDs_Rams_Ram1AID",ItemIsEditable); > > > WTableView *view = new WTableView (this); > view->resize(800, 300); > view->setSelectionMode(SingleSelection); > view->setModel(model); > > > } > > > The<Panel1> table is a view only table, in order to edit the data I have > to > do so through an instruction table via the following sqlite3 command > > insert into instructions(instruction_type, port, param1, param2, param3) > values (0,<1-4>, 86,<register name>,<register value>); > > So basically, I am attempting to read from table<Panel1>, have the > ability > to edit the data on a browser, and write the edited result to > the<register > value> parameter of the instruction table. > > Your help would be greatly appreciated! > > Thanks, > Joel > > > ------------------------------------------------------------------------------ > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. Discussions > will include endpoint security, mobile security and the latest in malware > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > _______________________________________________ > witty-interest mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/witty-interest > > ------------------------------------------------------------------------------ > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. Discussions > will include endpoint security, mobile security and the latest in malware > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > _______________________________________________ > witty-interest mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/witty-interest > > > ------------------------------------------------------------------------------ > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. Discussions > will include endpoint security, mobile security and the latest in malware > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > _______________________________________________ > witty-interest mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/witty-interest > > > > ------------------------------------------------------------------------------ > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. Discussions > will include endpoint security, mobile security and the latest in malware > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > > > > _______________________________________________ > witty-interest mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/witty-interest > > > > ------------------------------------------------------------------------------ > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. Discussions > will include endpoint security, mobile security and the latest in malware > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > _______________________________________________ > witty-interest mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/witty-interest > ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ witty-interest mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/witty-interest
