Alex, Very cool.
Give me a little time to study this. But, already, I can tell that you know some things that I do not. I have some learning to do. More later. Dave On Thu, Aug 30, 2018 at 09:03:56AM +0300, Alex Bodnaru wrote: > ah, good you told me. mine is working, and was based on your django code. > i'm loading tables, foreign keys an manytomany relations, and their data. > all this is being generated from one xsd automatically. my code will be > attached here. > although xsd can represent primary keys, mine doesn't have it, and i'm > allowing the > user to set one per table, and one default pk field. if inexistent, the pk > field will be > added as an auto incremented integer. > btw i'm performing the load of multiple xsd with multiple models in one > run, importing > them in a main.py. this complexity somewhat broke the preservation of older > files. > your generateDS.py has not changed at all. > > since my source data contains more than one xsd with overlapping entities, > and i've > got stuck when one table is being defined in one xsd as a named complex > type, > but in the other, is being defined as a child type element of a field, > hence it gets > the name of the field + 'Type'. i'd like to override this particular > behaviour, at least the > field type dot to get the suffix, so it could match the table from the > other xsd. > > thanks a lot for all your work, > alex > > On Thu, Aug 30, 2018 at 7:01 AM Dave Kuhlman <dkuhl...@davekuhlman.org> > wrote: > > > Alex, > > > > You are welcome. Hope generateds has been useful. > > > > Your work on an extension for SQLAlchemy sounds very interesting. I > > suspect that such a capability would be a very valuable addition. > > > > I'm working on something similar myself. I'm hoping to be able to > > generate an SQLAlchemy model from an XML schema, then use > > generateDS.py to generate a module contain export methods that would > > load data from an XML instance document into a SQLAlchemy database. > > I'm just now starting to study SQLAlchemy and am learning as I go. > > > > And, by the way, Denis Sutyagin aka jabber contributed the > > code base for my work. > > > > I've also done some initial work on an analogous capability for > > generateds and Django. > > > > I'm thinking that this is in the area of an ETL capability for > > generateds and SQLAlchemy (and Django): extract, transform, and > > load, without very much emphasis on the transform part. Wait. > > Maybe ... OK. I've added a hook for user transforms. Although, I'm > > groping about use-cases, which is likely obvious. > > > > I'm new to SQLAlchemy and am groping and learning about it as I work > > on this. So, it will likely be some time in the future before I > > have something that works. > > > > Maybe someday we can compare notes and compare ideas on this. > > > > Dave > > > > On Wed, Aug 29, 2018 at 06:06:33PM +0300, Alex Bodnaru wrote: > > > hello my friends, > > > > > > a big thank for generateds. > > > > > > in an aim to load a db from xsd and xml data files, i had the pleasure to > > > develop an sql alchemy extension. > > > my only wish I didn't find a way to fulfill is to generate anonymous > > types > > > without the 'Type' suffix. > > > however i tryed, my aim to do the change myself failed, since I didn't > > find > > > where un the code it's being done. > > > > > > thanks in advance, > > > alex > > > > > > > > > alex > > > > > > > ------------------------------------------------------------------------------ > > > Check out the vibrant tech community on one of the world's most > > > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > > > > > _______________________________________________ > > > generateds-users mailing list > > > generateds-users@lists.sourceforge.net > > > https://lists.sourceforge.net/lists/listinfo/generateds-users > > > > > > -- > > > > Dave Kuhlman > > http://www.davekuhlman.org > > > > > -- > -- > alex -- Dave Kuhlman http://www.davekuhlman.org ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ generateds-users mailing list generateds-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/generateds-users
