julioz

database.execSQL("""
    CREATE TABLE IF NOT EXISTS TrackCreator_temp (
        `track_id` TEXT NOT NULL,
        `user_id` TEXT NOT NULL,
        PRIMARY KEY(`track_id`, `user_id`),
        FOREIGN KEY(`track_id`) REFERENCES `Track`(`id`) ON UPDATE NO ACTION ON DELETE NO ACTION ,
        FOREIGN KEY(`user_id`) REFERENCES `User`(`id`) ON UPDATE NO ACTION ON DELETE NO ACTION 
        )
    """.trimIndent())

julioz

V/SQLiteStatements: /data/com.soundcloud/databases/sc.db: "BEGIN EXCLUSIVE;"
V/SQLiteStatements: /data/com.soundcloud/databases/sc.db: "INSERT OR REPLACE INTO `Users` (...) VALUES (...)"
V/SQLiteStatements: /data/com.soundcloud/databases/sc.db: "INSERT OR REPLACE INTO `Users` (...) VALUES (...)"
V/SQLiteStatements: /data/com.soundcloud/databases/sc.db: "-- TRIGGER room_table_modification_trigger_trackuser_DELETE"
V/SQLiteStatements: /data/com.soundcloud/databases/sc.db: "-- UPDATE room_table_modification_log SET invalidated = 1 WHERE table_id = 7 AND invalidated = 0"
V/SQLiteStatements: /data/com.soundcloud/databases/sc.db: "-- TRIGGER room_table_modification_trigger_trackuser_DELETE"
V/SQLiteStatements: /data/com.soundcloud/databases/sc.db: "-- UPDATE room_table_modification_log SET invalidated = 1 WHERE table_id = 7 AND invalidated = 0"
V/SQLiteStatements: /data/com.soundcloud/databases/sc.db: "-- TRIGGER room_table_modification_trigger_users_DELETE"
V/SQLiteStatements: /data/com.soundcloud/databases/sc.db:

julioz

@Dao
interface TrackDao {
    @Insert(onConflict = OnConflictStrategy.REPLACE)
    fun insert(tracks: List<TrackEntity>)
}

julioz

CREATE TABLE IF NOT EXISTS TrackCreator (
  `track_id` TEXT NOT NULL,
  `user_id` TEXT NOT NULL,
  
  PRIMARY KEY(`track_id`, `user_id`),
  
  FOREIGN KEY(`track_id`) REFERENCES `Track`(`id`) ON UPDATE NO ACTION ON DELETE CASCADE ,
  FOREIGN KEY(`user_id`) REFERENCES `User`(`id`) ON UPDATE NO ACTION ON DELETE CASCADE 
)

julioz

floorPlan {
  schemaLocation = "schemas/"
  outputLocation = "floorplan-output/"
  outputFormat {
    svg {
      enabled = true
    }
  }
}

julioz

val config = AudioPlaybackCaptureConfiguration.Builder(mediaProjection)
    .addMatchingUsage(AudioAttributes.USAGE_MEDIA)
    .build()

val audioFormat = AudioFormat.Builder()
    .setEncoding(AudioFormat.ENCODING_PCM_16BIT)
    .setSampleRate(8000)
    .setChannelMask(AudioFormat.CHANNEL_IN_MONO)
    .build()

julioz

<manifest>
  ...
  <uses-permission android:name="android.permission.RECORD_AUDIO />
  <uses-permission android:name="android.permission.FOREGROUND_SERVICE" />
  ...
</manifest>

julioz

<manifest ...>
  ...
  <application >
  <service
      android:name=".AudioCaptureService"
      android:foregroundServiceType="mediaProjection" />
    ...
  </application>
</manifest>

julioz

diskutil list # find the parition ID marked as Windows NTFS disk

# if ID is disk3s1, then, input disk password after running
sudo dislocker -V /dev/disk3s1 -u -- externalhdd/

# this will output partition reference
sudo hdiutil attach -imagekey diskimage-class=CRawDiskImage -nomount externalhdd/dislocker-file

# Create disk directory
sudo mkdir /Volumes/ExternalHDD

julioz

createStrippedAndDebugInfo() {
    cd ${REPO_PATH} # assuming we're in your repository's directory
    ANDROID_NDK=<PATH_TO_NDK>
    
    TMP_DIR_NAME=tmp_strip_symbols
    AAR=`find -name '*.aar'` # find the path to the AAR containing the binaries
    
    mkdir -p ${TMP_DIR_NAME}
    try cd ${TMP_DIR_NAME}