使用Express和TypeORM连接到MariaDB
我尝试执行了下面的示例代码。
typeorm / typescript-express-example
准备 MariaDB
用户:scott
密码:tiger123
数据库:my_database
程序的克隆
git clone https://github.com/typeorm/typescript-express-example
准备程序
cd typescript-express-example
npm install
设置数据库连接信息
{
"type": "mysql",
"host": "localhost",
"port": 3306,
"username": "scott",
"password": "tiger123",
"database": "my_database",
"synchronize": true,
"entities": [
"src/entity/*.js"
],
"subscribers": [
"src/subscriber/*.js"
],
"migrations": [
"src/migration/*.js"
],
"cli": {
"entitiesDir": "src/entity",
"migrationsDir": "src/migration",
"subscribersDir": "src/subscriber"
}
}
服务器的启动
npm start
在客户端上进行访问
$ curl http://localhost:3000/posts
[]
将数据存入MySQL。
insert into post set title='test_aa', text='Hello';
insert into post set title='test_cc', text='Good Morning';
insert into post set title='test_dd', text='Good Afternoon';
quit
执行SQL
mysql -uscott -ptiger123 my_database < insert.sql
从客户端访问
$ curl http://localhost:3000/posts | jq .
[
{
"id": 9,
"title": "test_aa",
"text": "Hello"
},
{
"id": 10,
"title": "test_cc",
"text": "Good Morning"
},
{
"id": 11,
"title": "test_dd",
"text": "Good Afternoon"
}
]
请通过指定ID进行访问。
$ curl http://localhost:3000/posts/10 | jq .
{
"id": 10,
"title": "test_cc",
"text": "Good Morning"
}
插入数据
curl -X POST -H "Content-Type: application/json" \
-d '{"title": "test_ee","text": "Good Evening"}' \
http://localhost:3000/posts
相关页面
使用Nest.js和TypeORM来连接MariaDB