WebOS Internals - User contributions [en]

File:Icon-stamp.png

2011-07-09T14:35:23Z

Haeffb: uploaded a new version of "File:Icon-stamp.png": Timestamp icon for enyo toolbar

Timestamp icon for enyo toolbar

Mojo Design Icons

2011-07-09T14:32:17Z

Haeffb: /* Enyo Toolbar Icons */

Icons can be anything that quickly relates to an application. No text should be used and the icon will be resized for other uses so keep this in mind as you design your icon.

== Basics ==

Icons should be 64x64, but try and contain most of it in a 56x56 space. The 4px border will make sure that the re-size of the icon does not give poorly anti-aliased edges.

== Circle Backing ==

Most applications have a circle in the background, it has been recreated and below.

{{icon|Mojo_Design_Circle_Back.png}}
<div style="clear:both"></div>
(if anyone finds a better version or the real version overwrite it with the one above by clicking on it)

== Enyo Toolbar Icons ==
{{icon|icon-info3.png}}{{icon|icon-mail.png}}{{icon|icon-stamp.png}}
<div style="clear:both"></div>

== Other ==

=== WebOS Internals ===

For projects under WebOS Internals DNS it is recommened that they use the icon templates.

[[Icons|WebOS Internals Icon Templates]]

File:Icon-stamp.png

2011-07-09T14:31:28Z

Haeffb: Timestamp icon for enyo toolbar

Timestamp icon for enyo toolbar

Mojo Design Icons

2011-07-09T05:24:23Z

Haeffb: /* Enyo Toolbar Icons */

Icons can be anything that quickly relates to an application. No text should be used and the icon will be resized for other uses so keep this in mind as you design your icon.

== Basics ==

Icons should be 64x64, but try and contain most of it in a 56x56 space. The 4px border will make sure that the re-size of the icon does not give poorly anti-aliased edges.

== Circle Backing ==

Most applications have a circle in the background, it has been recreated and below.

{{icon|Mojo_Design_Circle_Back.png}}
<div style="clear:both"></div>
(if anyone finds a better version or the real version overwrite it with the one above by clicking on it)

== Enyo Toolbar Icons ==
{{icon|icon-info3.png}}{{icon|icon-mail.png}}
<div style="clear:both"></div>

== Other ==

=== WebOS Internals ===

For projects under WebOS Internals DNS it is recommened that they use the icon templates.

[[Icons|WebOS Internals Icon Templates]]

File:Icon-mail.png

2011-07-09T05:23:02Z

Haeffb: Email icon for enyo toolbar

Email icon for enyo toolbar

Mojo Design Icons

2011-07-08T03:18:52Z

Haeffb:

Icons can be anything that quickly relates to an application. No text should be used and the icon will be resized for other uses so keep this in mind as you design your icon.

== Basics ==

Icons should be 64x64, but try and contain most of it in a 56x56 space. The 4px border will make sure that the re-size of the icon does not give poorly anti-aliased edges.

== Circle Backing ==

Most applications have a circle in the background, it has been recreated and below.

{{icon|Mojo_Design_Circle_Back.png}}
<div style="clear:both"></div>
(if anyone finds a better version or the real version overwrite it with the one above by clicking on it)

== Enyo Toolbar Icons ==
{{icon|icon-info3.png}}
<div style="clear:both"></div>

== Other ==

=== WebOS Internals ===

For projects under WebOS Internals DNS it is recommened that they use the icon templates.

[[Icons|WebOS Internals Icon Templates]]

File:Icon-info3.png

2011-07-08T02:54:00Z

Haeffb: Info icon for enyo toolbar

Info icon for enyo toolbar

Mojo Design Icons

2011-07-08T02:53:05Z

Haeffb:

Icons can be anything that quickly relates to an application. No text should be used and the icon will be resized for other uses so keep this in mind as you design your icon.

== Basics ==

Icons should be 64x64, but try and contain most of it in a 56x56 space. The 4px border will make sure that the re-size of the icon does not give poorly anti-aliased edges.

== Circle Backing ==

Most applications have a circle in the background, it has been recreated and below.

{{icon|Mojo_Design_Circle_Back.png}}
<div style="clear:both"></div>
(if anyone finds a better version or the real version overwrite it with the one above by clicking on it)

== Other ==

== Enyo Toolbar Icons ==
{{icon|icon-info3.png}}
<div style="clear:both"></div>

=== WebOS Internals ===

For projects under WebOS Internals DNS it is recommened that they use the icon templates.

[[Icons|WebOS Internals Icon Templates]]

Application:OpenSSH

2010-01-09T14:55:48Z

Haeffb:

OpenSSH is a FREE version of the SSH connectivity tools that technical users of the Internet rely on.

Please refer to the [http://www.openssh.com/ OpenSSH Home Page] and read the [http://www.openssh.com/manual.html OpenSSH Manual Pages] before using this package.

If you are connecting to your webOS device from a Windows host computer, please read the [http://unixwiz.net/techtips/putty-openssh.html Secure Linux/UNIX access with PuTTY and OpenSSH Tech Tip] and follow those instructions for generating your SSH keys. For the section "Install public key on Linux system", you will need to put the "Public Key for pasting into OpenSSH authorized_keys file" into a /home/root/.ssh/authorized_keys file.

Optware installs openssh under /opt, so you should replace any references to /bin, /sbin, and /etc in the OpenSSH documentation with /opt/bin, /opt/sbin and /opt/etc respectively.

If you are not able to follow the [http://unixwiz.net/techtips/putty-openssh.html Secure Linux/UNIX access with PuTTY and OpenSSH Tech Tip] to generate your SSH keys, you can use the [http://www.webos-internals.org/wiki/Application:Terminal Terminal] application to create your secure SSH keys for use with OpenSSH directly on your webOS device. Your public ssh key needs to be stored in /home/root/.ssh/authorized_keys to be read by OpenSSH to allow root login via ssh keys.

You can use:

/opt/bin/ssh-keygen

to create the private and public keys. Accept the default filename by pressing Enter at the prompt. Enter a passphrase for your private key file. You will use this passphrase later, so remember it. After the key file is generated:

mv /home/root/.ssh/id_rsa.pub /home/root/.ssh/authorized_keys

to move the public key to become the /home/root/.ssh/authorized_keys file.

Now the secret key needs to be transferred to the workstation you want to log into the Pre. First copy the secret key to the accessible area with

cp /home/root/.ssh/id_rsa /media/internal/id_rsa

Tap on the USB symbol at the bottom of the Pre screen and choose 'USB Device' in order to access the media. Move the secret key to your workstation and follow the terminal software's instructions on how to make this new secret key known to the terminal.

Mojo Storage Database

2009-08-13T21:14:15Z

Haeffb: /* Creating a Database and a Table */

This page was created to help others by giving a basic example of creating a new database for your application and storing some data in it.

==SQL Overview==

It needs to be mentioned that SQLite (what HTML5 uses), is not as controlling as other databases. For one it's not going to give you an error when you insert text into an integer, or anything like that so regex all input for users or limit it in some way.

{| border="1" cellpadding="5" cellspacing="0" style="border-color:silver;"
|Data Type
|Example
|-
|INTEGER
|'0' '123' '3939'
|-
|REAL
|'1.1' '10.0'
|-
|TEXT
|'foo' 'bar'
|-
|BLOB
|[binary data / images]
|-
|NULL
|absolutely nothing
|}

==Creating a Database and a Table==

<source lang="javascript">
var name = "MyDB"; // required
var version = "0.1"; // required
var displayName = "My Mojo-Driven database"; // optional
var size = 200000; // optional

var db = openDatabase(name, version, displayName, size);

if (!db) {
Mojo.Log.error("Could not open database");
} else {
var sql = "CREATE TABLE IF NOT EXISTS 'my_table' (id INTEGER PRIMARY KEY, num REAL, data TEXT)"; // check sqlite data types for other values
db.transaction( function (transaction) {
transaction.executeSql(sql, // SQL to execute
[], // array of substitution values (if you were inserting, for example)
function(transaction, results) { // success handler
Mojo.Log.info("Successfully created table");
},
function(transaction, error) { // error handler
Mojo.Log.error("Could not create table: " + error.message);
}
);
});
}
</source>

In order to use non-anonymous event handlers, the function supplied to db.transaction has to be bound to the current context, as in the folling, modified example:

<source lang="javascript">
SceneAssistant.prototype.createMyTable = function(){
var name = "MyDB"; // required
var version = "0.1"; // required
var displayName = "My Mojo-Driven database"; // optional
var size = 200000; // optional

var db = openDatabase(name, version, displayName, size);
if (!db) {
Mojo.Log.error("Could not open database");
} else {
var sql = "CREATE TABLE IF NOT EXISTS 'my_table' (id INTEGER PRIMARY KEY, num REAL, data TEXT)"; // check sqlite data types for other values
db.transaction(
function (transaction) {
transaction.executeSql(sql, [],
this.dbSuccessHandler.bind(this),
this.dbErrorHandler.bind(this));
}.bind(this)); //this is important!
}
}

SceneAssistant.prototype.dbSuccessHandler = function(transaction, results){}
SceneAssistant.prototype.dbErrorHandler = function(transaction, errors){}
</source>

===openDatabase===

If you try to look for '''MyDB''' on the filesystem, you won't find it. The '''openDatabase''' method creates an entry in the '''Databases''' table in '''/var/usr/home/root/html5-databases/Databases.db''' which points to the actual location of your database. Note that the details in the Databases table are what you specified in openDatabase except version. Version is contained in the '''__WebKitDatabaseInfoTable__''' table in the actual database.

In the examples contained in this page, the database that is created has a maximum storage capacity of 1 MB. If you need a larger database, then append ext: to the beginning of the database name. For example:

<source lang="javascript">
var db = openDatabase("ext:MyDB", "0.1");
</source>

This will create the database in '''/media/internal/.app-storage'''.

==Inserting a Row==

<source lang="javascript">
var myNum = 512.785;
var test = "I'm test data!";

var db = openDatabase("MyDB", "0.1"); // this is all that is required to open an existing DB
var sql = "INSERT INTO 'my_table' (num, data) VALUES (?, ?)";

db.transaction( function (transaction) {
transaction.executeSql(sql, [myNum, test],
function(transaction, results) { // success handler
Mojo.Log.info("Successfully inserted record");
},
function(transaction, error) { // error handler
Mojo.Log.error("Could not insert record: " + error.message);
}
);
});
</source>

==Inserting Multiple Rows==

With asynchronous database methods, you can really screw things up if you try to do too many transacations in rapid succession. Luckily, you can run as many executeSql methods inside a single transaction as you need.

<source lang="javascript">
var dataArray = [];
for(var i = 0; i < 100; i++) {
dataArray[i] = i;
}

var db = openDatabase("MyDB", "0.1");

db.transaction( function (transaction) {
for(var i=0; i < dataArray.length; i++) {
var sql = "INSERT INTO 'my_table' (num, data) VALUES (?, ?)";
transaction.executeSql(sql, [dataArray[i], dataArray[i]],
function(transaction, results) { // success handler
Mojo.Log.info("Successfully inserted record");
},
function(transaction, error) { // error handler
Mojo.Log.error("Could not insert record: " + error.message);
}
);
}
});
</source>

==Retrieving Data==

When a query returns results to the success handler, the rows are contained in '''.rows'''.

<source lang="javascript">
var db = openDatabase("MyDB", "0.1");
var sql = "SELECT * FROM 'my_table'";

db.transaction(function(transaction) {
transaction.executeSql(sql, [],
function(transaction, results) {
// results.rows holds the rows returned by the query
var my_num = results.rows.item(0).num; // returns value of column num from first row
},
function(transaction, error) {
Mojo.Log.error("Could not read");
});
});
</source>