FMDB & Swift, " Optional("no such table: Student info") " in real device but it can be done in simulator

Question

I'm newbie, plz help me to solve this out, I still have lots of other things to work on, really thank you thank you very much!

This is a further question after How to use FMDB on the generic iOS device instead of simulator? When I execute the app on my device and the error threw out: "no such table: Student info", I've print all the path and they all pointed to the same file so I assumed the database has already copied? Console shows like this:

file:///var/mobile/Containers/Data/Application/B5E42F3C-524E-4BBF-8667-1EED0C963A77/Documents/
file:///var/mobile/Containers/Data/Application/B5E42F3C-524E-4BBF-8667-1EED0C963A77/Documents/Data.db
/var/mobile/Containers/Data/Application/B5E42F3C-524E-4BBF-8667-1EED0C963A77/Documents/Data.db
file:///var/mobile/Containers/Data/Application/B5E42F3C-524E-4BBF-8667-1EED0C963A77/Documents/
file:///var/mobile/Containers/Data/Application/B5E42F3C-524E-4BBF-8667-1EED0C963A77/Documents/Data.db
/var/mobile/Containers/Data/Application/B5E42F3C-524E-4BBF-8667-1EED0C963A77/Documents/Data.db
/var/mobile/Containers/Data/Application/B5E42F3C-524E-4BBF-8667-1EED0C963A77/Documents/Data.db
<NSFileManager: 0x17401c1b0>
2017-03-13 16:43:25.446039 Test1.3[16360:5045427] [MC] System group container for systemgroup.com.apple.configurationprofiles path is /private/var/containers/Shared/SystemGroup/systemgroup.com.apple.configurationprofiles
2017-03-13 16:43:25.457278 Test1.3[16360:5045427] [MC] Reading from public effective user settings.
Insert failed:
Optional("no such table: Student info")

The Data.db is in my bundle resources in target; and the contents in my device is a blank Data.db;

The 2nd question: If you look at the Utility.Swift in the previous question, although the app works good on simulator but after it was loaded, there should be an alertView said "Your database copy successfully", but it didn't. Following is that part of the code:

    class func copyFile(_ fileName: NSString){

    let dbPath: String = getPath(fileName as String)
    let fileManager = FileManager.default

    print(dbPath)
    print(fileManager)

    if !fileManager.fileExists(atPath: dbPath) {
        let documentsURL = Bundle.main.resourceURL
        let fromPath = documentsURL!.appendingPathComponent(fileName as String)

        var error : NSError?
        do {
            try fileManager.copyItem(atPath: fromPath.path, toPath: dbPath)
        }
        catch let error1 as NSError {
            error = error1
        }
        if(error != nil){
            self.invokeAlertMethod("Error Occured", strBody: "\(error?.localizedDescription)" as NSString, delegate: nil)
        }
        else{
            self.invokeAlertMethod("Successed", strBody: "Your database copy successfully", delegate: nil)
        }
    }
}

Can you try to re install the app once again?. Just delete the app from device and reinstall. — Anil Kukadeja, Mar 14 '17 at 06:58
Can you share your source code with me..? I would like to figure out a piece of code. — Anil Kukadeja, Mar 15 '17 at 05:39
Oh yes Thank you so much!!!! Here's the link:https://www.dropbox.com/sh/zn2gijylqsfs7xb/AAAgzl9igmAwNg1xOBq5UNcta?dl=0 — Grace Yang, Mar 16 '17 at 21:19

score 0 · Answer 1 · answered Mar 14 '17 at 11:32

0

First trying delete your app and then reinstall it.

OR

I have created a project over FMDB in Swift which you can use to solve your issue. FMDB Wrapper class you can use in Objective C project as well.

https://github.com/LalitKY/Swift-FMDB

Hope this helps.

answered Mar 14 '17 at 11:32

Lalit

264
3
10

Thank you but I've tried to delete the app and reinstall again, it didn't work – Grace Yang Mar 14 '17 at 14:52
Then go with project i have shared. – Lalit Mar 15 '17 at 04:57

score 0 · Accepted Answer · answered Mar 17 '17 at 13:32

Okay for answering this question I went through your demo.

Where I found couple of mistakes. Let me go through one by one.

1) Your class Utility have a getPath method. What it does it will keep copying db every time although db is already present in documents directory and your documents directory db will be replaced with the sample structure. You should always check that if db is already present in documents directory or not.

2) Your db was getting copied into documents directory but structure wasn't. There was no Student info table in db of documents directory.

3) Please avoid using space or any special characters in table names.

So what I did just corrected your method getPath in utility class.

Please replace your method with this one

class func getPath(_ fileName: String) -> String {

         let bundlePath = Bundle.main.path(forResource: "Data", ofType: ".db")
         let destPath = NSSearchPathForDirectoriesInDomains(.documentDirectory, .userDomainMask, true)[0]
         let fileManager = FileManager.default
         let fullDestPath = URL(fileURLWithPath: destPath).appendingPathComponent("Data.db")
         if fileManager.fileExists(atPath: fullDestPath.path){
            print("Database file is exist")
            print(fileManager.fileExists(atPath: bundlePath!))
         }else{
            do{
                try fileManager.copyItem(atPath: bundlePath!, toPath: fullDestPath.path)
            }catch{
                print("\n",error)
            }
         }

        print(fullDestPath.path)
        return fullDestPath.path
}

After changing this piece of code I tried to run in my device and inserted couple of records.

Let me know if you have any more questions.

If you find this answer helpful just accept it.

Thank you very much!!!! It's very clear!! and I've tried the method you wrote, there's an error in `try`, it said cannot convert 'String' to 'URL', is this also happen to your Xcode? — Grace Yang, Mar 17 '17 at 15:09
Missed something XD, I think it will be good and I will try it immediately after I go back from library!!! Thank you!!! — Grace Yang, Mar 20 '17 at 19:02

FMDB & Swift, " Optional("no such table: Student info") " in real device but it can be done in simulator

2 Answers2