正点原子stm32f429阿波罗开发板上运行sqlite无法建表

发布于 2018-07-30 15:35:55 浏览：3942 订阅该版

在正点原子的F429开发板上跑的uffs,文件系统测试ok,但是跑sqlite的测试代码可以建立数据库,但无法建立表,有人遇到过吗？测试文件在附件里。
测试打印信息如下:
```
initialize stm32_hw_usart_init:0 done
initialize rt_hw_rtc_init:0 done
initialize mpu_init:0 done
initialize rt_hw_sdcard_initsdcard init failed
:1 done
initialize nand_MT29F4G08_hw_init
NAND ID: 0xDC909556
:0 done
initialize rt_hw_pin_init:0 done
initialize cortexm_cputime_init:0 done
 \ | /
- RT -     Thread Operating System
 / | \     3.0.4 build Jul 30 2018
 2006 - 2018 Copyright by rt-thread team
do components intialization.
initialize rti_board_end:0 done
initialize dfs_init:0 done
initialize lwip_system_initlwIP-2.0.2 initialized!
:0 done
initialize stm32f4_i2c_init:0 done
initialize rt_hw_spi5_init:0 done
initialize rt_hw_spi_flash_with_sfud_init[SFUD]Find a Winbond flash chip. Size is 33554432 bytes.
[SFUD]W25Q256 flash device is initialize success.
:0 done
initialize elm_init:0 done
initialize dfs_romfs_init:0 done
initialize dfs_uffs_init:0 done
initialize rt_i2c_core_init:0 done
initialize rt_rtc_ntp_sync_init:0 done
initialize libc_system_init:0 done
initialize pthread_system_init:0 done
initialize clock_time_system_init:0 done
initialize rt_hw_stm32_eth_init:0 done
initialize finsh_system_init:0 done
ROM file system initializated!
spi flash mount to /spi failed!
sd card mount to /sdcard failed!
os  : system memory alloc 320 bytes
flsh: UFFS consume spare data size 34
os  : system memory alloc 83520 bytes
os  : system memory alloc 52400 bytes
os  : system memory alloc 65536 bytes
tree: DIR 0, FILE 1, DATA 0
nand flash mount to /nand !
=====case 1:
opened a sqlite3 database named /nand/test.db successfully!
testdb1:73      SQL error: table test already exists
row:1 column=5
The result of querying is :
ID      AGE     LEVEL   NAME    SALARY
1       1       1       201312  120.9
=====case 2:
Successfully connected to database
testdb2:113     SQL error: no such table: t1
=====case 3:
Successfully connected to database
row:1 column=5
The result of querying is :
ID      AGE     LEVEL   NAME    SALARY
1       1       1       201401  200.9
finsh />[E/NTP]: ERROR no such host
finsh />ls("/")
Directory /:
readme.txt          12
sdcard              <DIR>
spi                 <DIR>
nand                <DIR>
        0, 0x00000000
finsh />ls("/nand")
Directory /nand:
test.db             8192
        0, 0x00000000
finsh />
```
下载附件 [sqlite_test.c](/uploads/201807/30/153339uv73ecknttakec1k.attach)

13 个回答

tsx1983 2018-07-30

这家伙很懒，什么也没写！

tsx1983 2018-07-30

这家伙很懒，什么也没写！

那个测试是对的.但是另外一个测试却没发建表如下:
```c
static int testdb4(void)
{
	sqlite3 *db=NULL;
	static sqlite3_stmt *stmt;
  static char sqlcmd[256];
  int rc;
	rt_kprintf("\n\n\n=====case 4:\n");
	sqlite3_initialize();
	if(sqlite3_open_v2(DB_FILE,&db,SQLITE_OPEN_READWRITE|SQLITE_OPEN_CREATE,NULL)!=SQLITE_OK)
	{
	  rt_kprintf("failed to open db !\n");
		if(db)
		{
		  sqlite3_close(db);
		}
	 sqlite3_shutdown();
	 return -1;
	}
	if(db)
		{
     //sprintf(sqlcmd,"CREATE TABLE IF NOT EXISTS %s (entry_id INTEGER,occur_time BLOB,item_id TEXT,domain_id TEXT,cur_state INT,num_of_var INT,list_of_var BLOB)","testtbl");
		  memset(sqlcmd,0,sizeof(sqlcmd));
			sprintf(sqlcmd,"CREATE TABLE IF NOT EXISTS %s (id INTEGER,name TEXT,baud INT,databits INT,stopbits INT,check INT)","testtbl");
      if((rc=sqlite3_prepare_v2(db,sqlcmd,strlen(sqlcmd),&stmt,NULL))!= SQLITE_OK) 
      {
       rt_kprintf("failed to prepare:%s when create table testtbl\n",sqlite3_errmsg(db));
       if(stmt)
        sqlite3_finalize(stmt); 
       sqlite3_close(db);
       sqlite3_shutdown();  
       return -2;			 
	    }
		 else
			{
       rc = sqlite3_step(stmt);
       if(rc!=SQLITE_DONE)
        {
         rt_kprintf("failed to step:%s when step\n",sqlite3_errmsg(db));
         sqlite3_finalize(stmt);
         sqlite3_close(db);
         sqlite3_shutdown();
         return -3;	
        }
       sqlite3_finalize(stmt);
       sqlite3_close(db);
       sqlite3_shutdown();
	    }
		}
	 return 0;
}
```
输出入下:
```
=====case 4:
failed to prepare:near "INT": syntax error when create table testtbl
```
这是什么鬼？无法解析INT符号