Opened 14 years ago

Closed 14 years ago

#215 closed enhancement (invalid)

DB helper functions and pgsql support

Reported by: fvilas@… Owned by: Isaac Richards
Priority: minor Milestone: unknown
Component: mythtv Version:
Severity: medium Keywords:
Cc: Ticket locked: no

Description

This includes the db helper functions for supporting more than just MySQL. It also includes preliminary Postgres support.

Attachments (6)

dbhelper.h (3.5 KB) - added by fvilas@… 14 years ago.
DB helper functions, place in libs/libmythtv
dbhelper.cpp (19.0 KB) - added by fvilas@… 14 years ago.
DB helper functions, place in libs/libmythtv
pgsql_support.patch.gz (42.2 KB) - added by fvilas@… 14 years ago.
diff from svn 20050812 before around noon Central time, gzipped for attachment size requirements
pgsql_support.patch-new.gz (43.0 KB) - added by fvilas@… 14 years ago.
diff from svn 7020, gzipped for size requirements. Ignore previous patch.
pgsql_support.patch-7025.gz (44.4 KB) - added by fvilas@… 14 years ago.
diff from svn 7025, gzipped for size requirements. Ignore previous patches, this also contains assorted pgsql bugfixes.
pg.sql (1.6 KB) - added by fvilas@… 14 years ago.
SQL setup script for pgsql, similar to mc.sql for MySQL

Download all attachments as: .zip

Change History (7)

Changed 14 years ago by fvilas@…

Attachment: dbhelper.h added

DB helper functions, place in libs/libmythtv

Changed 14 years ago by fvilas@…

Attachment: dbhelper.cpp added

DB helper functions, place in libs/libmythtv

Changed 14 years ago by fvilas@…

Attachment: pgsql_support.patch.gz added

diff from svn 20050812 before around noon Central time, gzipped for attachment size requirements

Changed 14 years ago by fvilas@…

Attachment: pgsql_support.patch-new.gz added

diff from svn 7020, gzipped for size requirements. Ignore previous patch.

Changed 14 years ago by fvilas@…

Attachment: pgsql_support.patch-7025.gz added

diff from svn 7025, gzipped for size requirements. Ignore previous patches, this also contains assorted pgsql bugfixes.

Changed 14 years ago by fvilas@…

Attachment: pg.sql added

SQL setup script for pgsql, similar to mc.sql for MySQL

comment:1 Changed 14 years ago by Isaac Richards

Resolution: invalid
Status: newclosed

This isn't anywhere near useable.

  • There's database specific tests in the app, which is absolutely broken.
  • You're breaking channel up/down ordering, and ordering in lots of other places.
  • The 'dbhelper' class is implemented poorly. It should be an interface with separate classes for mysql/etc.
  • lots more stuff.
Note: See TracTickets for help on using tickets.