linux认证:ucLinux下sqlite数据库移植全攻略(2)

会计考友

linux认证:ucLinux下sqlite数据库移植全攻略(2)
: T0 a; U9 y$ r2 ]5 G7 p

$ {1 ~" m' T% u$ k& c; a4、romfs
. X6 S4 s7 P2 d% I2 L将：
install： sqlite libsqlite.a sqlite.h
( p6 H' I5 g% q4 k5 Qmv sqlite /usr/bin
$ M, M8 T% E8 J3 T" Y7 @mv libsqlite.a /usr/lib
mv sqlite.h /usr/include
$ {( b* `" ~+ W) Q+ g- E替换为：
4 K( q. {# _4 X8 M: \romfs： sqlite
$（ROMFSINST） /bin/sqlite
9 w9 g8 u) M; Y; D: I5 ?即去掉make install项，加上make romfs项。 这个很重要，这将在romfs的/bin目录下生成sqlite。
" H4 S* L/ D' T" @1 Y9 {0 u5、clean
# o6 f5 Y( Z/ a7 ], W0 v* v将：
- C$ M) o3 V5 {1 L3 ^clean：
rm -f *.o sqlite libsqlite.a sqlite.h opcodes.*
8 m' D! h4 G8 p1 x- Erm -f lemon lempar.c parse.* sqlite*.tar.gz
6 [& Z: o5 O% \# S+ m1 B; Qrm -f $（PUBLISH）
1 a! h- x0 \% Y  Trm -f *.da *.bb *.bbg gmon.out
, B" h3 f8 B, [* R& K- G) nrm -rf tsrc
6 H' z9 p  Q( s- h+ b" C, Z替换为：
clean：
- Z  b. ]) y9 z4 m5 i7 s) b3 nrm -f *.o sqlite libsqlite.a sqlite.h opcodes.* sqlite.gdb
rm -f $（PUBLISH）
rm -f *.da *.bb *.bbg gmon.out
4 M; W4 c& e# L& g7 i  v2 ^8 nrm -rf tsrc
distclean： clean
! _* p# f2 s! {: X+ `* Mrm -f lemon lempar.c parse.* sqlite*.tar.gz
rm -f config.h
) n9 f5 f" S) t8 [% C即增加make distclean项。
二、在sqlite下增加Makefile文件
6 [7 o& U. ~' N! L* L在sqlite目录下应该没有Makefile文件，而只是有一个sqlite/Makefile.linux-gcc文件。我们要移植sqlite到uclinux，那么就要自己写一个合适的Makefile。
, D0 G; n8 X* O" F/ g$ J内容如下：
( P" e" `, v4 W* M===========Makefile内容开始===========
# f, \0 Y# P2 l) e* \#！/usr/make
#
# Makefile for SQLITE
#
* p# L; O0 }( j- |" h  M  I/ f# This is a template makefile for SQLite. Most people prefer to
% n" d6 s8 M  ?( V' X7 P; y8 B, z# use the autoconf generated “configure” script to generate the
# makefile automatically. But that does not work for everybody
/ N" i+ r+ R5 v, u/ S0 K# and in every situation. If you are having problems with the
% I0 K7 Y6 @* M2 \# “configure” script， you might want to try this makefile as an
# alternative. Create a copy of this file， edit the parameters
& b# S% M' c+ s" U8 x4 H# below and type “make”。
#
#### The toplevel directory of the source tree. This is the directory
# that contains this “Makefile.in” and the “configure.in” script.
#
  D; I# B5 k+ e7 y2 g0 _TOP = 。
4 t9 T) {6 j) r. y  m: U& j5 a#### C Compiler and options for use in building executables that
# will run on the platform that is doing the build.
* K' X. ~3 p. w  J& w. _#
BCC = gcc -g -O2
#BCC = /opt/ancic/bin/c89 -0
1 k5 c$ i) u9 d  r2 I7 I" Z8 a+ U#### If the target operating system supports the “usleep（）” system
& C1 O! W" P& y) e: m6 y; _# call， then define the HAVE_USLEEP macro for all C modules.


9 L5 O& D% p0 Y7 N0 t#
, D) V1 y# G1 g1 m/ u$ u# A( x#USLEEP =
7 p0 k- V2 O3 A2 |' \8 VUSLEEP = -DHAVE_USLEEP=1
#### If you want the SQLite library to be safe for use within a
$ A+ {, b$ w7 r* B+ a# multi-threaded program， then define the following macro
; Z: U! J' D6 v) o' Q# appropriately：
! g: I2 s( d9 A. F2 D' z#
#THREADSAFE = -DTHREADSAFE=1
THREADSAFE = -DTHREADSAFE=0
; d7 {5 p! u" @7 [( D1 v) ?#### Specify any extra linker options needed to make the library
# thread safe
#
/ F8 T# p8 G4 h/ \#THREADLIB = -lpthread
THREADLIB =
3 m; Q5 \+ k/ D$ z5 S$ f& B) S0 b$ o# f#### Leave MEMORY_DEBUG undefined for maximum speed. Use MEMORY_DEBUG=1
( K3 H1 p( s9 b3 n: V# to check for memory leaks. Use MEMORY_DEBUG=2 to print a log of all
- d; j9 {+ |3 q) r* D. E# malloc（）s and free（）s in order to track down memory leaks.
#
" }' Z9 }2 C/ x' y- z# SQLite uses some expensive assert（） statements in the inner loop.
# You can make the library go almost twice as fast if you compile
# with -DNDEBUG=1
#
#OPTS = -DMEMORY_DEBUG=2
* s% Q" T& `' ^3 D* _#OPTS = -DMEMORY_DEBUG=1
" t: t) h: H6 i8 z, N* Q#OPTS = -DNDEBUG=1
OPTS = -DMEMORY_DEBUG=1
#### The suffix to add to executable files. “.exe” for windows.
) b6 n" U$ k3 Z% y+ J; p! q; P# Nothing for unix.
#
: C8 W) a$ x0 P#EXE = .exe
EXE =
#### C Compile and options for use in building executables that
7 [) k0 u& a4 _# will run on the target platform. This is usually the same
# as BCC， unless you are cross-compiling.
#
TCC = $（CROSS）gcc
' d6 o' \8 \+ i: O& eFLTFLAGS += -s 12000
#TCC = gcc -g -O0 -Wall
: |- d6 @  m/ F3 N$ N* |#TCC = gcc -g -O0 -Wall -fprofile-arcs -ftest-coverage
#TCC = /opt/mingw/bin/i386-mingw32-gcc -O6
#TCC = /opt/ansic/bin/c89 -O +z -Wl，-a，archive
#### Tools used to build a static library.
#
0 V) j) F! f: P. j5 nAR = $（CROSS）ar cr
5 y! A: v5 K9 y/ t5 F( r1 S#AR = /opt/mingw/bin/i386-mingw32-ar cr
RANLIB = $（CROSS）ranlib
% a% [6 w  }8 T9 g' q8 G5 A$ m8 ~#RANLIB = /opt/mingw/bin/i386-mingw32-ranlib
2 u1 Y9 K! k. f2 b$ o' s! t#### Extra compiler options needed for programs that use the TCL library.
#
#TCL_FLAGS =
, p! [; X& i) _& ?7 P8 R. K. c#TCL_FLAGS = -DSTATIC_BUILD=1
#TCL_FLAGS = -I/home/drh/tcltk/8.4linux
#TCL_FLAGS = -I/home/drh/tcltk/8.4win -DSTATIC_BUILD=1
#TCL_FLAGS = -I/home/drh/tcltk/8.3hpux
#### Linker options needed to link against the TCL library.
- N% x: t/ I1 |+ u#
3 x; V0 C, x6 e. J) ?+ z! m#LIBTCL = -ltcl -lm -ldl
# P% Q( g8 {  ^' m: ^$ y; n#LIBTCL = /home/drh/tcltk/8.4linux/libtcl8.4g.a -lm -ldl
#LIBTCL = /home/drh/tcltk/8.4win/libtcl84s.a -lmsvcrt
4 {. r2 _. D4 e: X: u; T#LIBTCL = /home/drh/tcltk/8.3hpux/libtcl8.3.a -ldld -lm -lc
) ^8 b: i  |1 F0 s+ Z. Y3 B#### Compiler options needed for programs that use the readline（） library.
#
1 d+ A4 l$ }- j. B9 Q5 R7 WREADLINE_FLAGS =
9 s1 e7 G" w3 M, [% A* Q3 \  U#READLINE_FLAGS = -DHAVE_READLINE=1 -I/usr/include/readline
#### Linker options needed by programs using readline（） must link against.
#
#LIBREADLINE =
#LIBREADLINE = -static -lreadline -ltermcap
#### Should the database engine assume text is coded as UTF-8 or iso8859？
6 T2 C, i( m$ @. L#
& W, o: C7 N5 a# _6 z# ENCODING = UTF8
ENCODING = ISO8859
# You should not have to change anything below this line
###############################################################################
include $（TOP）/main.mk
+ Z) K$ W! {+ X1 s5 p3 i% n===========Makefile内容结束===========