sqlite-3.6.23.1 移植

1、下载源代码http://www.sqlite.org/download.html

2、tar -zxvf sqlite-amalgamation-3.6.23.1.tar.gz

3、进入sqlite-3.6.23.1

4、mkdir build

5、cd build

6、../configure --host=arm-linux --prefix=/usr/local/sqlite3

7、make

出现问题：
arm-none-linux-gnueabi-gcc: 3.6.23.1": No such file or directory
<command-line>: warning: missing terminating " character
^Cmake: *** [sqlite3.lo] 错误 1

解决：

Makefile中
-DPACKAGE_STRING=\"sqlite\ 3.6.23.1\"
改为：
-DPACKAGE_STRING=\"sqlite_3.6.23.1\"


8、sudo make install

出现问题：
arm-linux-ranlib /usr/local/sqlite3/lib/libsqlite3.a
./libtool: line 6619: arm-linux-ranlib: command not found
make[1]: *** [install-libLTLIBRARIES] 错误 127
make[1]:正在离开目录 `/work/development/sqlite/sqlite-3.6.23.1/build'
make: *** [install-am] 错误 2

原因：root权限的时候没有设置arm-linux 的PATH

解决：
su 根用户登录
export PATH=$PATH:/work/tools/arm/bin

make install

9、cd /usr/local/sqlite3

10、cp -arf bin include lib /work/nfs_root/sqlite/   复制到nfs共享文件夹下

11、mount -t nfs -o intr,nolock,rsize=1024,wsize=1024 192.168.
0.128:/work/nfs_root /mnt/nfs/    mount nfs文件系统

12、cp /mnt/nfs/sqlite/bin/* /usr/bin/
    mkdir /usr/lib
    cp -arf /mnt/nfs/sqlite/lib/* /usr/lib/
    mkdir /usr/include
    cp /mnt/nfs/sqlite/include/* /usr/include/

13、开发板上创建数据库
    # /usr/bin/sqlite3 demo
    SQLite version 3.6.23.1
    Enter ".help" for instructions
    Enter SQL statements terminated with a ";"
    sqlite> create table tbl_demo(uid int, uname varchar(20));
    sqlite> insert into tbl_demo values(1, 'jimmy');
    sqlite> insert into tbl_demo values(2, 'srp');
    sqlite> .quit

14、编写测试程序test.c

#include <stdio.h>
#include <stdlib.h>
#include "sqlite3.h"

static int callback(void *NotUsed, int argc, char **argv, char **azColName)
{
        int i;

        for(i=0; i<argc; i++) {
                printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
        }

        printf("\n");

        return 0;
}


int main(int argc, char **argv)
{
        sqlite3 *db;
        char *zErrMsg = 0;
        int rc;

        if( argc!=3 ){
                fprintf(stderr, "Usage: %s DATABASE SQL-STATEMENT\n", argv[0]);
                exit(1);
        }

        rc = sqlite3_open(argv[1], &db);
        if( rc ){
                fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
                sqlite3_close(db);
                exit(1);
        }

        rc = sqlite3_exec(db, argv[2], callback, 0, &zErrMsg);
        if( rc!=SQLITE_OK ){
                fprintf(stderr, "SQL error: %s\n", zErrMsg);
                sqlite3_free(zErrMsg);
    }

    sqlite3_close(db);

        return 0;
}

15、编译
    arm-linux-gcc test.c -I /usr/local/sqlite3/include -L /usr/local/sqlite3/lib -lsqlite3 -o test

16、将test拷贝到开发板与数据库demo同一个目录下
    sqlite
        demo 
        test

17、运行
    # ./test demo "select * from tbl_demo"
    uid = 1
    uname = jimmy

    uid = 2
    uname = srp

18、sqlite移植成功