User talk:๐Ÿ˜‚/Abstract schema

Add topic
From mediawiki.org
Latest comment: 14 years ago by ^demon

Just a couple of notes/ideas:

  • each Abstracion should provide a function to return current state of db schema. This class should then be able either parse a create script or alter scripts for each table.
  • overloaded tableName function that would on some abstractions take in account user namespace i.e. on Oracle you usualy do not give a normal user all privileges needed to manipulate schema, you usualy do that with an dba user but you then have to reference user objects by prefixing schema name. That can be then simply done with this overload.
  • some kind of notation to explain field renameing.

I'd like to achieve that this class would have the capabilities to not only create a new schema but to also be able to handle transitions between versions. freakolowsky

See r63025 for the first commit of this stuff. ^demon 22:58, 26 February 2010 (UTC)Reply