Android Question Database update for app in the play store

mscientist33 said:

I have an app that has the following code in the "Starter"

DB copy code:

If File.Exists(File.DirInternal, Filename) = False Then
        File.Copy(File.DirAssets, Filename, File.DirInternal, Filename)
        'Log("Copied")
    End If

It checks if the database exists and if not copies it.

Lets say the app then gets put on google play store. I then update the database, either add columns or add rows to some tables but not add new tables.

The main question is, how does google play work with "updates"? If I have to add code to the update, what is the best way for my program to check if the database actually needs to be replaced? I'm not sure how to update my database on an upgrade and it not copying the database every time the app runs.

Click to expand...

modDB.AddColumn("tblMobileUserAccounts","ProviderTypeID","INTEGER",SQL1)

public Sub AddColumn(TableName As String    ,FieldName As String, Definition As String ,SQL1 As SQLCipher)
    
    Try
        modFun.strName="modDB"
        
        Dim MySQL As String=""
        
        If IsFieldExists2(TableName,FieldName,SQL1)=True Then
            Return
        End If
                
        MySQL="ALTER TABLE " & TableName & " Add " & FieldName & " " & Definition & ";"
        
        SQL1.ExecNonQuery(MySQL)
        
    Catch
        Log("AddColumn " & LastException.Message)
        modFun.ShowError("modDB_AddColumn " & LastException.Message)
    End Try
    
End Sub

tblProfession="CREATE TABLE  IF NOT EXISTS tblProviderTypes ( "
    tblProfession=tblProfession & "ID INTEGER Not Null PRIMARY KEY AUTOINCREMENT, "
    tblProfession=tblProfession & "ProviderTypeID int,"
    tblProfession=tblProfession & "ProviderType Text,"
    tblProfession=tblProfession & "Description Text"
    tblProfession=tblProfession & ")"
    
    SQL1.ExecNonQuery(tblProfession)

mscientist33 said:

What is the logic you recommend so it doesn't try to run the script every time you run the app after the update?

Click to expand...

mscientist33 said:

I have an app that has the following code in the "Starter"

DB copy code:

If File.Exists(File.DirInternal, Filename) = False Then
        File.Copy(File.DirAssets, Filename, File.DirInternal, Filename)
        'Log("Copied")
    End If

It checks if the database exists and if not copies it.

Lets say the app then gets put on google play store. I then update the database, either add columns or add rows to some tables but not add new tables.

The main question is, how does google play work with "updates"? If I have to add code to the update, what is the best way for my program to check if the database actually needs to be replaced? I'm not sure how to update my database on an upgrade and it not copying the database every time the app runs.

Click to expand...

Sub Activity_Create(FirstTime As Boolean)
    Activity.LoadLayout("Layout")
    'Your App first version, you can create a new txt file named "version.txt" and write a sign(for example,it is a number 1.0)
    If File.Exists(File.DirInternal,"version.txt")=False Then
        File.Copy(File.DirAssets,"version.txt",File.DirInternal,"version.txt")
    End If
    Dim VersionNum As String
    VersionNum=File.ReadString(File.DirInternal,"version.txt")
    
    If FirstTime  And VersionNum<1.5 Then  '1.5 is the sign of new app version
        'del your old database
        If File.Exists(File.DirInternal, "my.db") = True Then
            File.Delete(File.DirInternal, "my.db")
        End If
        'copy new database to File.DirInternal
        File.Copy(File.DirAssets,"new.db",File.DirInternal,"my.db")
        File.WriteString(File.DirInternal,"version.txt",1.5) 'also not need this line
    End If
End Sub