Storage

The Social component in app builders typically provides functionalities that allow developers to integrate social media features into their applications, facilitating interaction, sharing, and engagement with social platforms.

About the component


Image Description
  •  Last Update 25 Oct, 2023
  •  Component Version : 2.0.0
  •  API 21, Android 5.0 Lollipop
  •  29 Blocks Available

SqLite

The SQLite component provides a non-visible component for working with SQLite databases.

Overview

The SQLite component is a non-visible component offering a range of functions for interacting with SQLite databases, including database management, data manipulation, and querying.

Events

Image Description
Events

AfterDelete

  • Event triggered after a delete operation.

    • # Name Type(s) Default Value
    1 rowCount int
    Image Description
    Events

    AfterExecute

  • Event triggered after executing a SQL statement.

    • # Name Type(s) Default Value
    1 result any
    Image Description
    Events

    AfterExecuteFile

  • Event triggered after executing SQL statements from a file.

    • # Name Type(s) Default Value
    1 execCount int
    Image Description
    Events

    AfterInsert

  • Event triggered after an insert operation.

    • # Name Type(s) Default Value
    1 rowId long
    Image Description
    Events

    AfterInsertFile

  • Event triggered after inserting data from a file.

    • # Name Type(s) Default Value
    1 rowCount int
    Image Description
    Events

    AfterReplace

  • Event triggered after a replace operation.

    • # Name Type(s) Default Value
    1 rowId long
    Image Description
    Events

    AfterSelect

  • Event triggered after a select operation.

    • # Name Type(s) Default Value
    1 rowCount int
    2 rows list
    Image Description
    Events

    AfterUpdate

  • Event triggered after an update operation.

    • # Name Type(s) Default Value
    1 rowCount int
    Image Description
    Events

    DatabaseClosed

  • Event triggered after the database is closed.

    • Image Description
    Events

    DatabaseCreated

  • Event triggered after the database is created.

    • Image Description
    Events

    DatabaseOpened

  • Event triggered after the database is opened.

    • Image Description
    Events

    DatabaseUpgrade

  • Event triggered when the database is upgraded.

    • # Name Type(s) Default Value
    1 oldVersion int
    2 newVersion int
    Image Description
    Events

    DatabaseDowngrade

  • Event triggered when the database is downgraded.

    • # Name Type(s) Default Value
    1 oldVersion int
    2 newVersion int
    Image Description
    Events

    SQLError

  • Event triggered when a SQL error occurs.

    • # Name Type(s) Default Value
    1 message text

    Methods

    Image Description
    Methods

    BeginTransaction

  • Begins a transaction.

    • Image Description
    Methods

    CloseDatabase

  • Closes the database connection.

    • Image Description
    Methods

    CommitTransaction

  • Commits the current transaction.

    • Image Description
    Methods

    DatabaseExists

  • < span class="legend-indicator bg-primary">

    Checks if the database exists.

    • # Name Type(s) Default Value
    1 databaseName String
    Image Description
    Methods

    DatabasePath

  • Returns the path to the database file.

    • # Name Type(s) Default Value
    1 databaseName String
    Image Description
    Methods

    Delete

  • Deletes rows from the specified table.

    • # Name Type(s) Default Value
    1 table String
    2 whereClause String
    3 bindParams list
    Image Description
    Methods

    DeleteAsync

  • Asynchronously deletes rows from the specified table.

    • # Name Type(s) Default Value
    1 tag String
    2 table String
    3 whereClause String
    4 bindParams list
    Image Description
    Methods

    DeleteDatabase

  • Deletes the specified database.

    • # Name Type(s) Default Value
    1 databaseName String
    Image Description
    Methods

    Execute

  • Executes a raw SQL statement.

    • # Name Type(s) Default Value
    1 sql String
    2 bindParams list
    Image Description
    Methods

    ExecuteAsync

  • Asynchronously executes a raw SQL statement.

    • # Name Type(s) Default Value
    1 tag String
    2 sql String
    3 bindParams list
    Image Description
    Methods

    ExecuteFile

  • Executes SQL statements from a file.

    • # Name Type(s) Default Value
    1 fileName String
    Image Description
    Methods

    ExecuteFileAsync

  • Asynchronously executes SQL statements from a file.

    • # Name Type(s) Default Value
    1 tag String
    2 fileName String
    Image Description
    Methods

    ExportDatabase

  • Exports the database to a file.

    • # Name Type(s) Default Value
    1 fileName String
    Image Description
    Methods

    ImportDatabase

  • Imports a database from a file.

    • # Name Type(s) Default Value
    1 fileName String
    Image Description
    Methods

    Insert

  • Inserts a new row into the specified table.

    • # Name Type(s) Default Value
    1 table String
    2 columns list
    3 values list
    Image Description
    Methods

    InsertAsync

  • Asynchronously inserts a new row into the specified table.

    • # Name Type(s) Default Value
    1 tag String
    2 table String
    3 columns list
    4 values list
    Image Description
    Methods

    InsertFile

  • Inserts data into a table from a CSV file.

    • # Name Type(s) Default Value
    1 table String
    2 fileName String
    Image Description
    Methods

    InsertFileAsync

  • Asynchronously inserts data into a table from a CSV file.

    • # Name Type(s) Default Value
    1 tag String
    2 table String
    3 fileName String
    Image Description
    Methods

    IsDatabaseOpen

  • Checks if the database is currently open.

    • # Name Type(s) Default Value
    1 databaseName String
    Image Description
    Methods

    OpenDatabase

  • Opens a connection to the database.

    • # Name Type(s) Default Value
    1 databaseName String
    Image Description
    Methods

    Replace

  • Replaces an existing row in the specified table, or inserts a new row if it doesn't exist.

    • # Name Type(s) Default Value
    1 table String
    2 columns list
    3 values list
    Image Description
    Methods

    ReplaceAsync

  • Asynchronously replaces an existing row or inserts a new row.

    • # Name Type(s) Default Value
    1 tag String
    2 table String
    3 columns list
    4 values list
    Image Description
    Methods

    RollbackTransaction

  • Rolls back the current transaction.

    • Image Description
    Methods

    Select

  • Selects rows from the specified table based on the given criteria.

    • # Name Type(s) Default Value
    1 table String
    2 distinct boolean
    3 columns list
    4 whereClause String
    5 bindParams list
    6 groupBy String
    7 having String
    8 orderBy String
    9 limit String
    Image Description
    Methods

    SelectAsync

  • Asynchronously selects rows from the specified table based on the given criteria.

    • # Name Type(s) Default Value
    1 tag String
    2 table String
    3 distinct boolean
    4 columns list
    5 whereClause String
    6 bindParams list
    7 groupBy String
    8 having String
    9 orderBy String
    10 limit String
    Image Description
    Methods

    SelectSQL

  • Executes a raw SQL SELECT query and returns the result.

    • # Name Type(s) Default Value
    1 sql String
    2 bindParams list
    Image Description
    Methods

    SelectSQLAsync

  • Asynchronously executes a raw SQL SELECT query.

    • # Name Type(s) Default Value
    1 tag String
    2 sql String
    3 bindParams list
    Image Description
    Methods

    TableCount

  • Returns the number of tables in the database.

    • Image Description
    Methods

    TableExists

  • Checks if a table exists in the database.

    • # Name Type(s) Default Value
    1 tableName String
    Image Description
    Methods

    TableNames

  • Returns a list of table names in the database.

    • Image Description
    Methods

    TableRowCount

  • Returns the number of rows in the specified table.

    • # Name Type(s) Default Value
    1 table String
    Image Description
    Methods

    Update

  • Updates rows in the specified table.

    • # Name Type(s) Default Value
    1 table String
    2 columns list
    3 values list
    4 whereClause String
    5 bindParams list
    Image Description
    Methods

    UpdateAsync

  • Asynchronously updates rows in the specified table.

    • # Name Type(s) Default Value
    1 tag String
    2 table String
    3 columns list
    4 values list
    5 whereClause String
    6 bindParams list

    Properties

    Image Description
    Properties

    DBName

  • Gets the name of the database.


    • # Name Type(s) Default Value
    1 DBName String
    Image Description
    Properties

    DBName

  • Sets the name of the database.


    • # Name Type(s) Default Value
    1 DBName String
    Image Description
    Properties

    DBVersion

  • Gets the version of the database.


    • # Name Type(s) Default Value
    1 DBVersion int
    Image Description
    Properties

    DBVersion

  • Sets the version of the database.


    • # Name Type(s) Default Value
    1 DBVersion int 1
    Image Description
    Properties

    DebugDialog

  • Gets whether debug dialogs are enabled.


    • # Name Type(s) Default Value
    1 DebugDialog boolean
    Image Description
    Properties

    DebugDialog

  • Sets whether debug dialogs are enabled.


    • # Name Type(s) Default Value
    1 DebugDialog boolean false
    Image Description
    Properties

    DebugToast

  • Gets whether debug toasts are enabled.


    • # Name Type(s) Default Value
    1 DebugToast boolean
    Image Description
    Properties

    DebugToast

  • Sets whether debug toasts are enabled.


    • # Name Type(s) Default Value
    1 DebugToast boolean false
    Image Description
    Properties

    ReturnColumnNames

  • Gets whether column names are returned in results.


    • # Name Type(s) Default Value
    1 ReturnColumnNames boolean
    Image Description
    Properties

    ReturnColumnNames

  • Sets whether column names are returned in results.


    • # Name Type(s) Default Value
    1 ReturnColumnNames boolean false