--- Webware/MiddleKit/Design/SQLGenerator.py Sun Nov 10 07:37:15 2002 +++ WebwareWithPostgres/MiddleKit/Design/SQLGenerator.py Fri Dec 6 20:50:31 2002 @@ -98,7 +98,15 @@ def writeInsertSamplesSQL(self, generator, dirname): if self._filename is not None: file = open(os.path.join(dirname, 'InsertSamples.sql'), 'w') - file.write('use %s;\n\n' % self.sqlDatabaseName()) + + # This is a poor way to get Postgres SQL Sample data working + # it needs to be refactored. + import PostgreSQLSQLGenerator + if (isinstance( generator, PostgreSQLSQLGenerator.PostgreSQLSQLGenerator)): + file.write('\c "%s"\n\n' % self.dbName()) + else: + file.write('use %s;\n\n' % self.sqlDatabaseName()) + self._klasses.writeDeleteAllRecords(generator, file) filenames = glob(os.path.join(self._filename, 'Sample*.csv')) for filename in filenames: