Make SQL statements be compatible with PostgreSQL #127

Open
tkdchen opened this Issue Jan 27, 2017 · 0 comments

Comments

Projects
None yet
1 participant
@tkdchen
Member

tkdchen commented Jan 27, 2017

Most of the code, the major features, could work with PostgreSQL well except the Report. There are several MySQL-specific SQL statements for statistics. To make them compatible with PostgreSQL. This issue has lower priority since it seems Report is seldom used. Anyway, feel free to comment if you are using Report and think this should have higher priority in the future.

@tkdchen tkdchen added the RFE label Jan 27, 2017

@tkdchen tkdchen changed the title from Compatible with PostgreSQL to Make SQL statements in Report be compatible with PostgreSQL Jan 27, 2017

@tkdchen tkdchen added the low label Jan 27, 2017

@tkdchen tkdchen added high and removed low labels Feb 18, 2017

@tkdchen tkdchen added this to the 4.0 milestone Feb 21, 2017

@tkdchen tkdchen changed the title from Make SQL statements in Report be compatible with PostgreSQL to Make SQL statements be compatible with PostgreSQL Mar 2, 2017

tkdchen added a commit to tkdchen/Nitrate that referenced this issue Mar 2, 2017

Remove back quotes from SQL statements
Related to #127

Signed-off-by: Chenxiong Qi <qcxhome@gmail.com>

tkdchen added a commit to tkdchen/Nitrate that referenced this issue Mar 2, 2017

Convert SQL statement to ORM query in testcases models
Related to #127

Signed-off-by: Chenxiong Qi <qcxhome@gmail.com>

tkdchen added a commit to tkdchen/Nitrate that referenced this issue Mar 2, 2017

Remove back quotes from SQL statements
Related to #127

Signed-off-by: Chenxiong Qi <qcxhome@gmail.com>

tkdchen added a commit to tkdchen/Nitrate that referenced this issue Mar 2, 2017

Convert SQL statement to ORM query in testcases models
Related to #127

Signed-off-by: Chenxiong Qi <qcxhome@gmail.com>

@tkdchen tkdchen modified the milestones: 4.1, 4.0 Apr 4, 2017

@tkdchen tkdchen modified the milestones: 4.1, Replace raw SQLs with ORM Dec 7, 2017

@tkdchen tkdchen modified the milestones: Compatible with both MariaDB and PostgreSQL, 4.3 Apr 6, 2018

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment