y Rajyalakshmi

29 Jul 2013 05:05

Hi Nour Saffaf, can you please send me your project code(sample) using Database. and select those fields as a list. i was fully confused with these methods. Thanks Rajyalakshmi

Reply to this post
Mark as answer

y Rajyalakshmi

29 Jul 2013 05:44

Hi Nour Saffaf, can you please send me your project code(sample) using Database. and select those fields as a list. i was fully confused with these methods. Thanks Rajyalakshmi

Reply to this post
Mark as answer

smith wil

29 Jul 2013 07:33

Sample code @https://developer.tizen.org/documentation/articles/dbcontrol-sample-code-using-dbmanager-class could be reffered

Reply to this post
Mark as answer

y Rajyalakshmi

29 Jul 2013 09:50

Hi smith, Thanks for your response. please let me know when we have to use Tizen::App::ISqlDataControlResponseListener: and Tizen::App::ISqlDataControlResponseListener:... I have a database. with so many tables. just i have to extract the data from those tables. (this Query i have to use ) SELECT page_instance.Title, page_html.Html FROM page_instance INNER JOIN page_html ON page_instance.PageInstanceId=page_html.PageInstanceId; Title html .......... ................... Blue Shark ..................... Blue Tartan ..................... Booster ..................... Bosom Caresser ..................... Boston Cocktail (2) ..................... on the first form we have to display titles. w.r.t titles in the next form we have to display html pages I have refered DictionaryDataControlProvider and DictionaryDataControl.. but i was fully confused. Thanks Rajyalakshmi

Reply to this post
Mark as answer

smith wil

31 Jul 2013 09:03

Have a look into the documentation part first, https://developer.tizen.org/help/index.jsp?topic=%2Forg.tizen.native.appprogramming%2Fhtml%2Fguide%2Fapp%2Fdata_controls.htm This will give you a better understanding of SQL data control and how it works. Read them patiently,I am sure you won't be confused.

Reply to this post
Mark as answer

y Rajyalakshmi

01 Aug 2013 03:14

Hi, how can we define the providerId. In the DataControl example we have used "http://tizen.org/datacontrol/provider/DictionaryDataControlProvider".. how to define providerId... Upto ( http://tizen.org/datacontrol/provider/) is it common for every ProviderId.. Last DictionaryDataControlProvider is the implemented class of ProviderEventListener..? can you please explain me each part in the providerId. Thanks Rajyalakshmi

Reply to this post
Mark as answer

y Rajyalakshmi

05 Aug 2013 09:13

Hi I have tried this code.. it is showing some runtime error please check it and guide me for further /** * Name : DatabaseProviderApp * Version : * Vendor : * Description : */ #include "DatabaseProvider.h" #include using namespace Tizen::Base; using namespace Tizen::Base::Collection; using namespace Tizen::Io; using namespace Tizen::System; using namespace Tizen::App; static const wchar_t* PROVIDER_ID = L"http://tizen.org/datacontrol/provider/DatabaseProvider"; DatabaseProviderApp::DatabaseProviderApp(void) { } DatabaseProviderApp::~DatabaseProviderApp(void) { } ServiceApp* DatabaseProviderApp::CreateInstance(void) { // Create the instance through the constructor. return new DatabaseProviderApp(); } bool DatabaseProviderApp::OnAppInitializing(AppRegistry& appRegistry) { // TODO: // Initialize App specific data. // The App's permanent data and context can be obtained from the appRegistry. // // If this method is successful, return true; otherwise, return false. // If this method returns false, the App will be terminated. // TODO: Add your initialization code here result r = E_SUCCESS; bool ret = true; DataControlProviderManager* pDcMgr = DataControlProviderManager::GetInstance(); TryReturn(pDcMgr != null, false, "Failed to get the data control provider manager instance."); r = pDcMgr->SetSqlDataControlProviderEventListener(this); TryReturn(!IsFailed(r), false, "Failed to Set the Sql data control provider listener."); Database* pDb = null; // String sqlCommand(L"CREATE TABLE IF NOT EXISTS Dictionary ( WORD VARCHAR(30) PRIMARY KEY, WORD_DESC TEXT )"); String dataPath = App::GetInstance()->GetAppDataPath(); __dbPath.Append(String(dataPath + L"data/bartendersbible_minerva.db")); if (File::IsFileExist(__dbPath)) { File::Remove(__dbPath); } pDb = new (std::nothrow) Database(); TryCatch(pDb != null, ret = false, "new Database() is null"); r = pDb->Construct(__dbPath, true); TryCatch(!IsFailed(r), ret = false, "Database Construct failed with error [%s] \n", GetErrorMessage(r)); //r = pDb->ExecuteSql(sqlCommand, true); //TryCatch(!IsFailed(r), ret = false, "ExecuteSql failed with error [%s] \n", GetErrorMessage(r)); // fall thru CATCH: delete pDb; return ret; return true; } bool DatabaseProviderApp::OnAppInitialized(void) { // TODO: // Comment. return true; } bool DatabaseProviderApp::OnAppWillTerminate(void) { // TODO: // Comment. return true; } bool DatabaseProviderApp::OnAppTerminating(AppRegistry& appRegistry, bool forcedTermination) { // TODO: // Deallocate resources allocated by this App for termination. // The App's permanent data and context can be saved via appRegistry. // TODO: Add your termination code here return true; } void DatabaseProviderApp::OnLowMemory(void) { // TODO: // Free unused resources or close the App. } void DatabaseProviderApp::OnBatteryLevelChanged(BatteryLevel batteryLevel) { // TODO: // Handle any changes in battery level here. // Stop using multimedia features(camera, mp3 etc.) if the battery level is CRITICAL. } void DatabaseProviderApp::OnSqlDataControlInsertRequestReceived(RequestId reqId, const Tizen::Base::String& providerId, const Tizen::Base::String& dataId, const Tizen::Base::Collection::IMap& insertMap) { } void DatabaseProviderApp::OnSqlDataControlSelectRequestReceived(RequestId reqId, const Tizen::Base::String& providerId, const Tizen::Base::String& dataId, const Tizen::Base::Collection::IList* pColumnList, const Tizen::Base::String* pWhere, const Tizen::Base::String* pOrder) { Database* pDb = null; DbEnumerator* pEnum = null; result r = E_SUCCESS; bool providerResult = false; String errorMsg; String sql; if (providerId.CompareTo(String(PROVIDER_ID)) == 0) { if (dataId.CompareTo(L"page_instance") == 0) { pDb = new (std::nothrow) Database(); if (pDb == null) { errorMsg.Append(L"[E_OUT_OF_MEMORY] Db could not be instantiated. Insufficient memory"); r = E_OUT_OF_MEMORY; goto CATCH; } r = pDb->Construct(__dbPath, DB_OPEN_READ_ONLY, 0); if (IsFailed(r)) { errorMsg.Format(32, L"[%s]", GetErrorMessage(r)); errorMsg.Append(L"Database::Construct failed"); r = E_SYSTEM; goto CATCH; } sql = SqlStatementBuilder::CreateSelectStatement(dataId, pColumnList, pWhere, pOrder, null, null, null); r = GetLastResult(); if (IsFailed(r)) { errorMsg.Format(32, L"[%s]", GetErrorMessage(r)); errorMsg.Append(L"CreateSelectStatement failed"); goto CATCH; } AppLog("Select sql:%ls", sql.GetPointer()); pEnum = pDb->QueryN(sql); r = GetLastResult(); if (IsFailed(r)) { errorMsg.Format(32, L"[%s]", GetErrorMessage(r)); errorMsg.Append(L"QueryN failed"); if (r == E_INVALID_OPERATION) { r = E_INVALID_ARG; } else { r = E_SYSTEM; } goto CATCH; } providerResult = true; } else { errorMsg.Append(L"[E_INVALID_ARG] Invalid dataId was passed"); r = E_INVALID_ARG; } } else { errorMsg.Append(L"[E_INVALID_ARG] Invalid ProviderId was passed"); r = E_INVALID_ARG; } // fall thru CATCH: if (providerResult == true) { r = DataControlProviderManager::GetInstance()->SendSqlDataControlSelectResult(reqId, pEnum); } else { AppLog("errorMsg: %ls", errorMsg.GetPointer()); r = DataControlProviderManager::GetInstance()->SendDataControlError(reqId, errorMsg); } if (IsFailed(r)) { AppLog("The data control provider failed to send the result."); } delete pEnum; delete pDb; } void DatabaseProviderApp::OnSqlDataControlUpdateRequestReceived(RequestId reqId, const Tizen::Base::String& providerId, const Tizen::Base::String& dataId, const Tizen::Base::Collection::IMap& updateMap, const Tizen::Base::String* pWhere) { } void DatabaseProviderApp::OnSqlDataControlDeleteRequestReceived(RequestId reqId, const Tizen::Base::String& providerId, const Tizen::Base::String& dataId, const Tizen::Base::String* pWhere) { } //SqlDataControl class //.................................. #include "SqlDataControlMainForm.h" #include "AppResourceId.h" #include #include #include using namespace Tizen::Base::Collection; using namespace Tizen::App; using namespace Tizen::Base; using namespace Tizen::Io; using namespace Tizen::Ui; using namespace Tizen::Ui::Controls; using namespace Tizen::Ui::Scenes; using namespace Tizen::Graphics; static const int _MAX_DB_COLUMNS = 2; SqlDataControlMainForm::SqlDataControlMainForm(void) { } SqlDataControlMainForm::~SqlDataControlMainForm(void) { } bool SqlDataControlMainForm::Initialize(void) { Form::Construct(FORM_STYLE_HEADER | FORM_STYLE_INDICATOR); TryReturn(LoadTitles() == true, false, "LoadTitles() failed."); return true; } result SqlDataControlMainForm::OnInitializing(void) { result r = E_SUCCESS; SetFormBackEventListener(this); Header* pHeader = GetHeader(); pHeader->SetTitleText(L"List of words"); ListView* pListView = new ListView(); pListView->Construct(Rectangle(0, 0, GetClientAreaBounds().width, GetClientAreaBounds().height), true, false); pListView->SetItemProvider(*this); // pListView->AddListViewItemEventListener(*this); AddControl(pListView); __pPopup = new Popup(); __pPopup->Construct(true, Dimension(600, 250)); __pPopup->SetTitleText(L"Please wait."); Rectangle rect; rect = __pPopup->GetClientAreaBounds(); __pLabel = new Label(); __pLabel->Construct(Rectangle(0, 0, rect.width, 80), L"Processing your request."); __pLabel->SetTextHorizontalAlignment(ALIGNMENT_CENTER); __pPopup->AddControl(__pLabel); return r; } result SqlDataControlMainForm::OnTerminating(void) { delete __pPopup; if (__pSqlDataControl != null) { __pSqlDataControl->SetSqlDataControlResponseListener(null); } return E_SUCCESS; } void SqlDataControlMainForm::OnFormBackRequested(Tizen::Ui::Controls::Form& source) { AppLog("OnFormBackRequested."); if (__pSqlDataControl != null) { __pSqlDataControl->SetSqlDataControlResponseListener(null); } SceneManager* pSceneManager = SceneManager::GetInstance(); pSceneManager->GoBackward(BackwardSceneTransition()); } void SqlDataControlMainForm::OnSceneActivatedN(const Tizen::Ui::Scenes::SceneId& previousSceneId, const Tizen::Ui::Scenes::SceneId& currentSceneId, Tizen::Base::Collection::IList* pArgs) { // TODO: // Add your scene activate code here AppLog("OnSceneActivatedN"); } void SqlDataControlMainForm::OnSceneDeactivated(const Tizen::Ui::Scenes::SceneId& currentSceneId, const Tizen::Ui::Scenes::SceneId& nextSceneId) { // TODO: // Add your scene deactivate code here AppLog("OnSceneDeactivated"); } ListItemBase* SqlDataControlMainForm::CreateItem(int index, int itemWidth) { ListAnnexStyle style = LIST_ANNEX_STYLE_NORMAL; result r; String* pWord = null; CustomItem* pItem = new (std::nothrow) CustomItem(); TryReturn(pItem != null, null, "new CustomItem() is null"); pItem->Construct(Tizen::Graphics::Dimension(itemWidth, 112), style); pWord = dynamic_cast< String* >(__title.GetValue(Integer(index))); r = pItem->AddElement(Rectangle(26, 32, 200, 80), 0, *pWord, false); TryLog(!IsFailed(r), "CustomItem::AddElement() is failed by %s", GetErrorMessage(r)); return pItem; } bool SqlDataControlMainForm::LoadTitles(void) { bool ret=true; if (__pSqlDataControl == null) { // send insert command __pSqlDataControl = AppManager::GetSqlDataControlN(L"http://tizen.org/datacontrol/provider/DatabaseProvider"); if (__pSqlDataControl == null) { // hide the popup and show result message. AppLog("GetSqlDataControlN() Failed"); MessageBox myMSGBox; myMSGBox.Construct(L"GetSqlDataControlN() failed", L"DatabaseProvider is not installed. Please install it !!", MSGBOX_STYLE_OK, 0); // Call ShowAndWait } } __pSqlDataControl->SetSqlDataControlResponseListener(this); __title.Construct(); return ret; } void SqlDataControlMainForm::OnSqlDataControlInsertResponseReceived(RequestId reqId, const String& providerId, const String& dataId, long long insertRowId, bool providerResult, const String* pErrorMsg) { } void SqlDataControlMainForm::OnSqlDataControlSelectResponseReceived(RequestId reqId, const String& providerId, const String& dataId, IDbEnumerator& resultSetEnum, bool providerResult, const String* pErrorMsg) { String where; RequestId selectReqId; ArrayList* pColumnList = null; String columnNames[_MAX_DB_COLUMNS] = { L"Title", L"Html" }; pColumnList = new (std::nothrow) ArrayList(); TryReturnVoid(pColumnList != null, "new ArrayList() is null."); result r = pColumnList->Add(*new String(columnNames[0])); TryCatch(!IsFailed(r), , "ArrayList::Add() failed to return E_SUCCESS, instead %s occured \n", GetErrorMessage(r)); where.Format(10, L"rowid=%ls", __lastInsertRowId); r = __pSqlDataControl->Select(L"Page_Instance", pColumnList, &where, null, selectReqId, 1, 1); if (IsFailed(r)) { AppLog("SqlDataControl::Select() failed to return E_SUCCESS, instead %s occured \n", GetErrorMessage(r)); // hide the popup and show result message. MessageBox myMSGBox; myMSGBox.Construct(L"SqlDataControl::Select", L"Request Failed!!", MSGBOX_STYLE_OK, 0); // Call ShowAndWait int modalResult = 0; myMSGBox.ShowAndWait(modalResult); //ShowAndWait() draw, show itself and process events } CATCH: AppLog("selectReqId:%d", selectReqId); pColumnList->RemoveAll(true); delete pColumnList; result ret = E_SUCCESS; AppLog("Tizen::Io >> reqId: %d, providerId: %ls, dataId: %ls, providerResult: %d", reqId, providerId.GetPointer(), dataId.GetPointer(), providerResult); // hide the popup. // show result message (word description on success or error message). if (providerResult == false) { AppLog("SqlDataControl::Select() failed. ErrorMsg (%ls). \n", pErrorMsg->GetPointer()); MessageBox myMSGBox; myMSGBox.Construct(L"SqlDataControl::Select", L"Response Failed!!", MSGBOX_STYLE_OK, 0); // Call ShowAndWait int modalResult = 0; myMSGBox.ShowAndWait(modalResult); //ShowAndWait() draw, show itself and process events return; } r = resultSetEnum.MoveNext(); AppLog("we have titles in enum"); String str = L"Test"; // Print the debug message "string: Test" to the console AppLogDebug("string: %ls", str.GetPointer()); if (r == E_SUCCESS) { String title; ret = resultSetEnum.GetStringAt(0, title); TryReturnVoid(!IsFailed(ret), "GetStringAt() failed to return E_SUCCESS, instead %s occured \n", GetErrorMessage(ret)); LinkedList* pList = new LinkedList(); pList->Add(*(new String(title))); String where; where.Format(10, L"rowid=%lld", __lastInsertRowId); } return; } void SqlDataControlMainForm::OnSqlDataControlUpdateResponseReceived(RequestId reqId, const String& providerId, const String& dataId, bool providerResult, const String* pErrorMsg) { TryLog(providerResult == true, "ErrorMsg (%ls). \n", pErrorMsg->GetPointer()); } void SqlDataControlMainForm::OnSqlDataControlDeleteResponseReceived(RequestId reqId, const String& providerId, const String& dataId, bool providerResult, const String* pErrorMsg) { TryLog(providerResult == true, "reqId(%d) ErrorMsg (%ls). \n", reqId, pErrorMsg->GetPointer()); } please let me know how to display the "title" in the table Page_Instance in .db file on the first form

Reply to this post
Mark as answer

User Menu

Tizen Forums

Community

Community

Responses

Search form

Responses