[04:18] hi === jkeyes0 is now known as Guest24975 === Guest24975 is now known as jkeyes0 [20:02] msg nik90 yo you got a second for a question about local storage ? [20:02] nailed it [20:02] aNickForMe: hey [20:02] sure [20:02] shoot [20:02] let me get a paste thingy togeather [20:03] nik90: why in the world is this not working ? http://paste.ubuntu.com/6692883/ [20:03] thanks [20:04] every thing else works [20:04] lik getDB() ect ect data base there and has data checked with sqliteman [20:04] I will paste full DBUtils.js [20:05] http://paste.ubuntu.com/6692898/ [20:07] I have also tried to set the query string as var foo = "SELECT VALUES " + rowName +" FROM Directions" ; db.tx.executeSql(foo) [20:08] so in essence the function to trying to retrieve a specific entry by row name? [20:08] correct [20:08] like the Row Name [20:10] but I want to pass from many places so I want to pass like import "Foo.js" as DataBase .. ... .. DataBase.getRowByName("home") [20:10] don't you do something similar in the getHome() function? [20:10] the function getHome() works fine so it is not the data base it is something in the query [20:11] I could make single rows and call by int but what if enduser works at 10 places like me [20:11] so when there setting there work they can have many [20:12] maybe I have to just make many tables for each [20:12] IDK [20:12] I am trying to wrap my mind around your database. [20:12] handling all this after in model is another issue [20:13] hmm why not wrap this whole thing inside a qml model rather than a js file? [20:13] let me find you an example [20:13] nik90: the data base is like this ran = has the program ever run ? home = the end users home address work = endusers work address ; [20:14] http://bazaar.launchpad.net/~ubuntu-clock-dev/ubuntu-clock-app/trunk/view/head:/clock/WorldClockModel.qml [20:14] lang is the end users language sysunits is like miles or KM [20:16] maybe SELECT statement will not allow ? , [value] [20:16] I would recommend using a qml listmodel as showcased in the example link I posted. The advantage is that handling a listmodel with data is so much easier. [20:17] nik90: yeah that is cool but it is the function that I need to get working [20:18] it is a nice model clean too [20:18] but model's are after I get the dang function to work. If I had access out side chroot then I would just do this in C++ [20:18] via mysql [20:19] how about you change the sqlite call to something like, [20:21] var rs = tx.executeSql('Select index from Directions where rowName=?', rowName); [20:21] first mistake I see in your sqlite call is using db.tx.executeSql while it should be tx.executeSql [20:23] in my sqlite call, you need replace "index" with somethign more appropriate [20:24] aNickForMe: does that help? [20:24] I am not awfully comfortable with qt localstorage. I am actually trying to move away to u1db :-) [20:24] just had a hangout about it :P [20:25] yeah I little but it is still not working [20:25] I changed it to var rs = tx.executeSql('Select ? from Directions',[rowName]); but it is returning undefined [20:27] my bad typo [20:27] did you use the caps like SELECT, FROM etc etc? [20:27] I made that mistake in my reply. [20:27] yeah it is returning the objects for some reason now [20:27] it console.logs [object Object] [object Object] [20:29] let me paste the function again [20:29] I dont see rowName property in the sqlite entries [20:29] http://paste.ubuntu.com/6693033/ [20:29] which property are you trying to match it against? [20:29] nik90: that is what I am getting from another page [20:30] aNickForMe: I know. But since you are effectively trying to get the data from another page and match it with the data in one of the entries in the table, which property are you comparing it against? [20:31] import "components/database.js" as DataBase onClicked:{var q = DataBase.getRowByName("home"); console.log(q) } [20:32] aNickForMe: ah okay. That makes sense now. [20:32] Component.onCompleted: { [20:32] DataBase.createInit() [20:32] var c = "home" [20:32] console.log("YO YO YO YO " +DataBase.getRowByName("home")) [20:33] that returns YO YO YO YO [object Object][object Object] [20:33] and not the string [20:41] I am sorry but I am not really sure what the issue is with the code === Ursinha-afk is now known as Ursinha === Ursinha is now known as Guest43575 [20:47] me either I am looking at the source code for location qml plugin [20:48] I know why it is retuning the object I just want to figure out how to change it know [20:48] nik90: you def helped with the string for the query [20:48] that was the big issue [20:48] hmm okay :-).. [20:48] I guess you need to access individual properties of the object somehow [20:49] so in your case that would be r.somepropertyname [20:49] that's what you need to figure out I guess === Guest43575 is now known as Ursinha === Ursinha is now known as Guest30084 [21:42] nik90: thanks again. [21:43] just got done reading the qmlsqldatabase_executeSql function good stuff [21:50] This is the app development chanel [21:50] where is the OS development chanel? [21:50] Channel* [22:11] PublicStaticVoid: join #ubuntu-touch [22:11] for OS development or any question related to Ubuntu Touch [22:11] nik90, awesome session on U1DB earlier. I've just started trying to figure out how to move our playlists/recently played data over to U1DB for the music-app [22:12] ahayzen: thnx mate [22:12] ahayzen: I am working on a sample app now to illustrate dyanmic document storage and retrieval stuff [22:12] nik90, playlists is an interesting one. because u can have many playlists and many tracks in each playlist [22:13] nik90, cool :) [22:13] I think there you would have one document per playlist [22:13] and each document will have the song name, duration as properties [22:13] nik90, yeah either 1 document per playlist or 1 per track in each playlist? [22:14] but I am new to this as well. So I would recommend running it by stuart later. [22:14] yup both should work [22:14] nik90, i think the former should work but yh i'm new so will have a play :) [22:14] exactly [22:14] :) [22:15] nik90, the only thing we were wondering is that we want *some* data to be synced and some not (eg settings synced but not playlists) so would these be best in diffferent databases? [22:16] ahayzen: wait what session ? [22:17] daker, https://plus.google.com/113051860352311525753/posts/UUjKWV3wGyi [22:18] ahayzen: aha! [22:18] daker, :) [22:21] ahayzen: regarding the sync part I am not sure. But as mentioned by stuart, sync is pretty much uncharted territory :) so hard to say [22:22] nik90, yep understood, we were just trying to think of limitations with our data. Did u say some community apps are currently using U1DB? [22:23] ahayzen: yup. Take a look at geldliste, saucybacon, ubuntu tasks (created as part of app developer showdown) [22:23] nik90, cool thanks :) [22:23] also word chain [22:24] nik90: Okay? [22:24] #ubuntu-touch [22:24] PublicStaticVoid: I forgot to ask if you are referring to Ubuntu Touch or Ubuntu development [22:24] PublicStaticVoid: for Ubuntu OS development go to #ubuntu-devel I think [22:25] Ubuntu Touch is for phones.. right? [22:25] PublicStaticVoid: well for now yes...eventually tablet, tv :) [22:26] I installed the package while installing from net install today [22:26] Thought it was a DE for my touchscreen haha [22:26] Dunno what it gave me [22:27] lol [23:09] nik90: Is there a beta for touch on touchscreen laptops x86_64 [23:19] PublicStaticVoid: Well the shell that you see in Touch called Unity 8 can be run on a laptop. so that's a yes to your question [23:19] it is obviously not yet suitable for a desktop yet. but the convergence work is undergoing. [23:21] PublicStaticVoid: here is a video of it running on a touchscreen laptop http://www.google.nl/url?sa=t&rct=j&q=&esrc=s&source=web&cd=9&cad=rja&ved=0CGwQtwIwCA&url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DK5BKtXpWN1A&ei=NJfIUsjKLenN0QXYz4HgDQ&usg=AFQjCNHstUcaddrkZ3z0ZtM_r_9oRJAiJQ&sig2=bkGNlR4TB2oKO4CE-O3RtQ [23:22] sorry that's a huge url. use this one -> http://www.youtube.com/watch?v=K5BKtXpWN1A [23:23] PublicStaticVoid: if you are on ubutu 13.10, you can install it using sudo apt-get install unity8 [23:24] and then run by "unity8 -mousetouch"