Re: saving pre-compiled scripts

Another thing which may be important to note re: my constraints is that
each script is essentially being run as a function.

In fact, every script element I parse in XML gets wrapped in a function
def before I send it to Py_CompileString.

I then PyEval the result of that function, and then run
Py_CompileString again, passing only the automatically generated
function call.

The result of the second Py_CompileString is what I pass to
PyEval_EvalCode whenever my app needs to run that script (function).

.

Relevant Pages

  • Re: Turning Off Foreign Keys during DB coping
    ... will disable and then reenable the constraints. ... > Do you suggest me to write the script for each table to disable keys? ... >> CREATE TABLE Test2 ...
    (microsoft.public.sqlserver.dts)
  • Re: Validating Surrogate Keys
    ... We aren't using Analysis Services. ... >> need that, as a matter of fact until now, we have used a script to ... >> build the constraints before the ETL process and drop them after it. ... >> the surrogate keys besides building foreign key constraints. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: create table statement
    ... called CopyOfEmployees that has no records at all, ... structure as Employees table: ... will not create indexes and constraints. ... Another option is to create a script from EM/QA or SSMS. ...
    (comp.databases.ms-sqlserver)
  • Re: Quicked way to create a copy of a table with all default values in
    ... You need to use ALTER TABLE to add constraints and indexes to the new ... The good news is that you can use SSMS to generate the script needed to ... associated object names to avoid duplication, ...
    (microsoft.public.sqlserver.programming)
  • Re: moving indexes
    ... output sql to drop ref constraints, ... run 2nd script on what's left, ... No. Dropping things is a subject I haven't dealt with enough. ... the references constraint info for those referenced by foreign keys only ...
    (comp.databases.informix)