Android Question [Discontinued] Dropbox-Sync-Library Reloaded - BETA-release

[DonManfred]

This Library is Discontinued as by 2.4.2015


This thread is a open betatest of a new Version of the Dropbox-Sync-Library.
This new Version will allow you to use Dropbox´s Datastores too.
You can find the Dropbox Api documentation here.

You can download the Library-files from my Dropbox-Account here. Examples will follow today too.

Actual Version shared: 3.29 (Library_3.29.rar)
This uses the most up to date Dropbox-SDK 3.1.2

Example 1: (Attached to this post)
This Example Loads a shareable Datastore and when you click on the MenuItem "Copy customers from DB to DS" Parts of the Northwind-Database (SQLite-DB, included in Assets) will be copied into the Datastore. Including BLOBs.
After the Data is inserted you can click on a table to show its content.
When viewing Employees and Categories the content is shown in a ListView (TwoLinesandBitmap)






To use the DropboxSync-Library (and the Datastores) you need to follow Erels Tutorial about the library first. When you setup everything correctly than you can have a look at the new Methods of the DbxAccountManager and the other new objects like DbxDatastore, DbxTable, DbxRecord... You will find more Informations about each object in the next posts.

But let´s start with the additions to the already know DbxAccountManager.

manager.hasLinkedAccount

Results true or false. It the app is not linked to an Dropboxaccount then it will be false
If the app is linked (passed the authorization) then this will show true

example:

Log("HasLinkedAccount="&manager.hasLinkedAccount)

manager.GetLinkedAccounts

Gets a list of all linked Accounts (it can be more than one)
example:

Dim acclist As List=manager.GetLinkedAccounts

manager.GetAccount

Returns some Infos about the linked Account (Username, Organisationname and Displayname
example:

Dim dbxacc As Map = manager.GetAccount

manager.ListDatastores

Returns a list of all accessible Datastores

Example:

Dim dslist As List = manager.ListDatastores
Log("dslistsize="&dslist.Size)
For i = 0 To dslist.Size -1
    Log(dslist.Get(i))
Next

manager.deleteDatastore(<dsid>)

Deletes the Datastore with the given ID

Example:

manager.deleteDatastore(".Q6k45pfVTNzrHnP4982XlPAm9v15Fzc0p225LS6mkhQ")

manager.getDatastore(<dsid>)

Get the Datastore with the given ID
A Datastore (in b4a) is an Instance of an Object of Type DbxDatastore

example:

DIM ds as DbxDatastore = manager.getDatastore(".KhR8uRUPUH963GBbcPvn5_RFH3Vp1XKq2pAqZtwynq4")

manager.openOrCreateDatastore(<dsid>)

Creates a PRIVATE Datastore with the given ID.
Private Datastores are not shareable. The are for your own app only.

example

Dim ds As DbxDatastore = manager.openOrCreateDatastore(".KhR8uRUPUH963GBbcPvn5_RFH3Vp1XKq2pAqZtwynq4")

manager.createDatastore(shareds As boolean)

Creates a shareable Datastore. The ID is autocalculated in this case.
THIS is probably the type of Datastore you want to have/use!
If shareds is set to true then the Datastore will become a Principal = PUBLIC and a Role = EDITOR
If shareds is set to false then the defaults from Dropbox will apply.

example:

Dim ds As DbxDatastore = manager.createDatastore(true)

In relation to SqLite for example we can say:
- A Datastore is likely a Database. It can hold any number of Tables. Each table can hold any number of Records (Object DbxRecord). Each record can hold any number of fields as the Datastores does not have a scheme like oridinary Databasesystems.
- A Record is like in normal Databases a "record" of one Table.

Edit
Autogenerated docs made with xml2bb script from @warwound

DropboxSync
Version: 3.29

• DbxAccountManager
  Events:
  • AccountReady (Success As Boolean)
  • DatastoreDeleted (Success As Boolean)
  • DownloadCompleted (Success As Boolean, LocalDir As String, LocalFileName As String)
  • SyncCompleted (Success As Boolean)
  • onAccountChange (acc As Object)
  • onLinkedAccountChange (mgr as Object As , acc As Object)
  Fields:
  • AutoSync As Boolean
    If True then the cache will be synchronized automatically when a file is downloaded to assure that the latest file is downloaded.
  Methods:
  • DownloadFile (RemoteDir As String, RemoteFile As String, LocalDir As String, LocalFile As String)
    Downloads a file. If the file is not already in the cache then it will be automatically downloaded.
    The DownloadComplete event will be raised when the local file is ready.
    RemoteDir / RemoteFile - Remote path. The root folder (which is the app folder) is "/".
    LocalDir / LocalFile - The local file.
  • GetAccount As Map
  • GetLinkedAccount As DbxAccount
  • GetLinkedAccounts As List
  • Initialize (AppKey As String, AppSecret As String, EventName As String, setdebug As Boolean)
    Initializes the object.
    AppKey - The app key from Dropbox developer console.
    AppSecret - The app secret from Dropbox developer console.
    EventName - Sets the subs that will handle the events.
  • InitializeDatastoreManager
  • LinkAccount
    Links the application with the user's Dropbox account.
    If the account was not linked before then the user will be shown an authentication form.
    The AccountReady event will be raised when the account is ready.
  • ListDatastores As List
  • ListFiles (Dir As String) As List
    Returns a List with the infos of the files and folders under the given path.
    Each item in the list is a DbxFileInfo object.
  • Sync
    Forces a check for new file info from the server. The SyncCompleted event will be raised when the sync is completed.
  • UnlinkAccount
    Unlinks the application from the user's Dropbox account.
  • UploadFile (LocalDir As String, LocalFile As String, RemoteDir As String, RemoteFile As String)
    Writes a file to the local Dropbox cache. The file will be automatically uploaded to the Dropbox account.
    LocalDir / LocalFile - Path to the local file.
    RemoteDir / RemoteFile - Remote path. The root folder (which is the app folder) is "/".
    
    No event is raised after this action.
  • addListener (EventName As String)
  • createDatastore (shareDS As Boolean) As DbxDatastore
  • delete (Dir As String, FileName As String)
  • deleteDatastore (dsid As String)
  • getDatastore (dsid As String) As DbxDatastore
    
    Return type: @return:the Datastore with the ID dsid
  • hasLinkedAccount As Boolean
  • openDatastore (id As String) As DbxDatastore
  • openOrCreateDatastore (id As String) As DbxDatastore
    Opens the datastore with the given ID, creating it if it does not already exist.
    Datastores can be created offline with this method, and their contents will be
    merged with any datastore of the same name when the app is online again.
    The same datastore can't be opened more than once. You should generally keep
    a datastore open only when your the relevant part of app is on the screen, to
    maximize battery life.
    You must call DbxDatastore.close() when you are finished with a Datastore.
    See DbxDatastore.isValidId() for a description of valid strings for a datastore ID.
    Throws
    DbxException
    if there is a failure opening the datastore.
  • setDebug (debug As Boolean) As Boolean
    
    debug: the debug to set
  • stopListening
  Permissions:
  • android.permission.ACCESS_NETWORK_STATE
  • android.permission.INTERNET
  Properties:
  • Debug As Boolean [read only]
  • FileSystem As DbxFileSystem [read only]
• DbxDatastore
  Events:
  • onstatuschange (ds As DbxDatastore)
  Methods:
  • BASE_CHANGE_SIZE As Long
  • BASE_DATASTORE_SIZE As Long
  • BASE_UNSYNCED_CHANGES_SIZE As Long
  • Close
  • DATASTORE_SIZE_LIMIT As Long
  • GetEffectiveRole As Role
  • IsInitialized As Boolean
  • ListTables As List
    
    Return type: @return:
  • RECORD_COUNT_LIMIT As Long
  • Sync As Map
  • UNSYNCED_CHANGES_SIZE_LIMIT As Long
  • getTable (id As String) As DbxTable
    
    Return type: @return:
  • isOpen As Boolean
    Returns whether this DbxDatastore is currently open (i.e. it has not been closed).
  • isShareable As Boolean
    Returns whether this DbxDatastore can be shared with other users. (This is currently equivalent to whether the ID starts with ".".)
    Return type: @return:
  • isWriteable As Boolean
    Returns whether this DbxDatastore is writable by the current user. (This is currently equivalent to whether the role is EDITOR or OWNER.)
  • setrole (principal As String, dsrole As String)
  • startListening (EventName As String)
  • stopListening
  Properties:
  • ID As String [read only]
    gets the id of this Datastore
  • Mtime As Date [read only]
  • RecordCount As Long [read only]
    getRecordCount
  • Size As Long [read only]
    gets the size
  • SyncStatus As DbxDatastoreStatus [read only]
  • Title As String
    Returns the title of this datastore.
• DbxDatastoreStatus
  Methods:
  • IsInitialized As Boolean
  • hasIncoming As Boolean
    Set when there are remote changes that will be incorporated by the next call to DbxDatastore.sync().
  • hasOutgoing As Boolean
    Set when there are local changes that haven't yet been committed by a call to DbxDatastore.sync().
  • isConnected As Boolean
    Set when the API is in active communication with the server, so that remote changes are likely to be visible quickly, and local changes can be uploaded soon. The API will attempt to connect when datastores are open, but may fail if offline.
  • isDownloading As Boolean
    Set when there are remote changes that need to be downloaded from the server. Always set when a DbxDatastore is opened until the first successful check for updates. Always set for a local datastore.
  • isUploading As Boolean
    Set when there are local changes that need to be uploaded to the server. Always set for a local datastore that has any changes at all.
  • needsReset As Boolean
    Set when the datastore needs to be reset with a call to DbxDatastore.close() followed by DbxDatastoreManager.uncacheDatastore().
• DbxFields
  Methods:
  • Fieldnames As List
  • Initialize As DbxFields
    getRecord delete field name
  • IsInitialized As Boolean
  • deleteField (name As String) As DbxRecord
  • getBoolean (name As String) As Boolean
    Returns the Boolean "name".
  • getBytes (name As String) As Byte[]
    Returns the Bytes "name".
  • getDate (name As String) As Long
    Returns the Date "name".
  • getDouble (name As String) As Double
    Returns the Double "name".
  • getFieldType (name As String) As ValueType
    Returns the Double "name".
  • getId (o As Object) As Boolean
  • getList (name As String) As DbxList
    Returns the List "name".
  • getLong (name As String) As Long
    Returns the Long "name".
  • getOrCreateList (name As String) As DbxList
    Returns the Long "name".
  • getString (name As String) As String
    Returns the String "name".
  • getTitle (name As String) As String
  • hasField (name As String) As Boolean
    Returns
  • hashCode As Int
    Returns
  • isValidFieldName (name As String) As Boolean
  • setBoolean (name As String, value As Boolean) As DbxFields
    Returns
  • setByte (name As String, value() As Byte) As DbxFields
    Returns
  • setDate (name As String, value As Long) As DbxFields
    Returns
  • setDouble (name As String, value As Double) As DbxFields
    Returns
  • setFields (fields As DbxFields) As DbxFields
    Returns
  • setList (name As String, value As DbxList) As DbxFields
    Returns
  • setLong (name As String, value As Long) As DbxFields
    Returns
  • setString (name As String, value As String) As DbxFields
    Returns
• DbxFileInfo
  Methods:
  • IsInitialized As Boolean
  Properties:
  • IsFolder As Boolean [read only]
    Tests whether this is a folder.
  • ModifiedTime As Long [read only]
    Returns the last modified time based on the local device system clock.
  • Name As String [read only]
    Returns the file or folder name.
  • Path As DbxPath [read only]
  • Size As Long [read only]
    Returns the file size in bytes.
• DbxFileSystem
  Events:
  • onPathChange (Path As DbxPath, m As Mode)
  Methods:
  • GetModes As List
  • IsInitialized As Boolean
  • addPathListener (EventName As String, path As String, m As String)
  • stopPathListening (path As DbxPath, mode As Mode)
• DbxList
  Methods:
  • IsInitialized As Boolean
  • addBoolean (elem As Boolean) As DbxList
    Adds the given boolean value, appending it to the end of the list. Returns a
    reference to this object, to allow for call chaining.
    elem:
    Return type: @return:
  • addBooleanAt (index As Int, elem As Boolean) As DbxList
    Adds the given boolean value, inserting it at the given
    index in the list. Returns a reference to this object,
    to allow for call chaining.
    index:
    elem:
    Return type: @return:
  • addByte (elem() As Byte) As DbxList
    Adds the given byte value, appending it to the end of the list.
    The value must not be null. Returns a reference to this object,
    to allow for call chaining.
    elem:
    Return type: @return:
  • addByteAt (index As Int, elem() As Byte) As DbxList
    Adds the given byte value, inserting it at the given
    index in the list. The value must not be null. Returns
    a reference to this object, to allow for call chaining.
    index:
    elem:
    Return type: @return:
  • addDate (elem As Long) As DbxList
    Adds the given Date value, appending it to the end of the
    list. The value must not be null. Returns a reference to
    this object, to allow for call chaining.
    elem:
    Return type: @return:
  • addDateAt (index As Int, elem As Long) As DbxList
    Adds the given Date value, inserting it at the given
    index in the list. The value must not be null. Returns
    a reference to this object, to allow for call chaining.
    index:
    elem:
    Return type: @return:
  • addDouble (elem As Double) As DbxList
    Adds the given double value, appending it to the end of the list. Returns a
    reference to this object, to allow for call chaining.
    elem:
    Return type: @return:
  • addDoubleAt (index As Int, elem As Double) As DbxList
    Adds the given double value, inserting it at the given
    index in the list. Returns a reference to this object,
    to allow for call chaining.
    index:
    elem:
    Return type: @return:
  • addLong (elem As Long) As DbxList
    Adds the given long value, appending it to the end of the list. Returns a
    reference to this object, to allow for call chaining.
    elem:
    Return type: @return:
  • addLongAt (index As Int, elem As Long) As DbxList
    Adds the given long value, inserting it at the given
    index in the list. Returns a reference to this object,
    to allow for call chaining.
    index:
    elem:
    Return type: @return:
  • addString (elem As String) As DbxList
    Adds the given String value, appending it to the end of the list. The value
    must not be null. Returns a reference to this object, to allow for call chaining.
    elem:
    Return type: @return:
  • addStringAt (index As Int, elem As String) As DbxList
    Adds the given String value, inserting it at the given
    index in the list. The value must not be null.Returns
    a reference to this object, to allow for call chaining.
    index:
    elem:
    Return type: @return:
  • clear As DbxList
    Deletes all elements from this list.
    This operation will override any parallel
    changes rather than merging with them.
  • equals (elem As DbxList) As Boolean
  • getBoolean (index As Int) As Boolean
    Returns the value of a boolean element at the given index, which must exist and be of the correct type.
    index:
  • getBytes (index As Int) As Byte[]
    Returns the value of a byte element at the given index, which must exist and be of the correct type.
    index:
  • getDate (index As Int) As Long
    Returns the value of a Date element at the given index, which must exist and be of the correct type.
    index:
  • getDouble (index As Int) As Double
    Returns the value of a double element at the given index, which must exist and be of a numerical type.
    If the field value is a long, this method will silently convert it to a double. No conversion is
    performed on other field types.
    index:
  • getLong (index As Int) As Long
    Returns the value of a long element at the given index, which must exist and be of the correct type.
    This method won't convert a double or boolean field to a long.
    index:
  • getString (index As Int) As String
    Returns the value of a String element at the given index, which must exist and be of the correct type.
    index:
  • getType (index As Integer) As AtomType
    Returns the type of the element at the given index.
    index:
    Return type: @return:
  • hashCode As Int
  • isEmpty As Boolean
    Returns whether this list is empty.
    Return type: @return:
  • move (oldindex As Int, newindex As Int) As DbxList
    Moves the element at oldIndex (which must exist)
    to a position such that its index in the modified
    list will be newIndex. Returns a reference to
    this object, to allow for call chaining.
    oldindex:
    newindex:
    Return type: @return:
  • remove (index As Int) As DbxList
    Removes the element at the given index,
    which must exist. Returns a reference to
    this object, to allow for call chaining.
    index:
    Return type: @return:
  • setBooleanAt (index As Int, elem As String) As DbxList
    Replaces the element at the given index
    with a new boolean value. Returns a
    reference to this object, to allow for
    call chaining.
    index:
    elem:
    Return type: @return:
  • setByteAt (index As Int, elem() As Byte) As DbxList
    Replaces the element at the given index with a
    new String value. The value must not be null.
    Returns a reference to this object, to allow
    for call chaining.
    index:
    elem:
    Return type: @return:
  • setDateAt (index As Int, elem As Long) As DbxList
    Replaces the element at the given index with a
    new Date value. The value must not be null.
    Returns a reference to this object, to allow
    for call chaining.
    index:
    elem:
    Return type: @return:
  • setDoubleAt (index As Int, elem As Double) As DbxList
    Replaces the element at the given index with a
    new double value. Returns a reference to this
    object, to allow for call chaining.
    index:
    elem:
    Return type: @return:
  • setLongAt (index As Int, elem As Long) As DbxList
    Replaces the element at the given index with
    a new long value. Returns a reference to this
    object, to allow for call chaining.
    index:
    elem:
    Return type: @return:
  • setStringAt (index As Int, elem As String) As DbxList
    Replaces the element at the given index with a
    new String value. The value must not be null.
    Returns a reference to this object, to allow
    for call chaining.
    index:
    elem:
    Return type: @return:
  • size As Int
    Returns the number of elements in this list.
    Return type: @return:integer
• DbxPath
  Methods:
  • IsInitialized As Boolean
• DbxRecord
  Methods:
  • IsInitialized As Boolean
  • asMap As Map
  • deleteRecord
  • fieldNames As List
  • getBoolean (name As String) As Boolean
    Returns the Boolean "name".
  • getBytes (name As String) As Byte[]
    Returns the Bytes "name".
  • getDate (name As String) As Date
    Returns the Date "name".
  • getDouble (name As String) As Double
    Returns the Double "name".
  • getFieldType (name As String) As ValueType
    Returns the Double "name".
  • getList (name As String) As DbxList
    Returns the List "name".
  • getLong (name As String) As Long
    Returns the Long "name".
  • getString (name As String) As String
    Returns the String "name".
  • hasField (name As String) As Boolean
    Returns
  • hashCode As Int
    Returns
  • isDeleted As Boolean
    Returns
  • setBoolean (name As String, value As Boolean) As DbxRecord
    Returns
  • setByte (name As String, value() As Byte) As DbxRecord
  • setDate (name As String, value As Long) As DbxRecord
  • setDouble (name As String, value As Double) As DbxRecord
  • setFields (fields As DbxFields) As DbxRecord
  • setList (name As String, value As DbxList) As DbxRecord
  • setLong (name As String, value As Long) As DbxRecord
  • setString (name As String, value As String) As DbxRecord
  Properties:
  • Id As String [read only]
    gets the ID
  • Size As Long [read only]
    Returns the Long "name".
• DbxTable
  Methods:
  • Insert As DbxRecord
    getRecord with ID id
  • IsInitialized As Boolean
  • getOrInsert (id As String) As DbxRecord
  • query As QueryResult
  Properties:
  • Id As String [read only]
    gets the ID
• QueryResult
  Methods:
  • GetAll As List
  • IsInitialized As Boolean
  • RecordCount As Integer
  • hasResults As Boolean

 

[DonManfred]

Placeholder for future editings (1)

The object DbxDatastore

Dim ds As DbxDatastore = manager.getDatastore(".KhR8uRUPUH963GBbcPvn5_RFH3Vp1XKq2pAqZtwynq4")

The Datastore can be treated like an sqlite-database. It´s the Database and it can hold any numbers of tables.

ds.setrole(String principal, String dsrole)

Sets the Role and the Pricipal to a Datastore.
Principal can be one of the strings "PUBLIC" or "TEAM".
Role can be one of the strings "OWNER", "EDITOR", "VIEWER" or "NONE".
This will only work with a "shareable Datastore"!
Available in Library v3.30

ds.isShareable()

Returns whether this DbxDatastore can be shared with other users. (This is currently equivalent to whether the ID starts with ".".)
Available in Library v3.30

ds.isWriteable()

Returns whether this DbxDatastore is writable by the current user. (This is currently equivalent to whether the role is EDITOR or OWNER.)
Available in Library v3.30

ds.ListTables

Returns a set of all tables in the datastore that currently contain any records.

Example:

Dim tabellen As List = ds.ListTables
Log("Num Tables="&tabellen.Size)
For i = 0 To tabellen.Size-1
    Dim dsid As String = tabellen.Get(i)
    If dsid.StartsWith(":") Then
    Else
        Log(tabellen.Get(i))
    End If
Next

ds.getTable("customers")

Get the Table with the given name from the Datastore. A Table in this case is a object of Type DbxTable.
The Table is a subset of an Datastore. The Table hold all Records which are in this Table.

Example:

Dim t As DbxTable = ds.getTable("customers")

ds.IsInitialized

Returns whether the Datastore is initialized or not.

ds.Close

Closes this datastore, and ceases monitoring for updates. This must be called to release this datastore when you're finished with it.

Any changes you committed with a call to sync() are safe on disk, and will continue to upload in the background until the DbxDatastoreManager is shut down, after which they will remain queued until the next time you open this datastore. Any changes made since the last call to sync() will be discarded.


You must close a datastore when you're done using it to indicate to the Sync API that you are no longer interested in receiving updates for this datastore. After a call to this method, the Datastore can no longer be used and listeners will no longer be called. You must open the datastore again if you want to access it.

ds.ID

Returns the ID of this Datastore

ds.isOpen

Returns whether a Datastore is opened or not.

ds.RecordCount

Returns the total number of records in this datastore.

ds.Size

Returns the size of this datastore in bytes. The overall size of a datastore is calculated by summing the size of all records, plus the base size of an empty datastore itself.

ds.Mtime

Returns the last modified time of this datastore, or null if no data has been synced yet.
The last modified time is automatically updated on each call to sync() which commits local changes, or incorporates remote changes. The timestamp is based on the local clock of the device where the change is made.

ds.Sync

Sync the Datastore. This is probably the MOST used command when working with Datastores. Everytime when you edit a record, change a record or create a new record in a table... All changes are in memory first.... A call of ds.Sync will "submit" all changes to the Datastore. The Dropbox manager will then sync th datastore with the dropboxserver mixing all together.

Apply all outstanding changes to the datastore, and also incorporate remote changes into this datastore. This method does not wait for network I/O, but does wait for disk I/O. When this method returns, all local changes have been safely saved to disk, and will be uploaded in the background.

Returns a map from table IDs to sets of DbxRecords. These correspond to the tables and records that changed due to remote changes applied during this sync. Records deleted on the server will be included in the list, and you can call DbxRecord.isDeleted() to detect them. If nothing was changed remotely, the result is an empty map.
NOTE: This is actually missing in the library but it stands on the Todo list.

Throws
DbxException.NotFound
if the datastore was deleted on the server.


DbxException
if there is a problem updating local state.

ds.Title

Gets or sets the Title of this Datastore

ds.BASE_CHANGE_SIZE ' The size in bytes of a change before accounting for the size of its values.The overall size of a change is this value plus the size of the values in the change.
ds.BASE_DATASTORE_SIZE '  The size in bytes of a datastore before accounting for the size of its records. The overall size of a datastore is this value plus the size of all records.
ds.BASE_UNSYNCED_CHANGES_SIZE ' The size in bytes of unsynced changes before accounting for the size of each change.The overall size of unsynced changes is this value plus the size of each change.
ds.DATASTORE_SIZE_LIMIT ' The maximum size in bytes of a datastore.
ds.UNSYNCED_CHANGES_SIZE_LIMIT ' The maximum size in bytes of changes that can be queued up between calls to sync().
ds.RECORD_COUNT_LIMIT ' The maximum number of records in a datastore.

Some Informations about sizes and limits.
tbc

 

[DonManfred]

The object DbxTable

Dim t As DbxTable = ds.getTable("customers")

Todo: Documenting the properties and methods

t.getOrInsert(<id>)

Get the DbxRecord with the given id. If the record is not found then it is created.

t.Id

Get the id of this Table

t.Insert

Insert a new Record in the Table and return the new created DbxRecord object

t.IsInitialized

Returns whether the table is initialized or not

t.query

Return all Records of this table as a QueryResult.

 

[DonManfred]

The object DbxRecord
The record is the smallest part of an Datastore.
Remember: A Datastore can hold any number of Tables. Each table can have its own Records

Dim rec As DbxRecord = t.Insert()

ToDo: Documenting the properties and methods

rec.asMap

Returns all fields of this record as a map. This is usually the most interesting method.

rec.fieldNames

Returns a list with all Fieldnames of this record.

rec.getBoolean(key As String)

Return a Boolean with the fieldname key

rec.getBytes(key As String)

Return a byte[] with the fieldname key

rec.getDate(key As String)

Return a Long with the fieldname key

rec.getDouble(key As String)

Return a Double with the fieldname key

rec.getFieldType(key As String)

Returns the Fieldtype of the field key

rec.getList(key As String)

Return a List of type DbxList with the fieldname key

rec.getLong(key As String)

Return a Long with the fieldname key

rec.getString(key As String)

Return a String with the fieldname key

rec.hasField(key As String)

Returns whether the record has the key or not

rec.hashCode

Return the hash-code of this Record

rec.Id

Return the records id

rec.isDeleted

Return whether the record is deleted

rec.isInitialized

Return whether the object is initialized

rec.setBoolean(key As String, value as Boolean)

Sets the boolean value to the field with the name key

rec.setBytes(key As String, value[] as Byte)

Sets the byte[] value to the field with the name key

rec.setDate(key As String, value as Long)

Sets the Long value to the field with the name key

rec.setDouble(key As String, value as Double)

Sets the Double value to the field with the name key

rec.setFields(value as DbxFields)

Sets the fields value to the record

rec.setList(key As String, value as DbxList)

Sets the List value to the field with the name key

rec.setLong(key As String, value as Long)

Sets the Long value to the field with the name key

rec.setString(key As String, value as String)

Sets the string value to the field with the name key

rec.Size

Returns the size of this record

 

[DonManfred]

The object DbxList

Spoiler: Properties and methods

ToDo: Documenting the methods

Dim l As DbxList
l.addBoolean
l.addBooleanAt
l.addByte
l.addByteAt
l.addDate
l.addDateAt
l.addDouble
l.addDoubleAt
l.addLong
l.addLongAt
l.clear
l.equals
l.GetType
l.hashCode
l.IsInitialized
l.setBooleanAt
l.setByteAt
l.setDateAt
l.setDoubleAt
l.setLongAt
l.setStringAt

 

[DonManfred]

The object QueryResult

The QueryResult is a list of all Records (DbxRecord) which is returned by a query-call in a table

Dim res As QueryResult = t.query
Dim l As List = res.GetAll
Log("SizeOfCustomers="&l.Size)
datastore.Clear
For i = 0 To l.Size -1
    Dim rec As DbxRecord  = l.Get(i)
    Log("Map="&rec.asMap)
Next

 

[lemonisdead]

Congrats dear DonManfred. Nice shot
Edit: but I wonder if this post won't be better put in the Library thread instead of the Question one

 

[DonManfred]

but I wonder if this post won't be better put in the Library thread instead of the Question one

The library will be published here, yes. BUT it is still a BETA-Release (not for production) and i asked erel what to do. I mean; where to discuss this betatest. I thought about a private message with all testers. But in private messages you are not allowed to upload attachments.
So i asked Erel

I think that a single thread in the questions forum should be the best place to discuss it.

Here is am. THIS is the thread i will use for my Betatest

When the libary is fit to get an RC-status then i will Post the library in the Librarysection too. For sure.

 

[DonManfred]

The object DbxDatastoreStatus hold some Sync-Informations about the Datastore.
You can get the Datastore-Sync-Status by calling

Dim dsstatus as DbxDatastoreStatus = ds.getSyncStatus

dsstatus.hasIncoming

Set when there are remote changes that will be incorporated by the next call to DbxDatastore.sync().

dsstatus.hasOutgoing

Set when there are local changes that haven't yet been committed by a call to DbxDatastore.sync().

dsstatus.isConnected

Set when the API is in active communication with the server, so that remote changes are likely to be visible quickly, and local changes can be uploaded soon. The API will attempt to connect when datastores are open, but may fail if offline.

dsstatus.isDownloading

Set when there are remote changes that need to be downloaded from the server. Always set when a DbxDatastore is opened until the first successful check for updates. Always set for a local datastore.

dsstatus.IsInitialized

dsstatus.isUploading

Set when there are local changes that need to be uploaded to the server. Always set for a local datastore that has any changes at all.

dsstatus.needsReset

Set when the datastore needs to be reset with a call to DbxDatastore.close() followed by DbxDatastoreManager.uncacheDatastore().

 

[DonManfred]

Start betatest now
The first post is updated and a link to download is inserted.
As to the size of the files i have shared it on my Dropbox

Example will follow later today. I´ll look out to create an suiteable example to convert exiting data into a Datastore.

 

[Peter Simpson]

Nice one Manfred

I like the way that you want really in depth with your tutorial in the first thread.

Cheers...

 

[DonManfred]

A few minutes ago i got a BADLY DAMN importantly note about my problem with the newest SDK 3.1.2 which are needed to Share a Datastore... I forgot to copy the native libs (.so)!!!

I´m working on trying the new SDK actually. Will update the files when i think it works later.

THANK YOU SO MUCH for the hint in b4a-chat just before i lost connection to it, @thedesolatesoul !!!!

 

[DonManfred]

Version updated to v3.29 (see Library_3.29.rar in my shared dropbox in post #1)!
New:
Sharing a Datastore is now possible!

 

[thedesolatesoul]

The server went down i think. But you were at work in the background!

 

[DonManfred]

The server went down i think. But you were at work in the background!

Let me say again a HUGE BIG THANK YOU at this point! The point with the nativelibs did the job! YES!
Thank you for this hint!!!! You rule

The library now uses the most actual SDK and Datastore can be declared as shareable resp. shared. GREAT!

 

[DonManfred]

First Example Online (See Post #1)

The Maincode is the copying of some data from the sqlite-database to the Datastore.

Here is the code (Full source is included in Example1 in Post #1)

Sub MenuCopycustomers_Click
    Log("MenuCopycustomers")
    If ds.IsInitialized = False Then
        Log("Datastore is not Initialized.")
    Else
        Log("Datastore is Initialized. Title: "&ds.Title)
        Dim Row As Int
        Dim cur As Cursor
     
        '
        ' Table Customers
        '
        Dim t As DbxTable = ds.getTable("Customers")
        Dim res As QueryResult = t.query
        Dim l As List = res.GetAll
        Log("SizeOfCustomers="&l.Size)
        datastore.Clear
        For i = 0 To l.Size -1
            'Log(l.Get(i))
            Dim rec As DbxRecord  = l.Get(i)
            rec.deleteRecord         
        Next

        'We read only the ID column and put them in a List
        cur = db.ExecQuery("SELECT * FROM Customers")
        If cur.RowCount > 0 Then                        'check if entries exist
            RowNumber = cur.RowCount                    'set the row count variable
            For Row = 0 To cur.RowCount - 1
                cur.Position = Row                            'set the Cursor to each row
                'Dim rec As DbxRecord = t.getOrInsert(cur.GetString("CustomerID"))
                Dim rec As DbxRecord = t.Insert()
                For i = 0 To cur.ColumnCount-1
                    Log(cur.GetColumnName(i)&"="&cur.GetString(cur.GetColumnName(i)))
                    If cur.GetString(cur.GetColumnName(i)) = Null Then
                        rec.setString(cur.GetColumnName(i),"")
                    Else
                        rec.setString(cur.GetColumnName(i),cur.GetString(cur.GetColumnName(i)))
                    End If
                Next
                Log(rec.asMap)
                'rec.setString("str","Teststring")
                'rec.setString("str2","Teststring2")
                'rec.setString("str3","Teststring3")
                'rec.setDate("datum",DateTime.Now)
                'rec.setLong("long",123456)
                'rec.setBoolean("boolean",False)
                'rec.setDouble("double",3.14)
                         
                Log(cur.GetString("CustomerID")&":"&cur.GetString("CompanyName"))
            Next
            ds.Sync
            CurrentIndex = 0                                            'set the current index to 0
        End If
        cur.Close                                                        'close the cursor, we don't need it anymore

        '
        ' Table Categories
        '
        Dim t As DbxTable = ds.getTable("Categories")
        Dim res As QueryResult = t.query
        Dim l As List = res.GetAll
        Log("SizeOfCategories="&l.Size)
        datastore.Clear
        For i = 0 To l.Size -1
            'Log(l.Get(i))
            Dim rec As DbxRecord  = l.Get(i)
            rec.deleteRecord         
        Next
        cur.Close                                                        'close the cursor, we don't need it anymore

        'We read only the ID column and put them in a List
        cur = db.ExecQuery("SELECT * FROM Categories")
        If cur.RowCount > 0 Then                        'check if entries exist
            RowNumber = cur.RowCount                    'set the row count variable
            For Row = 0 To cur.RowCount - 1
                cur.Position = Row                            'set the Cursor to each row
                'Dim rec As DbxRecord = t.getOrInsert(cur.GetString("CustomerID"))
                Dim rec As DbxRecord = t.Insert()
                Dim BlobBuffer() As Byte
                BlobBuffer = cur.GetBlob("Picture")

                rec.setString("CategoryID",CheckNull(cur.GetString("CategoryID")))
                rec.setString("CategoryName",CheckNull(cur.GetString("CategoryName")))
                rec.setString("Description",CheckNull(cur.GetString("Description")))
                rec.setByte("Picture",BlobBuffer)
                Log(rec.asMap)
                'rec.setString("str","Teststring")
                'rec.setString("str2","Teststring2")
                'rec.setString("str3","Teststring3")
                'rec.setDate("datum",DateTime.Now)
                'rec.setLong("long",123456)
                'rec.setBoolean("boolean",False)
                'rec.setDouble("double",3.14)
                         
                Log(cur.GetString("CategoryID")&":"&cur.GetString("CategoryName")&":"&cur.GetString("Description"))
            Next
            ds.Sync
            CurrentIndex = 0                                            'set the current index to 0
        End If
        cur.Close                                                        'close the cursor, we don't need it anymore

        '
        ' Table Employees
        '
        Dim t As DbxTable = ds.getTable("Employees")
        Dim res As QueryResult = t.query
        Dim l As List = res.GetAll
        Log("SizeOfCategories="&l.Size)
        datastore.Clear
        For i = 0 To l.Size -1
            'Log(l.Get(i))
            Dim rec As DbxRecord  = l.Get(i)
            rec.deleteRecord         
        Next
        cur.Close                                                        'close the cursor, we don't need it anymore

        'We read only the ID column and put them in a List
        cur = db.ExecQuery("SELECT * FROM Employees")
        If cur.RowCount > 0 Then                        'check if entries exist
            RowNumber = cur.RowCount                    'set the row count variable
            For Row = 0 To cur.RowCount - 1
                cur.Position = Row                            'set the Cursor to each row
                'Dim rec As DbxRecord = t.getOrInsert(cur.GetString("CustomerID"))
                Dim rec As DbxRecord = t.Insert()
                Dim BlobBuffer() As Byte
                'cur.GetBlob("Photo")

                rec.setLong("EmployeeID",cur.GetString("EmployeeID"))
                rec.setString("LastName",CheckNull(cur.GetString("LastName")))
                rec.setString("FirstName",CheckNull(cur.GetString("FirstName")))
                rec.setString("Title",CheckNull(cur.GetString("Title")))
                rec.setString("TitleOfCourtesy",CheckNull(cur.GetString("TitleOfCourtesy")))
                rec.setString("Address",CheckNull(cur.GetString("Address")))
                rec.setString("City",CheckNull(cur.GetString("City")))
                rec.setString("Region",CheckNull(cur.GetString("Region")))
                rec.setString("PostalCode",CheckNull(cur.GetString("PostalCode")))
                rec.setString("Country",CheckNull(cur.GetString("Country")))
                rec.setString("HomePhone",CheckNull(cur.GetString("HomePhone")))
                rec.setString("Extension",CheckNull(cur.GetString("Extension")))
                rec.setString("Notes",CheckNull(cur.GetString("Notes")))
                rec.setString("PhotoPath",CheckNull(cur.GetString("PhotoPath")))
                Dim BlobBuffer() As Byte
                BlobBuffer = cur.GetBlob("Photo")
                rec.setByte("Photo",BlobBuffer)
                rec.setString("BirthDate",cur.GetLong("BirthDate"))
                rec.setString("HireDate",cur.GetLong("HireDate"))

                Log(rec.asMap)
                'rec.setString("str","Teststring")
                'rec.setString("str2","Teststring2")
                'rec.setString("str3","Teststring3")
                'rec.setDate("datum",DateTime.Now)
                'rec.setLong("long",123456)
                'rec.setBoolean("boolean",False)
                'rec.setDouble("double",3.14)
                         
                Log(cur.GetString("EmployeeID")&":"&cur.GetString("LastName")&", "&cur.GetString("FirstName"))
            Next
            ds.Sync
            CurrentIndex = 0                                            'set the current index to 0
        End If
        cur.Close                                                        'close the cursor, we don't need it anymore

    End If
End Sub

and the maincode fillling the ListView is

Sub lv_ItemClick (Position As Int, Value As Object)
    Log("lv_ItemClick("&Position&", "&Value&")")
    Dim t As DbxTable = ds.getTable(Value)
    Dim res As QueryResult = t.query
    Dim l As List = res.GetAll
    Log("SizeOf("&Value&")="&l.Size)
    datastore.Clear
    For i = 0 To l.Size -1
        'Log(l.Get(i))
        Dim rec As DbxRecord  = l.Get(i)
        'Log(rec.fieldNames)
        'Select Value
        'Case "Categories"
        If Value = "Categories" Then
            Dim bmp As Bitmap
            Dim In1 As InputStream
          Dim buffer() As Byte           
            buffer = rec.getBytes("Picture")
            In1.InitializeFromBytesArray(buffer,0,buffer.Length)
            bmp.Initialize2(In1)           
            datastore.AddTwoLinesAndBitmap2(rec.asMap.Get("CategoryName"),rec.asMap.Get("Description"),bmp,rec.asMap)
        Else If Value = "Employees" Then
            Dim bmp As Bitmap
            Dim In1 As InputStream
          Dim buffer() As Byte           
            buffer = rec.getBytes("Photo")
            In1.InitializeFromBytesArray(buffer,0,buffer.Length)
            bmp.Initialize2(In1)           
            datastore.AddTwoLinesAndBitmap2(rec.asMap.Get("LastName")&", "&rec.asMap.Get("FirstName"),rec.asMap.Get("Address"),bmp,rec.asMap)
        Else   
            datastore.AddTwoLines2(rec.asMap.Get("datum"),rec.asMap,rec.asMap)
        End If
        Log("Map="&rec.asMap)
        'rec.
        'Log(rec)
        'Dim rec As DbxRecord = l.Get(i)
        'Log(rec.fieldNames)
    Next

    'Dim retmap As Map = Value   
End Sub

 

[DonManfred]

I would like to know whether someone has used the example and HE/SHE can use the Datastore with the ID i have included in Example??? This DS should be PUBLIC and EDITABLE by evryone who know the ID....
Feel free to use this ID and put data into this datastore to test this functionality of the library!

 

[LorenzoTRANSFEREX]

I would like to know whether someone has used the example and HE/SHE can use the Datastore with the ID i have included in Example??? This DS should be PUBLIC and EDITABLE by evryone who know the ID....
Feel free to use this ID and put data into this datastore to test this functionality of the library!

I don't able to use ds with your id, but I don't know if I am doing something worng because it don't work with my own id...

 

[MarcoRome]

Hi DonManfred
I saw properties "Path" documented but i dont see in the lib

The question is...after loading a file exists the way to get the link, example:

manager.UploadFile(File.DirRootExternal,"devil_logoxxx.jpg","/123/","devil_logoxxx.jpg")
Dim return_path as String
return_path = filemanger.path
or another thing.....

and we get this:

https://dl.dropboxusercontent.com/s/zrttoa6f74ij3ta/ico_recordocall.png?dl=0

Thank you in advance
Marco

 

[DonManfred]

I saw properties "Path" documented but i dont see in the lib

Path is a property of DbxFileinfo not of the DropboxManager.

The question is...after loading a file exists the way to get the link

Please try the Version here 3.31

With this Version you can get the url after you get a filelist

        Dim files As List = manager.ListFiles("/")   
        For i = 0 To files.Size -1
            Dim fi As DbxFileInfo = files.Get(i)
            Dim fs As DbxFileSystem = manager.fileSystem
            log(fs.fetchShareLink(fi.Path,False)) ' Normal link like the one you posted
            log(fs.fetchShareLink(fi.Path,true)) ' A shortenened version of the downloadlink
        Next