a0aec8bfae
- Updated package.json to use PostgreSQL dependencies (pg, @types/pg)
- Removed SQLite dependency
- Updated TypeORM configuration for PostgreSQL connection
- Modified database entities to use PostgreSQL-compatible column types (jsonb, timestamp)
- Created comprehensive database migration script for initial schema
- Updated environment configuration with PostgreSQL variables
- Updated README with PostgreSQL setup instructions and database migration steps
- Ensured storage directories are properly configured
🤖 Generated with BackendIM
Co-Authored-By: Claude <noreply@anthropic.com>
1.1 KiB
1.1 KiB
postgres-interval 
Parse Postgres interval columns
Install
$ npm install --save postgres-interval
Usage
var parse = require('postgres-interval')
var interval = parse('01:02:03')
//=> {hours: 1, minutes: 2, seconds: 3}
interval.toPostgres()
// 3 seconds 2 minutes 1 hours
interval.toISO()
// P0Y0M0DT1H2M3S
API
parse(pgInterval) -> interval
pgInterval
Required
Type: string
A Postgres interval string.
interval.toPostgres() -> string
Returns an interval string. This allows the interval object to be passed into prepared statements.
interval.toISOString() -> string
Returns an ISO 8601 compliant string.
Also available as interval.toISO() for backwards compatibility.
License
MIT © Ben Drucker