Implement SQLite support - Githubissues

kei-mag / Hakoirimusume

LINE bot for monitoring my rabbit with camera & thermometer.

MIT License

0 stars 0 forks source link

Implement SQLite support #4

Closed kei-mag closed 3 months ago

kei-mag commented 5 months ago

Functions

addUser(userId, authorityLevel) → result
setState(userId, newState) → result
resetState()

Database Design

UserData

UserID	AuthorityLevel	State	LatestRequestTime
LINE UserID	0(noUser), 1(normalUser), 2(adminUser)	int?	DateTime, null

db connection is opend when each request is processed, and closed when system finished processing database for each request.
State is set to 0 when system is launched.