How to create multiple tables in sqlite for react native?

Question

The basic construct of creating a single table in sqlite db is as follows:

const db = SQLite.openDatabase('students.db')

export const init = () => {
  const promise = new Promise((resolve, reject) => {
    db.transaction((tx) => {
      tx.executeSql(
        'CREATE TABLE IF NOT EXISTS stud(id INTEGER PRIMARY KEY, name TEXT NOT NULL);',
        [],
        () => {
          resolve()
        },
        (_, err) => {
          reject(err)
        }
      )
    })
  })
  return promise
}

However how to create another table (say) teachers?

Sameer Kumar Jain · Accepted Answer · 2021-06-12 14:54:17Z

2

I currently have no setup to test it but in general, this should work.

export const init = async () => {
  const promise = new Promise((resolve, reject) => {
    db.transaction(async (tx) => {
      await tx.executeSql(
        'CREATE TABLE IF NOT EXISTS stud(id INTEGER PRIMARY KEY, name TEXT NOT NULL);')
await tx.executeSql(
        'CREATE TABLE IF NOT EXISTS teachers(id INTEGER PRIMARY KEY, name TEXT NOT NULL);')
resolve();
    })
  })
  return promise
}

answered Jun 12, 2021 at 14:54

Sameer Kumar Jain

2,1351 gold badge14 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create multiple tables in sqlite for react native?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related