Support for firebird 3 about django-firebird HOT 13 CLOSED

Is there any news about supporting Firebird 3?

from django-firebird.

Hi Antonio,

I'm glad that it be useful for you.
Currently, the current version (in master branch) is based in django 1.9, I don't tested it in django 1.10. I hope this year to invest more time in this project, maybe jumping directly to 1.11 witch is the next django LTS release and then to 2.0
The update to firebird 3.x perhaps imply broken the compatibility with firebird 2, so this need more research.

Of course, PR are always welcome 😃

Best regards.
Maxi.

from django-firebird.

Hi @Ribeiroti I'm working on it right now. I hope to have news soon.

Regards

from django-firebird.

Hello,
cual es la compatibilidad para usar Firebird 3.02 ??

Gracias

from django-firebird.

Hola,

https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-compat-systables.html
https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-ddl-enhance.html

SQL> show version;
ISQL Version: LI-V3.0.1.32609 Firebird 3.0
Server version:
Firebird/Linux/Intel/i386 (access method), version "LI-V3.0.1.32609 Firebird 3.0"
on disk structure version 12.0

Saludos y gracias,
D

from django-firebird.

Hi @davevt,

Firebird 3 is not supported yet.
Regards.

from django-firebird.

Hi Maxi,

I have used Firebird 3.02 and Django 1.10 on django-firebird and it's working very well in production. But just only to query and to change data somefield in database. It's saving the data no problems. I will a lot use the django-firebird, there are plan to support and keep on that driver?

Regards,

Antonio.

from django-firebird.

Is there any news about supporting Firebird 3?

I managed to find a "solution" but I haven't verified the side effects of it.

from django-firebird.

Hello. Please show your solution

from django-firebird.

into schema.py

def _alter_column_set_null(self, table_name, column_name, is_null):
	fb_ver = str(self.connection.connection.engine_version).split('.')
	if fb_ver and len(fb_ver) > 0 and int(fb_ver[0]) >= 3:
		sql = "ALTER TABLE %(table_name)s ALTER %(column)s %(null_flag)s NOT NULL"
		null_flag = 'DROP' if is_null else 'SET'
	else:
		sql = """
			UPDATE RDB$RELATION_FIELDS SET RDB$NULL_FLAG = %(null_flag)s
			WHERE RDB$FIELD_NAME = '%(column)s'
			AND RDB$RELATION_NAME = '%(table_name)s'
		"""
		null_flag = 'NULL' if is_null else '1'
	return sql % {
		'null_flag': null_flag,
		'column': column_name.upper(),
		'table_name': table_name.upper()
	}

from django-firebird.

Hi @maxirobaina @toshiroakio Firebird 3.0 is not yet supported?

from django-firebird.

from django-firebird.

Some of the Firebird 3 issues are fixed by #111

I guess this can be closed

from django-firebird.