I had asked this question on Stack Overflow. The details are at this link:
http://stackoverflow.com/questions/24836816/updating-a-few-children-in-one-to-many-relationship-deletes-all-rows-and-adds-ne
The summary is I have a parent class A and a bidirectional one-to-many
relationship with class
Thanks Michael,
You of course is right and I rarely have to use this method.
Having said that, once in a while, if I need to migrate a version or do some
maintenance, I do need that option.
How would I do that in sqlalchemy? Do I have to use raw SQL for that? Why
would that not scale?
From:
On Mon, Jul 21, 2014 at 2:40 AM, 'Frank Liou' via sqlalchemy
sqlalchemy@googlegroups.com wrote:
there is no error msg
or
how can i trace the error msg?
OK, sorry, I misunderstood. How do you know it isn't working?
Simon
--
You received this message because you are subscribed to the
i use try
if do not return Success
it mean have not session.add
@app.route('/company/business_account_number/address/company_status/company_captial_amount/business_description/company_name',
methods=['POST'])
def
raw SQL and it wouldn't scale because you probably cannot emit two such ALTER
statements concurrently, and it probably doesn't run very fast either.
http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_2012.htm
On Jul 21, 2014, at 3:19 AM, Ofir Herzas herz...@gmail.com wrote:
the code there doesn't seem to show anything that would result in any DELETEs
emitted. a DELETE here would only occur if you deassociated a TestDevice and
a TestPartition by removing from the TestDevice.partitions collection or
setting a TestPartition.device to None, and I don't see that.
not to mention you're using strings to set integer values, again a bad idea,
can only confuse your database:
part.partition_id = '345' # -- this is a string
partition_id = sa.Column(sa.Integer, nullable=False) # -- should be integer
with this program you need to create a short test case
You are deliberately suppressing the error message with your exception
handler in the new_company_generation function. Try getting rid of the
try: and exception Exception: lines, then you should see the full
error message, either in your web browser, or on the console where you
are running the
I agree with what Mike said, but I would just suggest renaming
projector_table to something like purchased_table or inventory_table.
Everything in models is a different model of a projector, so the table
names are a bit confusing.
In non-database terms, a good way to visualize relationships
Hello guys,
I am learning Flask, I new started sqlalchemy with flask, so very easy is
both.
I am working with wtforms flask extension and sqlalchemy for flask
extension.
My Application and database initalize,
app = Flask(__name__)
# app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite::memory:'
how are the permissions on this file path:
/test.db
?
do you really want your database file in the root directory like that?
On Jul 21, 2014, at 2:58 PM, Imk Hacked ihacked1...@gmail.com wrote:
Hello guys,
I am learning Flask, I new started sqlalchemy with flask, so very easy is
both.
On Monday, July 21, 2014 8:38:54 AM UTC-7, Jonathan Vanasco wrote:
I agree with what Mike said, but I would just suggest renaming
projector_table to something like purchased_table or inventory_table.
Everything in models is a different model of a projector, so the table
names are a bit
Forgot to mention that during typical operation, the only time the database
will be accessed would be during down time (add/delete) or program startup
(retrieve list of projectors to control) - not during a presentation.
--
You received this message because you are subscribed to the Google
13 matches
Mail list logo